Debian Codegraph @

mysql-test/suite/x/t/find_funtion_call.test

raw
1 ########### ../t/find_function_call.test #############
2 ### #
3 ### This test runs aims to run FIND operation statements #
4 ### variant with mysqlxtest client for Table and Document data models. #
5 ### Test covers #
6 ### - find with functions #
7 ### - find with different function argument #
8 ### - find with different data types tables #
9 ### - find with with multiple recursive functions #
10 ### #
11 ########################################################################
12 #
13
14 ## =============================================
15 ##
16 ## CRUD FIND FUNCTION CALL
17 ##
18 ## =============================================
19
20 --echo ================================================================================
21 --echo PREAMBLE
22 --echo ================================================================================
23 --source include/xplugin_preamble.inc
24 create user crudfinduser@localhost identified by 'crudfinduser';
25 grant all on *.* to crudfinduser@localhost;
26
27 ## TEST STARTS HERE
28 --write_file $MYSQL_TMP_DIR/find_function_tables_setup.xpl
29 -->sql
30 DROP SCHEMA if EXISTS minisakila;
31 CREATE SCHEMA minisakila;
32 USE minisakila;
33
34 # Table Setup of different data types
35
36 DROP TABLE IF EXISTS t_bin;
37 CREATE TABLE t_bin (
38 _bin binary(255) DEFAULT NULL
39 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
40 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');
41
42 DROP TABLE IF EXISTS t_bis;
43 CREATE TABLE t_bis (
44 _bis bigint(20) DEFAULT NULL
45 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
46 INSERT INTO t_bis VALUES (NULL),(1),(12),(3);
47
48 DROP TABLE IF EXISTS t_bit;
49 CREATE TABLE t_bit (
50 _bit bit(64) DEFAULT NULL
51 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
52 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);
53
54 DROP TABLE IF EXISTS t_biu;
55 CREATE TABLE t_biu (
56 _biu bigint(20) unsigned DEFAULT NULL
57 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
58 INSERT INTO t_biu VALUES (NULL),(1),(12),(3);
59
60 DROP TABLE IF EXISTS t_blb;
61 CREATE TABLE t_blb (
62 _blb blob
63 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
64 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\"');
65
66 DROP TABLE IF EXISTS t_boo;
67 CREATE TABLE t_boo (
68 _boo tinyint(1) DEFAULT NULL
69 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
70 INSERT INTO t_boo VALUES (NULL),(1),(12),(3);
71
72 DROP TABLE IF EXISTS t_chr;
73 CREATE TABLE t_chr (
74 _chr char(255) DEFAULT NULL
75 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
76 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\"');
77
78 DROP TABLE IF EXISTS t_dat;
79 CREATE TABLE t_dat (
80 _dat date DEFAULT '2000-01-01'
81 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
82 INSERT INTO t_dat VALUES ('2000-01-01'),('2015-01-15'),('2015-05-30'),(NULL);
83
84 DROP TABLE IF EXISTS t_dec;
85 CREATE TABLE t_dec (
86 _dec decimal(5,2) DEFAULT NULL
87 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
88 INSERT INTO t_dec VALUES (NULL),(1.00),(12.00),(3.14);
89
90 DROP TABLE IF EXISTS t_dou;
91 CREATE TABLE t_dou (
92 _dou double DEFAULT NULL
93 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
94 INSERT INTO t_dou VALUES (NULL),(1),(12),(3.14);
95
96 DROP TABLE IF EXISTS t_dtt;
97 CREATE TABLE t_dtt (
98 _dtt datetime DEFAULT '2000-01-01 00:00:00'
99 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
100 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);
101
102 DROP TABLE IF EXISTS t_enu;
103 CREATE TABLE t_enu (
104 _enu enum('a','b','c') DEFAULT NULL
105 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
106 INSERT INTO t_enu VALUES (NULL);
107
108 DROP TABLE IF EXISTS t_flo;
109 CREATE TABLE t_flo (
110 _flo float DEFAULT NULL
111 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
112 INSERT INTO t_flo VALUES (NULL),(1),(12),(3.14);
113
114 DROP TABLE IF EXISTS t_gco;
115 CREATE TABLE t_gco (
116 _gco geometrycollection DEFAULT NULL
117 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
118 INSERT INTO t_gco VALUES (NULL);
119
120 DROP TABLE IF EXISTS t_geo;
121 CREATE TABLE t_geo (
122 _geo geometry DEFAULT NULL
123 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
124 INSERT INTO t_geo VALUES (NULL);
125
126 DROP TABLE IF EXISTS t_ins;
127 CREATE TABLE t_ins (
128 _ins int(11) DEFAULT NULL
129 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
130 INSERT INTO t_ins VALUES (NULL),(1),(12),(3);
131
132 DROP TABLE IF EXISTS t_inu;
133 CREATE TABLE t_inu (
134 _inu int(10) unsigned DEFAULT NULL
135 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
136 INSERT INTO t_inu VALUES (NULL),(1),(12),(3);
137
138 DROP TABLE IF EXISTS t_lbb;
139 CREATE TABLE t_lbb (
140 _lbb longblob
141 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
142 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\"');
143
144 DROP TABLE IF EXISTS t_lst;
145 CREATE TABLE t_lst (
146 _lst linestring DEFAULT NULL
147 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
148 INSERT INTO t_lst VALUES (NULL);
149
150 DROP TABLE IF EXISTS t_ltx;
151 CREATE TABLE t_ltx (
152 _ltx longtext
153 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
154 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\"');
155
156 DROP TABLE IF EXISTS t_mbb;
157 CREATE TABLE t_mbb (
158 _mbb mediumblob
159 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
160 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\"');
161
162 DROP TABLE IF EXISTS t_mes;
163 CREATE TABLE t_mes (
164 _mes mediumint(9) DEFAULT NULL
165 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
166 INSERT INTO t_mes VALUES (NULL),(1),(12),(3);
167
168 DROP TABLE IF EXISTS t_meu;
169 CREATE TABLE t_meu (
170 _meu mediumint(8) unsigned DEFAULT NULL
171 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
172 INSERT INTO t_meu VALUES (NULL),(1),(12),(3);
173
174 DROP TABLE IF EXISTS t_mls;
175 CREATE TABLE t_mls (
176 _mls multilinestring DEFAULT NULL
177 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
178 INSERT INTO t_mls VALUES (NULL);
179
180 DROP TABLE IF EXISTS t_mpt;
181 CREATE TABLE t_mpt (
182 _mpt multipoint DEFAULT NULL
183 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
184 INSERT INTO t_mpt VALUES (NULL);
185
186 DROP TABLE IF EXISTS t_mpy;
187 CREATE TABLE t_mpy (
188 _mpy multipolygon DEFAULT NULL
189 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
190 INSERT INTO t_mpy VALUES (NULL);
191
192 DROP TABLE IF EXISTS t_mtx;
193 CREATE TABLE t_mtx (
194 _mtx mediumtext
195 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
196 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\"');
197
198 DROP TABLE IF EXISTS t_pnt;
199 CREATE TABLE t_pnt (
200 _pnt point DEFAULT NULL
201 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
202 INSERT INTO t_pnt VALUES (NULL);
203
204 DROP TABLE IF EXISTS t_pol;
205 CREATE TABLE t_pol (
206 _pol polygon DEFAULT NULL
207 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
208 INSERT INTO t_pol VALUES (NULL);
209
210 DROP TABLE IF EXISTS t_set;
211 CREATE TABLE t_set (
212 _set set('a','b','c') DEFAULT NULL
213 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
214 INSERT INTO t_set VALUES (NULL);
215
216 DROP TABLE IF EXISTS t_smp;
217 CREATE TABLE t_smp (
218 _smp timestamp NOT NULL DEFAULT '1999-12-31 18:30:00'
219 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
220 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');
221
222 DROP TABLE IF EXISTS t_sms;
223 CREATE TABLE t_sms (
224 _sms smallint(6) DEFAULT NULL
225 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
226 INSERT INTO t_sms VALUES (NULL),(1),(12),(3);
227
228 DROP TABLE IF EXISTS t_smu;
229 CREATE TABLE t_smu (
230 _smu smallint(5) unsigned DEFAULT NULL
231 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
232 INSERT INTO t_smu VALUES (NULL),(1),(12),(3);
233
234 DROP TABLE IF EXISTS t_tbl;
235 CREATE TABLE t_tbl (
236 _tbl tinyblob
237 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
238 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\"');
239
240 DROP TABLE IF EXISTS t_tim;
241 CREATE TABLE t_tim (
242 _tim time DEFAULT '00:00:00'
243 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
244 INSERT INTO t_tim VALUES ('00:00:00'),('23:24:25'),(NULL);
245
246 DROP TABLE IF EXISTS t_tin;
247 CREATE TABLE t_tin (
248 _tin tinyint(8) DEFAULT NULL
249 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
250 INSERT INTO t_tin VALUES (NULL),(1),(12),(3);
251
252 DROP TABLE IF EXISTS t_ttx;
253 CREATE TABLE t_ttx (
254 _ttx tinytext
255 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
256 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\"');
257
258 DROP TABLE IF EXISTS t_txt;
259 CREATE TABLE t_txt (
260 _txt text
261 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
262 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\"');
263
264 DROP TABLE IF EXISTS t_vbn;
265 CREATE TABLE t_vbn (
266 _vbn varbinary(255) DEFAULT NULL
267 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
268 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\"');
269
270 DROP TABLE IF EXISTS t_vch;
271 CREATE TABLE t_vch (
272 _vch varchar(255) DEFAULT NULL
273 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
274 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\"');
275
276 DROP TABLE IF EXISTS t_yea;
277 CREATE TABLE t_yea (
278 _yea year(4) DEFAULT NULL
279 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
280 INSERT INTO t_yea VALUES (NULL),(2012),(2003);
281
282
283 -->endsql
284
285 -->echo Table based scenarios
286
287 -->echo Find all the rows including all the metadata
288 Mysqlx.Crud.Find {
289 collection {
290 name: "t_yea"
291 schema: "minisakila"
292 }
293 data_model: TABLE
294 }
295 -->recvresult
296 EOF
297
298 --exec $MYSQLXTEST -u crudfinduser --password='crudfinduser' --file=$MYSQL_TMP_DIR/find_function_tables_setup.xpl 2>&1
299 --remove_file $MYSQL_TMP_DIR/find_function_tables_setup.xpl
300
301
302
303 --write_file $MYSQL_TMP_DIR/find_functions_test.xpl
304
305 # Checking for the COUNT function on all datatypes Tables
306 #=========================================================
307 #=========================================================
308
309 # Binary datatype
310 #==========================
311 Mysqlx.Crud.Find {
312 collection {
313 name: "t_bin"
314 schema: "minisakila"
315 }
316 data_model: TABLE
317 projection {
318 source {
319 type: FUNC_CALL
320 function_call {
321 name {
322 name: "COUNT"
323 }
324 param {
325 type: IDENT
326 identifier {
327 name: "_bin"
328 }
329 }
330 }
331 }
332 alias: "count"
333 }
334 }
335 -->recvresult
336
337 # Big Int Signed datatype
338 #==========================
339 Mysqlx.Crud.Find {
340 collection {
341 name: "t_bis"
342 schema: "minisakila"
343 }
344 data_model: TABLE
345 projection {
346 source {
347 type: FUNC_CALL
348 function_call {
349 name {
350 name: "COUNT"
351 }
352 param {
353 type: IDENT
354 identifier {
355 name: "_bis"
356 }
357 }
358 }
359 }
360 alias: "count"
361 }
362 }
363 -->recvresult
364
365 # Bit datatype
366 #==========================
367 Mysqlx.Crud.Find {
368 collection {
369 name: "t_bit"
370 schema: "minisakila"
371 }
372 data_model: TABLE
373 projection {
374 source {
375 type: FUNC_CALL
376 function_call {
377 name {
378 name: "COUNT"
379 }
380 param {
381 type: IDENT
382 identifier {
383 name: "_bit"
384 }
385 }
386 }
387 }
388 alias: "count"
389 }
390 }
391 -->recvresult
392
393 # Big Int Unsigned datatype
394 #==========================
395 Mysqlx.Crud.Find {
396 collection {
397 name: "t_biu"
398 schema: "minisakila"
399 }
400 data_model: TABLE
401 projection {
402 source {
403 type: FUNC_CALL
404 function_call {
405 name {
406 name: "COUNT"
407 }
408 param {
409 type: IDENT
410 identifier {
411 name: "_biu"
412 }
413 }
414 }
415 }
416 alias: "count"
417 }
418 }
419 -->recvresult
420
421 # Char datatype
422 #==========================
423 Mysqlx.Crud.Find {
424 collection {
425 name: "t_chr"
426 schema: "minisakila"
427 }
428 data_model: TABLE
429 projection {
430 source {
431 type: FUNC_CALL
432 function_call {
433 name {
434 name: "COUNT"
435 }
436 param {
437 type: IDENT
438 identifier {
439 name: "_chr"
440 }
441 }
442 }
443 }
444 alias: "count"
445 }
446 }
447 -->recvresult
448
449 # Date datatype
450 #==========================
451 Mysqlx.Crud.Find {
452 collection {
453 name: "t_dat"
454 schema: "minisakila"
455 }
456 data_model: TABLE
457 projection {
458 source {
459 type: FUNC_CALL
460 function_call {
461 name {
462 name: "COUNT"
463 }
464 param {
465 type: IDENT
466 identifier {
467 name: "_dat"
468 }
469 }
470 }
471 }
472 alias: "count"
473 }
474 }
475 -->recvresult
476
477 # Decimal datatype
478 #==========================
479 Mysqlx.Crud.Find {
480 collection {
481 name: "t_dec"
482 schema: "minisakila"
483 }
484 data_model: TABLE
485 projection {
486 source {
487 type: FUNC_CALL
488 function_call {
489 name {
490 name: "COUNT"
491 }
492 param {
493 type: IDENT
494 identifier {
495 name: "_dec"
496 }
497 }
498 }
499 }
500 alias: "count"
501 }
502 }
503 -->recvresult
504
505 # Double datatype
506 #==========================
507 Mysqlx.Crud.Find {
508 collection {
509 name: "t_dou"
510 schema: "minisakila"
511 }
512 data_model: TABLE
513 projection {
514 source {
515 type: FUNC_CALL
516 function_call {
517 name {
518 name: "COUNT"
519 }
520 param {
521 type: IDENT
522 identifier {
523 name: "_dou"
524 }
525 }
526 }
527 }
528 alias: "count"
529 }
530 }
531 -->recvresult
532
533 # Datetime datatype
534 #==========================
535 Mysqlx.Crud.Find {
536 collection {
537 name: "t_dtt"
538 schema: "minisakila"
539 }
540 data_model: TABLE
541 projection {
542 source {
543 type: FUNC_CALL
544 function_call {
545 name {
546 name: "COUNT"
547 }
548 param {
549 type: IDENT
550 identifier {
551 name: "_dtt"
552 }
553 }
554 }
555 }
556 alias: "count"
557 }
558 }
559 -->recvresult
560
561
562 # Geometry datatype
563 #==========================
564 Mysqlx.Crud.Find {
565 collection {
566 name: "t_geo"
567 schema: "minisakila"
568 }
569 data_model: TABLE
570 projection {
571 source {
572 type: FUNC_CALL
573 function_call {
574 name {
575 name: "COUNT"
576 }
577 param {
578 type: IDENT
579 identifier {
580 name: "_geo"
581 }
582 }
583 }
584 }
585 alias: "count"
586 }
587 }
588 -->recvresult
589
590 # Int datatype
591 #==========================
592 Mysqlx.Crud.Find {
593 collection {
594 name: "t_inu"
595 schema: "minisakila"
596 }
597 data_model: TABLE
598 projection {
599 source {
600 type: FUNC_CALL
601 function_call {
602 name {
603 name: "COUNT"
604 }
605 param {
606 type: IDENT
607 identifier {
608 name: "_inu"
609 }
610 }
611 }
612 }
613 alias: "count"
614 }
615 }
616 -->recvresult
617
618 -->sql
619 SHOW STATUS LIKE 'Mysqlx_crud_find';
620 -->endsql
621
622
623 # Text datatype
624 #==========================
625 Mysqlx.Crud.Find {
626 collection {
627 name: "t_txt"
628 schema: "minisakila"
629 }
630 data_model: TABLE
631 projection {
632 source {
633 type: FUNC_CALL
634 function_call {
635 name {
636 name: "COUNT"
637 }
638 param {
639 type: IDENT
640 identifier {
641 name: "_txt"
642 }
643 }
644 }
645 }
646 alias: "count"
647 }
648 }
649 -->recvresult
650
651 # Set datatype
652 #==========================
653 Mysqlx.Crud.Find {
654 collection {
655 name: "t_set"
656 schema: "minisakila"
657 }
658 data_model: TABLE
659 projection {
660 source {
661 type: FUNC_CALL
662 function_call {
663 name {
664 name: "COUNT"
665 }
666 param {
667 type: IDENT
668 identifier {
669 name: "_set"
670 }
671 }
672 }
673 }
674 alias: "count"
675 }
676 }
677 -->recvresult
678
679 -->sql
680 SHOW STATUS LIKE 'Mysqlx_crud_find';
681 -->endsql
682
683
684
685 # Time datatype
686 #==========================
687 Mysqlx.Crud.Find {
688 collection {
689 name: "t_tim"
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: "_tim"
704 }
705 }
706 }
707 }
708 alias: "count"
709 }
710 }
711 -->recvresult
712
713 # varchar datatype
714 #==========================
715 Mysqlx.Crud.Find {
716 collection {
717 name: "t_vch"
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: "_vch"
732 }
733 }
734 }
735 }
736 alias: "count"
737 }
738 }
739 -->recvresult
740
741 -->sql
742 SHOW STATUS LIKE 'Mysqlx_crud_find';
743 -->endsql
744
745
746
747 # Checking with Multi Argument Funtions
748 #=========================================================
749 #=========================================================
750
751 # DATEDIFF - 2 Arguments
752 # =======================
753
754 Mysqlx.Crud.Find {
755 collection {
756 name: "t_dat"
757 schema: "minisakila"
758 }
759 data_model: TABLE
760 projection {
761 source {
762 type: FUNC_CALL
763 function_call {
764 name {
765 name: "DATEDIFF"
766 }
767 param {
768 type: IDENT
769 identifier {
770 name: "_dat"
771 }
772 }
773 param {
774 type: IDENT
775 identifier {
776 name: "_dat"
777 }
778 }
779 }
780 }
781 alias: "DateDiff"
782 }
783 }
784 -->recvresult
785
786 -->sql
787 SHOW STATUS LIKE 'Mysqlx_crud_find';
788 -->endsql
789
790
791 # CONV - 3 Arguments
792 # =======================
793
794 Mysqlx.Crud.Find {
795 collection {
796 name: "t_inu"
797 schema: "minisakila"
798 }
799 data_model: TABLE
800 projection {
801 source {
802 type: FUNC_CALL
803 function_call {
804 name {
805 name: "CONV"
806 }
807 param {
808 type: IDENT
809 identifier {
810 name: "_inu"
811 }
812 }
813 param {
814 type: LITERAL
815 literal {
816 type: V_SINT
817 v_signed_int: 18
818
819 }
820 }
821 param {
822 type: LITERAL
823 literal {
824 type: V_SINT
825 v_signed_int: 8
826
827 }
828 }
829 }
830 }
831 alias: "CONV"
832 }
833 }
834 -->recvresult
835
836
837 # Checking with Recursive Funtions
838 #=========================================================
839 #=========================================================
840
841 Mysqlx.Crud.Find {
842 collection {
843 name: "t_inu"
844 schema: "minisakila"
845 }
846 data_model: TABLE
847 projection {
848 source {
849 type: FUNC_CALL
850 function_call {
851 name {
852 name: "COUNT"
853 }
854 param {
855 type: FUNC_CALL
856 function_call {
857 name {
858 name: "DISTINCT"
859 }
860 param {
861 type: IDENT
862 identifier {
863 name: "_inu"
864 }
865 }
866 }
867 }
868 }
869 }
870 }
871 }
872
873 -->recvresult
874
875 # Checking with Funtions which work as Operator
876 #=========================================================
877 #=========================================================
878
879 # DATE_ADD -
880 # =======================
881
882 Mysqlx.Crud.Find {
883 collection {
884 name: "t_dat"
885 schema: "minisakila"
886 }
887 data_model: TABLE
888 projection {
889 source {
890 type: OPERATOR
891 operator {
892 name: "date_add"
893 param {
894 type: IDENT
895 identifier {
896 name: "_dat"
897 }
898 }
899 param {
900 type: LITERAL
901 literal {
902 type: V_SINT
903 v_signed_int: 31
904 }
905 }
906 param {
907 type: LITERAL
908 literal {
909 type: V_OCTETS
910 v_octets {value:"DAY"}
911 }
912 }
913 }
914 }
915 alias: "DateAdd"
916 }
917 }
918 -->recvresult
919
920
921 -->sql
922 SHOW STATUS LIKE 'Mysqlx_crud_find';
923 -->endsql
924
925
926
927 ## Cleanup
928 -->sql
929 DROP SCHEMA IF EXISTS minisakila;
930 DROP USER crudfinduser@localhost;
931 -->endsql
932 EOF
933 --exec $MYSQLXTEST -u crudfinduser --password='crudfinduser' --file=$MYSQL_TMP_DIR/find_functions_test.xpl 2>&1
934
935 ## Cleanup
936 --source ../include/xplugin_cleanup.inc
937