Debian Codegraph @

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

raw
1 CREATE SCHEMA xtest DEFAULT CHARSET 'utf8mb4';
2 CREATE TABLE xtest.mytable (a INT);
3 CREATE TABLE xtest.mytable2 (a INT, doc JSON);
4 CREATE VIEW xtest.myview AS SELECT 1;
5
6 command ok
7
8 0 rows affected
9
10 0 rows affected
11
12 0 rows affected
13 name type
14 books COLLECTION
15 fakecoll VIEW
16 fakexview VIEW
17 mytable TABLE
18 mytable2 TABLE
19 myview VIEW
20 xdoc COLLECTION_VIEW
21 command ok
22 Got expected error: Unknown database 'invalid' (code 1049)
23 name type
24 mytable TABLE
25 mytable2 TABLE
26 command ok
27 name type
28 command ok
29 Got expected error: No database selected (code 1046)
30
31 0 rows affected
32 name type
33 books COLLECTION
34 fakecoll VIEW
35 fakexview VIEW
36 mytable TABLE
37 mytable2 TABLE
38 myview VIEW
39 xdoc COLLECTION_VIEW
40 command ok
41 name type
42 fakecoll VIEW
43 fakexview VIEW
44 command ok
45
46 0 rows affected
47 Records: 0 Duplicates: 0 Warnings: 0
48 Field Type Null Key Default Extra
49 doc json YES null
50 _id varbinary(32) NO PRI null STORED GENERATED
51 _json_schema json YES null VIRTUAL GENERATED
52 nothing int YES null
53 0 rows affected
54 name type
55 books TABLE
56 command ok
57 name type
58 books TABLE
59 fakecoll VIEW
60 fakexview VIEW
61 mytable TABLE
62 mytable2 TABLE
63 myview VIEW
64 xdoc COLLECTION_VIEW
65 command ok
66
67 0 rows affected
68 name type
69 fakecoll VIEW
70 fakexview VIEW
71 mytable TABLE
72 mytable2 TABLE
73 myview VIEW
74 xdoc COLLECTION_VIEW
75 command ok
76 name type
77 processlist VIEW
78 command ok
79
80 Collection with index
81 ---------------------
82
83 command ok
84
85 command ok
86 name type
87 fruit COLLECTION
88 command ok
89
90 Collection with validation schema
91 ---------------------------------
92
93 command ok
94
95 command ok
96 name type
97 stuff COLLECTION
98 command ok
99
100 Removing `_id` from collection
101 ------------------------------
102
103 0 rows affected
104 Records: 0 Duplicates: 0 Warnings: 0
105 name type
106 fruit TABLE
107 command ok
108
109 Removing `_id` and index from collection
110 ----------------------------------------
111
112 command ok
113 name type
114 fruit TABLE
115 command ok
116 Mysqlx.Ok {
117 msg: "bye!"
118 }
119 ok