summaryrefslogtreecommitdiff
path: root/mysql-test/main/alias.test
diff options
context:
space:
mode:
authorMonty <monty@mariadb.org>2021-09-17 16:07:00 +0300
committerMonty <monty@mariadb.org>2021-09-17 16:07:39 +0300
commit03a10706ecfa5cf0a6252d436e341483f5c0827c (patch)
tree558ae8c0ed6d1cb959e934bd7e2068177a85f58e /mysql-test/main/alias.test
parenta2e55131c64bee63b980e78cec92cf9c4bf1b7ec (diff)
downloadmariadb-git-03a10706ecfa5cf0a6252d436e341483f5c0827c.tar.gz
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.
Diffstat (limited to 'mysql-test/main/alias.test')
-rw-r--r--mysql-test/main/alias.test2
1 files changed, 1 insertions, 1 deletions
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;