Debian Codegraph @

mysql-test/suite/x/r/find_table_find_rows_proj.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: TABLE
85 projection {
86 source {
87 type: IDENT
88 identifier {
89 name: "Name"
90 }
91 }
92 }
93 projection {
94 source {
95 type: IDENT
96 identifier {
97 name: "Population"
98 }
99 }
100 alias: "Pop"
101 }
102 criteria {
103 type: OPERATOR
104 operator {
105 name: "<"
106 param {
107 type: IDENT
108 identifier {
109 name: "Population"
110 }
111 }
112 param {
113 type: LITERAL
114 literal {
115 type: V_SINT
116 v_signed_int: 150000
117 }
118 }
119 }
120 }
121 }
122
123 Mysqlx.Resultset.ColumnMetaData {
124 type: BYTES
125 name: "Name"
126 original_name: "Name"
127 table: "city"
128 original_table: "city"
129 schema: "xtest"
130 catalog: "def"
131 collation: 255
132 length: 140
133 flags: 17
134 }
135
136 Mysqlx.Resultset.ColumnMetaData {
137 type: SINT
138 name: "Pop"
139 original_name: "Population"
140 table: "city"
141 original_table: "city"
142 schema: "xtest"
143 catalog: "def"
144 length: 11
145 flags: 16
146 }
147
148 Mysqlx.Resultset.Row {
149 field: "Mazar-e-Sharif\000"
150 field: "\360\314\017"
151 }
152
153 Mysqlx.Resultset.Row {
154 field: "Enschede\000"
155 field: "\320\240\022"
156 }
157
158 Mysqlx.Resultset.Row {
159 field: "Haarlem\000"
160 field: "\310\224\022"
161 }
162
163 Mysqlx.Resultset.FetchDone {
164 }
165
166 Mysqlx.Sql.StmtExecuteOk {
167 }
168
169 Mysqlx.Ok {
170 msg: "bye!"
171 }
172 ok