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

Unexpected syntax error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Incomplete
    • 10.3.12
    • N/A
    • OTHER

    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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.