Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.0.8
-
None
Description
With the following table definitions:
CREATE TABLE `airlines` (
|
`iata_code` char(2) NOT NULL,
|
`airline` varchar(30) DEFAULT NULL,
|
PRIMARY KEY (`iata_code`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8
|
|
|
CREATE TABLE `_airlines_new` (
|
`iata_code` char(2) NOT NULL,
|
`airline` varchar(30) DEFAULT NULL,
|
PRIMARY KEY (`iata_code`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8
|
|
|
insert into airlines values ('UA', 'United');
|
insert low priority ignore into select issues a warning referencing a columnstore temp table which shouldn't happen since both tables are innodb.
MariaDB [iflights]> INSERT LOW_PRIORITY IGNORE INTO `iflights`.`_airlines_new` (`iata_code`, `airline`) SELECT `iata_code`, `airline` FROM `iflights`.`airlines`;
|
Query OK, 14 rows affected, 1 warning (0.01 sec)
|
Records: 14 Duplicates: 0 Warnings: 1
|
|
|
MariaDB [iflights]> show warnings
|
-> ;
|
+-------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Level | Code | Message |
|
+-------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Note | 1051 | Unknown table 'infinidb_vtable.$vtable_21' |
|
| Note | 1592 | Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT IGNORE... SELECT is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are ignored. This order cannot be predicted and may differ on master and the slave. |
|
+-------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
2 rows in set (0.00 sec)
|
|
|
MariaDB [iflights]> truncate table _airlines_new;
|
Query OK, 0 rows affected (0.03 sec)
|
|
|
MariaDB [iflights]> INSERT LOW_PRIORITY INTO `iflights`.`_airlines_new` (`iata_code`, `airline`) SELECT `iata_code`, `airline` FROM `iflights`.`airlines`;
|
Query OK, 14 rows affected (0.00 sec)
|
Records: 14 Duplicates: 0 Warnings: 0
|