[MXS-4483] create table dual - is crashing in maxscale after upgrade Created: 2023-01-21  Updated: 2023-04-13  Resolved: 2023-01-23

Status: Closed
Project: MariaDB MaxScale
Component/s: N/A
Affects Version/s: 6.4.4
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Yakov Kushnirsky Assignee: Johan Wikman
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MXS-4481 Attempting to create a table with the... Closed

 Description   

the following SQL

create table DUAL (DUMMY integer not null, primary key (DUMMY)) engine=InnoDB;

is crashing in maxscale 6.4.4. While DUAL is reserved for special purpose (not to be used as user-defined table), the statement returned error in v.2.5, not a crash.

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 (DUMMY integer not null, primary key (DUMMY)) engine=InnoDB' at line 1

 Comments   
Comment by Yakov Kushnirsky [ 2023-01-21 ]

work-around is easy:

  • use any other name (not a reserve word), e.g. DUAL_1
Generated at Thu Feb 08 04:28:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.