summaryrefslogtreecommitdiff
path: root/plugin/type_inet/mysql-test/type_inet/type_inet4_mix_year.test
diff options
context:
space:
mode:
Diffstat (limited to 'plugin/type_inet/mysql-test/type_inet/type_inet4_mix_year.test')
-rw-r--r--plugin/type_inet/mysql-test/type_inet/type_inet4_mix_year.test19
1 files changed, 19 insertions, 0 deletions
diff --git a/plugin/type_inet/mysql-test/type_inet/type_inet4_mix_year.test b/plugin/type_inet/mysql-test/type_inet/type_inet4_mix_year.test
new file mode 100644
index 00000000000..34d6c1362ed
--- /dev/null
+++ b/plugin/type_inet/mysql-test/type_inet/type_inet4_mix_year.test
@@ -0,0 +1,19 @@
+--echo #
+--echo # Start of 10.10 tests
+--echo #
+
+--echo #
+--echo # MDEV-23287 The INET4 data type
+--echo #
+
+CREATE TABLE t1 (target INET4 DEFAULT '0.0.0.0', source YEAR DEFAULT 0);
+--source include/type_mix_incompatible.inc
+DROP TABLE t1;
+
+CREATE TABLE t1 (target YEAR DEFAULT 0, source INET4 DEFAULT '0.0.0.0');
+--source include/type_mix_incompatible.inc
+DROP TABLE t1;
+
+--echo #
+--echo # End of 10.10 tests
+--echo #