diff options
| author | Monty <monty@mariadb.org> | 2021-09-17 16:07:00 +0300 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2021-09-17 16:07:39 +0300 |
| commit | 03a10706ecfa5cf0a6252d436e341483f5c0827c (patch) | |
| tree | 558ae8c0ed6d1cb959e934bd7e2068177a85f58e | |
| parent | a2e55131c64bee63b980e78cec92cf9c4bf1b7ec (diff) | |
| download | mariadb-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.
| -rw-r--r-- | mysql-test/main/alias.result | 12 | ||||
| -rw-r--r-- | mysql-test/main/alias.test | 2 |
2 files changed, 7 insertions, 7 deletions
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; |