TC is passing with PXC-trunk so the issue seems got fixed by fixes we recently did to CTAS area. Will close the bug.
mysql> CREATE TABLE `Warenkorb_Master` ( -> `id` int(11) NOT NULL AUTO_INCREMENT, -> `Warenkorb_webpage` varchar(255) COLLATE latin1_general_cs NOT NULL, -> `Warenkorb_created_date` varchar(19) COLLATE latin1_general_cs NOT NULL, -> `Warenkorb_order_number` varchar(9) COLLATE latin1_general_cs NOT NULL, -> PRIMARY KEY (`id`), -> KEY `Warenkorb_webpage` (`Warenkorb_webpage`), -> KEY `Warenkorb_order_number` (`Warenkorb_order_number`) -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs; Query OK, 0 rows affected (0.05 sec)
mysql> CREATE TABLE IF NOT EXISTS `Warenkorb_31` AS (SELECT * FROM Warenkorb_Master WHERE 1=2); Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0
mysql> select * from Warenkorb_31; Empty set (0.00 sec)
TC is passing with PXC-trunk so the issue seems got fixed by fixes we recently did to CTAS area.
Will close the bug.
mysql> CREATE TABLE `Warenkorb_Master` ( created_ date` varchar(19) COLLATE latin1_general_cs NOT NULL, order_number` varchar(9) COLLATE latin1_general_cs NOT NULL, webpage` ), order_number` (`Warenkorb_ order_number` ) latin1_ general_ cs;
-> `id` int(11) NOT NULL AUTO_INCREMENT,
-> `Warenkorb_webpage` varchar(255) COLLATE latin1_general_cs NOT NULL,
-> `Warenkorb_
-> `Warenkorb_
-> PRIMARY KEY (`id`),
-> KEY `Warenkorb_webpage` (`Warenkorb_
-> KEY `Warenkorb_
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=
Query OK, 0 rows affected (0.05 sec)
mysql> CREATE TABLE IF NOT EXISTS `Warenkorb_31` AS (SELECT * FROM Warenkorb_Master WHERE 1=2);
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> select * from Warenkorb_31;
Empty set (0.00 sec)