From 03a10706ecfa5cf0a6252d436e341483f5c0827c Mon Sep 17 00:00:00 2001 From: Monty Date: Fri, 17 Sep 2021 16:07:00 +0300 Subject: Fixed alias.test to also works with ps The issue is that max_length for prepared statements are different from normal queries, which can optimize the max_length based on the result length. --- mysql-test/main/alias.result | 12 ++++++------ mysql-test/main/alias.test | 2 +- 2 files changed, 7 insertions(+), 7 deletions(-) (limited to 'mysql-test') diff --git a/mysql-test/main/alias.result b/mysql-test/main/alias.result index d8bb211539f..0d14607f613 100644 --- a/mysql-test/main/alias.result +++ b/mysql-test/main/alias.result @@ -223,16 +223,16 @@ disconnect c1; # create or replace table t1 (a int); create or replace table t2 (b int); -insert into t1 values(1),(2); +insert into t1 values(1<<30),(1<<29); insert into t2 values(1),(2); select t1.a as a1 from t1 as t1,t2 order by t2.b,t1.a; Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr -def test t1 t1 a a1 3 11 1 Y 32768 0 63 +def test t1 t1 a a1 3 11 10 Y 32768 0 63 a1 -1 -2 -1 -2 +536870912 +1073741824 +536870912 +1073741824 drop table t1,t2; # # End of 10.4 tests diff --git a/mysql-test/main/alias.test b/mysql-test/main/alias.test index f0c4e13abfd..2408509ba10 100644 --- a/mysql-test/main/alias.test +++ b/mysql-test/main/alias.test @@ -231,7 +231,7 @@ disconnect c1; --echo # create or replace table t1 (a int); create or replace table t2 (b int); -insert into t1 values(1),(2); +insert into t1 values(1<<30),(1<<29); insert into t2 values(1),(2); --enable_metadata select t1.a as a1 from t1 as t1,t2 order by t2.b,t1.a; -- cgit v1.2.1