Debian Codegraph @

mysql-test/suite/x/r/find_funtion_call.result

raw
1 ================================================================================
2 PREAMBLE
3 ================================================================================
4 create user crudfinduser@localhost identified by 'crudfinduser';
5 grant all on *.* to crudfinduser@localhost;
6 RUN DROP SCHEMA if EXISTS minisakila
7
8 0 rows affected
9 RUN CREATE SCHEMA minisakila
10
11 1 rows affected
12 RUN USE minisakila
13
14 0 rows affected
15 RUN DROP TABLE IF EXISTS t_bin
16
17 0 rows affected
18 RUN CREATE TABLE t_bin (
19 _bin binary(255) DEFAULT NULL
20 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
21
22 0 rows affected
23 RUN 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')
24
25 23 rows affected
26 Records: 23 Duplicates: 0 Warnings: 0
27 RUN DROP TABLE IF EXISTS t_bis
28
29 0 rows affected
30 RUN CREATE TABLE t_bis (
31 _bis bigint(20) DEFAULT NULL
32 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
33
34 0 rows affected
35 RUN INSERT INTO t_bis VALUES (NULL),(1),(12),(3)
36
37 4 rows affected
38 Records: 4 Duplicates: 0 Warnings: 0
39 RUN DROP TABLE IF EXISTS t_bit
40
41 0 rows affected
42 RUN CREATE TABLE t_bit (
43 _bit bit(64) DEFAULT NULL
44 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
45
46 0 rows affected
47 RUN 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)
48
49 12 rows affected
50 Records: 12 Duplicates: 0 Warnings: 0
51 RUN DROP TABLE IF EXISTS t_biu
52
53 0 rows affected
54 RUN CREATE TABLE t_biu (
55 _biu bigint(20) unsigned DEFAULT NULL
56 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
57
58 0 rows affected
59 RUN INSERT INTO t_biu VALUES (NULL),(1),(12),(3)
60
61 4 rows affected
62 Records: 4 Duplicates: 0 Warnings: 0
63 RUN DROP TABLE IF EXISTS t_blb
64
65 0 rows affected
66 RUN CREATE TABLE t_blb (
67 _blb blob
68 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
69
70 0 rows affected
71 RUN 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\"')
72
73 23 rows affected
74 Records: 23 Duplicates: 0 Warnings: 0
75 RUN DROP TABLE IF EXISTS t_boo
76
77 0 rows affected
78 RUN CREATE TABLE t_boo (
79 _boo tinyint(1) DEFAULT NULL
80 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
81
82 0 rows affected
83 RUN INSERT INTO t_boo VALUES (NULL),(1),(12),(3)
84
85 4 rows affected
86 Records: 4 Duplicates: 0 Warnings: 0
87 RUN DROP TABLE IF EXISTS t_chr
88
89 0 rows affected
90 RUN CREATE TABLE t_chr (
91 _chr char(255) DEFAULT NULL
92 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
93
94 0 rows affected
95 RUN 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\"')
96
97 23 rows affected
98 Records: 23 Duplicates: 0 Warnings: 0
99 RUN DROP TABLE IF EXISTS t_dat
100
101 0 rows affected
102 RUN CREATE TABLE t_dat (
103 _dat date DEFAULT '2000-01-01'
104 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
105
106 0 rows affected
107 RUN INSERT INTO t_dat VALUES ('2000-01-01'),('2015-01-15'),('2015-05-30'),(NULL)
108
109 4 rows affected
110 Records: 4 Duplicates: 0 Warnings: 0
111 RUN DROP TABLE IF EXISTS t_dec
112
113 0 rows affected
114 RUN CREATE TABLE t_dec (
115 _dec decimal(5,2) DEFAULT NULL
116 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
117
118 0 rows affected
119 RUN INSERT INTO t_dec VALUES (NULL),(1.00),(12.00),(3.14)
120
121 4 rows affected
122 Records: 4 Duplicates: 0 Warnings: 0
123 RUN DROP TABLE IF EXISTS t_dou
124
125 0 rows affected
126 RUN CREATE TABLE t_dou (
127 _dou double DEFAULT NULL
128 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
129
130 0 rows affected
131 RUN INSERT INTO t_dou VALUES (NULL),(1),(12),(3.14)
132
133 4 rows affected
134 Records: 4 Duplicates: 0 Warnings: 0
135 RUN DROP TABLE IF EXISTS t_dtt
136
137 0 rows affected
138 RUN CREATE TABLE t_dtt (
139 _dtt datetime DEFAULT '2000-01-01 00:00:00'
140 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
141
142 0 rows affected
143 RUN 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)
144
145 5 rows affected
146 Records: 5 Duplicates: 0 Warnings: 0
147 RUN DROP TABLE IF EXISTS t_enu
148
149 0 rows affected
150 RUN CREATE TABLE t_enu (
151 _enu enum('a','b','c') DEFAULT NULL
152 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
153
154 0 rows affected
155 RUN INSERT INTO t_enu VALUES (NULL)
156
157 1 rows affected
158 RUN DROP TABLE IF EXISTS t_flo
159
160 0 rows affected
161 RUN CREATE TABLE t_flo (
162 _flo float DEFAULT NULL
163 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
164
165 0 rows affected
166 RUN INSERT INTO t_flo VALUES (NULL),(1),(12),(3.14)
167
168 4 rows affected
169 Records: 4 Duplicates: 0 Warnings: 0
170 RUN DROP TABLE IF EXISTS t_gco
171
172 0 rows affected
173 RUN CREATE TABLE t_gco (
174 _gco geometrycollection DEFAULT NULL
175 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
176
177 0 rows affected
178 RUN INSERT INTO t_gco VALUES (NULL)
179
180 1 rows affected
181 RUN DROP TABLE IF EXISTS t_geo
182
183 0 rows affected
184 RUN CREATE TABLE t_geo (
185 _geo geometry DEFAULT NULL
186 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
187
188 0 rows affected
189 RUN INSERT INTO t_geo VALUES (NULL)
190
191 1 rows affected
192 RUN DROP TABLE IF EXISTS t_ins
193
194 0 rows affected
195 RUN CREATE TABLE t_ins (
196 _ins int(11) DEFAULT NULL
197 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
198
199 0 rows affected
200 RUN INSERT INTO t_ins VALUES (NULL),(1),(12),(3)
201
202 4 rows affected
203 Records: 4 Duplicates: 0 Warnings: 0
204 RUN DROP TABLE IF EXISTS t_inu
205
206 0 rows affected
207 RUN CREATE TABLE t_inu (
208 _inu int(10) unsigned DEFAULT NULL
209 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
210
211 0 rows affected
212 RUN INSERT INTO t_inu VALUES (NULL),(1),(12),(3)
213
214 4 rows affected
215 Records: 4 Duplicates: 0 Warnings: 0
216 RUN DROP TABLE IF EXISTS t_lbb
217
218 0 rows affected
219 RUN CREATE TABLE t_lbb (
220 _lbb longblob
221 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
222
223 0 rows affected
224 RUN 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\"')
225
226 23 rows affected
227 Records: 23 Duplicates: 0 Warnings: 0
228 RUN DROP TABLE IF EXISTS t_lst
229
230 0 rows affected
231 RUN CREATE TABLE t_lst (
232 _lst linestring DEFAULT NULL
233 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
234
235 0 rows affected
236 RUN INSERT INTO t_lst VALUES (NULL)
237
238 1 rows affected
239 RUN DROP TABLE IF EXISTS t_ltx
240
241 0 rows affected
242 RUN CREATE TABLE t_ltx (
243 _ltx longtext
244 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
245
246 0 rows affected
247 RUN 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\"')
248
249 23 rows affected
250 Records: 23 Duplicates: 0 Warnings: 0
251 RUN DROP TABLE IF EXISTS t_mbb
252
253 0 rows affected
254 RUN CREATE TABLE t_mbb (
255 _mbb mediumblob
256 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
257
258 0 rows affected
259 RUN 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\"')
260
261 23 rows affected
262 Records: 23 Duplicates: 0 Warnings: 0
263 RUN DROP TABLE IF EXISTS t_mes
264
265 0 rows affected
266 RUN CREATE TABLE t_mes (
267 _mes mediumint(9) DEFAULT NULL
268 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
269
270 0 rows affected
271 RUN INSERT INTO t_mes VALUES (NULL),(1),(12),(3)
272
273 4 rows affected
274 Records: 4 Duplicates: 0 Warnings: 0
275 RUN DROP TABLE IF EXISTS t_meu
276
277 0 rows affected
278 RUN CREATE TABLE t_meu (
279 _meu mediumint(8) unsigned DEFAULT NULL
280 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
281
282 0 rows affected
283 RUN INSERT INTO t_meu VALUES (NULL),(1),(12),(3)
284
285 4 rows affected
286 Records: 4 Duplicates: 0 Warnings: 0
287 RUN DROP TABLE IF EXISTS t_mls
288
289 0 rows affected
290 RUN CREATE TABLE t_mls (
291 _mls multilinestring DEFAULT NULL
292 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
293
294 0 rows affected
295 RUN INSERT INTO t_mls VALUES (NULL)
296
297 1 rows affected
298 RUN DROP TABLE IF EXISTS t_mpt
299
300 0 rows affected
301 RUN CREATE TABLE t_mpt (
302 _mpt multipoint DEFAULT NULL
303 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
304
305 0 rows affected
306 RUN INSERT INTO t_mpt VALUES (NULL)
307
308 1 rows affected
309 RUN DROP TABLE IF EXISTS t_mpy
310
311 0 rows affected
312 RUN CREATE TABLE t_mpy (
313 _mpy multipolygon DEFAULT NULL
314 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
315
316 0 rows affected
317 RUN INSERT INTO t_mpy VALUES (NULL)
318
319 1 rows affected
320 RUN DROP TABLE IF EXISTS t_mtx
321
322 0 rows affected
323 RUN CREATE TABLE t_mtx (
324 _mtx mediumtext
325 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
326
327 0 rows affected
328 RUN 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\"')
329
330 23 rows affected
331 Records: 23 Duplicates: 0 Warnings: 0
332 RUN DROP TABLE IF EXISTS t_pnt
333
334 0 rows affected
335 RUN CREATE TABLE t_pnt (
336 _pnt point DEFAULT NULL
337 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
338
339 0 rows affected
340 RUN INSERT INTO t_pnt VALUES (NULL)
341
342 1 rows affected
343 RUN DROP TABLE IF EXISTS t_pol
344
345 0 rows affected
346 RUN CREATE TABLE t_pol (
347 _pol polygon DEFAULT NULL
348 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
349
350 0 rows affected
351 RUN INSERT INTO t_pol VALUES (NULL)
352
353 1 rows affected
354 RUN DROP TABLE IF EXISTS t_set
355
356 0 rows affected
357 RUN CREATE TABLE t_set (
358 _set set('a','b','c') DEFAULT NULL
359 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
360
361 0 rows affected
362 RUN INSERT INTO t_set VALUES (NULL)
363
364 1 rows affected
365 RUN DROP TABLE IF EXISTS t_smp
366
367 0 rows affected
368 RUN CREATE TABLE t_smp (
369 _smp timestamp NOT NULL DEFAULT '1999-12-31 18:30:00'
370 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
371
372 0 rows affected
373 RUN 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')
374
375 7 rows affected
376 Records: 7 Duplicates: 0 Warnings: 0
377 RUN DROP TABLE IF EXISTS t_sms
378
379 0 rows affected
380 RUN CREATE TABLE t_sms (
381 _sms smallint(6) DEFAULT NULL
382 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
383
384 0 rows affected
385 RUN INSERT INTO t_sms VALUES (NULL),(1),(12),(3)
386
387 4 rows affected
388 Records: 4 Duplicates: 0 Warnings: 0
389 RUN DROP TABLE IF EXISTS t_smu
390
391 0 rows affected
392 RUN CREATE TABLE t_smu (
393 _smu smallint(5) unsigned DEFAULT NULL
394 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
395
396 0 rows affected
397 RUN INSERT INTO t_smu VALUES (NULL),(1),(12),(3)
398
399 4 rows affected
400 Records: 4 Duplicates: 0 Warnings: 0
401 RUN DROP TABLE IF EXISTS t_tbl
402
403 0 rows affected
404 RUN CREATE TABLE t_tbl (
405 _tbl tinyblob
406 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
407
408 0 rows affected
409 RUN 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\"')
410
411 23 rows affected
412 Records: 23 Duplicates: 0 Warnings: 0
413 RUN DROP TABLE IF EXISTS t_tim
414
415 0 rows affected
416 RUN CREATE TABLE t_tim (
417 _tim time DEFAULT '00:00:00'
418 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
419
420 0 rows affected
421 RUN INSERT INTO t_tim VALUES ('00:00:00'),('23:24:25'),(NULL)
422
423 3 rows affected
424 Records: 3 Duplicates: 0 Warnings: 0
425 RUN DROP TABLE IF EXISTS t_tin
426
427 0 rows affected
428 RUN CREATE TABLE t_tin (
429 _tin tinyint(8) DEFAULT NULL
430 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
431
432 0 rows affected
433 RUN INSERT INTO t_tin VALUES (NULL),(1),(12),(3)
434
435 4 rows affected
436 Records: 4 Duplicates: 0 Warnings: 0
437 RUN DROP TABLE IF EXISTS t_ttx
438
439 0 rows affected
440 RUN CREATE TABLE t_ttx (
441 _ttx tinytext
442 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
443
444 0 rows affected
445 RUN 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\"')
446
447 23 rows affected
448 Records: 23 Duplicates: 0 Warnings: 0
449 RUN DROP TABLE IF EXISTS t_txt
450
451 0 rows affected
452 RUN CREATE TABLE t_txt (
453 _txt text
454 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
455
456 0 rows affected
457 RUN 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\"')
458
459 23 rows affected
460 Records: 23 Duplicates: 0 Warnings: 0
461 RUN DROP TABLE IF EXISTS t_vbn
462
463 0 rows affected
464 RUN CREATE TABLE t_vbn (
465 _vbn varbinary(255) DEFAULT NULL
466 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
467
468 0 rows affected
469 RUN 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\"')
470
471 23 rows affected
472 Records: 23 Duplicates: 0 Warnings: 0
473 RUN DROP TABLE IF EXISTS t_vch
474
475 0 rows affected
476 RUN CREATE TABLE t_vch (
477 _vch varchar(255) DEFAULT NULL
478 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
479
480 0 rows affected
481 RUN 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\"')
482
483 23 rows affected
484 Records: 23 Duplicates: 0 Warnings: 0
485 RUN DROP TABLE IF EXISTS t_yea
486
487 0 rows affected
488 RUN CREATE TABLE t_yea (
489 _yea year(4) DEFAULT NULL
490 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
491
492 0 rows affected
493 RUN INSERT INTO t_yea VALUES (NULL),(2012),(2003)
494
495 3 rows affected
496 Records: 3 Duplicates: 0 Warnings: 0
497 Table based scenarios
498 Find all the rows including all the metadata
499 send Mysqlx.Crud.Find {
500 collection {
501 name: "t_yea"
502 schema: "minisakila"
503 }
504 data_model: TABLE
505 }
506
507 _yea
508 null
509 2012
510 2003
511 command ok
512 Mysqlx.Ok {
513 msg: "bye!"
514 }
515 ok
516 send Mysqlx.Crud.Find {
517 collection {
518 name: "t_bin"
519 schema: "minisakila"
520 }
521 data_model: TABLE
522 projection {
523 source {
524 type: FUNC_CALL
525 function_call {
526 name {
527 name: "COUNT"
528 }
529 param {
530 type: IDENT
531 identifier {
532 name: "_bin"
533 }
534 }
535 }
536 }
537 alias: "count"
538 }
539 }
540
541 count
542 22
543 command ok
544 send Mysqlx.Crud.Find {
545 collection {
546 name: "t_bis"
547 schema: "minisakila"
548 }
549 data_model: TABLE
550 projection {
551 source {
552 type: FUNC_CALL
553 function_call {
554 name {
555 name: "COUNT"
556 }
557 param {
558 type: IDENT
559 identifier {
560 name: "_bis"
561 }
562 }
563 }
564 }
565 alias: "count"
566 }
567 }
568
569 count
570 3
571 command ok
572 send Mysqlx.Crud.Find {
573 collection {
574 name: "t_bit"
575 schema: "minisakila"
576 }
577 data_model: TABLE
578 projection {
579 source {
580 type: FUNC_CALL
581 function_call {
582 name {
583 name: "COUNT"
584 }
585 param {
586 type: IDENT
587 identifier {
588 name: "_bit"
589 }
590 }
591 }
592 }
593 alias: "count"
594 }
595 }
596
597 count
598 11
599 command ok
600 send Mysqlx.Crud.Find {
601 collection {
602 name: "t_biu"
603 schema: "minisakila"
604 }
605 data_model: TABLE
606 projection {
607 source {
608 type: FUNC_CALL
609 function_call {
610 name {
611 name: "COUNT"
612 }
613 param {
614 type: IDENT
615 identifier {
616 name: "_biu"
617 }
618 }
619 }
620 }
621 alias: "count"
622 }
623 }
624
625 count
626 3
627 command ok
628 send Mysqlx.Crud.Find {
629 collection {
630 name: "t_chr"
631 schema: "minisakila"
632 }
633 data_model: TABLE
634 projection {
635 source {
636 type: FUNC_CALL
637 function_call {
638 name {
639 name: "COUNT"
640 }
641 param {
642 type: IDENT
643 identifier {
644 name: "_chr"
645 }
646 }
647 }
648 }
649 alias: "count"
650 }
651 }
652
653 count
654 22
655 command ok
656 send Mysqlx.Crud.Find {
657 collection {
658 name: "t_dat"
659 schema: "minisakila"
660 }
661 data_model: TABLE
662 projection {
663 source {
664 type: FUNC_CALL
665 function_call {
666 name {
667 name: "COUNT"
668 }
669 param {
670 type: IDENT
671 identifier {
672 name: "_dat"
673 }
674 }
675 }
676 }
677 alias: "count"
678 }
679 }
680
681 count
682 3
683 command ok
684 send Mysqlx.Crud.Find {
685 collection {
686 name: "t_dec"
687 schema: "minisakila"
688 }
689 data_model: TABLE
690 projection {
691 source {
692 type: FUNC_CALL
693 function_call {
694 name {
695 name: "COUNT"
696 }
697 param {
698 type: IDENT
699 identifier {
700 name: "_dec"
701 }
702 }
703 }
704 }
705 alias: "count"
706 }
707 }
708
709 count
710 3
711 command ok
712 send Mysqlx.Crud.Find {
713 collection {
714 name: "t_dou"
715 schema: "minisakila"
716 }
717 data_model: TABLE
718 projection {
719 source {
720 type: FUNC_CALL
721 function_call {
722 name {
723 name: "COUNT"
724 }
725 param {
726 type: IDENT
727 identifier {
728 name: "_dou"
729 }
730 }
731 }
732 }
733 alias: "count"
734 }
735 }
736
737 count
738 3
739 command ok
740 send Mysqlx.Crud.Find {
741 collection {
742 name: "t_dtt"
743 schema: "minisakila"
744 }
745 data_model: TABLE
746 projection {
747 source {
748 type: FUNC_CALL
749 function_call {
750 name {
751 name: "COUNT"
752 }
753 param {
754 type: IDENT
755 identifier {
756 name: "_dtt"
757 }
758 }
759 }
760 }
761 alias: "count"
762 }
763 }
764
765 count
766 4
767 command ok
768 send Mysqlx.Crud.Find {
769 collection {
770 name: "t_geo"
771 schema: "minisakila"
772 }
773 data_model: TABLE
774 projection {
775 source {
776 type: FUNC_CALL
777 function_call {
778 name {
779 name: "COUNT"
780 }
781 param {
782 type: IDENT
783 identifier {
784 name: "_geo"
785 }
786 }
787 }
788 }
789 alias: "count"
790 }
791 }
792
793 count
794 0
795 command ok
796 send Mysqlx.Crud.Find {
797 collection {
798 name: "t_inu"
799 schema: "minisakila"
800 }
801 data_model: TABLE
802 projection {
803 source {
804 type: FUNC_CALL
805 function_call {
806 name {
807 name: "COUNT"
808 }
809 param {
810 type: IDENT
811 identifier {
812 name: "_inu"
813 }
814 }
815 }
816 }
817 alias: "count"
818 }
819 }
820
821 count
822 3
823 command ok
824 RUN SHOW STATUS LIKE 'Mysqlx_crud_find'
825 Variable_name Value
826 Mysqlx_crud_find 11
827 0 rows affected
828 send Mysqlx.Crud.Find {
829 collection {
830 name: "t_txt"
831 schema: "minisakila"
832 }
833 data_model: TABLE
834 projection {
835 source {
836 type: FUNC_CALL
837 function_call {
838 name {
839 name: "COUNT"
840 }
841 param {
842 type: IDENT
843 identifier {
844 name: "_txt"
845 }
846 }
847 }
848 }
849 alias: "count"
850 }
851 }
852
853 count
854 22
855 command ok
856 send Mysqlx.Crud.Find {
857 collection {
858 name: "t_set"
859 schema: "minisakila"
860 }
861 data_model: TABLE
862 projection {
863 source {
864 type: FUNC_CALL
865 function_call {
866 name {
867 name: "COUNT"
868 }
869 param {
870 type: IDENT
871 identifier {
872 name: "_set"
873 }
874 }
875 }
876 }
877 alias: "count"
878 }
879 }
880
881 count
882 0
883 command ok
884 RUN SHOW STATUS LIKE 'Mysqlx_crud_find'
885 Variable_name Value
886 Mysqlx_crud_find 13
887 0 rows affected
888 send Mysqlx.Crud.Find {
889 collection {
890 name: "t_tim"
891 schema: "minisakila"
892 }
893 data_model: TABLE
894 projection {
895 source {
896 type: FUNC_CALL
897 function_call {
898 name {
899 name: "COUNT"
900 }
901 param {
902 type: IDENT
903 identifier {
904 name: "_tim"
905 }
906 }
907 }
908 }
909 alias: "count"
910 }
911 }
912
913 count
914 2
915 command ok
916 send Mysqlx.Crud.Find {
917 collection {
918 name: "t_vch"
919 schema: "minisakila"
920 }
921 data_model: TABLE
922 projection {
923 source {
924 type: FUNC_CALL
925 function_call {
926 name {
927 name: "COUNT"
928 }
929 param {
930 type: IDENT
931 identifier {
932 name: "_vch"
933 }
934 }
935 }
936 }
937 alias: "count"
938 }
939 }
940
941 count
942 22
943 command ok
944 RUN SHOW STATUS LIKE 'Mysqlx_crud_find'
945 Variable_name Value
946 Mysqlx_crud_find 15
947 0 rows affected
948 send Mysqlx.Crud.Find {
949 collection {
950 name: "t_dat"
951 schema: "minisakila"
952 }
953 data_model: TABLE
954 projection {
955 source {
956 type: FUNC_CALL
957 function_call {
958 name {
959 name: "DATEDIFF"
960 }
961 param {
962 type: IDENT
963 identifier {
964 name: "_dat"
965 }
966 }
967 param {
968 type: IDENT
969 identifier {
970 name: "_dat"
971 }
972 }
973 }
974 }
975 alias: "DateDiff"
976 }
977 }
978
979 DateDiff
980 0
981 0
982 0
983 null
984 command ok
985 RUN SHOW STATUS LIKE 'Mysqlx_crud_find'
986 Variable_name Value
987 Mysqlx_crud_find 16
988 0 rows affected
989 send Mysqlx.Crud.Find {
990 collection {
991 name: "t_inu"
992 schema: "minisakila"
993 }
994 data_model: TABLE
995 projection {
996 source {
997 type: FUNC_CALL
998 function_call {
999 name {
1000 name: "CONV"
1001 }
1002 param {
1003 type: IDENT
1004 identifier {
1005 name: "_inu"
1006 }
1007 }
1008 param {
1009 type: LITERAL
1010 literal {
1011 type: V_SINT
1012 v_signed_int: 18
1013 }
1014 }
1015 param {
1016 type: LITERAL
1017 literal {
1018 type: V_SINT
1019 v_signed_int: 8
1020 }
1021 }
1022 }
1023 }
1024 alias: "CONV"
1025 }
1026 }
1027
1028 CONV
1029 null
1030 1
1031 24
1032 3
1033 command ok
1034 send Mysqlx.Crud.Find {
1035 collection {
1036 name: "t_inu"
1037 schema: "minisakila"
1038 }
1039 data_model: TABLE
1040 projection {
1041 source {
1042 type: FUNC_CALL
1043 function_call {
1044 name {
1045 name: "COUNT"
1046 }
1047 param {
1048 type: FUNC_CALL
1049 function_call {
1050 name {
1051 name: "DISTINCT"
1052 }
1053 param {
1054 type: IDENT
1055 identifier {
1056 name: "_inu"
1057 }
1058 }
1059 }
1060 }
1061 }
1062 }
1063 }
1064 }
1065
1066 COUNT(DISTINCT(`_inu`))
1067 3
1068 command ok
1069 send Mysqlx.Crud.Find {
1070 collection {
1071 name: "t_dat"
1072 schema: "minisakila"
1073 }
1074 data_model: TABLE
1075 projection {
1076 source {
1077 type: OPERATOR
1078 operator {
1079 name: "date_add"
1080 param {
1081 type: IDENT
1082 identifier {
1083 name: "_dat"
1084 }
1085 }
1086 param {
1087 type: LITERAL
1088 literal {
1089 type: V_SINT
1090 v_signed_int: 31
1091 }
1092 }
1093 param {
1094 type: LITERAL
1095 literal {
1096 type: V_OCTETS
1097 v_octets {
1098 value: "DAY"
1099 }
1100 }
1101 }
1102 }
1103 }
1104 alias: "DateAdd"
1105 }
1106 }
1107
1108 DateAdd
1109 2000-02-01
1110 2015-02-15
1111 2015-06-30
1112 null
1113 command ok
1114 RUN SHOW STATUS LIKE 'Mysqlx_crud_find'
1115 Variable_name Value
1116 Mysqlx_crud_find 19
1117 0 rows affected
1118 RUN DROP SCHEMA IF EXISTS minisakila
1119
1120 41 rows affected
1121 RUN DROP USER crudfinduser@localhost
1122
1123 0 rows affected
1124 Mysqlx.Ok {
1125 msg: "bye!"
1126 }
1127 ok