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.test | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'mysql-test/main/alias.test') 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