summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/type_float.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/type_float.test')
-rw-r--r--mysql-test/main/type_float.test26
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 #