Debian Codegraph @

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

raw
1 CREATE SCHEMA xtest DEFAULT CHARSET 'utf8mb4';
2
3 command ok
4 Got expected error (code 0)
5 Tables_in_xtest
6 books
7 0 rows affected
8 Got expected error: Table 'books' already exists (code 1050)
9 Tables_in_xtest
10 books
11 0 rows affected
12
13 command ok
14 Got expected error (code 0)
15 Tables_in_xtest
16 books
17 0 rows affected
18
19 command ok
20
21 command ok
22 Got expected error (code 0)
23 Tables_in_xtest
24 books
25 0 rows affected
26
27 command ok
28
29 command ok
30 Got expected error (code 0)
31 Tables_in_xtest
32 books
33 0 rows affected
34
35 0 rows affected
36 Records: 0 Duplicates: 0 Warnings: 0
37 Got expected error: Table 'xtest.books' exists but is not a collection (code 5156)
38 Tables_in_xtest
39 books
40 0 rows affected
41
42 0 rows affected
43
44 command ok
45 Got expected error (code 0)
46 Tables_in_xtest
47 books
48 0 rows affected
49
50 0 rows affected
51
52 command ok
53 Got expected error (code 0)
54 Tables_in_xtest
55 books
56 0 rows affected
57
58 0 rows affected
59 Records: 0 Duplicates: 0 Warnings: 0
60 Got expected error: Table 'xtest.books' exists but is not a collection (code 5156)
61 Tables_in_xtest
62 books
63 0 rows affected
64
65 0 rows affected
66
67 0 rows affected
68 Got expected error: Table 'xtest.books' exists but is not a collection (code 5156)
69 Tables_in_xtest
70 books
71 0 rows affected
72
73 0 rows affected
74
75 0 rows affected
76 Got expected error: Table 'xtest.books' exists but is not a collection (code 5156)
77 Tables_in_xtest
78 books
79 0 rows affected
80
81 0 rows affected
82
83 0 rows affected
84 Got expected error: Table 'xtest.books' exists but is not a collection (code 5156)
85 Tables_in_xtest
86 books
87 0 rows affected
88 Got expected error: Unknown database 'nowhere' (code 1049)
89 Tables_in_xtest
90 books
91 0 rows affected
92
93 0 rows affected
94 Got expected error: No database selected (code 1046)
95 Tables_in_xtest
96 0 rows affected
97
98 0 rows affected
99
100 command ok
101 Got expected error (code 0)
102 Tables_in_xtest
103 books
104 0 rows affected
105
106 0 rows affected
107 connecting...
108 active session is now 'temp'
109
110 0 rows affected
111
112 command ok
113 Got expected error (code 0)
114 Tables_in_xtest
115 books
116 0 rows affected
117 Field Type Null Key Default Extra
118 it_is_not_collection int YES null NULL
119 0 rows affected
120 closing session temp
121 Mysqlx.Ok {
122 msg: "bye!"
123 }
124 switched to session default
125 Field Type Null Key Default Extra
126 doc json YES null
127 _id varbinary(32) NO PRI null STORED GENERATED
128 _json_schema json YES null VIRTUAL GENERATED
129 0 rows affected
130
131 0 rows affected
132
133 0 rows affected
134
135 0 rows affected
136
137 0 rows affected
138 connecting...
139 active session is now 'unable_to_create'
140 Got expected error: CREATE command denied to user 'unpriv'@'localhost' for table 'books' (code 1142)
141 Tables_in_xtest
142 0 rows affected
143 closing session unable_to_create
144 Mysqlx.Ok {
145 msg: "bye!"
146 }
147 switched to session default
148
149 0 rows affected
150
151 0 rows affected
152
153 0 rows affected
154 connecting...
155 active session is now 'lock'
156 Got expected error: Table 'xtest.books' exists but is not a collection (code 5156)
157 Tables_in_xtest
158 books
159 0 rows affected
160 closing session lock
161 Mysqlx.Ok {
162 msg: "bye!"
163 }
164 switched to session default
165
166 0 rows affected
167 Mysqlx.Ok {
168 msg: "bye!"
169 }
170 ok
171 SHOW STATUS like 'Mysqlx_stmt_create_collection';
172 Variable_name Value
173 Mysqlx_stmt_create_collection 3
174 SHOW STATUS like 'Mysqlx_stmt_ensure_collection';
175 Variable_name Value
176 Mysqlx_stmt_ensure_collection 15
177 SHOW STATUS like 'Mysqlx_stmt_execute_mysqlx';
178 Variable_name Value
179 Mysqlx_stmt_execute_mysqlx 20