Debian Codegraph @

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

raw
1 create schema xtest default charset='utf8mb4';
2 RUN use xtest
3
4 0 rows affected
5 RUN create table mytable (i int NOT NULL, ui int unsigned, vc varchar(100), f float, d double, dt datetime, ts timestamp(5), j json)
6
7 0 rows affected
8 send Mysqlx.Crud.Insert {
9 collection {
10 name: "mytable"
11 schema: "xtest"
12 }
13 data_model: TABLE
14 projection {
15 name: "badcol"
16 }
17 projection {
18 name: "ui"
19 }
20 projection {
21 name: "vc"
22 }
23 projection {
24 name: "f"
25 }
26 projection {
27 name: "d"
28 }
29 projection {
30 name: "dt"
31 }
32 projection {
33 name: "ts"
34 }
35 projection {
36 name: "j"
37 }
38 row {
39 field {
40 type: LITERAL
41 literal {
42 type: V_SINT
43 v_signed_int: -100
44 }
45 }
46 field {
47 type: LITERAL
48 literal {
49 type: V_UINT
50 v_unsigned_int: 100
51 }
52 }
53 field {
54 type: LITERAL
55 literal {
56 type: V_STRING
57 v_string {
58 value: ""
59 }
60 }
61 }
62 field {
63 type: LITERAL
64 literal {
65 type: V_FLOAT
66 v_float: 0.333333
67 }
68 }
69 field {
70 type: LITERAL
71 literal {
72 type: V_DOUBLE
73 v_double: 0.333333333333
74 }
75 }
76 field {
77 type: LITERAL
78 literal {
79 type: V_STRING
80 v_string {
81 value: "2015-05-05 1:20:30"
82 }
83 }
84 }
85 field {
86 type: LITERAL
87 literal {
88 type: V_STRING
89 v_string {
90 value: "2015-06-06 03:10:20.12345"
91 }
92 }
93 }
94 field {
95 type: LITERAL
96 literal {
97 type: V_STRING
98 v_string {
99 value: "{\"name\":\"Me\"}"
100 }
101 }
102 }
103 }
104 }
105
106 Mysqlx.Error {
107 severity: ERROR
108 code: 1054
109 msg: "Unknown column \'badcol\' in \'field list\'"
110 sql_state: "42S22"
111 }
112
113 Mysqlx.Ok {
114 msg: "bye!"
115 }
116 ok