Debian Codegraph @

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

raw
1 CREATE SCHEMA xtest;
2 USE xtest;
3 CREATE TABLE xtable (phrase VARCHAR(30));
4 INSERT INTO xtable (phrase) VALUES ('Alice has a cat');
5 send Mysqlx.Crud.Find {
6 collection {
7 name: "xtable"
8 schema: "xtest"
9 }
10 data_model: TABLE
11 projection {
12 source {
13 type: FUNC_CALL
14 function_call {
15 name {
16 name: "count"
17 }
18 param {
19 type: LITERAL
20 literal {
21 type: V_OCTETS
22 v_octets {
23 value: "*"
24 }
25 }
26 }
27 }
28 }
29 }
30 }
31
32 count('*')
33 1
34 command ok
35 send Mysqlx.Crud.Find {
36 collection {
37 name: "xtable"
38 schema: "xtest"
39 }
40 data_model: TABLE
41 projection {
42 source {
43 type: FUNC_CALL
44 function_call {
45 name {
46 name: "count"
47 }
48 param {
49 type: OPERATOR
50 operator {
51 name: "*"
52 }
53 }
54 }
55 }
56 }
57 }
58
59 count(*)
60 1
61 command ok
62 send Mysqlx.Crud.Find {
63 collection {
64 name: "xtable"
65 schema: "xtest"
66 }
67 data_model: TABLE
68 projection {
69 source {
70 type: LITERAL
71 literal {
72 type: V_OCTETS
73 v_octets {
74 value: "*"
75 }
76 }
77 }
78 }
79 }
80
81 *
82 *
83 command ok
84 send Mysqlx.Crud.Find {
85 collection {
86 name: "xtable"
87 schema: "xtest"
88 }
89 data_model: TABLE
90 projection {
91 source {
92 type: OPERATOR
93 operator {
94 name: "*"
95 }
96 }
97 }
98 }
99
100 phrase
101 Alice has a cat
102 command ok
103 Mysqlx.Ok {
104 msg: "bye!"
105 }
106 ok