mysql-test/suite/x/r/insert_table_string_quoting.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: "i" |
| 16 | } |
| 17 | projection { |
| 18 | name: "vc" |
| 19 | } |
| 20 | row { |
| 21 | field { |
| 22 | type: LITERAL |
| 23 | literal { |
| 24 | type: V_SINT |
| 25 | v_signed_int: 1 |
| 26 | } |
| 27 | } |
| 28 | field { |
| 29 | type: LITERAL |
| 30 | literal { |
| 31 | type: V_STRING |
| 32 | v_string { |
| 33 | value: " .\'\"``\\\\" |
| 34 | } |
| 35 | } |
| 36 | } |
| 37 | } |
| 38 | } |
| 39 | |
| 40 | |
| 41 | 1 rows affected |
| 42 | Mysqlx.Ok { |
| 43 | msg: "bye!" |
| 44 | } |
| 45 | ok |