Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18678

Unexpected syntax error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Incomplete
    • Affects Version/s: 10.3.12
    • Fix Version/s: N/A
    • Component/s: OTHER
    • Labels:

      Description

      After updating from 10.3.10 to 10.3.12 I get an error on such (simplified) query:

      SELECT COUNT(*)
      FROM people 
      LEFT JOIN `a_users` `user_create` on people.id_user_create = user_create.id 
      LEFT JOIN `a_users` `user_update` on people.id_user_update = user_update.id 
      

      10.3.10
      Result: 2397

      10.3.12
      Result: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

      If I just rename the table `a_users` to `b_users`, there is no error

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            maxx Максим Павлович Обухов
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: