feature: union with constant value dose not supported

[davidshiz]

mysql> CREATE TABLE t1 (a CHAR(6));
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE TABLE t2 (a VARCHAR(8));
Query OK, 0 rows affected (0.01 sec)

mysql> SELECT * FROM t1 UNION SELECT * FROM t2 UNION SELECT 123;
ERROR 6 (HY000): The query includes syntax that is not supported by the storage engine. Either restructure the query with supported syntax, or enable the MySQL core::Query Path in config file to execute the query with reduced performance.

[davidshiz]

union all is also not supported ref #1860

[RingsC]

mysql>  CREATE TABLE t1 (a CHAR(6));
Query OK, 0 rows affected (0.00 sec)

mysql>  CREATE TABLE t2 (a VARCHAR(8));
Query OK, 0 rows affected (0.01 sec)

mysql>  SELECT * FROM t1 UNION SELECT * FROM t2 UNION SELECT 123;
Empty set (2.61 sec)

[haitaoguan]

mysql> show create table x1\G
*************************** 1. row ***************************
       Table: x1
Create Table: CREATE TABLE `x1` (
  `a` char(6) DEFAULT NULL
) ENGINE=TIANMU DEFAULT CHARSET=utf8mb4
1 row in set (0.00 sec)

mysql> show create table x2\G
*************************** 1. row ***************************
       Table: x2
Create Table: CREATE TABLE `x2` (
  `a` varchar(8) DEFAULT NULL
) ENGINE=TIANMU DEFAULT CHARSET=utf8mb4
1 row in set (0.00 sec)

mysql> SELECT * FROM x1 UNION SELECT * FROM x2 UNION SELECT 123;
ERROR 2013 (HY000): Lost connection to MySQL server during query