Debian Codegraph @

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

raw
1 ########### ../t/expect_noerror.test #########
2 ### #
3 ### This test runs aims to run expect.open and expect.close xmessage #
4 ### with mysqlxtest client. #
5 ### Test covers #
6 ### - check condition_key (continue on error or not) #
7 # Do not continue on error if condition_key=1,default is #
8 # to continue #
9 ### - Inherit parent's open block condition with "op" #
10 ### - Nested open/close block #
11 ### #
12 ########################################################################
13 #
14
15 --source include/xplugin_preamble.inc
16 --source include/xplugin_create_user.inc
17 ## Test starts here
18 --write_file $MYSQL_TMP_DIR/expect_field.xpl
19 -->import expect.macro
20
21 #
22 ## Test
23 #
24
25 -->echo #
26 -->echo ## Expectation block
27 -->echo ## open([+field_exists=1]) / close()
28 -->echo #
29 -->callmacro Expect_open cond {condition_key:2 condition_value: "1"} ER_SUCCESS
30 -->callmacro Expect_close ER_SUCCESS
31
32 -->echo #
33 -->echo ## Expectation block
34 -->echo ## open([+field_exists=1]) / query() / close()
35 -->echo #
36 -->callmacro Expect_open cond {condition_key:2 condition_value: "1"} ER_SUCCESS
37 -->callmacro Execute_sql select "Yes" as 'Is_ok'; ER_SUCCESS
38 -->callmacro Expect_close ER_SUCCESS
39
40 -->echo #
41 -->echo ## Expectation block
42 -->echo ## open([+field_exists=1, +field_exists=2]) / query() / close()
43 -->echo #
44 -->callmacro Expect_open cond {condition_key:2 condition_value: "1"} cond {condition_key:2 condition_value: "2"} ER_SUCCESS
45 -->callmacro Execute_sql select "Yes" as 'Is_ok'; ER_SUCCESS
46 -->callmacro Expect_close ER_SUCCESS
47
48 -->echo #
49 -->echo ## Expectation block
50 -->echo ## open([+field_exists=1, +field_exists=unknown]) / query() / close()
51 -->echo #
52 -->callmacro Expect_open cond {condition_key:2 condition_value: "1"} cond {condition_key:2 condition_value: "1.1"} ER_X_EXPECT_FIELD_EXISTS_FAILED
53 -->callmacro Execute_sql select "Yes" as 'Is_ok'; ER_X_EXPECT_FIELD_EXISTS_FAILED
54 -->callmacro Expect_close ER_X_EXPECT_FIELD_EXISTS_FAILED
55
56 -->echo #
57 -->echo ## Expectation block
58 -->echo ## open([+field_exists=1]) / query():NOK / query() / close()
59 -->echo #
60 -->callmacro Expect_open cond {condition_key:2 condition_value: "1"} ER_SUCCESS
61 -->callmacro Execute_sql select `invalid_column_name`; ER_BAD_FIELD_ERROR
62 -->callmacro Execute_sql select "Yes" as 'Is_ok'; ER_SUCCESS
63 -->callmacro Expect_close ER_SUCCESS
64
65 -->echo #
66 -->echo ## Expectation block
67 -->echo ## open([+field_exists=unknown]):NOK / query():NOK / close():NOK
68 -->echo #
69 -->callmacro Expect_open cond {condition_key:2 condition_value: "1.1"} ER_X_EXPECT_FIELD_EXISTS_FAILED
70 -->callmacro Execute_sql select "No" as 'Is_ok'; ER_X_EXPECT_FIELD_EXISTS_FAILED
71 -->callmacro Expect_close ER_X_EXPECT_FIELD_EXISTS_FAILED
72
73 -->echo #
74 -->echo ## Expectation block
75 -->echo ## open([+field_exists=unknown, +no_error]):NOK / query():NOK / close():NOK
76 -->echo #
77 -->callmacro Expect_open cond {condition_key:2 condition_value: "1.1"} cond {condition_key:1} ER_X_EXPECT_FIELD_EXISTS_FAILED
78 -->callmacro Execute_sql select "No" as 'Is_ok'; ER_X_EXPECT_FIELD_EXISTS_FAILED
79 -->callmacro Expect_close ER_X_EXPECT_FIELD_EXISTS_FAILED
80
81 -->echo #
82 -->echo ## Expectation block
83 -->echo ## open([+field_exists=2, +no_error]):OK/
84 -->echo ## query():OK / query(error):NOK / query():NOK
85 -->echo ## close():NOK
86 -->echo #
87 -->callmacro Expect_open cond {condition_key:2 condition_value: "2"} cond {condition_key:1} ER_SUCCESS
88 -->callmacro Execute_sql select "Yes" as 'Is_ok'; ER_SUCCESS
89 -->callmacro Execute_sql select `invalid_column_name`; ER_BAD_FIELD_ERROR
90 -->callmacro Execute_sql select "No" as 'Is_ok'; ER_X_EXPECT_NO_ERROR_FAILED
91 -->callmacro Expect_close ER_X_EXPECT_NO_ERROR_FAILED
92
93 -->echo #
94 -->echo ## Nested expectation block
95 -->echo ## open([+field_exists=2]):OK/
96 -->echo ## open([+no_error]):OK/
97 -->echo ## query():OK / query(error):NOK / query():NOK
98 -->echo ## close():NOK
99 -->echo ## query():OK
100 -->echo ## close():OK
101 -->echo #
102 -->callmacro Expect_open cond {condition_key:2 condition_value: "2"} ER_SUCCESS
103 -->callmacro Expect_open cond {condition_key:1} ER_SUCCESS
104 -->callmacro Execute_sql select "Yes" as 'Is_ok'; ER_SUCCESS
105 -->callmacro Execute_sql select `invalid_column_name`; ER_BAD_FIELD_ERROR
106 -->callmacro Execute_sql select "No" as 'Is_ok'; ER_X_EXPECT_NO_ERROR_FAILED
107 -->callmacro Expect_close ER_X_EXPECT_NO_ERROR_FAILED
108 -->callmacro Execute_sql select "Yes" as 'Is_ok'; ER_SUCCESS
109 -->callmacro Expect_close ER_SUCCESS
110
111 -->echo #
112 -->echo ## Nested expectation block
113 -->echo ## open([+no_error]):OK/
114 -->echo ## open([+field_exists=2]):OK/
115 -->echo ## query(error):NOK
116 -->echo ## close():NOK
117 -->echo ## query():NOK
118 -->echo ## close():NOK
119 -->echo #
120 -->callmacro Expect_open cond {condition_key:1} ER_SUCCESS
121 -->callmacro Expect_open cond {condition_key:2 condition_value: "2"} ER_SUCCESS
122 -->callmacro Execute_sql select `invalid_column_name`; ER_BAD_FIELD_ERROR
123 -->callmacro Expect_close ER_X_EXPECT_NO_ERROR_FAILED
124 -->callmacro Execute_sql select "No" as 'Is_ok'; ER_X_EXPECT_NO_ERROR_FAILED
125 -->callmacro Expect_close ER_X_EXPECT_NO_ERROR_FAILED
126
127 -->echo #
128 -->echo ## Nested expectation block
129 -->echo ## open([+no_error]):OK/
130 -->echo ## open([+field_exists=2], new_context):OK/
131 -->echo ## query():NOK
132 -->echo ## close():OK
133 -->echo ## query():OK
134 -->echo ## close():OK
135 -->echo #
136 -->callmacro Expect_open cond {condition_key:1} ER_SUCCESS
137 -->callmacro Expect_open cond {condition_key:2 condition_value: "2"} op:EXPECT_CTX_EMPTY ER_SUCCESS
138 -->callmacro Execute_sql select `invalid_column_name`; ER_BAD_FIELD_ERROR
139 -->callmacro Expect_close ER_SUCCESS
140 -->callmacro Execute_sql select "Yes" as 'Is_ok'; ER_SUCCESS
141 -->callmacro Expect_close ER_SUCCESS
142 EOF
143
144 --exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/expect_field.xpl 2>&1
145
146 ## Cleanup
147 --source ../include/xplugin_cleanup.inc