1 files changed, 54 insertions, 0 deletions
diff --git a/plugin/type_inet/mysql-test/type_inet/type_inet4_csv.result b/plugin/type_inet/mysql-test/type_inet/type_inet4_csv.result
new file mode 100644
index 00000000000..bfade2b6207
--- /dev/null
+++ b/plugin/type_inet/mysql-test/type_inet/type_inet4_csv.result
@@ -0,0 +1,54 @@
+#
+# Start of 10.10 tests
+#
+#
+# MDEV-23287 The INET4 data type
+#
+SET default_storage_engine=CSV;
+CREATE TABLE t1 (a INET4 NOT NULL);
+SHOW CREATE TABLE t1;
+Table	Create Table
+t1	CREATE TABLE `t1` (
+  `a` inet4 NOT NULL
+) ENGINE=CSV DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
+FOR i IN 0..255
+DO
+INSERT INTO t1 VALUES (CONCAT('0.0.0.', i));
+END FOR
+$$
+SELECT * FROM t1 WHERE a='0.0.0.255';
+a
+0.0.0.255
+SELECT * FROM t1 WHERE a>='0.0.0.254' ORDER BY a;
+a
+0.0.0.254
+0.0.0.255
+SELECT * FROM t1 WHERE a IN ('0.0.0.128','0.0.0.160','0.0.0.240') ORDER BY a;
+a
+0.0.0.128
+0.0.0.160
+0.0.0.240
+SELECT * FROM t1 WHERE a BETWEEN '0.0.0.128' AND '0.0.0.129' ORDER BY a;
+a
+0.0.0.128
+0.0.0.129
+SELECT * FROM t1 WHERE a=CAST('0.0.0.255' AS INET4);
+a
+0.0.0.255
+UPDATE t1 SET a=CONCAT('12', a) WHERE a LIKE '0.0.0.14_';
+SELECT * FROM t1 WHERE a LIKE '12%' ORDER BY a;
+a
+120.0.0.140
+120.0.0.141
+120.0.0.142
+120.0.0.143
+120.0.0.144
+120.0.0.145
+120.0.0.146
+120.0.0.147
+120.0.0.148
+120.0.0.149
+DROP TABLE t1;
+#
+# End of 10.10 tests
+#