Debian Codegraph @

mysql-test/suite/storage_engine/insert.result

raw
1 DROP TABLE IF EXISTS t1, t2;
2 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
3 INSERT INTO t1 VALUES (100,'foobar'),(1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e');
4 SELECT a,b FROM t1;
5 a b
6 1 a
7 100 foobar
8 2 b
9 3 c
10 4 d
11 5 e
12 INSERT t1 VALUE (10,'foo'),(11,'abc');
13 SELECT a,b FROM t1;
14 a b
15 1 a
16 10 foo
17 100 foobar
18 11 abc
19 2 b
20 3 c
21 4 d
22 5 e
23 INSERT INTO t1 (b,a) VALUES ('test',0);
24 SELECT a,b FROM t1;
25 a b
26 0 test
27 1 a
28 10 foo
29 100 foobar
30 11 abc
31 2 b
32 3 c
33 4 d
34 5 e
35 INSERT INTO t1 VALUES (DEFAULT,DEFAULT);
36 SELECT a,b FROM t1;
37 a b
38 0 test
39 1 a
40 10 foo
41 100 foobar
42 11 abc
43 2 b
44 3 c
45 4 d
46 5 e
47 NULL NULL
48 INSERT t1 (a) VALUE (10),(20);
49 SELECT a,b FROM t1;
50 a b
51 0 test
52 1 a
53 10 NULL
54 10 foo
55 100 foobar
56 11 abc
57 2 b
58 20 NULL
59 3 c
60 4 d
61 5 e
62 NULL NULL
63 INSERT INTO t1 SET a = 11, b = 'f';
64 SELECT a,b FROM t1;
65 a b
66 0 test
67 1 a
68 10 NULL
69 10 foo
70 100 foobar
71 11 abc
72 11 f
73 2 b
74 20 NULL
75 3 c
76 4 d
77 5 e
78 NULL NULL
79 INSERT t1 SET b = DEFAULT;
80 SELECT a,b FROM t1;
81 a b
82 0 test
83 1 a
84 10 NULL
85 10 foo
86 100 foobar
87 11 abc
88 11 f
89 2 b
90 20 NULL
91 3 c
92 4 d
93 5 e
94 NULL NULL
95 NULL NULL
96 CREATE TABLE t2 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
97 INSERT INTO t2 SELECT a,b FROM t1;
98 INSERT INTO t1 (a) SELECT a FROM t2 WHERE b = 'foo';
99 SELECT a,b FROM t1;
100 a b
101 0 test
102 1 a
103 10 NULL
104 10 NULL
105 10 foo
106 100 foobar
107 11 abc
108 11 f
109 2 b
110 20 NULL
111 3 c
112 4 d
113 5 e
114 NULL NULL
115 NULL NULL
116 INSERT t1 (a,b) SELECT a,b FROM t1;
117 SELECT a,b FROM t1;
118 a b
119 0 test
120 0 test
121 1 a
122 1 a
123 10 NULL
124 10 NULL
125 10 NULL
126 10 NULL
127 10 foo
128 10 foo
129 100 foobar
130 100 foobar
131 11 abc
132 11 abc
133 11 f
134 11 f
135 2 b
136 2 b
137 20 NULL
138 20 NULL
139 3 c
140 3 c
141 4 d
142 4 d
143 5 e
144 5 e
145 NULL NULL
146 NULL NULL
147 NULL NULL
148 NULL NULL
149 DROP TABLE t1, t2;