Debian Codegraph @

mysql-test/suite/x/t/insert_table_string_quoting.test

raw
1 ## generated
2 ## Rel: Attempt to break value quoting
3
4 --source include/xplugin_preamble.inc
5 --source include/xplugin_create_user.inc
6
7 create schema xtest default charset='utf8mb4';
8
9 ## Test starts here
10 --write_file $MYSQL_TMP_DIR/insert_table_string_quoting.xpl
11 ## Test data
12 -->sql
13 use xtest;
14 create table mytable (i int NOT NULL, ui int unsigned, vc varchar(100), f float, d double, dt datetime, ts timestamp(5), j json);
15 -->endsql
16
17 Mysqlx.Crud.Insert {
18 collection {
19 name: "mytable"
20 schema: "xtest"
21 }
22 data_model: TABLE
23 projection {
24 name: "i"
25 }
26 projection {
27 name: "vc"
28 }
29 row {
30 field {
31 type: LITERAL
32 literal {
33 type: V_SINT
34 v_signed_int: 1
35 }
36 }
37 field {
38 type: LITERAL
39 literal {
40 type: V_STRING
41 v_string {
42 value: " .\'\"``\\\\"
43 }
44 }
45 }
46 }
47 }
48
49 ## expect Mysqlx.Sql.StmtExecuteOk
50 -->recvresult
51 EOF
52
53 --exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/insert_table_string_quoting.xpl 2>&1
54
55 ## Cleanup
56 --source ../include/xplugin_cleanup.inc