diff options
Diffstat (limited to 'plugin/type_inet/mysql-test/type_inet/binlog_stm_type_inet4.result')
| -rw-r--r-- | plugin/type_inet/mysql-test/type_inet/binlog_stm_type_inet4.result | 43 |
1 files changed, 43 insertions, 0 deletions
diff --git a/plugin/type_inet/mysql-test/type_inet/binlog_stm_type_inet4.result b/plugin/type_inet/mysql-test/type_inet/binlog_stm_type_inet4.result new file mode 100644 index 00000000000..81500ee78f4 --- /dev/null +++ b/plugin/type_inet/mysql-test/type_inet/binlog_stm_type_inet4.result @@ -0,0 +1,43 @@ +# +# Start of 10.10 tests +# +# +# MDEV-23287 The INET4 data type +# +CREATE TABLE t1 (a INET4); +INSERT INTO t1 VALUES ('0.0.0.0'); +INSERT INTO t1 VALUES ('255.255.255.255'); +PREPARE stmt FROM 'INSERT INTO t1 VALUES (?)'; +EXECUTE stmt USING CAST('0.0.0.1' AS INET4); +EXECUTE stmt USING CAST(CONCAT(REPEAT(0x00,3), 0x02) AS INET4); +DEALLOCATE PREPARE stmt; +BEGIN NOT ATOMIC +DECLARE a INET4 DEFAULT '0.0.0.3'; +INSERT INTO t1 VALUES (a); +END; +$$ +DROP TABLE t1; +include/show_binlog_events.inc +Log_name Pos Event_type Server_id End_log_pos Info +master-bin.000001 # Gtid # # GTID #-#-# +master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INET4) +master-bin.000001 # Gtid # # BEGIN GTID #-#-# +master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES ('0.0.0.0') +master-bin.000001 # Query # # COMMIT +master-bin.000001 # Gtid # # BEGIN GTID #-#-# +master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES ('255.255.255.255') +master-bin.000001 # Query # # COMMIT +master-bin.000001 # Gtid # # BEGIN GTID #-#-# +master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES ('0.0.0.1') +master-bin.000001 # Query # # COMMIT +master-bin.000001 # Gtid # # BEGIN GTID #-#-# +master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES ('0.0.0.2') +master-bin.000001 # Query # # COMMIT +master-bin.000001 # Gtid # # BEGIN GTID #-#-# +master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES ( NAME_CONST('a','0.0.0.3')) +master-bin.000001 # Query # # COMMIT +master-bin.000001 # Gtid # # GTID #-#-# +master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ +# +# End of 10.10 tests +# |