[MXS-4481] Attempting to create a table with the name "DUAL" crashes MaxScale Created: 2023-01-20  Updated: 2023-04-13  Resolved: 2023-01-20

Status: Closed
Project: MariaDB MaxScale
Component/s: qc_sqlite
Affects Version/s: 2.5, 6.4, 22.08
Fix Version/s: 6.4.6, 22.08.5, 23.02.0

Type: Bug Priority: Minor
Reporter: Johan Wikman Assignee: Johan Wikman
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MXS-4483 create table dual - is crashing in ma... Closed

 Description   

A statement like

create table DUAL (f int);

crashes MaxScale. The reason is that DUAL is a "magic" table that can be used when a table is not needed, e.g. select 1 from dual.

The create statement would fail like

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 'DUAL (f int)' at line 1

when executed directly against the server, so the statement is invalid anyway. But MaxScale must obviously not crash.


Generated at Thu Feb 08 04:28:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.