Crash if I use an SQL with a reserved word

[usatenko]

Bug Description:

SELECT MIN(ver) AS id FROM table LIMIT 1

in case I use the reserved word "id" in AS ... statement, it crashes manticore.

Manticore Search Version:

6.2.12 dc5144d@230822 (columnar 2.2.4 5aec342@230822) (secondary 2.2.4 5aec342@230822) git branch manticore-6.2.12...origin/manticore-6.2.12

Operating System Version:

6.7.12-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.7.12-1 (2024-04-24) x86_64 GNU/Linux

Have you tried the latest development version?

• Yes

Internal Checklist:

^{To be completed by the assignee. Check off tasks that have been completed or are not applicable.}

• Task estimated
• Specification created, reviewed, and approved
• Implementation completed
• Tests developed
• Documentation updated
• Documentation proofread
• Changelog updated

[sanikolaev]

Thanks. Reproduced in the latest dev version.

MRE

mysql> drop table if exists t; create table t(a int); SELECT MIN(a) AS id FROM t LIMIT 1;
--------------
drop table if exists t
--------------

Query OK, 0 rows affected (0.00 sec)

--------------
create table t(a int)
--------------

Query OK, 0 rows affected (0.01 sec)

--------------
SELECT MIN(a) AS id FROM t LIMIT 1
--------------

ERROR 2013 (HY000): Lost connection to MySQL server during query
No connection. Trying to reconnect...
ERROR 2003 (HY000): Can't connect to MySQL server on '0:9306' (61)
ERROR:
Can't connect to the server

[tomatolog]

the crash was fixed at 8c6cec3

You need to use package from the dev repository to get this crash fixed

[usatenko]

thank you

[sanikolaev]

Updated the changelog. Closing.