Debian Codegraph @

mysql-test/suite/x/r/insert_table_missing_notnull_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: "vc"
16 }
17 row {
18 field {
19 type: LITERAL
20 literal {
21 type: V_STRING
22 v_string {
23 value: "x"
24 }
25 }
26 }
27 }
28 }
29
30 Mysqlx.Error {
31 severity: ERROR
32 code: 1364
33 msg: "Field \'i\' doesn\'t have a default value"
34 sql_state: "HY000"
35 }
36
37 Mysqlx.Ok {
38 msg: "bye!"
39 }
40 ok