diff options
Diffstat (limited to 'plugin/type_inet/mysql-test/type_inet/type_inet4_mix_datetime.test')
-rw-r--r-- | plugin/type_inet/mysql-test/type_inet/type_inet4_mix_datetime.test | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/plugin/type_inet/mysql-test/type_inet/type_inet4_mix_datetime.test b/plugin/type_inet/mysql-test/type_inet/type_inet4_mix_datetime.test new file mode 100644 index 00000000000..06495e70fef --- /dev/null +++ b/plugin/type_inet/mysql-test/type_inet/type_inet4_mix_datetime.test @@ -0,0 +1,25 @@ +--echo # +--echo # Start of 10.10 tests +--echo # + +--echo # +--echo # MDEV-23287 The INET4 data type +--echo # + +# +# The DATETIME data type has loose control on the incoming data, +# so values like '0.0.0.0' do not fail when get inserted to a DATETIME field. +# Using '99.99.99.99' to make sure the month part is out of the range +# to guarantee the failure. + +CREATE TABLE t1 (target INET4 DEFAULT '99.99.99.99', source DATETIME DEFAULT '2001-01-01 10:20:30'); +--source include/type_mix_incompatible.inc +DROP TABLE t1; + +CREATE TABLE t1 (target DATETIME DEFAULT '2001-01-01 10:20:30', source INET4 DEFAULT '99.99.99.99'); +--source include/type_mix_incompatible.inc +DROP TABLE t1; + +--echo # +--echo # End of 10.10 tests +--echo # |