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