Debian Codegraph @

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

raw
1 ## XPLUGIN: Following test cases validates asserts, and its printouts
2 --source include/xplugin_preamble.inc
3 --source include/xplugin_create_user.inc
4
5 # Tests
6 --write_file $MYSQL_TMP_DIR/assert.xpl
7 -->echo
8 -->echo # 1.
9 -->echo #
10 assert_eq 1 1;
11 assert_eq A A;
12 assert_eq Abbc Abbc;
13 echo ok;
14
15 -->echo
16 -->echo # 2.
17 -->echo #
18 assert_ne 1 2;
19 assert_ne A B;
20 assert_ne Abbc Abbd;
21 echo ok;
22
23 -->echo
24 -->echo # 3.
25 -->echo #
26 assert_gt 6000000000 2;
27 assert_gt 6000000000 2000000000;
28 assert_gt -10 -20;
29 assert_gt 10 -20;
30 echo ok;
31
32 -->echo
33 -->echo # 4.
34 -->echo #
35 assert_ge 6000000000 2;
36 assert_ge 6000000000 6000000000;
37 assert_ge 6000000000 2000000000;
38 assert_ge -10 -20;
39 assert_ge -10 -10;
40 assert_ge 10 -20;
41 assert_ge 10 10;
42 echo ok;
43
44 -->echo
45 -->echo # 5.
46 -->echo #
47 assert 1 == 1;
48 assert A == A;
49 assert Abbc == Abbc;
50 echo ok;
51
52 -->echo
53 -->echo # 6.
54 -->echo #
55 assert 1 != 2;
56 assert A != B;
57 assert Abbc != Abbd;
58 echo ok;
59
60 -->echo
61 -->echo # 7.
62 -->echo #
63 assert 6000000000 > 2;
64 assert 6000000000 > 2000000000;
65 assert -10 > -20;
66 assert 10 > -20;
67 echo ok;
68
69 -->echo
70 -->echo # 8.
71 -->echo #
72 assert 6000000000 >= 2;
73 assert 6000000000 >= 6000000000;
74 assert 6000000000 >= 2000000000;
75 assert -10 >= -20;
76 assert -10 >= -10;
77 assert 10 >= -20;
78 assert 10 >= 10;
79 echo ok;
80
81 -->echo
82 -->echo # 9.
83 -->echo #
84 assert 2 < 6000000000;
85 assert 2000000000 < 6000000000;
86 assert -20 < -10;
87 assert -20 < 10;
88 echo ok;
89
90 -->echo
91 -->echo # 10.
92 -->echo #
93 assert 2 <= 6000000000;
94 assert 6000000000 <= 6000000000;
95 assert 2000000000 <= 6000000000;
96 assert -20 <= -10;
97 assert -10 <= -10;
98 assert -20 <= 10;
99 assert 10 <= 10;
100 echo ok;
101
102 -->echo
103 -->echo # 11.
104 -->echo #
105 varlet %abbc_P2% Abbc;
106 varlet %abbd_P2% Abbd;
107 varlet %2_P2% 2;
108 varlet %6000000000_P2% 6000000000;
109
110 assert Abbc == %abbc_P2%;
111 assert Abbc != %abbd_P2%;
112 assert 6000000000 > %2_P2%;
113 assert 6000000000 >= %2_P2%;
114 assert 6000000000 >= %6000000000_P2%;
115 assert 2 < %6000000000_P2%;
116 assert 2 <= %6000000000_P2%;
117 echo ok;
118
119 -->echo
120 -->echo # 12.
121 -->echo #
122 varlet %Abbc_P1% Abbc;
123 varlet %2_P1% 2;
124 varlet %6000000000_P1% 6000000000;
125
126 assert %Abbc_P1% == Abbc;
127 assert %Abbc_P1% != Abbd;
128 assert %6000000000_P1% > 2;
129 assert %6000000000_P1% >= 2;
130 assert %6000000000_P1% >= 6000000000;
131 assert %2_P1% < 6000000000;
132 assert %2_P1% <= 6000000000;
133 echo ok;
134
135 EOF
136
137 --echo
138 --echo ################################################################
139 --echo ## Test verifies "assert" commands, in following configurations:
140 --echo #
141 --echo # 1. verify assert_eq command
142 --echo # 2. verify assert_ne command
143 --echo # 3. verify assert_gt command
144 --echo # 4. verify assert_ge command
145 --echo # 5. verify assert command with equal operator (==)
146 --echo # 6. verify assert command with not equal operator (!=)
147 --echo # 7. verify assert command with greater operator (>)
148 --echo # 8. verify assert command with greater or equal operator (>=)
149 --echo # 9. verify assert command with less operator (<)
150 --echo # 10. verify assert command with less or equal operator (<=)
151 --echo # 11. verify assert command with veriable in thrid param
152 --echo # 12. verify assert command with veriable in first param
153 --echo #
154
155 exec $MYSQLXTEST
156 -ux_root --password=''
157 --host=127.0.0.1
158 --schema=test
159 --file=$MYSQL_TMP_DIR/assert.xpl 2>&1;
160
161
162 ## Cleanup
163 --source ../include/xplugin_cleanup.inc