1## Check column metadata
2--source ../include/xplugin_preamble.inc
3
4DROP SCHEMA IF EXISTS xtest;
5CREATE SCHEMA xtest;
6CREATE TABLE xtest.xtable (x INT AUTO_INCREMENT PRIMARY KEY, y VARCHAR(1) NOT NULL, z INT UNSIGNED UNIQUE);
7INSERT INTO xtest.xtable VALUES (1,2,3);
8
9CREATE TABLE xtest.ytable (a INT ZEROFILL, b TIMESTAMP, c FLOAT UNSIGNED, INDEX(a));
10INSERT INTO xtest.ytable VALUES (1,'2015-02-15',3);
11
12## Test starts here
13--write_file $MYSQL_TMP_DIR/crud_resultset_metadata.tmp
14## Test data
15-->quiet
16-->macro Select %TABLE%
17Mysqlx.Crud.Find {
18  collection {
19    name: "%TABLE%"
20    schema: "xtest"
21  }
22  data_model: TABLE
23}
24-->recvresult print-columnsinfo
25-->endmacro
26
27-->callmacro Select xtable
28-->callmacro Select ytable
29EOF
30
31--exec $MYSQLXTEST -uroot --password='' --file=$MYSQL_TMP_DIR/crud_resultset_metadata.tmp 2>&1
32
33
34## Cleanup
35--remove_file $MYSQL_TMP_DIR/crud_resultset_metadata.tmp
36
37## Postamble
38DROP SCHEMA IF EXISTS xtest;
39UNINSTALL PLUGIN mysqlx;
40