[MXS-1581] CREATE TABLE AS not supported Created: 2017-12-14  Updated: 2017-12-19  Resolved: 2017-12-14

Status: Closed
Project: MariaDB MaxScale
Component/s: avrorouter
Affects Version/s: 2.1.12
Fix Version/s: 2.1.13

Type: Bug Priority: Major
Reporter: markus makela Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None


 Description   

The following SQL causes a debug assertion in 2.1.12 when found in the binary logs.

CREATE TABLE t1(id INT);
 
INSERT INTO t1 VALUES (1);
 
CREATE TABLE t2 AS SELECT * FROM t1;
 
INSERT INTO t2 VALUES (2);



 Comments   
Comment by markus makela [ 2017-12-14 ]

Fixed by ignoring the statement as MaxScale cannot execute the SELECT to generate the table schema.

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