Debian Codegraph @

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

raw
1 ## generated
2 ## Rel: Find on a table as document
3
4 --source include/xplugin_preamble.inc
5 --source include/xplugin_create_user.inc
6
7 create schema xtest default charset 'utf8mb4';
8
9 ## Test starts here
10 --write_file $MYSQL_TMP_DIR/find_table_find_as_doc.xpl
11 ## Test data
12 -->sql
13 use xtest;
14 CREATE TABLE `city` (
15 `ID` int(11) NOT NULL auto_increment,
16 `Name` char(35) NOT NULL default '',
17 `CountryCode` char(3) NOT NULL default '',
18 `District` char(20) NOT NULL default '',
19 `Population` int(11) NOT NULL default '0',
20 PRIMARY KEY (`ID`)
21 );
22 INSERT INTO `city` VALUES (1,'Kabul','AFG','Kabol',1780000);
23 INSERT INTO `city` VALUES (2,'Qandahar','AFG','Qandahar',237500);
24 INSERT INTO `city` VALUES (3,'Herat','AFG','Herat',186800);
25 INSERT INTO `city` VALUES (4,'Mazar-e-Sharif','AFG','Balkh',127800);
26 INSERT INTO `city` VALUES (5,'Amsterdam','NLD','Noord-Holland',731200);
27 INSERT INTO `city` VALUES (6,'Rotterdam','NLD','Zuid-Holland',593321);
28 INSERT INTO `city` VALUES (7,'Haag','NLD','Zuid-Holland',440900);
29 INSERT INTO `city` VALUES (8,'Utrecht','NLD','Utrecht',234323);
30 INSERT INTO `city` VALUES (9,'Eindhoven','NLD','Noord-Brabant',201843);
31 INSERT INTO `city` VALUES (10,'Tilburg','NLD','Noord-Brabant',193238);
32 INSERT INTO `city` VALUES (11,'Groningen','NLD','Groningen',172701);
33 INSERT INTO `city` VALUES (12,'Breda','NLD','Noord-Brabant',160398);
34 INSERT INTO `city` VALUES (13,'Apeldoorn','NLD','Gelderland',153491);
35 INSERT INTO `city` VALUES (14,'Nijmegen','NLD','Gelderland',152463);
36 INSERT INTO `city` VALUES (15,'Enschede','NLD','Overijssel',149544);
37 INSERT INTO `city` VALUES (16,'Haarlem','NLD','Noord-Holland',148772);
38 -->endsql
39
40 Mysqlx.Crud.Find {
41 collection {
42 name: "city"
43 schema: "xtest"
44 }
45 data_model: DOCUMENT
46 }
47
48 ## expect Mysqlx.Error
49 -->recv
50 EOF
51
52 --exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/find_table_find_as_doc.xpl 2>&1
53
54 ## Cleanup
55 --source ../include/xplugin_cleanup.inc