[#MDEV-5082] EXPLAIN INSERT .. VALUES works as INSERT (adds rows to the table)

MariaDB [(none)]> set sql_log_bin=0;

MariaDB [openquery]> select @@version;

+---------------------------+

| @@version                 |

+---------------------------+

| 10.0.21-MariaDB-wsrep-log |

+---------------------------+

1 row in set (0.00 sec)

MariaDB [openquery]> CREATE TEMPORARY TABLE tt_temp    (       id BIGINT   AUTO_INCREMENT PRIMARY KEY ,         value VARCHAR(2)    )  AUTO_INCREMENT = 1;

Query OK, 0 rows affected (0.04 sec)

MariaDB [openquery]>  SELECT * from tt_temp;

Empty set (0.00 sec)

MariaDB [openquery]> EXPLAIN INSERT INTO tt_temp (value) select ('a')  union all select  ('b')  union all select  ('c')  union all select  ('c')  union all select  ('c')  union all select  ('c')  union all select  ('c')  union all select  ('c')  union all select  ('c');

+------+--------------+--------------------------+------+---------------+------+---------+------+------+----------------+

| id   | select_type  | table                    | type | possible_keys | key  | key_len | ref  | rows | Extra          |

+------+--------------+--------------------------+------+---------------+------+---------+------+------+----------------+

|    1 | PRIMARY      | NULL                     | NULL | NULL          | NULL | NULL    | NULL | NULL | No tables used |

|    2 | UNION        | NULL                     | NULL | NULL          | NULL | NULL    | NULL | NULL | No tables used |

|    3 | UNION        | NULL                     | NULL | NULL          | NULL | NULL    | NULL | NULL | No tables used |

|    4 | UNION        | NULL                     | NULL | NULL          | NULL | NULL    | NULL | NULL | No tables used |

|    5 | UNION        | NULL                     | NULL | NULL          | NULL | NULL    | NULL | NULL | No tables used |

|    6 | UNION        | NULL                     | NULL | NULL          | NULL | NULL    | NULL | NULL | No tables used |

|    7 | UNION        | NULL                     | NULL | NULL          | NULL | NULL    | NULL | NULL | No tables used |

|    8 | UNION        | NULL                     | NULL | NULL          | NULL | NULL    | NULL | NULL | No tables used |

|    9 | UNION        | NULL                     | NULL | NULL          | NULL | NULL    | NULL | NULL | No tables used |

| NULL | UNION RESULT | <union1,2,3,4,5,6,7,8,9> | ALL  | NULL          | NULL | NULL    | NULL | NULL |                |

+------+--------------+--------------------------+------+---------------+------+---------+------+------+----------------+

10 rows in set (0.01 sec)

MariaDB [openquery]> SELECT * from tt_temp;

+----+-------+

| id | value |

+----+-------+

|  1 | b     |

|  2 | c     |

|  3 | c     |

|  4 | c     |

|  5 | c     |

|  6 | c     |

|  7 | c     |

|  8 | c     |

+----+-------+

8 rows in set (0.00 sec)

[MDEV-5082] EXPLAIN INSERT .. VALUES works as INSERT (adds rows to the table) Created: 2013-10-01 Updated: 2015-10-26 Resolved: 2015-10-26
Status:	Closed
Project:	MariaDB Server
Component/s:	Optimizer
Affects Version/s:	10.0.21-galera
Fix Version/s:	10.0.5, 10.0.22, 10.1.8

[MDEV-5082] EXPLAIN INSERT .. VALUES works as INSERT (adds rows to the table) Created: 2013-10-01 Updated: 2015-10-26 Resolved: 2015-10-26