1================================================================================ 2PREAMBLE 3================================================================================ 4install plugin mysqlx soname "mysqlx.so"; 5call mtr.add_suppression("Plugin mysqlx reported: .Failed at SSL configuration: .SSL context is not usable without certificate and private key.."); 6call mtr.add_suppression("Plugin mysqlx reported: .SSL_CTX_load_verify_locations failed."); 7create user crudfinduser@localhost identified by 'crudfinduser'; 8grant all on *.* to crudfinduser@localhost; 9RUN DROP SCHEMA if EXISTS minisakila 10 110 rows affected 12RUN CREATE SCHEMA minisakila 13 141 rows affected 15RUN USE minisakila 16 170 rows affected 18RUN DROP TABLE IF EXISTS t_bin 19 200 rows affected 21RUN CREATE TABLE t_bin ( 22 _bin binary(255) DEFAULT NULL 23) ENGINE=InnoDB DEFAULT CHARSET=latin1 24 250 rows affected 26RUN INSERT INTO t_bin VALUES (NULL),('null\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('true\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('12\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('3.14\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('\"a\"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('\"1\"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('\"3.14\"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('{\"a\": 3}\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('[1, 2]\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('\"b,c\"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('\"b\"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('\"2015-01-15\"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('\"23:24:25.000000\"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('\"2015-01-15 23:24:25.000000\"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('\"base64:type255:AAAAAAEBAAAAAAAAAAAA8D8AAAAAAADwPw==\"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('\"base64:type16:yv4=\"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('\"base64:type13:MTk5Mg==\"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('\"base64:type252:yv66vg==\"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('\"base64:type251:yv66vg==\"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('\"base64:type250:yv66vg==\"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('\"base64:type249:yv66vg==\"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'),('\"base64:type15:Zm9v\"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0') 27 2823 rows affected 29Records: 23 Duplicates: 0 Warnings: 0 30RUN DROP TABLE IF EXISTS t_bis 31 320 rows affected 33RUN CREATE TABLE t_bis ( 34 _bis bigint(20) DEFAULT NULL 35) ENGINE=InnoDB DEFAULT CHARSET=latin1 36 370 rows affected 38RUN INSERT INTO t_bis VALUES (NULL),(1),(12),(3) 39 404 rows affected 41Records: 4 Duplicates: 0 Warnings: 0 42RUN DROP TABLE IF EXISTS t_bit 43 440 rows affected 45RUN CREATE TABLE t_bit ( 46 _bit bit(64) DEFAULT NULL 47) ENGINE=InnoDB DEFAULT CHARSET=latin1 48 490 rows affected 50RUN INSERT INTO t_bit VALUES ('\0\0\0\0null'),('\0\0\0\0true'),('\0\0\0\0\0\012'),('\0\0\0\03.14'),('\0\0\0\0\0\"a\"'),('\0\0\0\0\0\"1\"'),('\0\0\"3.14\"'),('{\"a\": 3}'),('\0\0[1, 2]'),('\0\0\0\"b,c\"'),('\0\0\0\0\0\"b\"'),(NULL) 51 5212 rows affected 53Records: 12 Duplicates: 0 Warnings: 0 54RUN DROP TABLE IF EXISTS t_biu 55 560 rows affected 57RUN CREATE TABLE t_biu ( 58 _biu bigint(20) unsigned DEFAULT NULL 59) ENGINE=InnoDB DEFAULT CHARSET=latin1 60 610 rows affected 62RUN INSERT INTO t_biu VALUES (NULL),(1),(12),(3) 63 644 rows affected 65Records: 4 Duplicates: 0 Warnings: 0 66RUN DROP TABLE IF EXISTS t_blb 67 680 rows affected 69RUN CREATE TABLE t_blb ( 70 _blb blob 71) ENGINE=InnoDB DEFAULT CHARSET=latin1 72 730 rows affected 74RUN INSERT INTO t_blb VALUES (NULL),('null'),('true'),('12'),('3.14'),('\"a\"'),('\"1\"'),('\"3.14\"'),('{\"a\": 3}'),('[1, 2]'),('\"b,c\"'),('\"b\"'),('\"2015-01-15\"'),('\"23:24:25.000000\"'),('\"2015-01-15 23:24:25.000000\"'),('\"base64:type255:AAAAAAEBAAAAAAAAAAAA8D8AAAAAAADwPw==\"'),('\"base64:type16:yv4=\"'),('\"base64:type13:MTk5Mg==\"'),('\"base64:type252:yv66vg==\"'),('\"base64:type251:yv66vg==\"'),('\"base64:type250:yv66vg==\"'),('\"base64:type249:yv66vg==\"'),('\"base64:type15:Zm9v\"') 75 7623 rows affected 77Records: 23 Duplicates: 0 Warnings: 0 78RUN DROP TABLE IF EXISTS t_boo 79 800 rows affected 81RUN CREATE TABLE t_boo ( 82 _boo tinyint(1) DEFAULT NULL 83) ENGINE=InnoDB DEFAULT CHARSET=latin1 84 850 rows affected 86RUN INSERT INTO t_boo VALUES (NULL),(1),(12),(3) 87 884 rows affected 89Records: 4 Duplicates: 0 Warnings: 0 90RUN DROP TABLE IF EXISTS t_chr 91 920 rows affected 93RUN CREATE TABLE t_chr ( 94 _chr char(255) DEFAULT NULL 95) ENGINE=InnoDB DEFAULT CHARSET=latin1 96 970 rows affected 98RUN INSERT INTO t_chr VALUES (NULL),('null'),('true'),('12'),('3.14'),('\"a\"'),('\"1\"'),('\"3.14\"'),('{\"a\": 3}'),('[1, 2]'),('\"b,c\"'),('\"b\"'),('\"2015-01-15\"'),('\"23:24:25.000000\"'),('\"2015-01-15 23:24:25.000000\"'),('\"base64:type255:AAAAAAEBAAAAAAAAAAAA8D8AAAAAAADwPw==\"'),('\"base64:type16:yv4=\"'),('\"base64:type13:MTk5Mg==\"'),('\"base64:type252:yv66vg==\"'),('\"base64:type251:yv66vg==\"'),('\"base64:type250:yv66vg==\"'),('\"base64:type249:yv66vg==\"'),('\"base64:type15:Zm9v\"') 99 10023 rows affected 101Records: 23 Duplicates: 0 Warnings: 0 102RUN DROP TABLE IF EXISTS t_dat 103 1040 rows affected 105RUN CREATE TABLE t_dat ( 106 _dat date DEFAULT '2000-01-01' 107) ENGINE=InnoDB DEFAULT CHARSET=latin1 108 1090 rows affected 110RUN INSERT INTO t_dat VALUES ('2000-01-01'),('2015-01-15'),('2015-05-30'),(NULL) 111 1124 rows affected 113Records: 4 Duplicates: 0 Warnings: 0 114RUN DROP TABLE IF EXISTS t_dec 115 1160 rows affected 117RUN CREATE TABLE t_dec ( 118 _dec decimal(5,2) DEFAULT NULL 119) ENGINE=InnoDB DEFAULT CHARSET=latin1 120 1210 rows affected 122RUN INSERT INTO t_dec VALUES (NULL),(1.00),(12.00),(3.14) 123 1244 rows affected 125Records: 4 Duplicates: 0 Warnings: 0 126RUN DROP TABLE IF EXISTS t_dou 127 1280 rows affected 129RUN CREATE TABLE t_dou ( 130 _dou double DEFAULT NULL 131) ENGINE=InnoDB DEFAULT CHARSET=latin1 132 1330 rows affected 134RUN INSERT INTO t_dou VALUES (NULL),(1),(12),(3.14) 135 1364 rows affected 137Records: 4 Duplicates: 0 Warnings: 0 138RUN DROP TABLE IF EXISTS t_dtt 139 1400 rows affected 141RUN CREATE TABLE t_dtt ( 142 _dtt datetime DEFAULT '2000-01-01 00:00:00' 143) ENGINE=InnoDB DEFAULT CHARSET=latin1 144 1450 rows affected 146RUN INSERT INTO t_dtt VALUES ('2000-01-01 00:00:00'),('2015-01-15 00:00:00'),('2015-05-30 23:24:25'),('2015-01-15 23:24:25'),(NULL) 147 1485 rows affected 149Records: 5 Duplicates: 0 Warnings: 0 150RUN DROP TABLE IF EXISTS t_enu 151 1520 rows affected 153RUN CREATE TABLE t_enu ( 154 _enu enum('a','b','c') DEFAULT NULL 155) ENGINE=InnoDB DEFAULT CHARSET=latin1 156 1570 rows affected 158RUN INSERT INTO t_enu VALUES (NULL) 159 1601 rows affected 161RUN DROP TABLE IF EXISTS t_flo 162 1630 rows affected 164RUN CREATE TABLE t_flo ( 165 _flo float DEFAULT NULL 166) ENGINE=InnoDB DEFAULT CHARSET=latin1 167 1680 rows affected 169RUN INSERT INTO t_flo VALUES (NULL),(1),(12),(3.14) 170 1714 rows affected 172Records: 4 Duplicates: 0 Warnings: 0 173RUN DROP TABLE IF EXISTS t_gco 174 1750 rows affected 176RUN CREATE TABLE t_gco ( 177 _gco geometrycollection DEFAULT NULL 178) ENGINE=InnoDB DEFAULT CHARSET=latin1 179 1800 rows affected 181RUN INSERT INTO t_gco VALUES (NULL) 182 1831 rows affected 184RUN DROP TABLE IF EXISTS t_geo 185 1860 rows affected 187RUN CREATE TABLE t_geo ( 188 _geo geometry DEFAULT NULL 189) ENGINE=InnoDB DEFAULT CHARSET=latin1 190 1910 rows affected 192RUN INSERT INTO t_geo VALUES (NULL) 193 1941 rows affected 195RUN DROP TABLE IF EXISTS t_ins 196 1970 rows affected 198RUN CREATE TABLE t_ins ( 199 _ins int(11) DEFAULT NULL 200) ENGINE=InnoDB DEFAULT CHARSET=latin1 201 2020 rows affected 203RUN INSERT INTO t_ins VALUES (NULL),(1),(12),(3) 204 2054 rows affected 206Records: 4 Duplicates: 0 Warnings: 0 207RUN DROP TABLE IF EXISTS t_inu 208 2090 rows affected 210RUN CREATE TABLE t_inu ( 211 _inu int(10) unsigned DEFAULT NULL 212) ENGINE=InnoDB DEFAULT CHARSET=latin1 213 2140 rows affected 215RUN INSERT INTO t_inu VALUES (NULL),(1),(12),(3) 216 2174 rows affected 218Records: 4 Duplicates: 0 Warnings: 0 219RUN DROP TABLE IF EXISTS t_lbb 220 2210 rows affected 222RUN CREATE TABLE t_lbb ( 223 _lbb longblob 224) ENGINE=InnoDB DEFAULT CHARSET=latin1 225 2260 rows affected 227RUN INSERT INTO t_lbb VALUES (NULL),('null'),('true'),('12'),('3.14'),('\"a\"'),('\"1\"'),('\"3.14\"'),('{\"a\": 3}'),('[1, 2]'),('\"b,c\"'),('\"b\"'),('\"2015-01-15\"'),('\"23:24:25.000000\"'),('\"2015-01-15 23:24:25.000000\"'),('\"base64:type255:AAAAAAEBAAAAAAAAAAAA8D8AAAAAAADwPw==\"'),('\"base64:type16:yv4=\"'),('\"base64:type13:MTk5Mg==\"'),('\"base64:type252:yv66vg==\"'),('\"base64:type251:yv66vg==\"'),('\"base64:type250:yv66vg==\"'),('\"base64:type249:yv66vg==\"'),('\"base64:type15:Zm9v\"') 228 22923 rows affected 230Records: 23 Duplicates: 0 Warnings: 0 231RUN DROP TABLE IF EXISTS t_lst 232 2330 rows affected 234RUN CREATE TABLE t_lst ( 235 _lst linestring DEFAULT NULL 236) ENGINE=InnoDB DEFAULT CHARSET=latin1 237 2380 rows affected 239RUN INSERT INTO t_lst VALUES (NULL) 240 2411 rows affected 242RUN DROP TABLE IF EXISTS t_ltx 243 2440 rows affected 245RUN CREATE TABLE t_ltx ( 246 _ltx longtext 247) ENGINE=InnoDB DEFAULT CHARSET=latin1 248 2490 rows affected 250RUN INSERT INTO t_ltx VALUES (NULL),('null'),('true'),('12'),('3.14'),('\"a\"'),('\"1\"'),('\"3.14\"'),('{\"a\": 3}'),('[1, 2]'),('\"b,c\"'),('\"b\"'),('\"2015-01-15\"'),('\"23:24:25.000000\"'),('\"2015-01-15 23:24:25.000000\"'),('\"base64:type255:AAAAAAEBAAAAAAAAAAAA8D8AAAAAAADwPw==\"'),('\"base64:type16:yv4=\"'),('\"base64:type13:MTk5Mg==\"'),('\"base64:type252:yv66vg==\"'),('\"base64:type251:yv66vg==\"'),('\"base64:type250:yv66vg==\"'),('\"base64:type249:yv66vg==\"'),('\"base64:type15:Zm9v\"') 251 25223 rows affected 253Records: 23 Duplicates: 0 Warnings: 0 254RUN DROP TABLE IF EXISTS t_mbb 255 2560 rows affected 257RUN CREATE TABLE t_mbb ( 258 _mbb mediumblob 259) ENGINE=InnoDB DEFAULT CHARSET=latin1 260 2610 rows affected 262RUN INSERT INTO t_mbb VALUES (NULL),('null'),('true'),('12'),('3.14'),('\"a\"'),('\"1\"'),('\"3.14\"'),('{\"a\": 3}'),('[1, 2]'),('\"b,c\"'),('\"b\"'),('\"2015-01-15\"'),('\"23:24:25.000000\"'),('\"2015-01-15 23:24:25.000000\"'),('\"base64:type255:AAAAAAEBAAAAAAAAAAAA8D8AAAAAAADwPw==\"'),('\"base64:type16:yv4=\"'),('\"base64:type13:MTk5Mg==\"'),('\"base64:type252:yv66vg==\"'),('\"base64:type251:yv66vg==\"'),('\"base64:type250:yv66vg==\"'),('\"base64:type249:yv66vg==\"'),('\"base64:type15:Zm9v\"') 263 26423 rows affected 265Records: 23 Duplicates: 0 Warnings: 0 266RUN DROP TABLE IF EXISTS t_mes 267 2680 rows affected 269RUN CREATE TABLE t_mes ( 270 _mes mediumint(9) DEFAULT NULL 271) ENGINE=InnoDB DEFAULT CHARSET=latin1 272 2730 rows affected 274RUN INSERT INTO t_mes VALUES (NULL),(1),(12),(3) 275 2764 rows affected 277Records: 4 Duplicates: 0 Warnings: 0 278RUN DROP TABLE IF EXISTS t_meu 279 2800 rows affected 281RUN CREATE TABLE t_meu ( 282 _meu mediumint(8) unsigned DEFAULT NULL 283) ENGINE=InnoDB DEFAULT CHARSET=latin1 284 2850 rows affected 286RUN INSERT INTO t_meu VALUES (NULL),(1),(12),(3) 287 2884 rows affected 289Records: 4 Duplicates: 0 Warnings: 0 290RUN DROP TABLE IF EXISTS t_mls 291 2920 rows affected 293RUN CREATE TABLE t_mls ( 294 _mls multilinestring DEFAULT NULL 295) ENGINE=InnoDB DEFAULT CHARSET=latin1 296 2970 rows affected 298RUN INSERT INTO t_mls VALUES (NULL) 299 3001 rows affected 301RUN DROP TABLE IF EXISTS t_mpt 302 3030 rows affected 304RUN CREATE TABLE t_mpt ( 305 _mpt multipoint DEFAULT NULL 306) ENGINE=InnoDB DEFAULT CHARSET=latin1 307 3080 rows affected 309RUN INSERT INTO t_mpt VALUES (NULL) 310 3111 rows affected 312RUN DROP TABLE IF EXISTS t_mpy 313 3140 rows affected 315RUN CREATE TABLE t_mpy ( 316 _mpy multipolygon DEFAULT NULL 317) ENGINE=InnoDB DEFAULT CHARSET=latin1 318 3190 rows affected 320RUN INSERT INTO t_mpy VALUES (NULL) 321 3221 rows affected 323RUN DROP TABLE IF EXISTS t_mtx 324 3250 rows affected 326RUN CREATE TABLE t_mtx ( 327 _mtx mediumtext 328) ENGINE=InnoDB DEFAULT CHARSET=latin1 329 3300 rows affected 331RUN INSERT INTO t_mtx VALUES (NULL),('null'),('true'),('12'),('3.14'),('\"a\"'),('\"1\"'),('\"3.14\"'),('{\"a\": 3}'),('[1, 2]'),('\"b,c\"'),('\"b\"'),('\"2015-01-15\"'),('\"23:24:25.000000\"'),('\"2015-01-15 23:24:25.000000\"'),('\"base64:type255:AAAAAAEBAAAAAAAAAAAA8D8AAAAAAADwPw==\"'),('\"base64:type16:yv4=\"'),('\"base64:type13:MTk5Mg==\"'),('\"base64:type252:yv66vg==\"'),('\"base64:type251:yv66vg==\"'),('\"base64:type250:yv66vg==\"'),('\"base64:type249:yv66vg==\"'),('\"base64:type15:Zm9v\"') 332 33323 rows affected 334Records: 23 Duplicates: 0 Warnings: 0 335RUN DROP TABLE IF EXISTS t_pnt 336 3370 rows affected 338RUN CREATE TABLE t_pnt ( 339 _pnt point DEFAULT NULL 340) ENGINE=InnoDB DEFAULT CHARSET=latin1 341 3420 rows affected 343RUN INSERT INTO t_pnt VALUES (NULL) 344 3451 rows affected 346RUN DROP TABLE IF EXISTS t_pol 347 3480 rows affected 349RUN CREATE TABLE t_pol ( 350 _pol polygon DEFAULT NULL 351) ENGINE=InnoDB DEFAULT CHARSET=latin1 352 3530 rows affected 354RUN INSERT INTO t_pol VALUES (NULL) 355 3561 rows affected 357RUN DROP TABLE IF EXISTS t_set 358 3590 rows affected 360RUN CREATE TABLE t_set ( 361 _set set('a','b','c') DEFAULT NULL 362) ENGINE=InnoDB DEFAULT CHARSET=latin1 363 3640 rows affected 365RUN INSERT INTO t_set VALUES (NULL) 366 3671 rows affected 368RUN DROP TABLE IF EXISTS t_smp 369 3700 rows affected 371RUN CREATE TABLE t_smp ( 372 _smp timestamp NOT NULL DEFAULT '1999-12-31 18:30:00' 373) ENGINE=InnoDB DEFAULT CHARSET=latin1 374 3750 rows affected 376RUN INSERT INTO t_smp VALUES ('1999-12-31 18:30:00'),('2015-01-14 18:30:00'),('2015-05-30 17:54:25'),('2015-01-15 17:54:25'),('2015-05-30 11:30:51'),('2015-05-30 11:30:54'),('2015-05-30 11:30:58') 377 3787 rows affected 379Records: 7 Duplicates: 0 Warnings: 0 380RUN DROP TABLE IF EXISTS t_sms 381 3820 rows affected 383RUN CREATE TABLE t_sms ( 384 _sms smallint(6) DEFAULT NULL 385) ENGINE=InnoDB DEFAULT CHARSET=latin1 386 3870 rows affected 388RUN INSERT INTO t_sms VALUES (NULL),(1),(12),(3) 389 3904 rows affected 391Records: 4 Duplicates: 0 Warnings: 0 392RUN DROP TABLE IF EXISTS t_smu 393 3940 rows affected 395RUN CREATE TABLE t_smu ( 396 _smu smallint(5) unsigned DEFAULT NULL 397) ENGINE=InnoDB DEFAULT CHARSET=latin1 398 3990 rows affected 400RUN INSERT INTO t_smu VALUES (NULL),(1),(12),(3) 401 4024 rows affected 403Records: 4 Duplicates: 0 Warnings: 0 404RUN DROP TABLE IF EXISTS t_tbl 405 4060 rows affected 407RUN CREATE TABLE t_tbl ( 408 _tbl tinyblob 409) ENGINE=InnoDB DEFAULT CHARSET=latin1 410 4110 rows affected 412RUN INSERT INTO t_tbl VALUES (NULL),('null'),('true'),('12'),('3.14'),('\"a\"'),('\"1\"'),('\"3.14\"'),('{\"a\": 3}'),('[1, 2]'),('\"b,c\"'),('\"b\"'),('\"2015-01-15\"'),('\"23:24:25.000000\"'),('\"2015-01-15 23:24:25.000000\"'),('\"base64:type255:AAAAAAEBAAAAAAAAAAAA8D8AAAAAAADwPw==\"'),('\"base64:type16:yv4=\"'),('\"base64:type13:MTk5Mg==\"'),('\"base64:type252:yv66vg==\"'),('\"base64:type251:yv66vg==\"'),('\"base64:type250:yv66vg==\"'),('\"base64:type249:yv66vg==\"'),('\"base64:type15:Zm9v\"') 413 41423 rows affected 415Records: 23 Duplicates: 0 Warnings: 0 416RUN DROP TABLE IF EXISTS t_tim 417 4180 rows affected 419RUN CREATE TABLE t_tim ( 420 _tim time DEFAULT '00:00:00' 421) ENGINE=InnoDB DEFAULT CHARSET=latin1 422 4230 rows affected 424RUN INSERT INTO t_tim VALUES ('00:00:00'),('23:24:25'),(NULL) 425 4263 rows affected 427Records: 3 Duplicates: 0 Warnings: 0 428RUN DROP TABLE IF EXISTS t_tin 429 4300 rows affected 431RUN CREATE TABLE t_tin ( 432 _tin tinyint(8) DEFAULT NULL 433) ENGINE=InnoDB DEFAULT CHARSET=latin1 434 4350 rows affected 436RUN INSERT INTO t_tin VALUES (NULL),(1),(12),(3) 437 4384 rows affected 439Records: 4 Duplicates: 0 Warnings: 0 440RUN DROP TABLE IF EXISTS t_ttx 441 4420 rows affected 443RUN CREATE TABLE t_ttx ( 444 _ttx tinytext 445) ENGINE=InnoDB DEFAULT CHARSET=latin1 446 4470 rows affected 448RUN INSERT INTO t_ttx VALUES (NULL),('null'),('true'),('12'),('3.14'),('\"a\"'),('\"1\"'),('\"3.14\"'),('{\"a\": 3}'),('[1, 2]'),('\"b,c\"'),('\"b\"'),('\"2015-01-15\"'),('\"23:24:25.000000\"'),('\"2015-01-15 23:24:25.000000\"'),('\"base64:type255:AAAAAAEBAAAAAAAAAAAA8D8AAAAAAADwPw==\"'),('\"base64:type16:yv4=\"'),('\"base64:type13:MTk5Mg==\"'),('\"base64:type252:yv66vg==\"'),('\"base64:type251:yv66vg==\"'),('\"base64:type250:yv66vg==\"'),('\"base64:type249:yv66vg==\"'),('\"base64:type15:Zm9v\"') 449 45023 rows affected 451Records: 23 Duplicates: 0 Warnings: 0 452RUN DROP TABLE IF EXISTS t_txt 453 4540 rows affected 455RUN CREATE TABLE t_txt ( 456 _txt text 457) ENGINE=InnoDB DEFAULT CHARSET=latin1 458 4590 rows affected 460RUN INSERT INTO t_txt VALUES (NULL),('null'),('true'),('12'),('3.14'),('\"a\"'),('\"1\"'),('\"3.14\"'),('{\"a\": 3}'),('[1, 2]'),('\"b,c\"'),('\"b\"'),('\"2015-01-15\"'),('\"23:24:25.000000\"'),('\"2015-01-15 23:24:25.000000\"'),('\"base64:type255:AAAAAAEBAAAAAAAAAAAA8D8AAAAAAADwPw==\"'),('\"base64:type16:yv4=\"'),('\"base64:type13:MTk5Mg==\"'),('\"base64:type252:yv66vg==\"'),('\"base64:type251:yv66vg==\"'),('\"base64:type250:yv66vg==\"'),('\"base64:type249:yv66vg==\"'),('\"base64:type15:Zm9v\"') 461 46223 rows affected 463Records: 23 Duplicates: 0 Warnings: 0 464RUN DROP TABLE IF EXISTS t_vbn 465 4660 rows affected 467RUN CREATE TABLE t_vbn ( 468 _vbn varbinary(255) DEFAULT NULL 469) ENGINE=InnoDB DEFAULT CHARSET=latin1 470 4710 rows affected 472RUN INSERT INTO t_vbn VALUES (NULL),('null'),('true'),('12'),('3.14'),('\"a\"'),('\"1\"'),('\"3.14\"'),('{\"a\": 3}'),('[1, 2]'),('\"b,c\"'),('\"b\"'),('\"2015-01-15\"'),('\"23:24:25.000000\"'),('\"2015-01-15 23:24:25.000000\"'),('\"base64:type255:AAAAAAEBAAAAAAAAAAAA8D8AAAAAAADwPw==\"'),('\"base64:type16:yv4=\"'),('\"base64:type13:MTk5Mg==\"'),('\"base64:type252:yv66vg==\"'),('\"base64:type251:yv66vg==\"'),('\"base64:type250:yv66vg==\"'),('\"base64:type249:yv66vg==\"'),('\"base64:type15:Zm9v\"') 473 47423 rows affected 475Records: 23 Duplicates: 0 Warnings: 0 476RUN DROP TABLE IF EXISTS t_vch 477 4780 rows affected 479RUN CREATE TABLE t_vch ( 480 _vch varchar(255) DEFAULT NULL 481) ENGINE=InnoDB DEFAULT CHARSET=latin1 482 4830 rows affected 484RUN INSERT INTO t_vch VALUES (NULL),('null'),('true'),('12'),('3.14'),('\"a\"'),('\"1\"'),('\"3.14\"'),('{\"a\": 3}'),('[1, 2]'),('\"b,c\"'),('\"b\"'),('\"2015-01-15\"'),('\"23:24:25.000000\"'),('\"2015-01-15 23:24:25.000000\"'),('\"base64:type255:AAAAAAEBAAAAAAAAAAAA8D8AAAAAAADwPw==\"'),('\"base64:type16:yv4=\"'),('\"base64:type13:MTk5Mg==\"'),('\"base64:type252:yv66vg==\"'),('\"base64:type251:yv66vg==\"'),('\"base64:type250:yv66vg==\"'),('\"base64:type249:yv66vg==\"'),('\"base64:type15:Zm9v\"') 485 48623 rows affected 487Records: 23 Duplicates: 0 Warnings: 0 488RUN DROP TABLE IF EXISTS t_yea 489 4900 rows affected 491RUN CREATE TABLE t_yea ( 492 _yea year(4) DEFAULT NULL 493) ENGINE=InnoDB DEFAULT CHARSET=latin1 494 4950 rows affected 496RUN INSERT INTO t_yea VALUES (NULL),(2012),(2003) 497 4983 rows affected 499Records: 3 Duplicates: 0 Warnings: 0 500Table based scenarios 501Find all the rows including all the metadata 502send Mysqlx.Crud.Find { 503 collection { 504 name: "t_yea" 505 schema: "minisakila" 506 } 507 data_model: TABLE 508} 509 510_yea 511null 5122012 5132003 514command ok 515Mysqlx.Ok { 516 msg: "bye!" 517} 518ok 519send Mysqlx.Crud.Find { 520 collection { 521 name: "t_bin" 522 schema: "minisakila" 523 } 524 data_model: TABLE 525 projection { 526 source { 527 type: FUNC_CALL 528 function_call { 529 name { 530 name: "COUNT" 531 } 532 param { 533 type: IDENT 534 identifier { 535 name: "_bin" 536 } 537 } 538 } 539 } 540 alias: "count" 541 } 542} 543 544count 54522 546command ok 547send Mysqlx.Crud.Find { 548 collection { 549 name: "t_bis" 550 schema: "minisakila" 551 } 552 data_model: TABLE 553 projection { 554 source { 555 type: FUNC_CALL 556 function_call { 557 name { 558 name: "COUNT" 559 } 560 param { 561 type: IDENT 562 identifier { 563 name: "_bis" 564 } 565 } 566 } 567 } 568 alias: "count" 569 } 570} 571 572count 5733 574command ok 575send Mysqlx.Crud.Find { 576 collection { 577 name: "t_bit" 578 schema: "minisakila" 579 } 580 data_model: TABLE 581 projection { 582 source { 583 type: FUNC_CALL 584 function_call { 585 name { 586 name: "COUNT" 587 } 588 param { 589 type: IDENT 590 identifier { 591 name: "_bit" 592 } 593 } 594 } 595 } 596 alias: "count" 597 } 598} 599 600count 60111 602command ok 603send Mysqlx.Crud.Find { 604 collection { 605 name: "t_biu" 606 schema: "minisakila" 607 } 608 data_model: TABLE 609 projection { 610 source { 611 type: FUNC_CALL 612 function_call { 613 name { 614 name: "COUNT" 615 } 616 param { 617 type: IDENT 618 identifier { 619 name: "_biu" 620 } 621 } 622 } 623 } 624 alias: "count" 625 } 626} 627 628count 6293 630command ok 631send Mysqlx.Crud.Find { 632 collection { 633 name: "t_chr" 634 schema: "minisakila" 635 } 636 data_model: TABLE 637 projection { 638 source { 639 type: FUNC_CALL 640 function_call { 641 name { 642 name: "COUNT" 643 } 644 param { 645 type: IDENT 646 identifier { 647 name: "_chr" 648 } 649 } 650 } 651 } 652 alias: "count" 653 } 654} 655 656count 65722 658command ok 659send Mysqlx.Crud.Find { 660 collection { 661 name: "t_dat" 662 schema: "minisakila" 663 } 664 data_model: TABLE 665 projection { 666 source { 667 type: FUNC_CALL 668 function_call { 669 name { 670 name: "COUNT" 671 } 672 param { 673 type: IDENT 674 identifier { 675 name: "_dat" 676 } 677 } 678 } 679 } 680 alias: "count" 681 } 682} 683 684count 6853 686command ok 687send Mysqlx.Crud.Find { 688 collection { 689 name: "t_dec" 690 schema: "minisakila" 691 } 692 data_model: TABLE 693 projection { 694 source { 695 type: FUNC_CALL 696 function_call { 697 name { 698 name: "COUNT" 699 } 700 param { 701 type: IDENT 702 identifier { 703 name: "_dec" 704 } 705 } 706 } 707 } 708 alias: "count" 709 } 710} 711 712count 7133 714command ok 715send Mysqlx.Crud.Find { 716 collection { 717 name: "t_dou" 718 schema: "minisakila" 719 } 720 data_model: TABLE 721 projection { 722 source { 723 type: FUNC_CALL 724 function_call { 725 name { 726 name: "COUNT" 727 } 728 param { 729 type: IDENT 730 identifier { 731 name: "_dou" 732 } 733 } 734 } 735 } 736 alias: "count" 737 } 738} 739 740count 7413 742command ok 743send Mysqlx.Crud.Find { 744 collection { 745 name: "t_dtt" 746 schema: "minisakila" 747 } 748 data_model: TABLE 749 projection { 750 source { 751 type: FUNC_CALL 752 function_call { 753 name { 754 name: "COUNT" 755 } 756 param { 757 type: IDENT 758 identifier { 759 name: "_dtt" 760 } 761 } 762 } 763 } 764 alias: "count" 765 } 766} 767 768count 7694 770command ok 771send Mysqlx.Crud.Find { 772 collection { 773 name: "t_geo" 774 schema: "minisakila" 775 } 776 data_model: TABLE 777 projection { 778 source { 779 type: FUNC_CALL 780 function_call { 781 name { 782 name: "COUNT" 783 } 784 param { 785 type: IDENT 786 identifier { 787 name: "_geo" 788 } 789 } 790 } 791 } 792 alias: "count" 793 } 794} 795 796count 7970 798command ok 799send Mysqlx.Crud.Find { 800 collection { 801 name: "t_inu" 802 schema: "minisakila" 803 } 804 data_model: TABLE 805 projection { 806 source { 807 type: FUNC_CALL 808 function_call { 809 name { 810 name: "COUNT" 811 } 812 param { 813 type: IDENT 814 identifier { 815 name: "_inu" 816 } 817 } 818 } 819 } 820 alias: "count" 821 } 822} 823 824count 8253 826command ok 827RUN SHOW STATUS LIKE 'Mysqlx_crud_find' 828Variable_name Value 829Mysqlx_crud_find 11 8300 rows affected 831send Mysqlx.Crud.Find { 832 collection { 833 name: "t_txt" 834 schema: "minisakila" 835 } 836 data_model: TABLE 837 projection { 838 source { 839 type: FUNC_CALL 840 function_call { 841 name { 842 name: "COUNT" 843 } 844 param { 845 type: IDENT 846 identifier { 847 name: "_txt" 848 } 849 } 850 } 851 } 852 alias: "count" 853 } 854} 855 856count 85722 858command ok 859send Mysqlx.Crud.Find { 860 collection { 861 name: "t_set" 862 schema: "minisakila" 863 } 864 data_model: TABLE 865 projection { 866 source { 867 type: FUNC_CALL 868 function_call { 869 name { 870 name: "COUNT" 871 } 872 param { 873 type: IDENT 874 identifier { 875 name: "_set" 876 } 877 } 878 } 879 } 880 alias: "count" 881 } 882} 883 884count 8850 886command ok 887RUN SHOW STATUS LIKE 'Mysqlx_crud_find' 888Variable_name Value 889Mysqlx_crud_find 13 8900 rows affected 891send Mysqlx.Crud.Find { 892 collection { 893 name: "t_tim" 894 schema: "minisakila" 895 } 896 data_model: TABLE 897 projection { 898 source { 899 type: FUNC_CALL 900 function_call { 901 name { 902 name: "COUNT" 903 } 904 param { 905 type: IDENT 906 identifier { 907 name: "_tim" 908 } 909 } 910 } 911 } 912 alias: "count" 913 } 914} 915 916count 9172 918command ok 919send Mysqlx.Crud.Find { 920 collection { 921 name: "t_vch" 922 schema: "minisakila" 923 } 924 data_model: TABLE 925 projection { 926 source { 927 type: FUNC_CALL 928 function_call { 929 name { 930 name: "COUNT" 931 } 932 param { 933 type: IDENT 934 identifier { 935 name: "_vch" 936 } 937 } 938 } 939 } 940 alias: "count" 941 } 942} 943 944count 94522 946command ok 947RUN SHOW STATUS LIKE 'Mysqlx_crud_find' 948Variable_name Value 949Mysqlx_crud_find 15 9500 rows affected 951send Mysqlx.Crud.Find { 952 collection { 953 name: "t_dat" 954 schema: "minisakila" 955 } 956 data_model: TABLE 957 projection { 958 source { 959 type: FUNC_CALL 960 function_call { 961 name { 962 name: "DATEDIFF" 963 } 964 param { 965 type: IDENT 966 identifier { 967 name: "_dat" 968 } 969 } 970 param { 971 type: IDENT 972 identifier { 973 name: "_dat" 974 } 975 } 976 } 977 } 978 alias: "DateDiff" 979 } 980} 981 982DateDiff 9830 9840 9850 986null 987command ok 988RUN SHOW STATUS LIKE 'Mysqlx_crud_find' 989Variable_name Value 990Mysqlx_crud_find 16 9910 rows affected 992send Mysqlx.Crud.Find { 993 collection { 994 name: "t_inu" 995 schema: "minisakila" 996 } 997 data_model: TABLE 998 projection { 999 source { 1000 type: FUNC_CALL 1001 function_call { 1002 name { 1003 name: "CONV" 1004 } 1005 param { 1006 type: IDENT 1007 identifier { 1008 name: "_inu" 1009 } 1010 } 1011 param { 1012 type: LITERAL 1013 literal { 1014 type: V_SINT 1015 v_signed_int: 18 1016 } 1017 } 1018 param { 1019 type: LITERAL 1020 literal { 1021 type: V_SINT 1022 v_signed_int: 8 1023 } 1024 } 1025 } 1026 } 1027 alias: "CONV" 1028 } 1029} 1030 1031CONV 1032null 10331 103424 10353 1036command ok 1037send Mysqlx.Crud.Find { 1038 collection { 1039 name: "t_inu" 1040 schema: "minisakila" 1041 } 1042 data_model: TABLE 1043 projection { 1044 source { 1045 type: FUNC_CALL 1046 function_call { 1047 name { 1048 name: "COUNT" 1049 } 1050 param { 1051 type: FUNC_CALL 1052 function_call { 1053 name { 1054 name: "DISTINCT" 1055 } 1056 param { 1057 type: IDENT 1058 identifier { 1059 name: "_inu" 1060 } 1061 } 1062 } 1063 } 1064 } 1065 } 1066 } 1067} 1068 1069COUNT(DISTINCT(`_inu`)) 10703 1071command ok 1072send Mysqlx.Crud.Find { 1073 collection { 1074 name: "t_dat" 1075 schema: "minisakila" 1076 } 1077 data_model: TABLE 1078 projection { 1079 source { 1080 type: OPERATOR 1081 operator { 1082 name: "date_add" 1083 param { 1084 type: IDENT 1085 identifier { 1086 name: "_dat" 1087 } 1088 } 1089 param { 1090 type: LITERAL 1091 literal { 1092 type: V_SINT 1093 v_signed_int: 31 1094 } 1095 } 1096 param { 1097 type: LITERAL 1098 literal { 1099 type: V_OCTETS 1100 v_octets { 1101 value: "DAY" 1102 } 1103 } 1104 } 1105 } 1106 } 1107 alias: "DateAdd" 1108 } 1109} 1110 1111DateAdd 11122000/02/01 00:00:00 11132015/02/15 00:00:00 11142015/06/30 00:00:00 1115null 1116command ok 1117RUN SHOW STATUS LIKE 'Mysqlx_crud_find' 1118Variable_name Value 1119Mysqlx_crud_find 19 11200 rows affected 1121RUN DROP SCHEMA IF EXISTS minisakila 1122 112341 rows affected 1124RUN DROP USER crudfinduser@localhost 1125 11260 rows affected 1127Mysqlx.Ok { 1128 msg: "bye!" 1129} 1130ok 1131uninstall plugin mysqlx; 1132