Comment 6 for bug 1126207

Revision history for this message
Krunal Bauskar (krunal-bauskar) wrote :

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)