diff options
| author | Alexander Barkov <bar@mariadb.org> | 2017-04-28 16:27:55 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2017-04-28 16:27:55 +0400 |
| commit | ea18b11235448a6416de5ce78792e24861a7a73e (patch) | |
| tree | 9ef3c10ff249a81392aa0572dd4039418b28e305 /mysql-test/t/union.test | |
| parent | a147eea62c7ad0462f1ee85e50c7628a734c33ae (diff) | |
| download | mariadb-git-ea18b11235448a6416de5ce78792e24861a7a73e.tar.gz | |
MDEV-12619 UNION creates excessive integer column types for integer literals
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index fa07dc22dbb..04ab71588be 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -1523,3 +1523,27 @@ SELECT * FROM t1 t1_1 LEFT JOIN t1 t1_2 ON ( t1_2.b = t1_1.a ) WHERE t1_2.b NOT IN ( SELECT 4 UNION ALL SELECT 5 ); DROP TABLE t1; + +--echo # +--echo # Start of 10.3 tests +--echo # + +--echo # +--echo # MDEV-12619 UNION creates excessive integer column types for integer literals +--echo # + +CREATE TABLE t1 AS SELECT 1; +SHOW CREATE TABLE t1; +DROP TABLE t1; + +CREATE OR REPLACE TABLE t1 AS SELECT 1 UNION SELECT 1; +SHOW CREATE TABLE t1; +DROP TABLE t1; + +CREATE OR REPLACE TABLE t1 AS SELECT * FROM (SELECT 1 UNION SELECT 1) AS t0; +SHOW CREATE TABLE t1; +DROP TABLE t1; + +--echo # +--echo # End of 10.3 tests +--echo # |