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 |