summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMonty <monty@mariadb.org>2021-09-21 14:03:24 +0300
committerMonty <monty@mariadb.org>2021-09-21 15:06:22 +0300
commitd6bddfca229c702fba94b5ed5a864d7df130ca3a (patch)
tree94082bc13fc3dbdae684c01a26739ca12ea27943
parenta584117c0c6ce58e665dc84d8005d25403d0d22e (diff)
downloadmariadb-git-d6bddfca229c702fba94b5ed5a864d7df130ca3a.tar.gz
Updated main.alias test to fix max_length
The test will work after libmariadb has been updated to return correct max_length for prepared statements
-rw-r--r--mysql-test/main/alias.result12
-rw-r--r--mysql-test/main/alias.test2
2 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/main/alias.result b/mysql-test/main/alias.result
index 0d14607f613..266991afbec 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<<30),(1<<29);
+insert into t1 values(111111111),(-2147483648);
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 10 Y 32768 0 63
+def test t1 t1 a a1 3 11 11 Y 32768 0 63
a1
-536870912
-1073741824
-536870912
-1073741824
+-2147483648
+111111111
+-2147483648
+111111111
drop table t1,t2;
#
# End of 10.4 tests
diff --git a/mysql-test/main/alias.test b/mysql-test/main/alias.test
index 2408509ba10..881cc34d6c6 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<<30),(1<<29);
+insert into t1 values(111111111),(-2147483648);
insert into t2 values(1),(2);
--enable_metadata
select t1.a as a1 from t1 as t1,t2 order by t2.b,t1.a;