summaryrefslogtreecommitdiff
path: root/mysql-test/main/prepare.test
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2021-07-24 09:18:50 +0200
committerSergei Golubchik <serg@mariadb.org>2021-07-24 10:14:30 +0200
commiteaae13059f413647f8a406b52f212d70dca69661 (patch)
tree8ac8efb616e240431175f962b305d3c7166bcfe8 /mysql-test/main/prepare.test
parent9fde2bbacf79557aa7f0a959a77aa4f6226dc8d9 (diff)
downloadmariadb-git-eaae13059f413647f8a406b52f212d70dca69661.tar.gz
MDEV-25808 PREPARE/EXECUTE makes signed integer out of unsigned
Closes #1844
Diffstat (limited to 'mysql-test/main/prepare.test')
-rw-r--r--mysql-test/main/prepare.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/main/prepare.test b/mysql-test/main/prepare.test
index eaab376a5a2..4d1573eb0c8 100644
--- a/mysql-test/main/prepare.test
+++ b/mysql-test/main/prepare.test
@@ -40,3 +40,15 @@ execute stmt2;
deallocate prepare stmt1;
deallocate prepare stmt2;
drop table t1;
+
+--echo #
+--echo # MDEV-25808 PREPARE/EXECUTE makes signed integer out of unsigned
+--echo #
+prepare p1 from 'select concat(?)';
+execute p1 using 17864960750176564435;
+prepare p1 from 'select SQRT(?) is not null';
+execute p1 using 17864960750176564435;
+
+--echo #
+--echo # End of 10.3 tests
+--echo #