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