A cleanup for MDEV-12619 UNION creates excessive integer column types for integer literals

Fixing result set metadata for Item_int to match type_handler(),
i.e. MYSQL_TYPE_LONG for small numbers and MYSQL_TYPE_LONGLONG for big numbers.

1 files changed, 45 insertions, 0 deletions

diff --git a/mysql-test/t/metadata.test b/mysql-test/t/metadata.test
index f5ed65cf7e2..60c7470cb67 100644
--- a/mysql-test/t/metadata.test
+++ b/mysql-test/t/metadata.test
@@ -14,6 +14,51 @@ drop table if exists t1,t2;
 #
 
 select 1, 1.0, -1, "hello", NULL;
+SELECT
+  1 AS c1,
+  11 AS c2,
+  111 AS c3,
+  1111 AS c4,
+  11111 AS c5,
+  111111 AS c6,
+  1111111 AS c7,
+  11111111 AS c8,
+  111111111 AS c9,
+  1111111111 AS c10,
+  11111111111 AS c11,
+  111111111111 AS c12,
+  1111111111111 AS c13,
+  11111111111111 AS c14,
+  111111111111111 AS c15,
+  1111111111111111 AS c16,
+  11111111111111111 AS c17,
+  111111111111111111 AS c18,
+  1111111111111111111 AS c19,
+  11111111111111111111 AS c20,
+  111111111111111111111 AS c21;
+
+SELECT
+  -1 AS c1,
+  -11 AS c2,
+  -111 AS c3,
+  -1111 AS c4,
+  -11111 AS c5,
+  -111111 AS c6,
+  -1111111 AS c7,
+  -11111111 AS c8,
+  -111111111 AS c9,
+  -1111111111 AS c10,
+  -11111111111 AS c11,
+  -111111111111 AS c12,
+  -1111111111111 AS c13,
+  -11111111111111 AS c14,
+  -111111111111111 AS c15,
+  -1111111111111111 AS c16,
+  -11111111111111111 AS c17,
+  -111111111111111111 AS c18,
+  -1111111111111111111 AS c19,
+  -11111111111111111111 AS c20,
+  -111111111111111111111 AS c21;
 
 create table t1 (a tinyint, b smallint, c mediumint, d int, e bigint, f float(3,2), g double(4,3), h decimal(5,4), i year, j date, k timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, l datetime, m enum('a','b'), n set('a','b'), o char(10));
 select * from t1;