Debian Codegraph @

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

raw
1 --source include/xplugin_preamble.inc
2 --source include/xplugin_create_user.inc
3 ## Test starts here
4 --write_file $MYSQL_TMP_DIR/expect_docid.xpl
5 -->import expect.macro
6
7 #
8 ## Test
9 #
10
11 -->echo #
12 -->echo ## Expectation block
13 -->echo ## open([+docid_generated]) / close()
14 -->echo #
15 -->callmacro Expect_open cond {condition_key:3} ER_SUCCESS
16 -->callmacro Expect_close ER_SUCCESS
17
18 -->echo #
19 -->echo ## Expectation block
20 -->echo ## open([+docid_generated]) / query() / close()
21 -->echo #
22 -->callmacro Expect_open cond {condition_key:3} ER_SUCCESS
23 -->callmacro Execute_sql select "Yes" as 'Is_ok'; ER_SUCCESS
24 -->callmacro Expect_close ER_SUCCESS
25
26 -->echo #
27 -->echo ## Expectation block
28 -->echo ## open([+docid_generated, +docid_generated]) / query() / close()
29 -->echo #
30 -->callmacro Expect_open cond {condition_key:3} cond {condition_key:3} ER_SUCCESS
31 -->callmacro Execute_sql select "Yes" as 'Is_ok'; ER_SUCCESS
32 -->callmacro Expect_close ER_SUCCESS
33
34 -->echo #
35 -->echo ## Expectation block
36 -->echo ## open([+docid_generated]) / query():NOK / query() / close()
37 -->echo #
38 -->callmacro Expect_open cond {condition_key:3} ER_SUCCESS
39 -->callmacro Execute_sql select `invalid_column_name`; ER_BAD_FIELD_ERROR
40 -->callmacro Execute_sql select "Yes" as 'Is_ok'; ER_SUCCESS
41 -->callmacro Expect_close ER_SUCCESS
42
43 -->echo #
44 -->echo ## Expectation block
45 -->echo ## open([+docid_generated, +no_error]):OK/
46 -->echo ## query():OK / query(error):NOK / query():NOK
47 -->echo ## close():NOK
48 -->echo #
49 -->callmacro Expect_open cond {condition_key:3} cond {condition_key:1} ER_SUCCESS
50 -->callmacro Execute_sql select "Yes" as 'Is_ok'; ER_SUCCESS
51 -->callmacro Execute_sql select `invalid_column_name`; ER_BAD_FIELD_ERROR
52 -->callmacro Execute_sql select "No" as 'Is_ok'; ER_X_EXPECT_NO_ERROR_FAILED
53 -->callmacro Expect_close ER_X_EXPECT_NO_ERROR_FAILED
54
55 -->echo #
56 -->echo ## Nested expectation block
57 -->echo ## open([+docid_generated]):OK/
58 -->echo ## open([+no_error]):OK/
59 -->echo ## query():OK / query(error):NOK / query():NOK
60 -->echo ## close():NOK
61 -->echo ## query():OK
62 -->echo ## close():OK
63 -->echo #
64 -->callmacro Expect_open cond {condition_key:3} ER_SUCCESS
65 -->callmacro Expect_open cond {condition_key:1} ER_SUCCESS
66 -->callmacro Execute_sql select "Yes" as 'Is_ok'; ER_SUCCESS
67 -->callmacro Execute_sql select `invalid_column_name`; ER_BAD_FIELD_ERROR
68 -->callmacro Execute_sql select "No" as 'Is_ok'; ER_X_EXPECT_NO_ERROR_FAILED
69 -->callmacro Expect_close ER_X_EXPECT_NO_ERROR_FAILED
70 -->callmacro Execute_sql select "Yes" as 'Is_ok'; ER_SUCCESS
71 -->callmacro Expect_close ER_SUCCESS
72
73 -->echo #
74 -->echo ## Nested expectation block
75 -->echo ## open([+no_error]):OK/
76 -->echo ## open([+docid_generated]):OK/
77 -->echo ## query(error):NOK
78 -->echo ## close():NOK
79 -->echo ## query():NOK
80 -->echo ## close():NOK
81 -->echo #
82 -->callmacro Expect_open cond {condition_key:1} ER_SUCCESS
83 -->callmacro Expect_open cond {condition_key:3} ER_SUCCESS
84 -->callmacro Execute_sql select `invalid_column_name`; ER_BAD_FIELD_ERROR
85 -->callmacro Expect_close ER_X_EXPECT_NO_ERROR_FAILED
86 -->callmacro Execute_sql select "No" as 'Is_ok'; ER_X_EXPECT_NO_ERROR_FAILED
87 -->callmacro Expect_close ER_X_EXPECT_NO_ERROR_FAILED
88
89 -->echo #
90 -->echo ## Nested expectation block
91 -->echo ## open([+no_error]):OK/
92 -->echo ## open([+docid_generated], new_context):OK/
93 -->echo ## query():NOK
94 -->echo ## close():OK
95 -->echo ## query():OK
96 -->echo ## close():OK
97 -->echo #
98 -->callmacro Expect_open cond {condition_key:1} ER_SUCCESS
99 -->callmacro Expect_open cond {condition_key:3} op:EXPECT_CTX_EMPTY ER_SUCCESS
100 -->callmacro Execute_sql select `invalid_column_name`; ER_BAD_FIELD_ERROR
101 -->callmacro Expect_close ER_SUCCESS
102 -->callmacro Execute_sql select "Yes" as 'Is_ok'; ER_SUCCESS
103 -->callmacro Expect_close ER_SUCCESS
104 EOF
105
106 --exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/expect_docid.xpl 2>&1
107
108 ## Cleanup
109 --source ../include/xplugin_cleanup.inc