diff options
Diffstat (limited to 'mysql-test/main/func_math.test')
-rw-r--r-- | mysql-test/main/func_math.test | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/mysql-test/main/func_math.test b/mysql-test/main/func_math.test index 51452d3e6af..c865aa88660 100644 --- a/mysql-test/main/func_math.test +++ b/mysql-test/main/func_math.test @@ -1870,3 +1870,41 @@ DROP TABLE t1,t2; --echo # --echo # End of 10.4 tests --echo # + + +--echo # +--echo # Start of 10.5 tests +--echo # + +--echo # +--echo # MDEV-21278 Assertion `is_unsigned() == attr.unsigned_flag' or Assertion `field.is_sane()' failed +--echo # + +CREATE TABLE t1 (a TIMESTAMP); +INSERT INTO t1 VALUES (NULL),(NULL); +SET SESSION SQL_MODE= 'NO_UNSIGNED_SUBTRACTION'; +--replace_column 1 xxx +SELECT DISTINCT UUID_SHORT() - a FROM t1; +CREATE TABLE t2 AS SELECT DISTINCT UUID_SHORT() - a FROM t1; +SHOW CREATE TABLE t2; +DROP TABLE t2, t1; +SET sql_mode=DEFAULT; + +CREATE TABLE t1 (a TIMESTAMP); +INSERT INTO t1 VALUES (NULL),(NULL); +SET SESSION SQL_MODE= 'NO_UNSIGNED_SUBTRACTION'; +--replace_column 1 xxx +SELECT UUID_SHORT() - a FROM t1; +CREATE TABLE t2 AS SELECT UUID_SHORT() - a FROM t1; +SHOW CREATE TABLE t2; +DROP TABLE t2, t1; + +--echo # +--echo # MDEV-23680 Assertion `data' failed in crcr32_calc_pclmulqdq +--echo # +SELECT CRC32(ExtractValue('<a><b/></a>', '/a/b')) AS f; + + +--echo # +--echo # End of 10.5 tests +--echo # |