[MDEV-17862] Incorrect error message when the IN operator is missing in a query Created: 2018-11-28  Updated: 2018-11-29  Resolved: 2018-11-29

Status: Closed
Project: MariaDB Server
Component/s: Parser
Affects Version/s: 10.1.37
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Peter Chaula Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Debian Jessy

Attachments: PNG File mariadb-error.png    

 Description   

When I run the query in the attached image, instead of throwing a syntax error, it throws an error which to me seems inappropriate

 Comments   
Comment by Alice Sherepa [ 2018-11-28 ] 

MariaDB [test]> select * from t1 where transaction id  (2,12);
 
ERROR 1064 (42000): 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 'id  (2,12)' at line 1
 
 
 
MariaDB [test]> select version();
 
+-----------------+
 
| version()       |
 
+-----------------+
 
| 10.1.37-MariaDB |
 
+-----------------+
 
1 row in set (0.00 sec)

The error you get seems to be a result of schema changes (usually solved by running mysql_upgrade)

Comment by Elena Stepanova [ 2018-11-28 ]

The problem should be visible in the error log, please provide it.
Also, even with the wrong structure of mysql.proc, simple select shouldn't touch it. It must be a part of some procedure to make it happen.

Comment by Peter Chaula [ 2018-11-29 ]

Unfortunately I can't reproduce the issue after restarting the docker. We can close this issue. Thank you for looking

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