Debian Codegraph @

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

raw
1 ## generated
2
3 --source include/xplugin_preamble.inc
4 --source include/xplugin_create_user.inc
5
6 create schema xtest;
7
8 ## Test starts here
9 --write_file $MYSQL_TMP_DIR/delete_del_bad_expr.xpl
10 ## Test data
11
12 -->stmtadmin create_collection {"schema":"xtest","name":"mycoll"}
13 -->recvresult
14
15 -->sql
16 use xtest;
17 insert into mycoll (doc) values ('{"_id": "1", "name": "Joe1"}');
18 insert into mycoll (doc) values ('{"_id": "2", "name": "Joe2", "last_name": "Smith"}');
19 insert into mycoll (doc) values ('{"_id": "3", "name": "Joe2", "last_name": "Shmo"}');
20 -->endsql
21
22 Mysqlx.Crud.Delete {
23 collection {
24 name: "mycoll"
25 schema: "xtest"
26 }
27 data_model: DOCUMENT
28 criteria {
29 type: OPERATOR
30 operator {
31 name: "=="
32 param {
33 type: IDENT
34 identifier {
35 document_path {
36 type: MEMBER
37 value: "last_name"
38 }
39 }
40 }
41 param {
42 type: LITERAL
43 literal {
44 type: V_OCTETS
45 v_octets {value:"xxx"}
46 }
47 }
48 }
49 }
50 }
51
52 ## expect Mysqlx.Sql.StmtExecuteOk
53 -->recvresult
54 EOF
55
56 --exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/delete_del_bad_expr.xpl 2>&1
57
58 ## Cleanup
59 --source ../include/xplugin_cleanup.inc