| 2119 | |
| 2120 | template <typename T> |
| 2121 | bool run_test02() |
| 2122 | { |
| 2123 | static const test_ab<T> test_list[] = |
| 2124 | { |
| 2125 | test_ab<T>("'aaa' == 'aaa'" ,"","",T(1.0)), |
| 2126 | test_ab<T>("'aaa' < 'bbb'" ,"","",T(1.0)), |
| 2127 | test_ab<T>("'aaa' <= 'bbb'" ,"","",T(1.0)), |
| 2128 | test_ab<T>("'bbb' > 'aaa'" ,"","",T(1.0)), |
| 2129 | test_ab<T>("'bbb' >= 'aaa'" ,"","",T(1.0)), |
| 2130 | test_ab<T>("'aaa' != 'aaa'" ,"","",T(0.0)), |
| 2131 | test_ab<T>("'aaa' != 'bbb'" ,"","",T(1.0)), |
| 2132 | test_ab<T>("'aaa' + '123' == 'aaa123'" ,"","",T(1.0)), |
| 2133 | test_ab<T>("'aaa123' == 'aaa' + '123'" ,"","",T(1.0)), |
| 2134 | test_ab<T>("('aaa' + '123') == 'aaa123'" ,"","",T(1.0)), |
| 2135 | test_ab<T>("'aaa123' == ('aaa' + '123')" ,"","",T(1.0)), |
| 2136 | test_ab<T>("'aaa' in 'aaa123'" ,"","",T(1.0)), |
| 2137 | test_ab<T>("'123' in 'aaa123'" ,"","",T(1.0)), |
| 2138 | test_ab<T>("'a123b' like '*123*'" ,"","",T(1.0)), |
| 2139 | test_ab<T>("'a123b' like '*123?'" ,"","",T(1.0)), |
| 2140 | test_ab<T>("'1XYZ2' ilike '*xyz*'" ,"","",T(1.0)), |
| 2141 | test_ab<T>("'1XYZ2' ilike '*xyz?'" ,"","",T(1.0)), |
| 2142 | test_ab<T>("inrange('aaa','bbb','ccc')" ,"","",T(1.0)), |
| 2143 | test_ab<T>("a == b" ,"aaa","aaa",T(1.0)), |
| 2144 | test_ab<T>("a != b" ,"aaa","bbb",T(1.0)), |
| 2145 | test_ab<T>("a < b" ,"aaa","bbb",T(1.0)), |
| 2146 | test_ab<T>("a <= b" ,"aaa","bbb",T(1.0)), |
| 2147 | test_ab<T>("b > a" ,"aaa","bbb",T(1.0)), |
| 2148 | test_ab<T>("b >= a" ,"aaa","bbb",T(1.0)), |
| 2149 | test_ab<T>("a in b" ,"aaa","aaa123",T(1.0)), |
| 2150 | test_ab<T>("a in b" ,"123","aaa123",T(1.0)), |
| 2151 | test_ab<T>("a == 'aaa'" ,"aaa","aaa",T(1.0)), |
| 2152 | test_ab<T>("'aaa' == a" ,"aaa","aaa",T(1.0)), |
| 2153 | test_ab<T>("a != 'bbb'" ,"aaa","bbb",T(1.0)), |
| 2154 | test_ab<T>("'bbb' != a" ,"aaa","bbb",T(1.0)), |
| 2155 | test_ab<T>("a < 'bbb'" ,"aaa","bbb",T(1.0)), |
| 2156 | test_ab<T>("a <= 'bbb'" ,"aaa","bbb",T(1.0)), |
| 2157 | test_ab<T>("'bbb' > a" ,"aaa","bbb",T(1.0)), |
| 2158 | test_ab<T>("'bbb' >= a" ,"aaa","bbb",T(1.0)), |
| 2159 | test_ab<T>("a in 'aaa123'" ,"aaa","aaa123",T(1.0)), |
| 2160 | test_ab<T>("a in 'aaa123'" ,"123","aaa123",T(1.0)), |
| 2161 | test_ab<T>("'aaa' in b" ,"aaa","aaa123",T(1.0)), |
| 2162 | test_ab<T>("'123' in b" ,"aaa","aaa123",T(1.0)), |
| 2163 | test_ab<T>("(a < b) or (a == b)" ,"aaa","bbb",T(1.0)), |
| 2164 | test_ab<T>("(a == b) or (a < b)" ,"aaa","bbb",T(1.0)), |
| 2165 | test_ab<T>("(b > a) or (b == a)" ,"aaa","bbb",T(1.0)), |
| 2166 | test_ab<T>("(b == a) or (b > a)" ,"aaa","bbb",T(1.0)), |
| 2167 | test_ab<T>("(a < b) and (b > a)" ,"aaa","bbb",T(1.0)), |
| 2168 | test_ab<T>("a like '*123*'" ,"a123b","",T(1.0)), |
| 2169 | test_ab<T>("a like '*123?'" ,"a123b","",T(1.0)), |
| 2170 | test_ab<T>("'a123b' like b" ,"a123b","*123*",T(1.0)), |
| 2171 | test_ab<T>("'a123b' like b" ,"a123b","*123?",T(1.0)), |
| 2172 | test_ab<T>("a ilike '*xyz*'" ,"1XYZ2","",T(1.0)), |
| 2173 | test_ab<T>("a ilike '*xyz?'" ,"1XYZ2","",T(1.0)), |
| 2174 | test_ab<T>("'1XYZ2' ilike b" ,"","*xyz*",T(1.0)), |
| 2175 | test_ab<T>("'1XYZ2' ilike b" ,"","*xyz?",T(1.0)), |
| 2176 | test_ab<T>("inrange(a,'bbb',c)" ,"aaa","bbb",T(1.0)), |
| 2177 | test_ab<T>("inrange('aaa',b,'ccc')" ,"aaa","bbb",T(1.0)), |
| 2178 | test_ab<T>("inrange(a,b,c)" ,"aaa","bbb",T(1.0)), |