diff options
Diffstat (limited to 'mysql-test/main/type_float.test')
-rw-r--r-- | mysql-test/main/type_float.test | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/main/type_float.test b/mysql-test/main/type_float.test index 12e3f070..c90d8b8a 100644 --- a/mysql-test/main/type_float.test +++ b/mysql-test/main/type_float.test @@ -717,6 +717,32 @@ DELIMITER ;$$ --horizontal_results --echo # +--echo # MDEV-32645 CAST(AS UNSIGNED) fails with --view-protocol +--echo # + +SELECT + CAST(-1e0 AS UNSIGNED), + CAST(--2e0 AS UNSIGNED), + CAST(---3e0 AS UNSIGNED), + CAST(----4e0 AS UNSIGNED); + +EXPLAIN EXTENDED SELECT + CAST(-1e0 AS UNSIGNED), + CAST(--2e0 AS UNSIGNED), + CAST(---3e0 AS UNSIGNED), + CAST(----4e0 AS UNSIGNED); + +CREATE VIEW v1 AS SELECT + CAST(-1e0 AS UNSIGNED), + CAST(--2e0 AS UNSIGNED), + CAST(---3e0 AS UNSIGNED), + CAST(----4e0 AS UNSIGNED); + +SHOW CREATE VIEW v1; +SELECT * FROM v1; +DROP VIEW v1; + +--echo # --echo # End of 10.4 tests --echo # |