Debian Codegraph @

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

raw
1 create schema xtest default charset 'utf8mb4';
2 RUN use xtest
3
4 0 rows affected
5 RUN CREATE TABLE `city` (
6 `ID` int(11) NOT NULL auto_increment,
7 `Name` char(35) NOT NULL default '',
8 `CountryCode` char(3) NOT NULL default '',
9 `District` char(20) NOT NULL default '',
10 `Population` int(11) NOT NULL default '0',
11 PRIMARY KEY (`ID`)
12 )
13
14 0 rows affected
15 RUN INSERT INTO `city` VALUES (1,'Kabul','AFG','Kabol',1780000)
16
17 1 rows affected
18 last insert id: 1
19 RUN INSERT INTO `city` VALUES (2,'Qandahar','AFG','Qandahar',237500)
20
21 1 rows affected
22 last insert id: 2
23 RUN INSERT INTO `city` VALUES (3,'Herat','AFG','Herat',186800)
24
25 1 rows affected
26 last insert id: 3
27 RUN INSERT INTO `city` VALUES (4,'Mazar-e-Sharif','AFG','Balkh',127800)
28
29 1 rows affected
30 last insert id: 4
31 RUN INSERT INTO `city` VALUES (5,'Amsterdam','NLD','Noord-Holland',731200)
32
33 1 rows affected
34 last insert id: 5
35 RUN INSERT INTO `city` VALUES (6,'Rotterdam','NLD','Zuid-Holland',593321)
36
37 1 rows affected
38 last insert id: 6
39 RUN INSERT INTO `city` VALUES (7,'Haag','NLD','Zuid-Holland',440900)
40
41 1 rows affected
42 last insert id: 7
43 RUN INSERT INTO `city` VALUES (8,'Utrecht','NLD','Utrecht',234323)
44
45 1 rows affected
46 last insert id: 8
47 RUN INSERT INTO `city` VALUES (9,'Eindhoven','NLD','Noord-Brabant',201843)
48
49 1 rows affected
50 last insert id: 9
51 RUN INSERT INTO `city` VALUES (10,'Tilburg','NLD','Noord-Brabant',193238)
52
53 1 rows affected
54 last insert id: 10
55 RUN INSERT INTO `city` VALUES (11,'Groningen','NLD','Groningen',172701)
56
57 1 rows affected
58 last insert id: 11
59 RUN INSERT INTO `city` VALUES (12,'Breda','NLD','Noord-Brabant',160398)
60
61 1 rows affected
62 last insert id: 12
63 RUN INSERT INTO `city` VALUES (13,'Apeldoorn','NLD','Gelderland',153491)
64
65 1 rows affected
66 last insert id: 13
67 RUN INSERT INTO `city` VALUES (14,'Nijmegen','NLD','Gelderland',152463)
68
69 1 rows affected
70 last insert id: 14
71 RUN INSERT INTO `city` VALUES (15,'Enschede','NLD','Overijssel',149544)
72
73 1 rows affected
74 last insert id: 15
75 RUN INSERT INTO `city` VALUES (16,'Haarlem','NLD','Noord-Holland',148772)
76
77 1 rows affected
78 last insert id: 16
79 send Mysqlx.Crud.Find {
80 collection {
81 name: "city"
82 schema: "xtest"
83 }
84 data_model: DOCUMENT
85 }
86
87 Mysqlx.Error {
88 severity: ERROR
89 code: 5117
90 msg: "Unknown column \'doc\' in collection"
91 sql_state: "HY000"
92 }
93
94 Mysqlx.Ok {
95 msg: "bye!"
96 }
97 ok