[MDEV-18678] Unexpected syntax error Created: 2019-02-21  Updated: 2019-04-01  Resolved: 2019-04-01

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.3.12
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: Максим Павлович Обухов Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback


 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

 Comments   
Comment by Elena Stepanova [ 2019-03-04 ]

Are you sure you haven't oversimplified it? Can you run the query that you pasted above on both versions again and make sure you're really getting results that you've described?

Generated at Thu Feb 08 08:45:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.