Test select3.test.sql (id 48c24a608176) (err)
select3.test.stable.out.int128.FILTERED 2019-09-08 03:56:46.211189816 +0200select3.test.test.out.FILTERED 2019-09-08 03:56:48.360201450 +0200
1 Statistics about stdout of test 'select3.test` in directory 'sql/test/SQLite_regress/sqllogictest`: 1 1 Statistics about stdout of test 'select3.test` in directory 'sql/test/SQLite_regress/sqllogictest`: 1
2 63078 lines, 391897 words, 1410841 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 55782 lines, 347303 words, 1253106 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 63078 lines, 391897 words, 1410841 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 55782 lines, 347303 words, 1253106 chars in lines not matching '^$|^(\| |)#` 3
4 # 98918 lines, 559266 words, 2150829 chars in all lines 4 ! 4 # 87017 lines, 492900 words, 1898088 chars in all lines 4
5 5 5 5
..................
# L2, L4, L6, d, L11,
87021 [ 222, 2, 666, 222, 222, 224, -3 ] 87021 87017 [ 222, 2, 666, 222, 222, 224, -3 ] 87017
87022 #SELECT (a+b+c+d+e)/5, 87022 -
87023 # c-d, 87023 -
87024 # a+b*2, 87024 -
87025 # d, 87025 -
87026 # CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 87026 -
87027 # WHEN a<b+3 THEN 333 ELSE 444 END, 87027 -
87028 # c, 87028 -
87029 # a-b 87029 -
87030 # FROM t1 87030 -
87031 # WHERE (c<=d-2 OR c>=d+2) 87031 -
87032 # AND c>d 87032 -
87033 # AND (e>a AND e<b) 87033 -
87034 # ORDER BY 2,3,7,5,6,4 87034 -
87035 #; 87035 -
87036 % sys., sys., sys., sys.t1, sys., sys.t1, sys. # table_name 87036 -
87037 # sys.L2, sys.L4, sys.L6, sys.t1, sys.L11, sys.t1, sys.L14 # table_name 87037 -
87038 % L, L, L, d, L, c, L # name 87038 -
87039 # L2, L4, L6, d, L11, c, L14 # name 87039 -
87040 % hugeint, bigint, bigint, int, smallint, int, bigint # type 87040 -
87041 % 3, 1, 3, 3, 3, 3, 2 # length 87041 -
87042 [ 222, 2, 666, 222, 222, 224, -3 ] 87042 -
87043 [ 192, 3, 579, 190, 222, 193, -3 ] 87043 -
87044 #SELECT (a+b+c+d+e)/5, 87044 -
87045 # c-d, 87045 -
87046 # a+b*2, 87046 -
87047 # d, 87047 -
87048 # CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 87048 -
87049 # WHEN a<b+3 THEN 333 ELSE 444 END, 87049 -
87050 # c, 87050 -
87051 # a-b 87051 -
87052 # FROM t1 87052 -
87053 # WHERE c>d 87053 -
87054 # AND (e>a AND e<b) 87054 -
87055 # AND (c<=d-2 OR c>=d+2) 87055 -
87056 #; 87056 -
87057 % sys., sys., sys., sys.t1, sys., sys.t1, sys. # table_name 87057 -
87058 # sys.L2, sys.L4, sys.L6, sys.t1, sys.L11, sys.t1, sys.L14 # table_name 87058 -
87059 % L, L, L, d, L, c, L # name 87059 -
87060 # L2, L4, L6, d, L11, c, L14 # name 87060 -
87061 % hugeint, bigint, bigint, int, smallint, int, bigint # type 87061 -
87062 % 3, 1, 3, 3, 3, 3, 2 # length 87062 -
87063 [ 192, 3, 579, 190, 222, 193, -3 ] 87063 -
87064 [ 222, 2, 666, 222, 222, 224, -3 ] 87064 -
87065 #SELECT (a+b+c+d+e)/5, 87065 -
87066 # c-d, 87066 -
87067 # a+b*2, 87067 -
87068 # d, 87068 -
87069 # CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 87069 -
87070 # WHEN a<b+3 THEN 333 ELSE 444 END, 87070 -
87071 # c, 87071 -
87072 # a-b 87072 -
87073 # FROM t1 87073 -
87074 # WHERE c>d 87074 -
87075 # AND (e>a AND e<b) 87075 -
87076 # AND (c<=d-2 OR c>=d+2) 87076 -
87077 # ORDER BY 5,2 87077 -
87078 #; 87078 -
87079 % sys., sys., sys., sys.t1, sys., sys.t1, sys. # table_name 87079 -
87080 # sys.L2, sys.L4, sys.L6, sys.t1, sys.L11, sys.t1, sys.L14 # table_name 87080 -
87081 % L, L, L, d, L, c, L # name 87081 -
87082 # L2, L4, L6, d, L11, c, L14 # name 87082 -
87083 % hugeint, bigint, bigint, int, smallint, int, bigint # type 87083 -
87084 % 3, 1, 3, 3, 3, 3, 2 # length 87084 -
87085 [ 222, 2, 666, 222, 222, 224, -3 ] 87085 -
87086 [ 192, 3, 579, 190, 222, 193, -3 ] 87086 -
87087 #SELECT (a+b+c+d+e)/5, 87087 -
87088 # c-d, 87088 -
87089 # a+b*2, 87089 -
87090 # d, 87090 -
87091 # CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 87091 -
87092 # WHEN a<b+3 THEN 333 ELSE 444 END, 87092 -
87093 # c, 87093 -
87094 # a-b 87094 -
87095 # FROM t1 87095 -
87096 # WHERE (c<=d-2 OR c>=d+2) 87096 -
87097 # AND (e>a AND e<b) 87097 -
87098 # AND c>d 87098 -
87099 #; 87099 -
87100 % sys., sys., sys., sys.t1, sys., sys.t1, sys. # table_name 87100 -
87101 # sys.L2, sys.L4, sys.L6, sys.t1, sys.L11, sys.t1, sys.L14 # table_name 87101 -
87102 % L, L, L, d, L, c, L # name 87102 -
87103 # L2, L4, L6, d, L11, c, L14 # name 87103 -
87104 % hugeint, bigint, bigint, int, smallint, int, bigint # type 87104 -
87105 % 3, 1, 3, 3, 3, 3, 2 # length 87105 -
87106 [ 192, 3, 579, 190, 222, 193, -3 ] 87106 -
87107 [ 222, 2, 666, 222, 222, 224, -3 ] 87107 -
87108 #SELECT (a+b+c+d+e)/5, 87108 -
87109 # c-d, 87109 -
87110 # a+b*2, 87110 -
87111 # d, 87111 -
87112 # CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 87112 -
87113 # WHEN a<b+3 THEN 333 ELSE 444 END, 87113 -
87114 # c, 87114 -
87115 # a-b 87115 -
87116 # FROM t1 87116 -
87117 # WHERE (c<=d-2 OR c>=d+2) 87117 -
87118 # AND (e>a AND e<b) 87118 -
87119 # AND c>d 87119 -
87120 # ORDER BY 4,5,1 87120 -
87121 #; 87121 -
87122 % sys., sys., sys., sys.t1, sys., sys.t1, sys. # table_name 87122 -
87123 # sys.L2, sys.L4, sys.L6, sys.t1, sys.L11, sys.t1, sys.L14 # table_name 87123 -
87124 % L, L, L, d, L, c, L # name 87124 -
87125 # L2, L4, L6, d, L11, c, L14 # name 87125 -
87126 % hugeint, bigint, bigint, int, smallint, int, bigint # type 87126 -
87127 % 3, 1, 3, 3, 3, 3, 2 # length 87127 -
87128 [ 192, 3, 579, 190, 222, 193, -3 ] 87128 -
87129 [ 222, 2, 666, 222, 222, 224, -3 ] 87129 -
87130 #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 87130 -
87131 # WHEN a<b+3 THEN 333 ELSE 444 END, 87131 -
87132 # (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d), 87132 -
87133 # c, 87133 -
87134 # d-e, 87134 -
87135 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 87135 -
87136 # b, 87136 -
87137 # CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END 87137 -
87138 # FROM t1 87138 -
87139 #; 87139 -
87140 % ., ., .t1, ., ., .t1, . # table_name 87140 -
87141 # .L2, .L7, .t1, .L13, .L21, .t1, .L33 # table_name 87141 -
87142 % L, L, c, L, L, b, L # name 87142 -
87143 # L2, L7, c, L13, L21, b, L33 # name 87143 -
87144 % smallint, bigint, int, bigint, bigint, int, bigint # type 87144 -
87145 % 3, 1, 3, 2, 2, 3, 4 # length 87145 -
87146 [ 444, 0, 113, 4, 1, 112, 1120 ] 87146 -
87147 [ 222, 0, 123, NULL, 2, 124, 1240 ] 87147 -
87148 [ 222, 0, 125, 2, 3, 129, 1290 ] 87148 -
87149 [ 333, 0, 134, 1, 4, 130, 1300 ] 87149 -
87150 [ 222, 0, 137, 1, 5, 139, 1390 ] 87150 -
87151 [ 222, 0, 141, -4, 6, 143, 1430 ] 87151 -
87152 [ 444, 0, 147, NULL, 7, 145, 1450 ] 87152 -
87153 [ 333, 0, 150, NULL, 8, 151, 1510 ] 87153 -
87154 [ 333, 0, 155, NULL, 9, 158, 1580 ] 87154 -
87155 [ 444, 0, 161, 2, 10, 160, 1600 ] 87155 -
87156 [ 333, 0, 166, NULL, 11, 167, 1670 ] 87156 -
87157 [ 444, 0, 172, -2, 12, 170, 1700 ] 87157 -
87158 [ 444, 0, 176, NULL, 13, 175, 358 ] 87158 -
87159 [ 333, 0, 184, 3, 14, 181, 364 ] 87159 -
87160 [ 333, 0, 187, -4, 15, 186, 376 ] 87160 -
87161 [ 222, 0, 193, -2, 16, 194, 382 ] 87161 -
87162 [ 333, 0, 195, -1, 17, 198, 398 ] 87162 -
87163 [ 444, 0, 208, NULL, 18, 206, NULL ] 87163 -
87164 [ 333, 0, 214, 2, 19, 211, 426 ] 87164 -
87165 [ 222, 0, 215, -2, 20, 218, 432 ] 87165 -
87166 [ 222, 0, 224, 1, 21, 223, 440 ] 87166 -
87167 [ 333, 0, 225, -1, 22, 228, 458 ] 87167 -
87168 [ 333, 0, 231, 3, 23, 232, 468 ] 87168 -
87169 [ 444, 0, NULL, 1, 24, 236, 2360 ] 87169 -
87170 [ 444, 0, 244, NULL, 25, 240, 486 ] 87170 -
87171 [ 111, 0, 247, 2, 26, 249, 490 ] 87171 -
87172 [ 444, 0, 102, NULL, 0, NULL, NULL ] 87172 -
87173 [ 333, 0, 106, -1, 0, 105, 1050 ] 87173 -
87174 [ 444, 0, 119, -1, 0, NULL, NULL ] 87174 -
87175 [ 444, 0, 202, -1, 0, NULL, 402 ] 87175 -
87176 #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 87176 -
87177 # WHEN a<b+3 THEN 333 ELSE 444 END, 87177 -
87178 # (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d), 87178 -
87179 # c, 87179 -
87180 # d-e, 87180 -
87181 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 87181 -
87182 # b, 87182 -
87183 # CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END 87183 -
87184 # FROM t1 87184 -
87185 # ORDER BY 4,5 87185 -
87186 #; 87186 -
87187 % ., ., .t1, ., ., .t1, . # table_name 87187 -
87188 # .L2, .L7, .t1, .L13, .L21, .t1, .L33 # table_name 87188 -
87189 % L, L, c, L, L, b, L # name 87189 -
87190 # L2, L7, c, L13, L21, b, L33 # name 87190 -
87191 % smallint, bigint, int, bigint, bigint, int, bigint # type 87191 -
87192 % 3, 1, 3, 2, 2, 3, 4 # length 87192 -
87193 [ 444, 0, 102, NULL, 0, NULL, NULL ] 87193 -
87194 [ 222, 0, 123, NULL, 2, 124, 1240 ] 87194 -
87195 [ 444, 0, 147, NULL, 7, 145, 1450 ] 87195 -
87196 [ 333, 0, 150, NULL, 8, 151, 1510 ] 87196 -
87197 [ 333, 0, 155, NULL, 9, 158, 1580 ] 87197 -
87198 [ 333, 0, 166, NULL, 11, 167, 1670 ] 87198 -
87199 [ 444, 0, 176, NULL, 13, 175, 358 ] 87199 -
87200 [ 444, 0, 208, NULL, 18, 206, NULL ] 87200 -
87201 [ 444, 0, 244, NULL, 25, 240, 486 ] 87201 -
87202 [ 222, 0, 141, -4, 6, 143, 1430 ] 87202 -
87203 [ 333, 0, 187, -4, 15, 186, 376 ] 87203 -
87204 [ 444, 0, 172, -2, 12, 170, 1700 ] 87204 -
87205 [ 222, 0, 193, -2, 16, 194, 382 ] 87205 -
87206 [ 222, 0, 215, -2, 20, 218, 432 ] 87206 -
87207 [ 333, 0, 106, -1, 0, 105, 1050 ] 87207 -
87208 [ 444, 0, 119, -1, 0, NULL, NULL ] 87208 -
87209 [ 444, 0, 202, -1, 0, NULL, 402 ] 87209 -
87210 [ 333, 0, 195, -1, 17, 198, 398 ] 87210 -
87211 [ 333, 0, 225, -1, 22, 228, 458 ] 87211 -
87212 [ 333, 0, 134, 1, 4, 130, 1300 ] 87212 -
87213 [ 222, 0, 137, 1, 5, 139, 1390 ] 87213 -
87214 [ 222, 0, 224, 1, 21, 223, 440 ] 87214 -
87215 [ 444, 0, NULL, 1, 24, 236, 2360 ] 87215 -
87216 [ 222, 0, 125, 2, 3, 129, 1290 ] 87216 -
87217 [ 444, 0, 161, 2, 10, 160, 1600 ] 87217 -
87218 [ 333, 0, 214, 2, 19, 211, 426 ] 87218 -
87219 [ 111, 0, 247, 2, 26, 249, 490 ] 87219 -
87220 [ 333, 0, 184, 3, 14, 181, 364 ] 87220 -
87221 [ 333, 0, 231, 3, 23, 232, 468 ] 87221 -
87222 [ 444, 0, 113, 4, 1, 112, 1120 ] 87222 -
87223 #SELECT a+b*2+c*3+d*4, 87223 -
87224 # CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 87224 -
87225 # WHEN a<b+3 THEN 333 ELSE 444 END, 87225 -
87226 # CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 87226 -
87227 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 87227 -
87228 # c-d 87228 -
87229 # FROM t1 87229 -
87230 # WHERE d NOT BETWEEN 110 AND 150 87230 -
87231 # AND d>e 87231 -
87232 #; 87232 -
87233 % ., ., ., ., . # table_name 87233 -
87234 # .L2, .L4, .L12, .L20, .L24 # table_name 87234 -
87235 % L, L, L, L, L # name 87235 -
87236 # L2, L4, L12, L20, L24 # name 87236 -
87237 % hugeint, smallint, bigint, bigint, bigint # type 87237 -
87238 % 4, 3, 4, 2, 2 # length 87238 -
87239 [ 1622, 444, 1600, 10, -3 ] 87239 -
87240 [ 1828, 333, 364, 14, 1 ] 87240 -
87241 [ 2125, 333, 426, 19, 2 ] 87241 -
87242 [ 2226, 222, 440, 21, 2 ] 87242 -
87243 [ 2323, 333, 468, 23, -2 ] 87243 -
87244 [ NULL, 444, 2360, 24, NULL ] 87244 -
87245 [ 2476, 111, 490, 26, -1 ] 87245 -
87246 #SELECT a+b*2+c*3+d*4, 87246 -
87247 # CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 87247 -
87248 # WHEN a<b+3 THEN 333 ELSE 444 END, 87248 -
87249 # CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 87249 -
87250 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 87250 -
87251 # c-d 87251 -
87252 # FROM t1 87252 -
87253 # WHERE d NOT BETWEEN 110 AND 150 87253 -
87254 # AND d>e 87254 -
87255 # ORDER BY 4,5,3,2 87255 -
87256 #; 87256 -
87257 % ., ., ., ., . # table_name 87257 -
87258 # .L2, .L4, .L12, .L20, .L24 # table_name 87258 -
87259 % L, L, L, L, L # name 87259 -
87260 # L2, L4, L12, L20, L24 # name 87260 -
87261 % hugeint, smallint, bigint, bigint, bigint # type 87261 -
87262 % 4, 3, 4, 2, 2 # length 87262 -
87263 [ 1622, 444, 1600, 10, -3 ] 87263 -
87264 [ 1828, 333, 364, 14, 1 ] 87264 -
87265 [ 2125, 333, 426, 19, 2 ] 87265 -
87266 [ 2226, 222, 440, 21, 2 ] 87266 -
87267 [ 2323, 333, 468, 23, -2 ] 87267 -
87268 [ NULL, 444, 2360, 24, NULL ] 87268 -
87269 [ 2476, 111, 490, 26, -1 ] 87269 -
87270 #SELECT a+b*2+c*3+d*4, 87270 -
87271 # CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 87271 -
87272 # WHEN a<b+3 THEN 333 ELSE 444 END, 87272 -
87273 # CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 87273 -
87274 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 87274 -
87275 # c-d 87275 -
87276 # FROM t1 87276 -
87277 # WHERE d>e 87277 -
87278 # AND d NOT BETWEEN 110 AND 150 87278 -
87279 #; 87279 -
87280 % ., ., ., ., . # table_name 87280 -
87281 # .L2, .L4, .L12, .L20, .L24 # table_name 87281 -
87282 % L, L, L, L, L # name 87282 -
87283 # L2, L4, L12, L20, L24 # name 87283 -
87284 % hugeint, smallint, bigint, bigint, bigint # type 87284 -
87285 % 4, 3, 4, 2, 2 # length 87285 -
87286 [ 1622, 444, 1600, 10, -3 ] 87286 -
87287 [ 1828, 333, 364, 14, 1 ] 87287 -
87288 [ 2125, 333, 426, 19, 2 ] 87288 -
87289 [ 2226, 222, 440, 21, 2 ] 87289 -
87290 [ 2323, 333, 468, 23, -2 ] 87290 -
87291 [ NULL, 444, 2360, 24, NULL ] 87291 -
87292 [ 2476, 111, 490, 26, -1 ] 87292 -
87293 #SELECT a+b*2+c*3+d*4, 87293 -
87294 # CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 87294 -
87295 # WHEN a<b+3 THEN 333 ELSE 444 END, 87295 -
87296 # CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 87296 -
87297 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 87297 -
87298 # c-d 87298 -
87299 # FROM t1 87299 -
87300 # WHERE d>e 87300 -
87301 # AND d NOT BETWEEN 110 AND 150 87301 -
87302 # ORDER BY 5,2,4,1 87302 -
87303 #; 87303 -
87304 % ., ., ., ., . # table_name 87304 -
87305 # .L2, .L4, .L12, .L20, .L24 # table_name 87305 -
87306 % L, L, L, L, L # name 87306 -
87307 # L2, L4, L12, L20, L24 # name 87307 -
87308 % hugeint, smallint, bigint, bigint, bigint # type 87308 -
87309 % 4, 3, 4, 2, 2 # length 87309 -
87310 [ NULL, 444, 2360, 24, NULL ] 87310 -
87311 [ 1622, 444, 1600, 10, -3 ] 87311 -
87312 [ 2323, 333, 468, 23, -2 ] 87312 -
87313 [ 2476, 111, 490, 26, -1 ] 87313 -
87314 [ 1828, 333, 364, 14, 1 ] 87314 -
87315 [ 2226, 222, 440, 21, 2 ] 87315 -
87316 [ 2125, 333, 426, 19, 2 ] 87316 -
87317 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d), 87317 -
87318 # CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 87318 -
87319 # WHEN a<b+3 THEN 333 ELSE 444 END 87319 -
87320 # FROM t1 87320 -
87321 #; 87321 -
87322 % ., . # table_name 87322 -
87323 # .L5, .L7 # table_name 87323 -
87324 % L, L # name 87324 -
87325 # L5, L7 # name 87325 -
87326 % bigint, smallint # type 87326 -
87327 % 1, 3 # length 87327 -
87328 [ 0, 444 ] 87328 -
87329 [ 0, 333 ] 87329 -
87330 [ 0, 444 ] 87330 -
87331 [ 0, 444 ] 87331 -
87332 [ 0, 222 ] 87332 -
87333 [ 0, 222 ] 87333 -
87334 [ 0, 333 ] 87334 -
87335 [ 0, 222 ] 87335 -
87336 [ 0, 222 ] 87336 -
87337 [ 0, 444 ] 87337 -
87338 [ 0, 333 ] 87338 -
87339 [ 0, 333 ] 87339 -
87340 [ 0, 444 ] 87340 -
87341 [ 0, 333 ] 87341 -
87342 [ 0, 444 ] 87342 -
87343 [ 0, 444 ] 87343 -
87344 [ 0, 333 ] 87344 -
87345 [ 0, 333 ] 87345 -
87346 [ 0, 222 ] 87346 -
87347 [ 0, 333 ] 87347 -
87348 [ 0, 444 ] 87348 -
87349 [ 0, 444 ] 87349 -
87350 [ 0, 333 ] 87350 -
87351 [ 0, 222 ] 87351 -
87352 [ 0, 222 ] 87352 -
87353 [ 0, 333 ] 87353 -
87354 [ 0, 333 ] 87354 -
87355 [ 0, 444 ] 87355 -
87356 [ 0, 444 ] 87356 -
87357 [ 0, 111 ] 87357 -
87358 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d), 87358 -
87359 # CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 87359 -
87360 # WHEN a<b+3 THEN 333 ELSE 444 END 87360 -
87361 # FROM t1 87361 -
87362 # ORDER BY 1,2 87362 -
87363 #; 87363 -
87364 % ., . # table_name 87364 -
87365 # .L5, .L7 # table_name 87365 -
87366 % L, L # name 87366 -
87367 # L5, L7 # name 87367 -
87368 % bigint, smallint # type 87368 -
87369 % 1, 3 # length 87369 -
87370 [ 0, 111 ] 87370 -
87371 [ 0, 222 ] 87371 -
87372 [ 0, 222 ] 87372 -
87373 [ 0, 222 ] 87373 -
87374 [ 0, 222 ] 87374 -
87375 [ 0, 222 ] 87375 -
87376 [ 0, 222 ] 87376 -
87377 [ 0, 222 ] 87377 -
87378 [ 0, 333 ] 87378 -
87379 [ 0, 333 ] 87379 -
87380 [ 0, 333 ] 87380 -
87381 [ 0, 333 ] 87381 -
87382 [ 0, 333 ] 87382 -
87383 [ 0, 333 ] 87383 -
87384 [ 0, 333 ] 87384 -
87385 [ 0, 333 ] 87385 -
87386 [ 0, 333 ] 87386 -
87387 [ 0, 333 ] 87387 -
87388 [ 0, 333 ] 87388 -
87389 [ 0, 444 ] 87389 -
87390 [ 0, 444 ] 87390 -
87391 [ 0, 444 ] 87391 -
87392 [ 0, 444 ] 87392 -
87393 [ 0, 444 ] 87393 -
87394 [ 0, 444 ] 87394 -
87395 [ 0, 444 ] 87395 -
87396 [ 0, 444 ] 87396 -
87397 [ 0, 444 ] 87397 -
87398 [ 0, 444 ] 87398 -
87399 [ 0, 444 ] 87399 -
87400 #SELECT abs(a), 87400 -
87401 # c 87401 -
87402 # FROM t1 87402 -
87403 # WHERE d NOT BETWEEN 110 AND 150 87403 -
87404 # AND c BETWEEN b-2 AND d+2 87404 -
87405 #; 87405 -
87406 % sys., sys.t1 # table_name 87406 -
87407 # sys.L2, sys.t1 # table_name 87407 -
87408 % L, c # name 87408 -
87409 # L2, c # name 87409 -
87410 % int, int # type 87410 -
87411 % 3, 3 # length 87411 -
87412 [ 107, 106 ] 87412 -
87413 [ 163, 161 ] 87413 -
87414 [ 174, 172 ] 87414 -
87415 [ 182, 184 ] 87415 -
87416 [ 188, 187 ] 87416 -
87417 [ NULL, 208 ] 87417 -
87418 [ 213, 214 ] 87418 -
87419 [ 220, 224 ] 87419 -
87420 [ 234, 231 ] 87420 -
87421 [ 245, 247 ] 87421 -
87422 #SELECT abs(a), 87422 -
87423 # c 87423 -
87424 # FROM t1 87424 -
87425 # WHERE d NOT BETWEEN 110 AND 150 87425 -
87426 # AND c BETWEEN b-2 AND d+2 87426 -
87427 # ORDER BY 1,2 87427 -
87428 #; 87428 -
87429 % sys., sys.t1 # table_name 87429 -
87430 # sys.L2, sys.t1 # table_name 87430 -
87431 % L, c # name 87431 -
87432 # L2, c # name 87432 -
87433 % int, int # type 87433 -
87434 % 3, 3 # length 87434 -
87435 [ NULL, 208 ] 87435 -
87436 [ 107, 106 ] 87436 -
87437 [ 163, 161 ] 87437 -
87438 [ 174, 172 ] 87438 -
87439 [ 182, 184 ] 87439 -
87440 [ 188, 187 ] 87440 -
87441 [ 213, 214 ] 87441 -
87442 [ 220, 224 ] 87442 -
87443 [ 234, 231 ] 87443 -
87444 [ 245, 247 ] 87444 -
87445 #SELECT abs(a), 87445 -
87446 # c 87446 -
87447 # FROM t1 87447 -
87448 # WHERE c BETWEEN b-2 AND d+2 87448 -
87449 # AND d NOT BETWEEN 110 AND 150 87449 -
87450 #; 87450 -
87451 % sys., sys.t1 # table_name 87451 -
87452 # sys.L2, sys.t1 # table_name 87452 -
87453 % L, c # name 87453 -
87454 # L2, c # name 87454 -
87455 % int, int # type 87455 -
87456 % 3, 3 # length 87456 -
87457 [ 107, 106 ] 87457 -
87458 [ 163, 161 ] 87458 -
87459 [ 174, 172 ] 87459 -
87460 [ 182, 184 ] 87460 -
87461 [ 188, 187 ] 87461 -
87462 [ NULL, 208 ] 87462 -
87463 [ 213, 214 ] 87463 -
87464 [ 220, 224 ] 87464 -
87465 [ 234, 231 ] 87465 -
87466 [ 245, 247 ] 87466 -
87467 #SELECT abs(a), 87467 -
87468 # c 87468 -
87469 # FROM t1 87469 -
87470 # WHERE c BETWEEN b-2 AND d+2 87470 -
87471 # AND d NOT BETWEEN 110 AND 150 87471 -
87472 # ORDER BY 1,2 87472 -
87473 #; 87473 -
87474 % sys., sys.t1 # table_name 87474 -
87475 # sys.L2, sys.t1 # table_name 87475 -
87476 % L, c # name 87476 -
87477 # L2, c # name 87477 -
87478 % int, int # type 87478 -
87479 % 3, 3 # length 87479 -
87480 [ NULL, 208 ] 87480 -
87481 [ 107, 106 ] 87481 -
87482 [ 163, 161 ] 87482 -
87483 [ 174, 172 ] 87483 -
87484 [ 182, 184 ] 87484 -
87485 [ 188, 187 ] 87485 -
87486 [ 213, 214 ] 87486 -
87487 [ 220, 224 ] 87487 -
87488 [ 234, 231 ] 87488 -
87489 [ 245, 247 ] 87489 -
87490 #SELECT e, 87490 -
87491 # a, 87491 -
87492 # a-b 87492 -
87493 # FROM t1 87493 -
87494 # WHERE e+d BETWEEN a+b-10 AND c+130 87494 -
87495 #; 87495 -
87496 % sys.t1, sys.t1, sys. # table_name 87496 -
87497 # sys.t1, sys.t1, sys.L4 # table_name 87497 -
87498 % e, a, L # name 87498 -
87499 # e, a, L4 # name 87499 -
87500 % int, int, bigint # type 87500 -
87501 % 3, 3, 2 # length 87501 -
87502 [ 109, 107, 2 ] 87502 -
87503 [ 126, 127, -2 ] 87503 -
87504 #SELECT e, 87504 -
87505 # a, 87505 -
87506 # a-b 87506 -
87507 # FROM t1 87507 -
87508 # WHERE e+d BETWEEN a+b-10 AND c+130 87508 -
87509 # ORDER BY 3,2,1 87509 -
87510 #; 87510 -
87511 % sys.t1, sys.t1, sys. # table_name 87511 -
87512 # sys.t1, sys.t1, sys.L4 # table_name 87512 -
87513 % e, a, L # name 87513 -
87514 # e, a, L4 # name 87514 -
87515 % int, int, bigint # type 87515 -
87516 % 3, 3, 2 # length 87516 -
87517 [ 126, 127, -2 ] 87517 -
87518 [ 109, 107, 2 ] 87518 -
87519 #SELECT a-b, 87519 -
87520 # a+b*2 87520 -
87521 # FROM t1 87521 -
87522 # WHERE c BETWEEN b-2 AND d+2 87522 -
87523 # AND (e>a AND e<b) 87523 -
87524 #; 87524 -
87525 % sys., sys. # table_name 87525 -
87526 # sys.L2, sys.L4 # table_name 87526 -
87527 % L, L # name 87527 -
87528 # L2, L4 # name 87528 -
87529 % bigint, bigint # type 87529 -
87530 % 2, 3 # length 87530 -
87531 [ -3, 666 ] 87531 -
87532 [ -4, 743 ] 87532 -
87533 #SELECT a-b, 87533 -
87534 # a+b*2 87534 -
87535 # FROM t1 87535 -
87536 # WHERE c BETWEEN b-2 AND d+2 87536 -
87537 # AND (e>a AND e<b) 87537 -
87538 # ORDER BY 2,1 87538 -
87539 #; 87539 -
87540 % sys., sys. # table_name 87540 -
87541 # sys.L2, sys.L4 # table_name 87541 -
87542 % L, L # name 87542 -
87543 # L2, L4 # name 87543 -
87544 % bigint, bigint # type 87544 -
87545 % 2, 3 # length 87545 -
87546 [ -3, 666 ] 87546 -
87547 [ -4, 743 ] 87547 -
87548 #SELECT a-b, 87548 -
87549 # a+b*2 87549 -
87550 # FROM t1 87550 -
87551 # WHERE (e>a AND e<b) 87551 -
87552 # AND c BETWEEN b-2 AND d+2 87552 -
87553 #; 87553 -
87554 % sys., sys. # table_name 87554 -
87555 # sys.L2, sys.L4 # table_name 87555 -
87556 % L, L # name 87556 -
87557 # L2, L4 # name 87557 -
87558 % bigint, bigint # type 87558 -
87559 % 2, 3 # length 87559 -
87560 [ -3, 666 ] 87560 -
87561 [ -4, 743 ] 87561 -
87562 #SELECT a-b, 87562 -
87563 # a+b*2 87563 -
87564 # FROM t1 87564 -
87565 # WHERE (e>a AND e<b) 87565 -
87566 # AND c BETWEEN b-2 AND d+2 87566 -
87567 # ORDER BY 2,1 87567 -
87568 #; 87568 -
87569 % sys., sys. # table_name 87569 -
87570 # sys.L2, sys.L4 # table_name 87570 -
87571 % L, L # name 87571 -
87572 # L2, L4 # name 87572 -
87573 % bigint, bigint # type 87573 -
87574 % 2, 3 # length 87574 -
87575 [ -3, 666 ] 87575 -
87576 [ -4, 743 ] 87576 -
87577 #SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END 87577 -
87578 # FROM t1 87578 -
87579 #; 87579 -
87580 % sys. # table_name 87580 -
87581 # sys.L6 # table_name 87581 -
87582 % L # name 87582 -
87583 # L6 # name 87583 -
87584 % bigint # type 87584 -
87585 % 4 # length 87585 -
87586 [ NULL ] 87586 -
87587 [ 1050 ] 87587 -
87588 [ 1120 ] 87588 -
87589 [ NULL ] 87589 -
87590 [ 1240 ] 87590 -
87591 [ 1290 ] 87591 -
87592 [ 1300 ] 87592 -
87593 [ 1390 ] 87593 -
87594 [ 1430 ] 87594 -
87595 [ 1450 ] 87595 -
87596 [ 1510 ] 87596 -
87597 [ 1580 ] 87597 -
87598 [ 1600 ] 87598 -
87599 [ 1670 ] 87599 -
87600 [ 1700 ] 87600 -
87601 [ 358 ] 87601 -
87602 [ 364 ] 87602 -
87603 [ 376 ] 87603 -
87604 [ 382 ] 87604 -
87605 [ 398 ] 87605 -
87606 [ 402 ] 87606 -
87607 [ NULL ] 87607 -
87608 [ 426 ] 87608 -
87609 [ 432 ] 87609 -
87610 [ 440 ] 87610 -
87611 [ 458 ] 87611 -
87612 [ 468 ] 87612 -
87613 [ 2360 ] 87613 -
87614 [ 486 ] 87614 -
87615 [ 490 ] 87615 -
87616 #SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END 87616 -
87617 # FROM t1 87617 -
87618 # ORDER BY 1 87618 -
87619 #; 87619 -
87620 % sys. # table_name 87620 -
87621 # sys.L6 # table_name 87621 -
87622 % L # name 87622 -
87623 # L6 # name 87623 -
87624 % bigint # type 87624 -
87625 % 4 # length 87625 -
87626 [ NULL ] 87626 -
87627 [ NULL ] 87627 -
87628 [ NULL ] 87628 -
87629 [ 358 ] 87629 -
87630 [ 364 ] 87630 -
87631 [ 376 ] 87631 -
87632 [ 382 ] 87632 -
87633 [ 398 ] 87633 -
87634 [ 402 ] 87634 -
87635 [ 426 ] 87635 -
87636 [ 432 ] 87636 -
87637 [ 440 ] 87637 -
87638 [ 458 ] 87638 -
87639 [ 468 ] 87639 -
87640 [ 486 ] 87640 -
87641 [ 490 ] 87641 -
87642 [ 1050 ] 87642 -
87643 [ 1120 ] 87643 -
87644 [ 1240 ] 87644 -
87645 [ 1290 ] 87645 -
87646 [ 1300 ] 87646 -
87647 [ 1390 ] 87647 -
87648 [ 1430 ] 87648 -
87649 [ 1450 ] 87649 -
87650 [ 1510 ] 87650 -
87651 [ 1580 ] 87651 -
87652 [ 1600 ] 87652 -
87653 [ 1670 ] 87653 -
87654 [ 1700 ] 87654 -
87655 [ 2360 ] 87655 -
87656 #SELECT a+b*2+c*3+d*4, 87656 -
87657 # a+b*2, 87657 -
87658 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 87658 -
87659 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 87659 -
87660 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 87660 -
87661 # CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 87661 -
87662 # a+b*2+c*3+d*4+e*5 87662 -
87663 # FROM t1 87663 -
87664 #; 87664 -
87665 % ., ., ., ., ., . # table_name 87665 -
87666 # .L2, .L4, .L11, .L14, .L23, .L25 # table_name 87666 -
87667 % L, L, L, L, L, L # name 87667 -
87668 # L2, L4, L11, L14, L23, L25 # name 87668 -
87669 % hugeint, bigint, bigint, smallint, bigint, hugeint # type 87669 -
87670 % 4, 3, 2, 3, 4, 4 # length 87670 -
87671 [ NULL, NULL, 1, 555, 1120, NULL ] 87671 -
87672 [ 1226, 369, 2, 333, 1240, NULL ] 87672 -
87673 [ 1272, 385, 3, 333, 1290, 1902 ] 87673 -
87674 [ 1325, 391, 4, 444, 1300, 1985 ] 87674 -
87675 [ 1371, 416, 5, 111, 1390, 2046 ] 87675 -
87676 [ 1411, 428, 6, 111, 1430, 2131 ] 87676 -
87677 [ NULL, 439, 7, 555, 1450, NULL ] 87677 -
87678 [ NULL, 455, 8, 555, 1510, NULL ] 87678 -
87679 [ NULL, 475, 9, 555, 1580, NULL ] 87679 -
87680 [ 1622, 483, 10, 333, 1600, 2432 ] 87680 -
87681 [ NULL, 502, 11, 555, 1670, NULL ] 87681 -
87682 [ 1714, 514, 12, 555, 1700, 2579 ] 87682 -
87683 [ NULL, 529, 13, 555, 358, NULL ] 87683 -
87684 [ 1828, 544, 14, 333, 364, 2728 ] 87684 -
87685 [ 1861, 560, 15, 444, 376, 2806 ] 87685 -
87686 [ 1918, 579, 16, 444, 382, 2878 ] 87686 -
87687 [ 1964, 595, 17, 555, 398, 2949 ] 87687 -
87688 [ NULL, NULL, 18, 555, NULL, NULL ] 87688 -
87689 [ 2125, 635, 19, 222, 426, 3175 ] 87689 -
87690 [ 2165, 652, 20, 333, 432, 3260 ] 87690 -
87691 [ 2226, 666, 21, 444, 440, 3331 ] 87691 -
87692 [ 2264, 685, 22, 555, 458, 3399 ] 87692 -
87693 [ 2323, 698, 23, 555, 468, 3473 ] 87693 -
87694 [ NULL, 711, 24, 555, 2360, NULL ] 87694 -
87695 [ NULL, 723, 25, 222, 486, NULL ] 87695 -
87696 [ 2476, 743, 26, 444, 490, 3706 ] 87696 -
87697 [ NULL, NULL, 0, 555, NULL, NULL ] 87697 -
87698 [ 1067, 317, 0, 333, 1050, 1612 ] 87698 -
87699 [ NULL, NULL, 0, 333, NULL, NULL ] 87699 -
87700 [ NULL, NULL, 0, 222, 402, NULL ] 87700 -
87701 #SELECT a+b*2+c*3+d*4, 87701 -
87702 # a+b*2, 87702 -
87703 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 87703 -
87704 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 87704 -
87705 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 87705 -
87706 # CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 87706 -
87707 # a+b*2+c*3+d*4+e*5 87707 -
87708 # FROM t1 87708 -
87709 # ORDER BY 2,1,4 87709 -
87710 #; 87710 -
87711 % ., ., ., ., ., . # table_name 87711 -
87712 # .L2, .L4, .L11, .L14, .L23, .L25 # table_name 87712 -
87713 % L, L, L, L, L, L # name 87713 -
87714 # L2, L4, L11, L14, L23, L25 # name 87714 -
87715 % hugeint, bigint, bigint, smallint, bigint, hugeint # type 87715 -
87716 % 4, 3, 2, 3, 4, 4 # length 87716 -
87717 [ NULL, NULL, 0, 222, 402, NULL ] 87717 -
87718 [ NULL, NULL, 0, 333, NULL, NULL ] 87718 -
87719 [ NULL, NULL, 1, 555, 1120, NULL ] 87719 -
87720 [ NULL, NULL, 18, 555, NULL, NULL ] 87720 -
87721 [ NULL, NULL, 0, 555, NULL, NULL ] 87721 -
87722 [ 1067, 317, 0, 333, 1050, 1612 ] 87722 -
87723 [ 1226, 369, 2, 333, 1240, NULL ] 87723 -
87724 [ 1272, 385, 3, 333, 1290, 1902 ] 87724 -
87725 [ 1325, 391, 4, 444, 1300, 1985 ] 87725 -
87726 [ 1371, 416, 5, 111, 1390, 2046 ] 87726 -
87727 [ 1411, 428, 6, 111, 1430, 2131 ] 87727 -
87728 [ NULL, 439, 7, 555, 1450, NULL ] 87728 -
87729 [ NULL, 455, 8, 555, 1510, NULL ] 87729 -
87730 [ NULL, 475, 9, 555, 1580, NULL ] 87730 -
87731 [ 1622, 483, 10, 333, 1600, 2432 ] 87731 -
87732 [ NULL, 502, 11, 555, 1670, NULL ] 87732 -
87733 [ 1714, 514, 12, 555, 1700, 2579 ] 87733 -
87734 [ NULL, 529, 13, 555, 358, NULL ] 87734 -
87735 [ 1828, 544, 14, 333, 364, 2728 ] 87735 -
87736 [ 1861, 560, 15, 444, 376, 2806 ] 87736 -
87737 [ 1918, 579, 16, 444, 382, 2878 ] 87737 -
87738 [ 1964, 595, 17, 555, 398, 2949 ] 87738 -
87739 [ 2125, 635, 19, 222, 426, 3175 ] 87739 -
87740 [ 2165, 652, 20, 333, 432, 3260 ] 87740 -
87741 [ 2226, 666, 21, 444, 440, 3331 ] 87741 -
87742 [ 2264, 685, 22, 555, 458, 3399 ] 87742 -
87743 [ 2323, 698, 23, 555, 468, 3473 ] 87743 -
87744 [ NULL, 711, 24, 555, 2360, NULL ] 87744 -
87745 [ NULL, 723, 25, 222, 486, NULL ] 87745 -
87746 [ 2476, 743, 26, 444, 490, 3706 ] 87746 -
87747 #SELECT e 87747 -
87748 # FROM t1 87748 -
87749 # WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 87749 -
87750 #; 87750 -
87751 % sys.t1 # table_name 87751 -
87752 % e # name 87752 -
87753 % int # type 87753 -
87754 % 3 # length 87754 -
87755 [ 110 ] 87755 -
87756 [ NULL ] 87756 -
87757 [ 126 ] 87757 -
87758 [ 132 ] 87758 -
87759 [ 135 ] 87759 -
87760 [ 144 ] 87760 -
87761 [ 146 ] 87761 -
87762 [ NULL ] 87762 -
87763 [ 157 ] 87763 -
87764 [ 162 ] 87764 -
87765 [ 165 ] 87765 -
87766 [ 173 ] 87766 -
87767 [ 177 ] 87767 -
87768 [ 180 ] 87768 -
87769 [ 189 ] 87769 -
87770 [ 192 ] 87770 -
87771 [ 197 ] 87771 -
87772 [ NULL ] 87772 -
87773 [ 210 ] 87773 -
87774 [ 219 ] 87774 -
87775 [ 221 ] 87775 -
87776 [ 227 ] 87776 -
87777 [ 230 ] 87777 -
87778 [ 237 ] 87778 -
87779 [ NULL ] 87779 -
87780 [ 246 ] 87780 -
87781 #SELECT e 87781 -
87782 # FROM t1 87782 -
87783 # WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 87783 -
87784 # ORDER BY 1 87784 -
87785 #; 87785 -
87786 % sys.t1 # table_name 87786 -
87787 % e # name 87787 -
87788 % int # type 87788 -
87789 % 3 # length 87789 -
87790 [ NULL ] 87790 -
87791 [ NULL ] 87791 -
87792 [ NULL ] 87792 -
87793 [ NULL ] 87793 -
87794 [ 110 ] 87794 -
87795 [ 126 ] 87795 -
87796 [ 132 ] 87796 -
87797 [ 135 ] 87797 -
87798 [ 144 ] 87798 -
87799 [ 146 ] 87799 -
87800 [ 157 ] 87800 -
87801 [ 162 ] 87801 -
87802 [ 165 ] 87802 -
87803 [ 173 ] 87803 -
87804 [ 177 ] 87804 -
87805 [ 180 ] 87805 -
87806 [ 189 ] 87806 -
87807 [ 192 ] 87807 -
87808 [ 197 ] 87808 -
87809 [ 210 ] 87809 -
87810 [ 219 ] 87810 -
87811 [ 221 ] 87811 -
87812 [ 227 ] 87812 -
87813 [ 230 ] 87813 -
87814 [ 237 ] 87814 -
87815 [ 246 ] 87815 -
87816 #SELECT d-e, 87816 -
87817 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 87817 -
87818 # a+b*2+c*3, 87818 -
87819 # a 87819 -
87820 # FROM t1 87820 -
87821 #; 87821 -
87822 % ., ., ., .t1 # table_name 87822 -
87823 # .L2, .L7, .L12, .t1 # table_name 87823 -
87824 % L, L, L, a # name 87824 -
87825 # L2, L7, L12, a # name 87825 -
87826 % bigint, bigint, hugeint, int # type 87826 -
87827 % 2, 2, 4, 3 # length 87827 -
87828 [ 4, 1, NULL, NULL ] 87828 -
87829 [ NULL, 2, 738, 121 ] 87829 -
87830 [ 2, 3, 760, 127 ] 87830 -
87831 [ 1, 4, 793, 131 ] 87831 -
87832 [ 1, 5, 827, 138 ] 87832 -
87833 [ -4, 6, 851, 142 ] 87833 -
87834 [ NULL, 7, 880, 149 ] 87834 -
87835 [ NULL, 8, 905, 153 ] 87835 -
87836 [ NULL, 9, 940, 159 ] 87836 -
87837 [ 2, 10, 966, 163 ] 87837 -
87838 [ NULL, 11, 1000, 168 ] 87838 -
87839 [ -2, 12, 1030, 174 ] 87839 -
87840 [ NULL, 13, 1057, 179 ] 87840 -
87841 [ 3, 14, 1096, 182 ] 87841 -
87842 [ -4, 15, 1121, 188 ] 87842 -
87843 [ -2, 16, 1158, 191 ] 87843 -
87844 [ -1, 17, 1180, 199 ] 87844 -
87845 [ NULL, 18, NULL, NULL ] 87845 -
87846 [ 2, 19, 1277, 213 ] 87846 -
87847 [ -2, 20, 1297, 216 ] 87847 -
87848 [ 1, 21, 1338, 220 ] 87848 -
87849 [ -1, 22, 1360, 229 ] 87849 -
87850 [ 3, 23, 1391, 234 ] 87850 -
87851 [ 1, 24, NULL, 239 ] 87851 -
87852 [ NULL, 25, 1455, 243 ] 87852 -
87853 [ 2, 26, 1484, 245 ] 87853 -
87854 [ NULL, 0, NULL, 104 ] 87854 -
87855 [ -1, 0, 635, 107 ] 87855 -
87856 [ -1, 0, NULL, 115 ] 87856 -
87857 [ -1, 0, NULL, 201 ] 87857 -
87858 #SELECT d-e, 87858 -
87859 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 87859 -
87860 # a+b*2+c*3, 87860 -
87861 # a 87861 -
87862 # FROM t1 87862 -
87863 # ORDER BY 2,1,3 87863 -
87864 #; 87864 -
87865 % ., ., ., .t1 # table_name 87865 -
87866 # .L2, .L7, .L12, .t1 # table_name 87866 -
87867 % L, L, L, a # name 87867 -
87868 # L2, L7, L12, a # name 87868 -
87869 % bigint, bigint, hugeint, int # type 87869 -
87870 % 2, 2, 4, 3 # length 87870 -
87871 [ NULL, 0, NULL, 104 ] 87871 -
87872 [ -1, 0, NULL, 115 ] 87872 -
87873 [ -1, 0, NULL, 201 ] 87873 -
87874 [ -1, 0, 635, 107 ] 87874 -
87875 [ 4, 1, NULL, NULL ] 87875 -
87876 [ NULL, 2, 738, 121 ] 87876 -
87877 [ 2, 3, 760, 127 ] 87877 -
87878 [ 1, 4, 793, 131 ] 87878 -
87879 [ 1, 5, 827, 138 ] 87879 -
87880 [ -4, 6, 851, 142 ] 87880 -
87881 [ NULL, 7, 880, 149 ] 87881 -
87882 [ NULL, 8, 905, 153 ] 87882 -
87883 [ NULL, 9, 940, 159 ] 87883 -
87884 [ 2, 10, 966, 163 ] 87884 -
87885 [ NULL, 11, 1000, 168 ] 87885 -
87886 [ -2, 12, 1030, 174 ] 87886 -
87887 [ NULL, 13, 1057, 179 ] 87887 -
87888 [ 3, 14, 1096, 182 ] 87888 -
87889 [ -4, 15, 1121, 188 ] 87889 -
87890 [ -2, 16, 1158, 191 ] 87890 -
87891 [ -1, 17, 1180, 199 ] 87891 -
87892 [ NULL, 18, NULL, NULL ] 87892 -
87893 [ 2, 19, 1277, 213 ] 87893 -
87894 [ -2, 20, 1297, 216 ] 87894 -
87895 [ 1, 21, 1338, 220 ] 87895 -
87896 [ -1, 22, 1360, 229 ] 87896 -
87897 [ 3, 23, 1391, 234 ] 87897 -
87898 [ 1, 24, NULL, 239 ] 87898 -
87899 [ NULL, 25, 1455, 243 ] 87899 -
87900 [ 2, 26, 1484, 245 ] 87900 -
87901 #SELECT d, 87901 -
87902 # a+b*2+c*3+d*4, 87902 -
87903 # c, 87903 -
87904 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b) 87904 -
87905 # FROM t1 87905 -
87906 # WHERE (e>a AND e<b) 87906 -
87907 # OR (a>b-2 AND a<b+2) 87907 -
87908 # OR e+d BETWEEN a+b-10 AND c+130 87908 -
87909 #; 87909 -
87910 % .t1, ., .t1, . # table_name 87910 -
87911 # .t1, .L3, .t1, .L11 # table_name 87911 -
87912 % d, L, c, L # name 87912 -
87913 # d, L3, c, L11 # name 87913 -
87914 % int, hugeint, int, bigint # type 87914 -
87915 % 3, 4, 3, 2 # length 87915 -
87916 [ 128, 1272, 125, 3 ] 87916 -
87917 [ 133, 1325, 134, 4 ] 87917 -
87918 [ 136, 1371, 137, 5 ] 87918 -
87919 [ 140, 1411, 141, 6 ] 87919 -
87920 [ NULL, NULL, 155, 9 ] 87920 -
87921 [ NULL, NULL, 166, 11 ] 87921 -
87922 [ 183, 1828, 184, 14 ] 87922 -
87923 [ 190, 1918, 193, 16 ] 87923 -
87924 [ 196, 1964, 195, 17 ] 87924 -
87925 [ 222, 2226, 224, 21 ] 87925 -
87926 [ 226, 2264, 225, 22 ] 87926 -
87927 [ 248, 2476, 247, 26 ] 87927 -
87928 [ 108, 1067, 106, 0 ] 87928 -
87929 #SELECT d, 87929 -
87930 # a+b*2+c*3+d*4, 87930 -
87931 # c, 87931 -
87932 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b) 87932 -
87933 # FROM t1 87933 -
87934 # WHERE (e>a AND e<b) 87934 -
87935 # OR (a>b-2 AND a<b+2) 87935 -
87936 # OR e+d BETWEEN a+b-10 AND c+130 87936 -
87937 # ORDER BY 1,4,2,3 87937 -
87938 #; 87938 -
87939 % .t1, ., .t1, . # table_name 87939 -
87940 # .t1, .L3, .t1, .L11 # table_name 87940 -
87941 % d, L, c, L # name 87941 -
87942 # d, L3, c, L11 # name 87942 -
87943 % int, hugeint, int, bigint # type 87943 -
87944 % 3, 4, 3, 2 # length 87944 -
87945 [ NULL, NULL, 155, 9 ] 87945 -
87946 [ NULL, NULL, 166, 11 ] 87946 -
87947 [ 108, 1067, 106, 0 ] 87947 -
87948 [ 128, 1272, 125, 3 ] 87948 -
87949 [ 133, 1325, 134, 4 ] 87949 -
87950 [ 136, 1371, 137, 5 ] 87950 -
87951 [ 140, 1411, 141, 6 ] 87951 -
87952 [ 183, 1828, 184, 14 ] 87952 -
87953 [ 190, 1918, 193, 16 ] 87953 -
87954 [ 196, 1964, 195, 17 ] 87954 -
87955 [ 222, 2226, 224, 21 ] 87955 -
87956 [ 226, 2264, 225, 22 ] 87956 -
87957 [ 248, 2476, 247, 26 ] 87957 -
87958 #SELECT d, 87958 -
87959 # a+b*2+c*3+d*4, 87959 -
87960 # c, 87960 -
87961 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b) 87961 -
87962 # FROM t1 87962 -
87963 # WHERE (a>b-2 AND a<b+2) 87963 -
87964 # OR (e>a AND e<b) 87964 -
87965 # OR e+d BETWEEN a+b-10 AND c+130 87965 -
87966 #; 87966 -
87967 % .t1, ., .t1, . # table_name 87967 -
87968 # .t1, .L3, .t1, .L11 # table_name 87968 -
87969 % d, L, c, L # name 87969 -
87970 # d, L3, c, L11 # name 87970 -
87971 % int, hugeint, int, bigint # type 87971 -
87972 % 3, 4, 3, 2 # length 87972 -
87973 [ 128, 1272, 125, 3 ] 87973 -
87974 [ 133, 1325, 134, 4 ] 87974 -
87975 [ 136, 1371, 137, 5 ] 87975 -
87976 [ 140, 1411, 141, 6 ] 87976 -
87977 [ NULL, NULL, 155, 9 ] 87977 -
87978 [ NULL, NULL, 166, 11 ] 87978 -
87979 [ 183, 1828, 184, 14 ] 87979 -
87980 [ 190, 1918, 193, 16 ] 87980 -
87981 [ 196, 1964, 195, 17 ] 87981 -
87982 [ 222, 2226, 224, 21 ] 87982 -
87983 [ 226, 2264, 225, 22 ] 87983 -
87984 [ 248, 2476, 247, 26 ] 87984 -
87985 [ 108, 1067, 106, 0 ] 87985 -
87986 #SELECT d, 87986 -
87987 # a+b*2+c*3+d*4, 87987 -
87988 # c, 87988 -
87989 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b) 87989 -
87990 # FROM t1 87990 -
87991 # WHERE (a>b-2 AND a<b+2) 87991 -
87992 # OR (e>a AND e<b) 87992 -
87993 # OR e+d BETWEEN a+b-10 AND c+130 87993 -
87994 # ORDER BY 3,4 87994 -
87995 #; 87995 -
87996 % .t1, ., .t1, . # table_name 87996 -
87997 # .t1, .L3, .t1, .L11 # table_name 87997 -
87998 % d, L, c, L # name 87998 -
87999 # d, L3, c, L11 # name 87999 -
88000 % int, hugeint, int, bigint # type 88000 -
88001 % 3, 4, 3, 2 # length 88001 -
88002 [ 108, 1067, 106, 0 ] 88002 -
88003 [ 128, 1272, 125, 3 ] 88003 -
88004 [ 133, 1325, 134, 4 ] 88004 -
88005 [ 136, 1371, 137, 5 ] 88005 -
88006 [ 140, 1411, 141, 6 ] 88006 -
88007 [ NULL, NULL, 155, 9 ] 88007 -
88008 [ NULL, NULL, 166, 11 ] 88008 -
88009 [ 183, 1828, 184, 14 ] 88009 -
88010 [ 190, 1918, 193, 16 ] 88010 -
88011 [ 196, 1964, 195, 17 ] 88011 -
88012 [ 222, 2226, 224, 21 ] 88012 -
88013 [ 226, 2264, 225, 22 ] 88013 -
88014 [ 248, 2476, 247, 26 ] 88014 -
88015 #SELECT d, 88015 -
88016 # a+b*2+c*3+d*4, 88016 -
88017 # c, 88017 -
88018 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b) 88018 -
88019 # FROM t1 88019 -
88020 # WHERE e+d BETWEEN a+b-10 AND c+130 88020 -
88021 # OR (a>b-2 AND a<b+2) 88021 -
88022 # OR (e>a AND e<b) 88022 -
88023 #; 88023 -
88024 % .t1, ., .t1, . # table_name 88024 -
88025 # .t1, .L3, .t1, .L11 # table_name 88025 -
88026 % d, L, c, L # name 88026 -
88027 # d, L3, c, L11 # name 88027 -
88028 % int, hugeint, int, bigint # type 88028 -
88029 % 3, 4, 3, 2 # length 88029 -
88030 [ 128, 1272, 125, 3 ] 88030 -
88031 [ 133, 1325, 134, 4 ] 88031 -
88032 [ 136, 1371, 137, 5 ] 88032 -
88033 [ 140, 1411, 141, 6 ] 88033 -
88034 [ NULL, NULL, 155, 9 ] 88034 -
88035 [ NULL, NULL, 166, 11 ] 88035 -
88036 [ 183, 1828, 184, 14 ] 88036 -
88037 [ 190, 1918, 193, 16 ] 88037 -
88038 [ 196, 1964, 195, 17 ] 88038 -
88039 [ 222, 2226, 224, 21 ] 88039 -
88040 [ 226, 2264, 225, 22 ] 88040 -
88041 [ 248, 2476, 247, 26 ] 88041 -
88042 [ 108, 1067, 106, 0 ] 88042 -
88043 #SELECT d, 88043 -
88044 # a+b*2+c*3+d*4, 88044 -
88045 # c, 88045 -
88046 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b) 88046 -
88047 # FROM t1 88047 -
88048 # WHERE e+d BETWEEN a+b-10 AND c+130 88048 -
88049 # OR (a>b-2 AND a<b+2) 88049 -
88050 # OR (e>a AND e<b) 88050 -
88051 # ORDER BY 4,2,3 88051 -
88052 #; 88052 -
88053 % .t1, ., .t1, . # table_name 88053 -
88054 # .t1, .L3, .t1, .L11 # table_name 88054 -
88055 % d, L, c, L # name 88055 -
88056 # d, L3, c, L11 # name 88056 -
88057 % int, hugeint, int, bigint # type 88057 -
88058 % 3, 4, 3, 2 # length 88058 -
88059 [ 108, 1067, 106, 0 ] 88059 -
88060 [ 128, 1272, 125, 3 ] 88060 -
88061 [ 133, 1325, 134, 4 ] 88061 -
88062 [ 136, 1371, 137, 5 ] 88062 -
88063 [ 140, 1411, 141, 6 ] 88063 -
88064 [ NULL, NULL, 155, 9 ] 88064 -
88065 [ NULL, NULL, 166, 11 ] 88065 -
88066 [ 183, 1828, 184, 14 ] 88066 -
88067 [ 190, 1918, 193, 16 ] 88067 -
88068 [ 196, 1964, 195, 17 ] 88068 -
88069 [ 222, 2226, 224, 21 ] 88069 -
88070 [ 226, 2264, 225, 22 ] 88070 -
88071 [ 248, 2476, 247, 26 ] 88071 -
88072 #SELECT d, 88072 -
88073 # a+b*2+c*3+d*4, 88073 -
88074 # c, 88074 -
88075 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b) 88075 -
88076 # FROM t1 88076 -
88077 # WHERE (e>a AND e<b) 88077 -
88078 # OR e+d BETWEEN a+b-10 AND c+130 88078 -
88079 # OR (a>b-2 AND a<b+2) 88079 -
88080 #; 88080 -
88081 % .t1, ., .t1, . # table_name 88081 -
88082 # .t1, .L3, .t1, .L11 # table_name 88082 -
88083 % d, L, c, L # name 88083 -
88084 # d, L3, c, L11 # name 88084 -
88085 % int, hugeint, int, bigint # type 88085 -
88086 % 3, 4, 3, 2 # length 88086 -
88087 [ 128, 1272, 125, 3 ] 88087 -
88088 [ 133, 1325, 134, 4 ] 88088 -
88089 [ 136, 1371, 137, 5 ] 88089 -
88090 [ 140, 1411, 141, 6 ] 88090 -
88091 [ NULL, NULL, 155, 9 ] 88091 -
88092 [ NULL, NULL, 166, 11 ] 88092 -
88093 [ 183, 1828, 184, 14 ] 88093 -
88094 [ 190, 1918, 193, 16 ] 88094 -
88095 [ 196, 1964, 195, 17 ] 88095 -
88096 [ 222, 2226, 224, 21 ] 88096 -
88097 [ 226, 2264, 225, 22 ] 88097 -
88098 [ 248, 2476, 247, 26 ] 88098 -
88099 [ 108, 1067, 106, 0 ] 88099 -
88100 #SELECT d, 88100 -
88101 # a+b*2+c*3+d*4, 88101 -
88102 # c, 88102 -
88103 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b) 88103 -
88104 # FROM t1 88104 -
88105 # WHERE (e>a AND e<b) 88105 -
88106 # OR e+d BETWEEN a+b-10 AND c+130 88106 -
88107 # OR (a>b-2 AND a<b+2) 88107 -
88108 # ORDER BY 1,4,2,3 88108 -
88109 #; 88109 -
88110 % .t1, ., .t1, . # table_name 88110 -
88111 # .t1, .L3, .t1, .L11 # table_name 88111 -
88112 % d, L, c, L # name 88112 -
88113 # d, L3, c, L11 # name 88113 -
88114 % int, hugeint, int, bigint # type 88114 -
88115 % 3, 4, 3, 2 # length 88115 -
88116 [ NULL, NULL, 155, 9 ] 88116 -
88117 [ NULL, NULL, 166, 11 ] 88117 -
88118 [ 108, 1067, 106, 0 ] 88118 -
88119 [ 128, 1272, 125, 3 ] 88119 -
88120 [ 133, 1325, 134, 4 ] 88120 -
88121 [ 136, 1371, 137, 5 ] 88121 -
88122 [ 140, 1411, 141, 6 ] 88122 -
88123 [ 183, 1828, 184, 14 ] 88123 -
88124 [ 190, 1918, 193, 16 ] 88124 -
88125 [ 196, 1964, 195, 17 ] 88125 -
88126 [ 222, 2226, 224, 21 ] 88126 -
88127 [ 226, 2264, 225, 22 ] 88127 -
88128 [ 248, 2476, 247, 26 ] 88128 -
88129 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 88129 -
88130 # c-d, 88130 -
88131 # d 88131 -
88132 # FROM t1 88132 -
88133 # WHERE (a>b-2 AND a<b+2) 88133 -
88134 # OR (e>c OR e<d) 88134 -
88135 # OR c>d 88135 -
88136 #; 88136 -
88137 % ., ., .t1 # table_name 88137 -
88138 # .L5, .L7, .t1 # table_name 88138 -
88139 % L, L, d # name 88139 -
88140 # L5, L7, d # name 88140 -
88141 % bigint, bigint, int # type 88141 -
88142 % 2, 2, 3 # length 88142 -
88143 [ 1, -1, 114 ] 88143 -
88144 [ 2, 1, 122 ] 88144 -
88145 [ 3, -3, 128 ] 88145 -
88146 [ 4, 1, 133 ] 88146 -
88147 [ 5, 1, 136 ] 88147 -
88148 [ 6, 1, 140 ] 88148 -
88149 [ 9, NULL, NULL ] 88149 -
88150 [ 10, -3, 164 ] 88150 -
88151 [ 11, NULL, NULL ] 88151 -
88152 [ 12, 1, 171 ] 88152 -
88153 [ 13, NULL, NULL ] 88153 -
88154 [ 14, 1, 183 ] 88154 -
88155 [ 15, 2, 185 ] 88155 -
88156 [ 16, 3, 190 ] 88156 -
88157 [ 17, -1, 196 ] 88157 -
88158 [ 18, 1, 207 ] 88158 -
88159 [ 19, 2, 212 ] 88159 -
88160 [ 20, -2, 217 ] 88160 -
88161 [ 21, 2, 222 ] 88161 -
88162 [ 22, -1, 226 ] 88162 -
88163 [ 23, -2, 233 ] 88163 -
88164 [ 24, NULL, 238 ] 88164 -
88165 [ 26, -1, 248 ] 88165 -
88166 [ 0, 1, 101 ] 88166 -
88167 [ 0, -2, 108 ] 88167 -
88168 [ 0, 3, 116 ] 88168 -
88169 [ 0, -1, 203 ] 88169 -
88170 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 88170 -
88171 # c-d, 88171 -
88172 # d 88172 -
88173 # FROM t1 88173 -
88174 # WHERE (a>b-2 AND a<b+2) 88174 -
88175 # OR (e>c OR e<d) 88175 -
88176 # OR c>d 88176 -
88177 # ORDER BY 1,2 88177 -
88178 #; 88178 -
88179 % ., ., .t1 # table_name 88179 -
88180 # .L5, .L7, .t1 # table_name 88180 -
88181 % L, L, d # name 88181 -
88182 # L5, L7, d # name 88182 -
88183 % bigint, bigint, int # type 88183 -
88184 % 2, 2, 3 # length 88184 -
88185 [ 0, -2, 108 ] 88185 -
88186 [ 0, -1, 203 ] 88186 -
88187 [ 0, 1, 101 ] 88187 -
88188 [ 0, 3, 116 ] 88188 -
88189 [ 1, -1, 114 ] 88189 -
88190 [ 2, 1, 122 ] 88190 -
88191 [ 3, -3, 128 ] 88191 -
88192 [ 4, 1, 133 ] 88192 -
88193 [ 5, 1, 136 ] 88193 -
88194 [ 6, 1, 140 ] 88194 -
88195 [ 9, NULL, NULL ] 88195 -
88196 [ 10, -3, 164 ] 88196 -
88197 [ 11, NULL, NULL ] 88197 -
88198 [ 12, 1, 171 ] 88198 -
88199 [ 13, NULL, NULL ] 88199 -
88200 [ 14, 1, 183 ] 88200 -
88201 [ 15, 2, 185 ] 88201 -
88202 [ 16, 3, 190 ] 88202 -
88203 [ 17, -1, 196 ] 88203 -
88204 [ 18, 1, 207 ] 88204 -
88205 [ 19, 2, 212 ] 88205 -
88206 [ 20, -2, 217 ] 88206 -
88207 [ 21, 2, 222 ] 88207 -
88208 [ 22, -1, 226 ] 88208 -
88209 [ 23, -2, 233 ] 88209 -
88210 [ 24, NULL, 238 ] 88210 -
88211 [ 26, -1, 248 ] 88211 -
88212 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 88212 -
88213 # c-d, 88213 -
88214 # d 88214 -
88215 # FROM t1 88215 -
88216 # WHERE (a>b-2 AND a<b+2) 88216 -
88217 # OR c>d 88217 -
88218 # OR (e>c OR e<d) 88218 -
88219 #; 88219 -
88220 % ., ., .t1 # table_name 88220 -
88221 # .L5, .L7, .t1 # table_name 88221 -
88222 % L, L, d # name 88222 -
88223 # L5, L7, d # name 88223 -
88224 % bigint, bigint, int # type 88224 -
88225 % 2, 2, 3 # length 88225 -
88226 [ 1, -1, 114 ] 88226 -
88227 [ 2, 1, 122 ] 88227 -
88228 [ 3, -3, 128 ] 88228 -
88229 [ 4, 1, 133 ] 88229 -
88230 [ 5, 1, 136 ] 88230 -
88231 [ 6, 1, 140 ] 88231 -
88232 [ 9, NULL, NULL ] 88232 -
88233 [ 10, -3, 164 ] 88233 -
88234 [ 11, NULL, NULL ] 88234 -
88235 [ 12, 1, 171 ] 88235 -
88236 [ 13, NULL, NULL ] 88236 -
88237 [ 14, 1, 183 ] 88237 -
88238 [ 15, 2, 185 ] 88238 -
88239 [ 16, 3, 190 ] 88239 -
88240 [ 17, -1, 196 ] 88240 -
88241 [ 18, 1, 207 ] 88241 -
88242 [ 19, 2, 212 ] 88242 -
88243 [ 20, -2, 217 ] 88243 -
88244 [ 21, 2, 222 ] 88244 -
88245 [ 22, -1, 226 ] 88245 -
88246 [ 23, -2, 233 ] 88246 -
88247 [ 24, NULL, 238 ] 88247 -
88248 [ 26, -1, 248 ] 88248 -
88249 [ 0, 1, 101 ] 88249 -
88250 [ 0, -2, 108 ] 88250 -
88251 [ 0, 3, 116 ] 88251 -
88252 [ 0, -1, 203 ] 88252 -
88253 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 88253 -
88254 # c-d, 88254 -
88255 # d 88255 -
88256 # FROM t1 88256 -
88257 # WHERE (a>b-2 AND a<b+2) 88257 -
88258 # OR c>d 88258 -
88259 # OR (e>c OR e<d) 88259 -
88260 # ORDER BY 1,2 88260 -
88261 #; 88261 -
88262 % ., ., .t1 # table_name 88262 -
88263 # .L5, .L7, .t1 # table_name 88263 -
88264 % L, L, d # name 88264 -
88265 # L5, L7, d # name 88265 -
88266 % bigint, bigint, int # type 88266 -
88267 % 2, 2, 3 # length 88267 -
88268 [ 0, -2, 108 ] 88268 -
88269 [ 0, -1, 203 ] 88269 -
88270 [ 0, 1, 101 ] 88270 -
88271 [ 0, 3, 116 ] 88271 -
88272 [ 1, -1, 114 ] 88272 -
88273 [ 2, 1, 122 ] 88273 -
88274 [ 3, -3, 128 ] 88274 -
88275 [ 4, 1, 133 ] 88275 -
88276 [ 5, 1, 136 ] 88276 -
88277 [ 6, 1, 140 ] 88277 -
88278 [ 9, NULL, NULL ] 88278 -
88279 [ 10, -3, 164 ] 88279 -
88280 [ 11, NULL, NULL ] 88280 -
88281 [ 12, 1, 171 ] 88281 -
88282 [ 13, NULL, NULL ] 88282 -
88283 [ 14, 1, 183 ] 88283 -
88284 [ 15, 2, 185 ] 88284 -
88285 [ 16, 3, 190 ] 88285 -
88286 [ 17, -1, 196 ] 88286 -
88287 [ 18, 1, 207 ] 88287 -
88288 [ 19, 2, 212 ] 88288 -
88289 [ 20, -2, 217 ] 88289 -
88290 [ 21, 2, 222 ] 88290 -
88291 [ 22, -1, 226 ] 88291 -
88292 [ 23, -2, 233 ] 88292 -
88293 [ 24, NULL, 238 ] 88293 -
88294 [ 26, -1, 248 ] 88294 -
88295 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 88295 -
88296 # c-d, 88296 -
88297 # d 88297 -
88298 # FROM t1 88298 -
88299 # WHERE c>d 88299 -
88300 # OR (e>c OR e<d) 88300 -
88301 # OR (a>b-2 AND a<b+2) 88301 -
88302 #; 88302 -
88303 % ., ., .t1 # table_name 88303 -
88304 # .L5, .L7, .t1 # table_name 88304 -
88305 % L, L, d # name 88305 -
88306 # L5, L7, d # name 88306 -
88307 % bigint, bigint, int # type 88307 -
88308 % 2, 2, 3 # length 88308 -
88309 [ 1, -1, 114 ] 88309 -
88310 [ 2, 1, 122 ] 88310 -
88311 [ 3, -3, 128 ] 88311 -
88312 [ 4, 1, 133 ] 88312 -
88313 [ 5, 1, 136 ] 88313 -
88314 [ 6, 1, 140 ] 88314 -
88315 [ 9, NULL, NULL ] 88315 -
88316 [ 10, -3, 164 ] 88316 -
88317 [ 11, NULL, NULL ] 88317 -
88318 [ 12, 1, 171 ] 88318 -
88319 [ 13, NULL, NULL ] 88319 -
88320 [ 14, 1, 183 ] 88320 -
88321 [ 15, 2, 185 ] 88321 -
88322 [ 16, 3, 190 ] 88322 -
88323 [ 17, -1, 196 ] 88323 -
88324 [ 18, 1, 207 ] 88324 -
88325 [ 19, 2, 212 ] 88325 -
88326 [ 20, -2, 217 ] 88326 -
88327 [ 21, 2, 222 ] 88327 -
88328 [ 22, -1, 226 ] 88328 -
88329 [ 23, -2, 233 ] 88329 -
88330 [ 24, NULL, 238 ] 88330 -
88331 [ 26, -1, 248 ] 88331 -
88332 [ 0, 1, 101 ] 88332 -
88333 [ 0, -2, 108 ] 88333 -
88334 [ 0, 3, 116 ] 88334 -
88335 [ 0, -1, 203 ] 88335 -
88336 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 88336 -
88337 # c-d, 88337 -
88338 # d 88338 -
88339 # FROM t1 88339 -
88340 # WHERE c>d 88340 -
88341 # OR (e>c OR e<d) 88341 -
88342 # OR (a>b-2 AND a<b+2) 88342 -
88343 # ORDER BY 3,2,1 88343 -
88344 #; 88344 -
88345 % ., ., .t1 # table_name 88345 -
88346 # .L5, .L7, .t1 # table_name 88346 -
88347 % L, L, d # name 88347 -
88348 # L5, L7, d # name 88348 -
88349 % bigint, bigint, int # type 88349 -
88350 % 2, 2, 3 # length 88350 -
88351 [ 9, NULL, NULL ] 88351 -
88352 [ 11, NULL, NULL ] 88352 -
88353 [ 13, NULL, NULL ] 88353 -
88354 [ 0, 1, 101 ] 88354 -
88355 [ 0, -2, 108 ] 88355 -
88356 [ 1, -1, 114 ] 88356 -
88357 [ 0, 3, 116 ] 88357 -
88358 [ 2, 1, 122 ] 88358 -
88359 [ 3, -3, 128 ] 88359 -
88360 [ 4, 1, 133 ] 88360 -
88361 [ 5, 1, 136 ] 88361 -
88362 [ 6, 1, 140 ] 88362 -
88363 [ 10, -3, 164 ] 88363 -
88364 [ 12, 1, 171 ] 88364 -
88365 [ 14, 1, 183 ] 88365 -
88366 [ 15, 2, 185 ] 88366 -
88367 [ 16, 3, 190 ] 88367 -
88368 [ 17, -1, 196 ] 88368 -
88369 [ 0, -1, 203 ] 88369 -
88370 [ 18, 1, 207 ] 88370 -
88371 [ 19, 2, 212 ] 88371 -
88372 [ 20, -2, 217 ] 88372 -
88373 [ 21, 2, 222 ] 88373 -
88374 [ 22, -1, 226 ] 88374 -
88375 [ 23, -2, 233 ] 88375 -
88376 [ 24, NULL, 238 ] 88376 -
88377 [ 26, -1, 248 ] 88377 -
88378 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 88378 -
88379 # c-d, 88379 -
88380 # d 88380 -
88381 # FROM t1 88381 -
88382 # WHERE (e>c OR e<d) 88382 -
88383 # OR c>d 88383 -
88384 # OR (a>b-2 AND a<b+2) 88384 -
88385 #; 88385 -
88386 % ., ., .t1 # table_name 88386 -
88387 # .L5, .L7, .t1 # table_name 88387 -
88388 % L, L, d # name 88388 -
88389 # L5, L7, d # name 88389 -
88390 % bigint, bigint, int # type 88390 -
88391 % 2, 2, 3 # length 88391 -
88392 [ 1, -1, 114 ] 88392 -
88393 [ 2, 1, 122 ] 88393 -
88394 [ 3, -3, 128 ] 88394 -
88395 [ 4, 1, 133 ] 88395 -
88396 [ 5, 1, 136 ] 88396 -
88397 [ 6, 1, 140 ] 88397 -
88398 [ 9, NULL, NULL ] 88398 -
88399 [ 10, -3, 164 ] 88399 -
88400 [ 11, NULL, NULL ] 88400 -
88401 [ 12, 1, 171 ] 88401 -
88402 [ 13, NULL, NULL ] 88402 -
88403 [ 14, 1, 183 ] 88403 -
88404 [ 15, 2, 185 ] 88404 -
88405 [ 16, 3, 190 ] 88405 -
88406 [ 17, -1, 196 ] 88406 -
88407 [ 18, 1, 207 ] 88407 -
88408 [ 19, 2, 212 ] 88408 -
88409 [ 20, -2, 217 ] 88409 -
88410 [ 21, 2, 222 ] 88410 -
88411 [ 22, -1, 226 ] 88411 -
88412 [ 23, -2, 233 ] 88412 -
88413 [ 24, NULL, 238 ] 88413 -
88414 [ 26, -1, 248 ] 88414 -
88415 [ 0, 1, 101 ] 88415 -
88416 [ 0, -2, 108 ] 88416 -
88417 [ 0, 3, 116 ] 88417 -
88418 [ 0, -1, 203 ] 88418 -
88419 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 88419 -
88420 # c-d, 88420 -
88421 # d 88421 -
88422 # FROM t1 88422 -
88423 # WHERE (e>c OR e<d) 88423 -
88424 # OR c>d 88424 -
88425 # OR (a>b-2 AND a<b+2) 88425 -
88426 # ORDER BY 2,1 88426 -
88427 #; 88427 -
88428 % ., ., .t1 # table_name 88428 -
88429 # .L5, .L7, .t1 # table_name 88429 -
88430 % L, L, d # name 88430 -
88431 # L5, L7, d # name 88431 -
88432 % bigint, bigint, int # type 88432 -
88433 % 2, 2, 3 # length 88433 -
88434 [ 9, NULL, NULL ] 88434 -
88435 [ 11, NULL, NULL ] 88435 -
88436 [ 13, NULL, NULL ] 88436 -
88437 [ 24, NULL, 238 ] 88437 -
88438 [ 3, -3, 128 ] 88438 -
88439 [ 10, -3, 164 ] 88439 -
88440 [ 0, -2, 108 ] 88440 -
88441 [ 20, -2, 217 ] 88441 -
88442 [ 23, -2, 233 ] 88442 -
88443 [ 0, -1, 203 ] 88443 -
88444 [ 1, -1, 114 ] 88444 -
88445 [ 17, -1, 196 ] 88445 -
88446 [ 22, -1, 226 ] 88446 -
88447 [ 26, -1, 248 ] 88447 -
88448 [ 0, 1, 101 ] 88448 -
88449 [ 2, 1, 122 ] 88449 -
88450 [ 4, 1, 133 ] 88450 -
88451 [ 5, 1, 136 ] 88451 -
88452 [ 6, 1, 140 ] 88452 -
88453 [ 12, 1, 171 ] 88453 -
88454 [ 14, 1, 183 ] 88454 -
88455 [ 18, 1, 207 ] 88455 -
88456 [ 15, 2, 185 ] 88456 -
88457 [ 19, 2, 212 ] 88457 -
88458 [ 21, 2, 222 ] 88458 -
88459 [ 0, 3, 116 ] 88459 -
88460 [ 16, 3, 190 ] 88460 -
88461 #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 88461 -
88462 # WHEN a<b+3 THEN 333 ELSE 444 END, 88462 -
88463 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 88463 -
88464 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 88464 -
88465 # d-e 88465 -
88466 # FROM t1 88466 -
88467 # WHERE d>e 88467 -
88468 #; 88468 -
88469 % sys., sys., sys. # table_name 88469 -
88470 # sys.L2, sys.L4, sys.L6 # table_name 88470 -
88471 % L, L, L # name 88471 -
88472 # L2, L4, L6 # name 88472 -
88473 % smallint, smallint, bigint # type 88473 -
88474 % 3, 3, 1 # length 88474 -
88475 [ 444, 555, 4 ] 88475 -
88476 [ 222, 333, 2 ] 88476 -
88477 [ 333, 444, 1 ] 88477 -
88478 [ 222, 111, 1 ] 88478 -
88479 [ 444, 333, 2 ] 88479 -
88480 [ 333, 333, 3 ] 88480 -
88481 [ 333, 222, 2 ] 88481 -
88482 [ 222, 444, 1 ] 88482 -
88483 [ 333, 555, 3 ] 88483 -
88484 [ 444, 555, 1 ] 88484 -
88485 [ 111, 444, 2 ] 88485 -
88486 #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 88486 -
88487 # WHEN a<b+3 THEN 333 ELSE 444 END, 88487 -
88488 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 88488 -
88489 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 88489 -
88490 # d-e 88490 -
88491 # FROM t1 88491 -
88492 # WHERE d>e 88492 -
88493 # ORDER BY 2,1 88493 -
88494 #; 88494 -
88495 % sys., sys., sys. # table_name 88495 -
88496 # sys.L2, sys.L4, sys.L6 # table_name 88496 -
88497 % L, L, L # name 88497 -
88498 # L2, L4, L6 # name 88498 -
88499 % smallint, smallint, bigint # type 88499 -
88500 % 3, 3, 1 # length 88500 -
88501 [ 222, 111, 1 ] 88501 -
88502 [ 333, 222, 2 ] 88502 -
88503 [ 222, 333, 2 ] 88503 -
88504 [ 333, 333, 3 ] 88504 -
88505 [ 444, 333, 2 ] 88505 -
88506 [ 111, 444, 2 ] 88506 -
88507 [ 222, 444, 1 ] 88507 -
88508 [ 333, 444, 1 ] 88508 -
88509 [ 333, 555, 3 ] 88509 -
88510 [ 444, 555, 4 ] 88510 -
88511 [ 444, 555, 1 ] 88511 -
88512 #SELECT a, 88512 -
88513 # abs(b-c), 88513 -
88514 # c, 88514 -
88515 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 88515 -
88516 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 88516 -
88517 # a+b*2+c*3+d*4+e*5 88517 -
88518 # FROM t1 88518 -
88519 # WHERE (a>b-2 AND a<b+2) 88519 -
88520 # AND (e>c OR e<d) 88520 -
88521 #; 88521 -
88522 % sys.t1, sys., sys.t1, sys., sys. # table_name 88522 -
88523 # sys.t1, sys.L3, sys.t1, sys.L6, sys.L10 # table_name 88523 -
88524 % a, L, c, L, L # name 88524 -
88525 # a, L3, c, L6, L10 # name 88525 -
88526 % int, bigint, int, smallint, hugeint # type 88526 -
88527 % 3, 1, 3, 3, 4 # length 88527 -
88528 [ 131, 4, 134, 444, 1985 ] 88528 -
88529 [ 138, 2, 137, 111, 2046 ] 88529 -
88530 [ 142, 2, 141, 111, 2131 ] 88530 -
88531 [ 159, 3, 155, 555, NULL ] 88531 -
88532 [ 182, 3, 184, 333, 2728 ] 88532 -
88533 [ 199, 3, 195, 555, 2949 ] 88533 -
88534 [ 229, 3, 225, 555, 3399 ] 88534 -
88535 #SELECT a, 88535 -
88536 # abs(b-c), 88536 -
88537 # c, 88537 -
88538 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 88538 -
88539 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 88539 -
88540 # a+b*2+c*3+d*4+e*5 88540 -
88541 # FROM t1 88541 -
88542 # WHERE (a>b-2 AND a<b+2) 88542 -
88543 # AND (e>c OR e<d) 88543 -
88544 # ORDER BY 4,3 88544 -
88545 #; 88545 -
88546 % sys.t1, sys., sys.t1, sys., sys. # table_name 88546 -
88547 # sys.t1, sys.L3, sys.t1, sys.L6, sys.L10 # table_name 88547 -
88548 % a, L, c, L, L # name 88548 -
88549 # a, L3, c, L6, L10 # name 88549 -
88550 % int, bigint, int, smallint, hugeint # type 88550 -
88551 % 3, 1, 3, 3, 4 # length 88551 -
88552 [ 138, 2, 137, 111, 2046 ] 88552 -
88553 [ 142, 2, 141, 111, 2131 ] 88553 -
88554 [ 182, 3, 184, 333, 2728 ] 88554 -
88555 [ 131, 4, 134, 444, 1985 ] 88555 -
88556 [ 159, 3, 155, 555, NULL ] 88556 -
88557 [ 199, 3, 195, 555, 2949 ] 88557 -
88558 [ 229, 3, 225, 555, 3399 ] 88558 -
88559 #SELECT a, 88559 -
88560 # abs(b-c), 88560 -
88561 # c, 88561 -
88562 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 88562 -
88563 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 88563 -
88564 # a+b*2+c*3+d*4+e*5 88564 -
88565 # FROM t1 88565 -
88566 # WHERE (e>c OR e<d) 88566 -
88567 # AND (a>b-2 AND a<b+2) 88567 -
88568 #; 88568 -
88569 % sys.t1, sys., sys.t1, sys., sys. # table_name 88569 -
88570 # sys.t1, sys.L3, sys.t1, sys.L6, sys.L10 # table_name 88570 -
88571 % a, L, c, L, L # name 88571 -
88572 # a, L3, c, L6, L10 # name 88572 -
88573 % int, bigint, int, smallint, hugeint # type 88573 -
88574 % 3, 1, 3, 3, 4 # length 88574 -
88575 [ 131, 4, 134, 444, 1985 ] 88575 -
88576 [ 138, 2, 137, 111, 2046 ] 88576 -
88577 [ 142, 2, 141, 111, 2131 ] 88577 -
88578 [ 159, 3, 155, 555, NULL ] 88578 -
88579 [ 182, 3, 184, 333, 2728 ] 88579 -
88580 [ 199, 3, 195, 555, 2949 ] 88580 -
88581 [ 229, 3, 225, 555, 3399 ] 88581 -
88582 #SELECT a, 88582 -
88583 # abs(b-c), 88583 -
88584 # c, 88584 -
88585 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 88585 -
88586 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 88586 -
88587 # a+b*2+c*3+d*4+e*5 88587 -
88588 # FROM t1 88588 -
88589 # WHERE (e>c OR e<d) 88589 -
88590 # AND (a>b-2 AND a<b+2) 88590 -
88591 # ORDER BY 1,4,5 88591 -
88592 #; 88592 -
88593 % sys.t1, sys., sys.t1, sys., sys. # table_name 88593 -
88594 # sys.t1, sys.L3, sys.t1, sys.L6, sys.L10 # table_name 88594 -
88595 % a, L, c, L, L # name 88595 -
88596 # a, L3, c, L6, L10 # name 88596 -
88597 % int, bigint, int, smallint, hugeint # type 88597 -
88598 % 3, 1, 3, 3, 4 # length 88598 -
88599 [ 131, 4, 134, 444, 1985 ] 88599 -
88600 [ 138, 2, 137, 111, 2046 ] 88600 -
88601 [ 142, 2, 141, 111, 2131 ] 88601 -
88602 [ 159, 3, 155, 555, NULL ] 88602 -
88603 [ 182, 3, 184, 333, 2728 ] 88603 -
88604 [ 199, 3, 195, 555, 2949 ] 88604 -
88605 [ 229, 3, 225, 555, 3399 ] 88605 -
88606 #SELECT c, 88606 -
88607 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 88607 -
88608 # b, 88608 -
88609 # a, 88609 -
88610 # a+b*2 88610 -
88611 # FROM t1 88611 -
88612 # WHERE e+d BETWEEN a+b-10 AND c+130 88612 -
88613 #; 88613 -
88614 % .t1, ., .t1, .t1, . # table_name 88614 -
88615 # .t1, .L6, .t1, .t1, .L13 # table_name 88615 -
88616 % c, L, b, a, L # name 88616 -
88617 # c, L6, b, a, L13 # name 88617 -
88618 % int, bigint, int, int, bigint # type 88618 -
88619 % 3, 1, 3, 3, 3 # length 88619 -
88620 [ 125, 3, 129, 127, 385 ] 88620 -
88621 [ 106, 0, 105, 107, 317 ] 88621 -
88622 #SELECT c, 88622 -
88623 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 88623 -
88624 # b, 88624 -
88625 # a, 88625 -
88626 # a+b*2 88626 -
88627 # FROM t1 88627 -
88628 # WHERE e+d BETWEEN a+b-10 AND c+130 88628 -
88629 # ORDER BY 1,3,4,5,2 88629 -
88630 #; 88630 -
88631 % .t1, ., .t1, .t1, . # table_name 88631 -
88632 # .t1, .L6, .t1, .t1, .L13 # table_name 88632 -
88633 % c, L, b, a, L # name 88633 -
88634 # c, L6, b, a, L13 # name 88634 -
88635 % int, bigint, int, int, bigint # type 88635 -
88636 % 3, 1, 3, 3, 3 # length 88636 -
88637 [ 106, 0, 105, 107, 317 ] 88637 -
88638 [ 125, 3, 129, 127, 385 ] 88638 -
88639 #SELECT (a+b+c+d+e)/5, 88639 -
88640 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b) 88640 -
88641 # FROM t1 88641 -
88642 # WHERE b>c 88642 -
88643 #; 88643 -
88644 % ., . # table_name 88644 -
88645 # .L2, .L7 # table_name 88645 -
88646 % L, L # name 88646 -
88647 # L2, L7 # name 88647 -
88648 % hugeint, bigint # type 88648 -
88649 % 3, 2 # length 88649 -
88650 [ NULL, 2 ] 88650 -
88651 [ 127, 3 ] 88651 -
88652 [ 137, 5 ] 88652 -
88653 [ 142, 6 ] 88653 -
88654 [ NULL, 8 ] 88654 -
88655 [ NULL, 9 ] 88655 -
88656 [ NULL, 11 ] 88656 -
88657 [ 192, 16 ] 88657 -
88658 [ 197, 17 ] 88658 -
88659 [ 217, 20 ] 88659 -
88660 [ 227, 22 ] 88660 -
88661 [ 232, 23 ] 88661 -
88662 [ 247, 26 ] 88662 -
88663 #SELECT (a+b+c+d+e)/5, 88663 -
88664 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b) 88664 -
88665 # FROM t1 88665 -
88666 # WHERE b>c 88666 -
88667 # ORDER BY 1,2 88667 -
88668 #; 88668 -
88669 % ., . # table_name 88669 -
88670 # .L2, .L7 # table_name 88670 -
88671 % L, L # name 88671 -
88672 # L2, L7 # name 88672 -
88673 % hugeint, bigint # type 88673 -
88674 % 3, 2 # length 88674 -
88675 [ NULL, 2 ] 88675 -
88676 [ NULL, 8 ] 88676 -
88677 [ NULL, 9 ] 88677 -
88678 [ NULL, 11 ] 88678 -
88679 [ 127, 3 ] 88679 -
88680 [ 137, 5 ] 88680 -
88681 [ 142, 6 ] 88681 -
88682 [ 192, 16 ] 88682 -
88683 [ 197, 17 ] 88683 -
88684 [ 217, 20 ] 88684 -
88685 [ 227, 22 ] 88685 -
88686 [ 232, 23 ] 88686 -
88687 [ 247, 26 ] 88687 -
88688 #SELECT a-b, 88688 -
88689 # b-c, 88689 -
88690 # d, 88690 -
88691 # abs(b-c), 88691 -
88692 # e 88692 -
88693 # FROM t1 88693 -
88694 # WHERE (e>a AND e<b) 88694 -
88695 #; 88695 -
88696 % sys., sys., sys.t1, sys., sys.t1 # table_name 88696 -
88697 # sys.L2, sys.L4, sys.t1, sys.L7, sys.t1 # table_name 88697 -
88698 % L, L, d, L, e # name 88698 -
88699 # L2, L4, d, L7, e # name 88699 -
88700 % bigint, bigint, int, bigint, int # type 88700 -
88701 % 2, 2, 3, 1, 3 # length 88701 -
88702 [ -3, 1, 190, 1, 192 ] 88702 -
88703 [ -3, -1, 222, 1, 221 ] 88703 -
88704 [ -4, 2, 248, 2, 246 ] 88704 -
88705 #SELECT a-b, 88705 -
88706 # b-c, 88706 -
88707 # d, 88707 -
88708 # abs(b-c), 88708 -
88709 # e 88709 -
88710 # FROM t1 88710 -
88711 # WHERE (e>a AND e<b) 88711 -
88712 # ORDER BY 5,1 88712 -
88713 #; 88713 -
88714 % sys., sys., sys.t1, sys., sys.t1 # table_name 88714 -
88715 # sys.L2, sys.L4, sys.t1, sys.L7, sys.t1 # table_name 88715 -
88716 % L, L, d, L, e # name 88716 -
88717 # L2, L4, d, L7, e # name 88717 -
88718 % bigint, bigint, int, bigint, int # type 88718 -
88719 % 2, 2, 3, 1, 3 # length 88719 -
88720 [ -3, 1, 190, 1, 192 ] 88720 -
88721 [ -3, -1, 222, 1, 221 ] 88721 -
88722 [ -4, 2, 248, 2, 246 ] 88722 -
88723 #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 88723 -
88724 # WHEN a<b+3 THEN 333 ELSE 444 END, 88724 -
88725 # a-b, 88725 -
88726 # a+b*2+c*3 88726 -
88727 # FROM t1 88727 -
88728 #; 88728 -
88729 % sys., sys., sys. # table_name 88729 -
88730 # sys.L2, sys.L4, sys.L6 # table_name 88730 -
88731 % L, L, L # name 88731 -
88732 # L2, L4, L6 # name 88732 -
88733 % smallint, bigint, hugeint # type 88733 -
88734 % 3, 2, 4 # length 88734 -
88735 [ 444, NULL, NULL ] 88735 -
88736 [ 333, 2, 635 ] 88736 -
88737 [ 444, NULL, NULL ] 88737 -
88738 [ 444, NULL, NULL ] 88738 -
88739 [ 222, -3, 738 ] 88739 -
88740 [ 222, -2, 760 ] 88740 -
88741 [ 333, 1, 793 ] 88741 -
88742 [ 222, -1, 827 ] 88742 -
88743 [ 222, -1, 851 ] 88743 -
88744 [ 444, 4, 880 ] 88744 -
88745 [ 333, 2, 905 ] 88745 -
88746 [ 333, 1, 940 ] 88746 -
88747 [ 444, 3, 966 ] 88747 -
88748 [ 333, 1, 1000 ] 88748 -
88749 [ 444, 4, 1030 ] 88749 -
88750 [ 444, 4, 1057 ] 88750 -
88751 [ 333, 1, 1096 ] 88751 -
88752 [ 333, 2, 1121 ] 88752 -
88753 [ 222, -3, 1158 ] 88753 -
88754 [ 333, 1, 1180 ] 88754 -
88755 [ 444, NULL, NULL ] 88755 -
88756 [ 444, NULL, NULL ] 88756 -
88757 [ 333, 2, 1277 ] 88757 -
88758 [ 222, -2, 1297 ] 88758 -
88759 [ 222, -3, 1338 ] 88759 -
88760 [ 333, 1, 1360 ] 88760 -
88761 [ 333, 2, 1391 ] 88761 -
88762 [ 444, 3, NULL ] 88762 -
88763 [ 444, 3, 1455 ] 88763 -
88764 [ 111, -4, 1484 ] 88764 -
88765 #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 88765 -
88766 # WHEN a<b+3 THEN 333 ELSE 444 END, 88766 -
88767 # a-b, 88767 -
88768 # a+b*2+c*3 88768 -
88769 # FROM t1 88769 -
88770 # ORDER BY 1,3,2 88770 -
88771 #; 88771 -
88772 % sys., sys., sys. # table_name 88772 -
88773 # sys.L2, sys.L4, sys.L6 # table_name 88773 -
88774 % L, L, L # name 88774 -
88775 # L2, L4, L6 # name 88775 -
88776 % smallint, bigint, hugeint # type 88776 -
88777 % 3, 2, 4 # length 88777 -
88778 [ 111, -4, 1484 ] 88778 -
88779 [ 222, -3, 738 ] 88779 -
88780 [ 222, -2, 760 ] 88780 -
88781 [ 222, -1, 827 ] 88781 -
88782 [ 222, -1, 851 ] 88782 -
88783 [ 222, -3, 1158 ] 88783 -
88784 [ 222, -2, 1297 ] 88784 -
88785 [ 222, -3, 1338 ] 88785 -
88786 [ 333, 2, 635 ] 88786 -
88787 [ 333, 1, 793 ] 88787 -
88788 [ 333, 2, 905 ] 88788 -
88789 [ 333, 1, 940 ] 88789 -
88790 [ 333, 1, 1000 ] 88790 -
88791 [ 333, 1, 1096 ] 88791 -
88792 [ 333, 2, 1121 ] 88792 -
88793 [ 333, 1, 1180 ] 88793 -
88794 [ 333, 2, 1277 ] 88794 -
88795 [ 333, 1, 1360 ] 88795 -
88796 [ 333, 2, 1391 ] 88796 -
88797 [ 444, NULL, NULL ] 88797 -
88798 [ 444, NULL, NULL ] 88798 -
88799 [ 444, NULL, NULL ] 88799 -
88800 [ 444, NULL, NULL ] 88800 -
88801 [ 444, NULL, NULL ] 88801 -
88802 [ 444, 3, NULL ] 88802 -
88803 [ 444, 4, 880 ] 88803 -
88804 [ 444, 3, 966 ] 88804 -
88805 [ 444, 4, 1030 ] 88805 -
88806 [ 444, 4, 1057 ] 88806 -
88807 [ 444, 3, 1455 ] 88807 -
88808 #SELECT d, 88808 -
88809 # b-c, 88809 -
88810 # abs(a), 88810 -
88811 # c-d, 88811 -
88812 # e, 88812 -
88813 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 88813 -
88814 # c 88814 -
88815 # FROM t1 88815 -
88816 #; 88816 -
88817 % .t1, ., ., ., .t1, ., .t1 # table_name 88817 -
88818 # .t1, .L3, .L5, .L7, .t1, .L15, .t1 # table_name 88818 -
88819 % d, L, L, L, e, L, c # name 88819 -
88820 # d, L3, L5, L7, e, L15, c # name 88820 -
88821 % int, bigint, int, bigint, int, bigint, int # type 88821 -
88822 % 3, 2, 3, 2, 3, 2, 3 # length 88822 -
88823 [ 114, -1, NULL, -1, 110, 1, 113 ] 88823 -
88824 [ 122, 1, 121, 1, NULL, 2, 123 ] 88824 -
88825 [ 128, 4, 127, -3, 126, 3, 125 ] 88825 -
88826 [ 133, -4, 131, 1, 132, 4, 134 ] 88826 -
88827 [ 136, 2, 138, 1, 135, 5, 137 ] 88827 -
88828 [ 140, 2, 142, 1, 144, 6, 141 ] 88828 -
88829 [ NULL, -2, 149, NULL, 146, 7, 147 ] 88829 -
88830 [ NULL, 1, 153, NULL, NULL, 8, 150 ] 88830 -
88831 [ NULL, 3, 159, NULL, 157, 9, 155 ] 88831 -
88832 [ 164, -1, 163, -3, 162, 10, 161 ] 88832 -
88833 [ NULL, 1, 168, NULL, 165, 11, 166 ] 88833 -
88834 [ 171, -2, 174, 1, 173, 12, 172 ] 88834 -
88835 [ NULL, -1, 179, NULL, 177, 13, 176 ] 88835 -
88836 [ 183, -3, 182, 1, 180, 14, 184 ] 88836 -
88837 [ 185, -1, 188, 2, 189, 15, 187 ] 88837 -
88838 [ 190, 1, 191, 3, 192, 16, 193 ] 88838 -
88839 [ 196, 3, 199, -1, 197, 17, 195 ] 88839 -
88840 [ 207, -2, NULL, 1, NULL, 18, 208 ] 88840 -
88841 [ 212, -3, 213, 2, 210, 19, 214 ] 88841 -
88842 [ 217, 3, 216, -2, 219, 20, 215 ] 88842 -
88843 [ 222, -1, 220, 2, 221, 21, 224 ] 88843 -
88844 [ 226, 3, 229, -1, 227, 22, 225 ] 88844 -
88845 [ 233, 1, 234, -2, 230, 23, 231 ] 88845 -
88846 [ 238, NULL, 239, NULL, 237, 24, NULL ] 88846 -
88847 [ NULL, -4, 243, NULL, NULL, 25, 244 ] 88847 -
88848 [ 248, 2, 245, -1, 246, 26, 247 ] 88848 -
88849 [ 101, NULL, 104, 1, NULL, 0, 102 ] 88849 -
88850 [ 108, -1, 107, -2, 109, 0, 106 ] 88850 -
88851 [ 116, NULL, 115, 3, 117, 0, 119 ] 88851 -
88852 [ 203, NULL, 201, -1, 204, 0, 202 ] 88852 -
88853 #SELECT d, 88853 -
88854 # b-c, 88854 -
88855 # abs(a), 88855 -
88856 # c-d, 88856 -
88857 # e, 88857 -
88858 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 88858 -
88859 # c 88859 -
88860 # FROM t1 88860 -
88861 # ORDER BY 2,7,5,1,4 88861 -
88862 #; 88862 -
88863 % .t1, ., ., ., .t1, ., .t1 # table_name 88863 -
88864 # .t1, .L3, .L5, .L7, .t1, .L15, .t1 # table_name 88864 -
88865 % d, L, L, L, e, L, c # name 88865 -
88866 # d, L3, L5, L7, e, L15, c # name 88866 -
88867 % int, bigint, int, bigint, int, bigint, int # type 88867 -
88868 % 3, 2, 3, 2, 3, 2, 3 # length 88868 -
88869 [ 238, NULL, 239, NULL, 237, 24, NULL ] 88869 -
88870 [ 101, NULL, 104, 1, NULL, 0, 102 ] 88870 -
88871 [ 116, NULL, 115, 3, 117, 0, 119 ] 88871 -
88872 [ 203, NULL, 201, -1, 204, 0, 202 ] 88872 -
88873 [ 133, -4, 131, 1, 132, 4, 134 ] 88873 -
88874 [ NULL, -4, 243, NULL, NULL, 25, 244 ] 88874 -
88875 [ 183, -3, 182, 1, 180, 14, 184 ] 88875 -
88876 [ 212, -3, 213, 2, 210, 19, 214 ] 88876 -
88877 [ NULL, -2, 149, NULL, 146, 7, 147 ] 88877 -
88878 [ 171, -2, 174, 1, 173, 12, 172 ] 88878 -
88879 [ 207, -2, NULL, 1, NULL, 18, 208 ] 88879 -
88880 [ 108, -1, 107, -2, 109, 0, 106 ] 88880 -
88881 [ 114, -1, NULL, -1, 110, 1, 113 ] 88881 -
88882 [ 164, -1, 163, -3, 162, 10, 161 ] 88882 -
88883 [ NULL, -1, 179, NULL, 177, 13, 176 ] 88883 -
88884 [ 185, -1, 188, 2, 189, 15, 187 ] 88884 -
88885 [ 222, -1, 220, 2, 221, 21, 224 ] 88885 -
88886 [ 122, 1, 121, 1, NULL, 2, 123 ] 88886 -
88887 [ NULL, 1, 153, NULL, NULL, 8, 150 ] 88887 -
88888 [ NULL, 1, 168, NULL, 165, 11, 166 ] 88888 -
88889 [ 190, 1, 191, 3, 192, 16, 193 ] 88889 -
88890 [ 233, 1, 234, -2, 230, 23, 231 ] 88890 -
88891 [ 136, 2, 138, 1, 135, 5, 137 ] 88891 -
88892 [ 140, 2, 142, 1, 144, 6, 141 ] 88892 -
88893 [ 248, 2, 245, -1, 246, 26, 247 ] 88893 -
88894 [ NULL, 3, 159, NULL, 157, 9, 155 ] 88894 -
88895 [ 196, 3, 199, -1, 197, 17, 195 ] 88895 -
88896 [ 217, 3, 216, -2, 219, 20, 215 ] 88896 -
88897 [ 226, 3, 229, -1, 227, 22, 225 ] 88897 -
88898 [ 128, 4, 127, -3, 126, 3, 125 ] 88898 -
88899 #SELECT b-c, 88899 -
88900 # c-d, 88900 -
88901 # CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 88901 -
88902 # WHEN a<b+3 THEN 333 ELSE 444 END, 88902 -
88903 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 88903 -
88904 # abs(b-c), 88904 -
88905 # b, 88905 -
88906 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 88906 -
88907 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END 88907 -
88908 # FROM t1 88908 -
88909 # WHERE d>e 88909 -
88910 #; 88910 -
88911 % ., ., ., ., ., .t1, . # table_name 88911 -
88912 # .L2, .L4, .L6, .L13, .L16, .t1, .L21 # table_name 88912 -
88913 % L, L, L, L, L, b, L # name 88913 -
88914 # L2, L4, L6, L13, L16, b, L21 # name 88914 -
88915 % bigint, bigint, smallint, bigint, bigint, int, smallint # type 88915 -
88916 % 2, 2, 3, 2, 1, 3, 3 # length 88916 -
88917 [ -1, -1, 444, 1, 1, 112, 555 ] 88917 -
88918 [ 4, -3, 222, 3, 4, 129, 333 ] 88918 -
88919 [ -4, 1, 333, 4, 4, 130, 444 ] 88919 -
88920 [ 2, 1, 222, 5, 2, 139, 111 ] 88920 -
88921 [ -1, -3, 444, 10, 1, 160, 333 ] 88921 -
88922 [ -3, 1, 333, 14, 3, 181, 333 ] 88922 -
88923 [ -3, 2, 333, 19, 3, 211, 222 ] 88923 -
88924 [ -1, 2, 222, 21, 1, 223, 444 ] 88924 -
88925 [ 1, -2, 333, 23, 1, 232, 555 ] 88925 -
88926 [ NULL, NULL, 444, 24, NULL, 236, 555 ] 88926 -
88927 [ 2, -1, 111, 26, 2, 249, 444 ] 88927 -
88928 #SELECT b-c, 88928 -
88929 # c-d, 88929 -
88930 # CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 88930 -
88931 # WHEN a<b+3 THEN 333 ELSE 444 END, 88931 -
88932 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 88932 -
88933 # abs(b-c), 88933 -
88934 # b, 88934 -
88935 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 88935 -
88936 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END 88936 -
88937 # FROM t1 88937 -
88938 # WHERE d>e 88938 -
88939 # ORDER BY 2,7,4,3,6 88939 -
88940 #; 88940 -
88941 % ., ., ., ., ., .t1, . # table_name 88941 -
88942 # .L2, .L4, .L6, .L13, .L16, .t1, .L21 # table_name 88942 -
88943 % L, L, L, L, L, b, L # name 88943 -
88944 # L2, L4, L6, L13, L16, b, L21 # name 88944 -
88945 % bigint, bigint, smallint, bigint, bigint, int, smallint # type 88945 -
88946 % 2, 2, 3, 2, 1, 3, 3 # length 88946 -
88947 [ NULL, NULL, 444, 24, NULL, 236, 555 ] 88947 -
88948 [ 4, -3, 222, 3, 4, 129, 333 ] 88948 -
88949 [ -1, -3, 444, 10, 1, 160, 333 ] 88949 -
88950 [ 1, -2, 333, 23, 1, 232, 555 ] 88950 -
88951 [ 2, -1, 111, 26, 2, 249, 444 ] 88951 -
88952 [ -1, -1, 444, 1, 1, 112, 555 ] 88952 -
88953 [ 2, 1, 222, 5, 2, 139, 111 ] 88953 -
88954 [ -3, 1, 333, 14, 3, 181, 333 ] 88954 -
88955 [ -4, 1, 333, 4, 4, 130, 444 ] 88955 -
88956 [ -3, 2, 333, 19, 3, 211, 222 ] 88956 -
88957 [ -1, 2, 222, 21, 1, 223, 444 ] 88957 -
88958 #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 88958 -
88959 # WHEN a<b+3 THEN 333 ELSE 444 END 88959 -
88960 # FROM t1 88960 -
88961 # WHERE (c<=d-2 OR c>=d+2) 88961 -
88962 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 88962 -
88963 # AND c>d 88963 -
88964 #; 88964 -
88965 % sys. # table_name 88965 -
88966 # sys.L7 # table_name 88966 -
88967 % L # name 88967 -
88968 # L7 # name 88968 -
88969 % smallint # type 88969 -
88970 % 3 # length 88970 -
88971 [ 333 ] 88971 -
88972 [ 222 ] 88972 -
88973 [ 333 ] 88973 -
88974 [ 222 ] 88974 -
88975 #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 88975 -
88976 # WHEN a<b+3 THEN 333 ELSE 444 END 88976 -
88977 # FROM t1 88977 -
88978 # WHERE (c<=d-2 OR c>=d+2) 88978 -
88979 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 88979 -
88980 # AND c>d 88980 -
88981 # ORDER BY 1 88981 -
88982 #; 88982 -
88983 % sys. # table_name 88983 -
88984 # sys.L7 # table_name 88984 -
88985 % L # name 88985 -
88986 # L7 # name 88986 -
88987 % smallint # type 88987 -
88988 % 3 # length 88988 -
88989 [ 222 ] 88989 -
88990 [ 222 ] 88990 -
88991 [ 333 ] 88991 -
88992 [ 333 ] 88992 -
88993 #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 88993 -
88994 # WHEN a<b+3 THEN 333 ELSE 444 END 88994 -
88995 # FROM t1 88995 -
88996 # WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 88996 -
88997 # AND (c<=d-2 OR c>=d+2) 88997 -
88998 # AND c>d 88998 -
88999 #; 88999 -
89000 % sys. # table_name 89000 -
89001 # sys.L7 # table_name 89001 -
89002 % L # name 89002 -
89003 # L7 # name 89003 -
89004 % smallint # type 89004 -
89005 % 3 # length 89005 -
89006 [ 333 ] 89006 -
89007 [ 222 ] 89007 -
89008 [ 333 ] 89008 -
89009 [ 222 ] 89009 -
89010 #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 89010 -
89011 # WHEN a<b+3 THEN 333 ELSE 444 END 89011 -
89012 # FROM t1 89012 -
89013 # WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 89013 -
89014 # AND (c<=d-2 OR c>=d+2) 89014 -
89015 # AND c>d 89015 -
89016 # ORDER BY 1 89016 -
89017 #; 89017 -
89018 % sys. # table_name 89018 -
89019 # sys.L7 # table_name 89019 -
89020 % L # name 89020 -
89021 # L7 # name 89021 -
89022 % smallint # type 89022 -
89023 % 3 # length 89023 -
89024 [ 222 ] 89024 -
89025 [ 222 ] 89025 -
89026 [ 333 ] 89026 -
89027 [ 333 ] 89027 -
89028 #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 89028 -
89029 # WHEN a<b+3 THEN 333 ELSE 444 END 89029 -
89030 # FROM t1 89030 -
89031 # WHERE (c<=d-2 OR c>=d+2) 89031 -
89032 # AND c>d 89032 -
89033 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 89033 -
89034 #; 89034 -
89035 % sys. # table_name 89035 -
89036 # sys.L7 # table_name 89036 -
89037 % L # name 89037 -
89038 # L7 # name 89038 -
89039 % smallint # type 89039 -
89040 % 3 # length 89040 -
89041 [ 333 ] 89041 -
89042 [ 222 ] 89042 -
89043 [ 333 ] 89043 -
89044 [ 222 ] 89044 -
89045 #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 89045 -
89046 # WHEN a<b+3 THEN 333 ELSE 444 END 89046 -
89047 # FROM t1 89047 -
89048 # WHERE (c<=d-2 OR c>=d+2) 89048 -
89049 # AND c>d 89049 -
89050 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 89050 -
89051 # ORDER BY 1 89051 -
89052 #; 89052 -
89053 % sys. # table_name 89053 -
89054 # sys.L7 # table_name 89054 -
89055 % L # name 89055 -
89056 # L7 # name 89056 -
89057 % smallint # type 89057 -
89058 % 3 # length 89058 -
89059 [ 222 ] 89059 -
89060 [ 222 ] 89060 -
89061 [ 333 ] 89061 -
89062 [ 333 ] 89062 -
89063 #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 89063 -
89064 # WHEN a<b+3 THEN 333 ELSE 444 END 89064 -
89065 # FROM t1 89065 -
89066 # WHERE c>d 89066 -
89067 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 89067 -
89068 # AND (c<=d-2 OR c>=d+2) 89068 -
89069 #; 89069 -
89070 % sys. # table_name 89070 -
89071 # sys.L7 # table_name 89071 -
89072 % L # name 89072 -
89073 # L7 # name 89073 -
89074 % smallint # type 89074 -
89075 % 3 # length 89075 -
89076 [ 333 ] 89076 -
89077 [ 222 ] 89077 -
89078 [ 333 ] 89078 -
89079 [ 222 ] 89079 -
89080 #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 89080 -
89081 # WHEN a<b+3 THEN 333 ELSE 444 END 89081 -
89082 # FROM t1 89082 -
89083 # WHERE c>d 89083 -
89084 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 89084 -
89085 # AND (c<=d-2 OR c>=d+2) 89085 -
89086 # ORDER BY 1 89086 -
89087 #; 89087 -
89088 % sys. # table_name 89088 -
89089 # sys.L7 # table_name 89089 -
89090 % L # name 89090 -
89091 # L7 # name 89091 -
89092 % smallint # type 89092 -
89093 % 3 # length 89093 -
89094 [ 222 ] 89094 -
89095 [ 222 ] 89095 -
89096 [ 333 ] 89096 -
89097 [ 333 ] 89097 -
89098 #SELECT abs(b-c), 89098 -
89099 # c, 89099 -
89100 # e, 89100 -
89101 # c-d 89101 -
89102 # FROM t1 89102 -
89103 # WHERE (c<=d-2 OR c>=d+2) 89103 -
89104 # AND (a>b-2 AND a<b+2) 89104 -
89105 #; 89105 -
89106 % sys., sys.t1, sys.t1, sys. # table_name 89106 -
89107 # sys.L2, sys.t1, sys.t1, sys.L6 # table_name 89107 -
89108 % L, c, e, L # name 89108 -
89109 # L2, c, e, L6 # name 89109 -
89110 % bigint, int, int, bigint # type 89110 -
89111 % 1, 1, 1, 1 # length 89111 -
89112 #SELECT abs(b-c), 89112 -
89113 # c, 89113 -
89114 # e, 89114 -
89115 # c-d 89115 -
89116 # FROM t1 89116 -
89117 # WHERE (c<=d-2 OR c>=d+2) 89117 -
89118 # AND (a>b-2 AND a<b+2) 89118 -
89119 # ORDER BY 3,4,1,2 89119 -
89120 #; 89120 -
89121 % sys., sys.t1, sys.t1, sys. # table_name 89121 -
89122 # sys.L2, sys.t1, sys.t1, sys.L6 # table_name 89122 -
89123 % L, c, e, L # name 89123 -
89124 # L2, c, e, L6 # name 89124 -
89125 % bigint, int, int, bigint # type 89125 -
89126 % 1, 1, 1, 1 # length 89126 -
89127 #SELECT b-c, 89127 -
89128 # a-b, 89128 -
89129 # CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 89129 -
89130 # WHEN a<b+3 THEN 333 ELSE 444 END, 89130 -
89131 # abs(b-c) 89131 -
89132 # FROM t1 89132 -
89133 #; 89133 -
89134 % sys., sys., sys., sys. # table_name 89134 -
89135 # sys.L2, sys.L4, sys.L6, sys.L10 # table_name 89135 -
89136 % L, L, L, L # name 89136 -
89137 # L2, L4, L6, L10 # name 89137 -
89138 % bigint, bigint, smallint, bigint # type 89138 -
89139 % 2, 2, 3, 1 # length 89139 -
89140 [ NULL, NULL, 444, NULL ] 89140 -
89141 [ -1, 2, 333, 1 ] 89141 -
89142 [ -1, NULL, 444, 1 ] 89142 -
89143 [ NULL, NULL, 444, NULL ] 89143 -
89144 [ 1, -3, 222, 1 ] 89144 -
89145 [ 4, -2, 222, 4 ] 89145 -
89146 [ -4, 1, 333, 4 ] 89146 -
89147 [ 2, -1, 222, 2 ] 89147 -
89148 [ 2, -1, 222, 2 ] 89148 -
89149 [ -2, 4, 444, 2 ] 89149 -
89150 [ 1, 2, 333, 1 ] 89150 -
89151 [ 3, 1, 333, 3 ] 89151 -
89152 [ -1, 3, 444, 1 ] 89152 -
89153 [ 1, 1, 333, 1 ] 89153 -
89154 [ -2, 4, 444, 2 ] 89154 -
89155 [ -1, 4, 444, 1 ] 89155 -
89156 [ -3, 1, 333, 3 ] 89156 -
89157 [ -1, 2, 333, 1 ] 89157 -
89158 [ 1, -3, 222, 1 ] 89158 -
89159 [ 3, 1, 333, 3 ] 89159 -
89160 [ NULL, NULL, 444, NULL ] 89160 -
89161 [ -2, NULL, 444, 2 ] 89161 -
89162 [ -3, 2, 333, 3 ] 89162 -
89163 [ 3, -2, 222, 3 ] 89163 -
89164 [ -1, -3, 222, 1 ] 89164 -
89165 [ 3, 1, 333, 3 ] 89165 -
89166 [ 1, 2, 333, 1 ] 89166 -
89167 [ NULL, 3, 444, NULL ] 89167 -
89168 [ -4, 3, 444, 4 ] 89168 -
89169 [ 2, -4, 111, 2 ] 89169 -
89170 #SELECT b-c, 89170 -
89171 # a-b, 89171 -
89172 # CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 89172 -
89173 # WHEN a<b+3 THEN 333 ELSE 444 END, 89173 -
89174 # abs(b-c) 89174 -
89175 # FROM t1 89175 -
89176 # ORDER BY 2,4,1,3 89176 -
89177 #; 89177 -
89178 % sys., sys., sys., sys. # table_name 89178 -
89179 # sys.L2, sys.L4, sys.L6, sys.L10 # table_name 89179 -
89180 % L, L, L, L # name 89180 -
89181 # L2, L4, L6, L10 # name 89181 -
89182 % bigint, bigint, smallint, bigint # type 89182 -
89183 % 2, 2, 3, 1 # length 89183 -
89184 [ NULL, NULL, 444, NULL ] 89184 -
89185 [ NULL, NULL, 444, NULL ] 89185 -
89186 [ NULL, NULL, 444, NULL ] 89186 -
89187 [ -1, NULL, 444, 1 ] 89187 -
89188 [ -2, NULL, 444, 2 ] 89188 -
89189 [ 2, -4, 111, 2 ] 89189 -
89190 [ -1, -3, 222, 1 ] 89190 -
89191 [ 1, -3, 222, 1 ] 89191 -
89192 [ 1, -3, 222, 1 ] 89192 -
89193 [ 3, -2, 222, 3 ] 89193 -
89194 [ 4, -2, 222, 4 ] 89194 -
89195 [ 2, -1, 222, 2 ] 89195 -
89196 [ 2, -1, 222, 2 ] 89196 -
89197 [ 1, 1, 333, 1 ] 89197 -
89198 [ -3, 1, 333, 3 ] 89198 -
89199 [ 3, 1, 333, 3 ] 89199 -
89200 [ 3, 1, 333, 3 ] 89200 -
89201 [ 3, 1, 333, 3 ] 89201 -
89202 [ -4, 1, 333, 4 ] 89202 -
89203 [ -1, 2, 333, 1 ] 89203 -
89204 [ -1, 2, 333, 1 ] 89204 -
89205 [ 1, 2, 333, 1 ] 89205 -
89206 [ 1, 2, 333, 1 ] 89206 -
89207 [ -3, 2, 333, 3 ] 89207 -
89208 [ NULL, 3, 444, NULL ] 89208 -
89209 [ -1, 3, 444, 1 ] 89209 -
89210 [ -4, 3, 444, 4 ] 89210 -
89211 [ -1, 4, 444, 1 ] 89211 -
89212 [ -2, 4, 444, 2 ] 89212 -
89213 [ -2, 4, 444, 2 ] 89213 -
89214 #SELECT abs(b-c), 89214 -
89215 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 89215 -
89216 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 89216 -
89217 # a+b*2+c*3, 89217 -
89218 # a-b 89218 -
89219 # FROM t1 89219 -
89220 # WHERE b>c 89220 -
89221 # AND c BETWEEN b-2 AND d+2 89221 -
89222 # AND (a>b-2 AND a<b+2) 89222 -
89223 #; 89223 -
89224 % sys., sys., sys., sys. # table_name 89224 -
89225 # sys.L2, sys.L4, sys.L6, sys.L10 # table_name 89225 -
89226 % L, L, L, L # name 89226 -
89227 # L2, L4, L6, L10 # name 89227 -
89228 % bigint, smallint, hugeint, bigint # type 89228 -
89229 % 1, 3, 3, 2 # length 89229 -
89230 [ 2, 111, 827, -1 ] 89230 -
89231 [ 2, 111, 851, -1 ] 89231 -
89232 #SELECT abs(b-c), 89232 -
89233 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 89233 -
89234 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 89234 -
89235 # a+b*2+c*3, 89235 -
89236 # a-b 89236 -
89237 # FROM t1 89237 -
89238 # WHERE b>c 89238 -
89239 # AND c BETWEEN b-2 AND d+2 89239 -
89240 # AND (a>b-2 AND a<b+2) 89240 -
89241 # ORDER BY 3,2 89241 -
89242 #; 89242 -
89243 % sys., sys., sys., sys. # table_name 89243 -
89244 # sys.L2, sys.L4, sys.L6, sys.L10 # table_name 89244 -
89245 % L, L, L, L # name 89245 -
89246 # L2, L4, L6, L10 # name 89246 -
89247 % bigint, smallint, hugeint, bigint # type 89247 -
89248 % 1, 3, 3, 2 # length 89248 -
89249 [ 2, 111, 827, -1 ] 89249 -
89250 [ 2, 111, 851, -1 ] 89250 -
89251 #SELECT abs(b-c), 89251 -
89252 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 89252 -
89253 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 89253 -
89254 # a+b*2+c*3, 89254 -
89255 # a-b 89255 -
89256 # FROM t1 89256 -
89257 # WHERE (a>b-2 AND a<b+2) 89257 -
89258 # AND c BETWEEN b-2 AND d+2 89258 -
89259 # AND b>c 89259 -
89260 #; 89260 -
89261 % sys., sys., sys., sys. # table_name 89261 -
89262 # sys.L2, sys.L4, sys.L6, sys.L10 # table_name 89262 -
89263 % L, L, L, L # name 89263 -
89264 # L2, L4, L6, L10 # name 89264 -
89265 % bigint, smallint, hugeint, bigint # type 89265 -
89266 % 1, 3, 3, 2 # length 89266 -
89267 [ 2, 111, 827, -1 ] 89267 -
89268 [ 2, 111, 851, -1 ] 89268 -
89269 #SELECT abs(b-c), 89269 -
89270 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 89270 -
89271 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 89271 -
89272 # a+b*2+c*3, 89272 -
89273 # a-b 89273 -
89274 # FROM t1 89274 -
89275 # WHERE (a>b-2 AND a<b+2) 89275 -
89276 # AND c BETWEEN b-2 AND d+2 89276 -
89277 # AND b>c 89277 -
89278 # ORDER BY 1,3 89278 -
89279 #; 89279 -
89280 % sys., sys., sys., sys. # table_name 89280 -
89281 # sys.L2, sys.L4, sys.L6, sys.L10 # table_name 89281 -
89282 % L, L, L, L # name 89282 -
89283 # L2, L4, L6, L10 # name 89283 -
89284 % bigint, smallint, hugeint, bigint # type 89284 -
89285 % 1, 3, 3, 2 # length 89285 -
89286 [ 2, 111, 827, -1 ] 89286 -
89287 [ 2, 111, 851, -1 ] 89287 -
89288 #SELECT abs(b-c), 89288 -
89289 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 89289 -
89290 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 89290 -
89291 # a+b*2+c*3, 89291 -
89292 # a-b 89292 -
89293 # FROM t1 89293 -
89294 # WHERE c BETWEEN b-2 AND d+2 89294 -
89295 # AND (a>b-2 AND a<b+2) 89295 -
89296 # AND b>c 89296 -
89297 #; 89297 -
89298 % sys., sys., sys., sys. # table_name 89298 -
89299 # sys.L2, sys.L4, sys.L6, sys.L10 # table_name 89299 -
89300 % L, L, L, L # name 89300 -
89301 # L2, L4, L6, L10 # name 89301 -
89302 % bigint, smallint, hugeint, bigint # type 89302 -
89303 % 1, 3, 3, 2 # length 89303 -
89304 [ 2, 111, 827, -1 ] 89304 -
89305 [ 2, 111, 851, -1 ] 89305 -
89306 #SELECT abs(b-c), 89306 -
89307 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 89307 -
89308 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 89308 -
89309 # a+b*2+c*3, 89309 -
89310 # a-b 89310 -
89311 # FROM t1 89311 -
89312 # WHERE c BETWEEN b-2 AND d+2 89312 -
89313 # AND (a>b-2 AND a<b+2) 89313 -
89314 # AND b>c 89314 -
89315 # ORDER BY 2,4,1,3 89315 -
89316 #; 89316 -
89317 % sys., sys., sys., sys. # table_name 89317 -
89318 # sys.L2, sys.L4, sys.L6, sys.L10 # table_name 89318 -
89319 % L, L, L, L # name 89319 -
89320 # L2, L4, L6, L10 # name 89320 -
89321 % bigint, smallint, hugeint, bigint # type 89321 -
89322 % 1, 3, 3, 2 # length 89322 -
89323 [ 2, 111, 827, -1 ] 89323 -
89324 [ 2, 111, 851, -1 ] 89324 -
89325 #SELECT a+b*2+c*3+d*4+e*5, 89325 -
89326 # d-e, 89326 -
89327 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 89327 -
89328 # (a+b+c+d+e)/5, 89328 -
89329 # abs(a) 89329 -
89330 # FROM t1 89330 -
89331 # WHERE c BETWEEN b-2 AND d+2 89331 -
89332 #; 89332 -
89333 % ., ., ., ., . # table_name 89333 -
89334 # .L2, .L4, .L11, .L14, .L16 # table_name 89334 -
89335 % L, L, L, L, L # name 89335 -
89336 # L2, L4, L11, L14, L16 # name 89336 -
89337 % hugeint, bigint, bigint, hugeint, int # type 89337 -
89338 % 4, 2, 2, 3, 3 # length 89338 -
89339 [ NULL, 4, 1, NULL, NULL ] 89339 -
89340 [ NULL, NULL, 2, NULL, 121 ] 89340 -
89341 [ 1985, 1, 4, 132, 131 ] 89341 -
89342 [ 2046, 1, 5, 137, 138 ] 89342 -
89343 [ 2131, -4, 6, 142, 142 ] 89343 -
89344 [ 2432, 2, 10, 162, 163 ] 89344 -
89345 [ 2579, -2, 12, 172, 174 ] 89345 -
89346 [ 2728, 3, 14, 182, 182 ] 89346 -
89347 [ 2806, -4, 15, 187, 188 ] 89347 -
89348 [ NULL, NULL, 18, NULL, NULL ] 89348 -
89349 [ 3175, 2, 19, 212, 213 ] 89349 -
89350 [ 3331, 1, 21, 222, 220 ] 89350 -
89351 [ 3473, 3, 23, 232, 234 ] 89351 -
89352 [ 3706, 2, 26, 247, 245 ] 89352 -
89353 [ 1612, -1, 0, 107, 107 ] 89353 -
89354 #SELECT a+b*2+c*3+d*4+e*5, 89354 -
89355 # d-e, 89355 -
89356 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 89356 -
89357 # (a+b+c+d+e)/5, 89357 -
89358 # abs(a) 89358 -
89359 # FROM t1 89359 -
89360 # WHERE c BETWEEN b-2 AND d+2 89360 -
89361 # ORDER BY 4,3,5,1,2 89361 -
89362 #; 89362 -
89363 % ., ., ., ., . # table_name 89363 -
89364 # .L2, .L4, .L11, .L14, .L16 # table_name 89364 -
89365 % L, L, L, L, L # name 89365 -
89366 # L2, L4, L11, L14, L16 # name 89366 -
89367 % hugeint, bigint, bigint, hugeint, int # type 89367 -
89368 % 4, 2, 2, 3, 3 # length 89368 -
89369 [ NULL, 4, 1, NULL, NULL ] 89369 -
89370 [ NULL, NULL, 2, NULL, 121 ] 89370 -
89371 [ NULL, NULL, 18, NULL, NULL ] 89371 -
89372 [ 1612, -1, 0, 107, 107 ] 89372 -
89373 [ 1985, 1, 4, 132, 131 ] 89373 -
89374 [ 2046, 1, 5, 137, 138 ] 89374 -
89375 [ 2131, -4, 6, 142, 142 ] 89375 -
89376 [ 2432, 2, 10, 162, 163 ] 89376 -
89377 [ 2579, -2, 12, 172, 174 ] 89377 -
89378 [ 2728, 3, 14, 182, 182 ] 89378 -
89379 [ 2806, -4, 15, 187, 188 ] 89379 -
89380 [ 3175, 2, 19, 212, 213 ] 89380 -
89381 [ 3331, 1, 21, 222, 220 ] 89381 -
89382 [ 3473, 3, 23, 232, 234 ] 89382 -
89383 [ 3706, 2, 26, 247, 245 ] 89383 -
89384 #SELECT d-e 89384 -
89385 # FROM t1 89385 -
89386 # WHERE e+d BETWEEN a+b-10 AND c+130 89386 -
89387 # AND (e>a AND e<b) 89387 -
89388 #; 89388 -
89389 % sys. # table_name 89389 -
89390 # sys.L2 # table_name 89390 -
89391 % L # name 89391 -
89392 # L2 # name 89392 -
89393 % bigint # type 89393 -
89394 % 1 # length 89394 -
89395 #SELECT d-e 89395 -
89396 # FROM t1 89396 -
89397 # WHERE e+d BETWEEN a+b-10 AND c+130 89397 -
89398 # AND (e>a AND e<b) 89398 -
89399 # ORDER BY 1 89399 -
89400 #; 89400 -
89401 % sys. # table_name 89401 -
89402 # sys.L2 # table_name 89402 -
89403 % L # name 89403 -
89404 # L2 # name 89404 -
89405 % bigint # type 89405 -
89406 % 1 # length 89406 -
89407 #SELECT d-e 89407 -
89408 # FROM t1 89408 -
89409 # WHERE (e>a AND e<b) 89409 -
89410 # AND e+d BETWEEN a+b-10 AND c+130 89410 -
89411 #; 89411 -
89412 % sys. # table_name 89412 -
89413 # sys.L2 # table_name 89413 -
89414 % L # name 89414 -
89415 # L2 # name 89415 -
89416 % bigint # type 89416 -
89417 % 1 # length 89417 -
89418 #SELECT d-e 89418 -
89419 # FROM t1 89419 -
89420 # WHERE (e>a AND e<b) 89420 -
89421 # AND e+d BETWEEN a+b-10 AND c+130 89421 -
89422 # ORDER BY 1 89422 -
89423 #; 89423 -
89424 % sys. # table_name 89424 -
89425 # sys.L2 # table_name 89425 -
89426 % L # name 89426 -
89427 # L2 # name 89427 -
89428 % bigint # type 89428 -
89429 % 1 # length 89429 -
89430 #SELECT a, 89430 -
89431 # abs(b-c), 89431 -
89432 # c 89432 -
89433 # FROM t1 89433 -
89434 # WHERE e+d BETWEEN a+b-10 AND c+130 89434 -
89435 #; 89435 -
89436 % sys.t1, sys., sys.t1 # table_name 89436 -
89437 # sys.t1, sys.L3, sys.t1 # table_name 89437 -
89438 % a, L, c # name 89438 -
89439 # a, L3, c # name 89439 -
89440 % int, bigint, int # type 89440 -
89441 % 3, 1, 3 # length 89441 -
89442 [ 107, 1, 106 ] 89442 -
89443 [ 127, 4, 125 ] 89443 -
89444 #SELECT a, 89444 -
89445 # abs(b-c), 89445 -
89446 # c 89446 -
89447 # FROM t1 89447 -
89448 # WHERE e+d BETWEEN a+b-10 AND c+130 89448 -
89449 # ORDER BY 2,3,1 89449 -
89450 #; 89450 -
89451 % sys.t1, sys., sys.t1 # table_name 89451 -
89452 # sys.t1, sys.L3, sys.t1 # table_name 89452 -
89453 % a, L, c # name 89453 -
89454 # a, L3, c # name 89454 -
89455 % int, bigint, int # type 89455 -
89456 % 3, 1, 3 # length 89456 -
89457 [ 107, 1, 106 ] 89457 -
89458 [ 127, 4, 125 ] 89458 -
89459 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b) 89459 -
89460 # FROM t1 89460 -
89461 #; 89461 -
89462 % . # table_name 89462 -
89463 # .L5 # table_name 89463 -
89464 % L # name 89464 -
89465 # L5 # name 89465 -
89466 % bigint # type 89466 -
89467 % 2 # length 89467 -
89468 [ 1 ] 89468 -
89469 [ 2 ] 89469 -
89470 [ 3 ] 89470 -
89471 [ 4 ] 89471 -
89472 [ 5 ] 89472 -
89473 [ 6 ] 89473 -
89474 [ 7 ] 89474 -
89475 [ 8 ] 89475 -
89476 [ 9 ] 89476 -
89477 [ 10 ] 89477 -
89478 [ 11 ] 89478 -
89479 [ 12 ] 89479 -
89480 [ 13 ] 89480 -
89481 [ 14 ] 89481 -
89482 [ 15 ] 89482 -
89483 [ 16 ] 89483 -
89484 [ 17 ] 89484 -
89485 [ 18 ] 89485 -
89486 [ 19 ] 89486 -
89487 [ 20 ] 89487 -
89488 [ 21 ] 89488 -
89489 [ 22 ] 89489 -
89490 [ 23 ] 89490 -
89491 [ 24 ] 89491 -
89492 [ 25 ] 89492 -
89493 [ 26 ] 89493 -
89494 [ 0 ] 89494 -
89495 [ 0 ] 89495 -
89496 [ 0 ] 89496 -
89497 [ 0 ] 89497 -
89498 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b) 89498 -
89499 # FROM t1 89499 -
89500 # ORDER BY 1 89500 -
89501 #; 89501 -
89502 % . # table_name 89502 -
89503 # .L5 # table_name 89503 -
89504 % L # name 89504 -
89505 # L5 # name 89505 -
89506 % bigint # type 89506 -
89507 % 2 # length 89507 -
89508 [ 0 ] 89508 -
89509 [ 0 ] 89509 -
89510 [ 0 ] 89510 -
89511 [ 0 ] 89511 -
89512 [ 1 ] 89512 -
89513 [ 2 ] 89513 -
89514 [ 3 ] 89514 -
89515 [ 4 ] 89515 -
89516 [ 5 ] 89516 -
89517 [ 6 ] 89517 -
89518 [ 7 ] 89518 -
89519 [ 8 ] 89519 -
89520 [ 9 ] 89520 -
89521 [ 10 ] 89521 -
89522 [ 11 ] 89522 -
89523 [ 12 ] 89523 -
89524 [ 13 ] 89524 -
89525 [ 14 ] 89525 -
89526 [ 15 ] 89526 -
89527 [ 16 ] 89527 -
89528 [ 17 ] 89528 -
89529 [ 18 ] 89529 -
89530 [ 19 ] 89530 -
89531 [ 20 ] 89531 -
89532 [ 21 ] 89532 -
89533 [ 22 ] 89533 -
89534 [ 23 ] 89534 -
89535 [ 24 ] 89535 -
89536 [ 25 ] 89536 -
89537 [ 26 ] 89537 -
89538 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d), 89538 -
89539 # d-e 89539 -
89540 # FROM t1 89540 -
89541 # WHERE (e>c OR e<d) 89541 -
89542 # OR (e>a AND e<b) 89542 -
89543 #; 89543 -
89544 % ., . # table_name 89544 -
89545 # .L5, .L7 # table_name 89545 -
89546 % L, L # name 89546 -
89547 # L5, L7 # name 89547 -
89548 % bigint, bigint # type 89548 -
89549 % 1, 2 # length 89549 -
89550 [ 0, -1 ] 89550 -
89551 [ 0, 4 ] 89551 -
89552 [ 0, 2 ] 89552 -
89553 [ 0, 1 ] 89553 -
89554 [ 0, 1 ] 89554 -
89555 [ 0, -4 ] 89555 -
89556 [ 0, NULL ] 89556 -
89557 [ 0, 2 ] 89557 -
89558 [ 0, -2 ] 89558 -
89559 [ 0, NULL ] 89559 -
89560 [ 0, 3 ] 89560 -
89561 [ 0, -4 ] 89561 -
89562 [ 0, -2 ] 89562 -
89563 [ 0, -1 ] 89563 -
89564 [ 0, -1 ] 89564 -
89565 [ 0, 2 ] 89565 -
89566 [ 0, -2 ] 89566 -
89567 [ 0, 1 ] 89567 -
89568 [ 0, -1 ] 89568 -
89569 [ 0, 3 ] 89569 -
89570 [ 0, 1 ] 89570 -
89571 [ 0, 2 ] 89571 -
89572 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d), 89572 -
89573 # d-e 89573 -
89574 # FROM t1 89574 -
89575 # WHERE (e>c OR e<d) 89575 -
89576 # OR (e>a AND e<b) 89576 -
89577 # ORDER BY 2,1 89577 -
89578 #; 89578 -
89579 % ., . # table_name 89579 -
89580 # .L5, .L7 # table_name 89580 -
89581 % L, L # name 89581 -
89582 # L5, L7 # name 89582 -
89583 % bigint, bigint # type 89583 -
89584 % 1, 2 # length 89584 -
89585 [ 0, NULL ] 89585 -
89586 [ 0, NULL ] 89586 -
89587 [ 0, -4 ] 89587 -
89588 [ 0, -4 ] 89588 -
89589 [ 0, -2 ] 89589 -
89590 [ 0, -2 ] 89590 -
89591 [ 0, -2 ] 89591 -
89592 [ 0, -1 ] 89592 -
89593 [ 0, -1 ] 89593 -
89594 [ 0, -1 ] 89594 -
89595 [ 0, -1 ] 89595 -
89596 [ 0, 1 ] 89596 -
89597 [ 0, 1 ] 89597 -
89598 [ 0, 1 ] 89598 -
89599 [ 0, 1 ] 89599 -
89600 [ 0, 2 ] 89600 -
89601 [ 0, 2 ] 89601 -
89602 [ 0, 2 ] 89602 -
89603 [ 0, 2 ] 89603 -
89604 [ 0, 3 ] 89604 -
89605 [ 0, 3 ] 89605 -
89606 [ 0, 4 ] 89606 -
89607 #SELECT a+b*2, 89607 -
89608 # a+b*2+c*3+d*4 89608 -
89609 # FROM t1 89609 -
89610 # WHERE c BETWEEN b-2 AND d+2 89610 -
89611 #; 89611 -
89612 % sys., sys. # table_name 89612 -
89613 # sys.L2, sys.L4 # table_name 89613 -
89614 % L, L # name 89614 -
89615 # L2, L4 # name 89615 -
89616 % bigint, hugeint # type 89616 -
89617 % 3, 4 # length 89617 -
89618 [ 317, 1067 ] 89618 -
89619 [ NULL, NULL ] 89619 -
89620 [ 369, 1226 ] 89620 -
89621 [ 391, 1325 ] 89621 -
89622 [ 416, 1371 ] 89622 -
89623 [ 428, 1411 ] 89623 -
89624 [ 483, 1622 ] 89624 -
89625 [ 514, 1714 ] 89625 -
89626 [ 544, 1828 ] 89626 -
89627 [ 560, 1861 ] 89627 -
89628 [ NULL, NULL ] 89628 -
89629 [ 635, 2125 ] 89629 -
89630 [ 666, 2226 ] 89630 -
89631 [ 698, 2323 ] 89631 -
89632 [ 743, 2476 ] 89632 -
89633 #SELECT a+b*2, 89633 -
89634 # a+b*2+c*3+d*4 89634 -
89635 # FROM t1 89635 -
89636 # WHERE c BETWEEN b-2 AND d+2 89636 -
89637 # ORDER BY 1,2 89637 -
89638 #; 89638 -
89639 % sys., sys. # table_name 89639 -
89640 # sys.L2, sys.L4 # table_name 89640 -
89641 % L, L # name 89641 -
89642 # L2, L4 # name 89642 -
89643 % bigint, hugeint # type 89643 -
89644 % 3, 4 # length 89644 -
89645 [ NULL, NULL ] 89645 -
89646 [ NULL, NULL ] 89646 -
89647 [ 317, 1067 ] 89647 -
89648 [ 369, 1226 ] 89648 -
89649 [ 391, 1325 ] 89649 -
89650 [ 416, 1371 ] 89650 -
89651 [ 428, 1411 ] 89651 -
89652 [ 483, 1622 ] 89652 -
89653 [ 514, 1714 ] 89653 -
89654 [ 544, 1828 ] 89654 -
89655 [ 560, 1861 ] 89655 -
89656 [ 635, 2125 ] 89656 -
89657 [ 666, 2226 ] 89657 -
89658 [ 698, 2323 ] 89658 -
89659 [ 743, 2476 ] 89659 -
89660 #SELECT a+b*2+c*3+d*4 89660 -
89661 # FROM t1 89661 -
89662 #; 89662 -
89663 % sys. # table_name 89663 -
89664 # sys.L2 # table_name 89664 -
89665 % L # name 89665 -
89666 # L2 # name 89666 -
89667 % hugeint # type 89667 -
89668 % 4 # length 89668 -
89669 [ NULL ] 89669 -
89670 [ 1067 ] 89670 -
89671 [ NULL ] 89671 -
89672 [ NULL ] 89672 -
89673 [ 1226 ] 89673 -
89674 [ 1272 ] 89674 -
89675 [ 1325 ] 89675 -
89676 [ 1371 ] 89676 -
89677 [ 1411 ] 89677 -
89678 [ NULL ] 89678 -
89679 [ NULL ] 89679 -
89680 [ NULL ] 89680 -
89681 [ 1622 ] 89681 -
89682 [ NULL ] 89682 -
89683 [ 1714 ] 89683 -
89684 [ NULL ] 89684 -
89685 [ 1828 ] 89685 -
89686 [ 1861 ] 89686 -
89687 [ 1918 ] 89687 -
89688 [ 1964 ] 89688 -
89689 [ NULL ] 89689 -
89690 [ NULL ] 89690 -
89691 [ 2125 ] 89691 -
89692 [ 2165 ] 89692 -
89693 [ 2226 ] 89693 -
89694 [ 2264 ] 89694 -
89695 [ 2323 ] 89695 -
89696 [ NULL ] 89696 -
89697 [ NULL ] 89697 -
89698 [ 2476 ] 89698 -
89699 #SELECT a+b*2+c*3+d*4 89699 -
89700 # FROM t1 89700 -
89701 # ORDER BY 1 89701 -
89702 #; 89702 -
89703 % sys. # table_name 89703 -
89704 # sys.L2 # table_name 89704 -
89705 % L # name 89705 -
89706 # L2 # name 89706 -
89707 % hugeint # type 89707 -
89708 % 4 # length 89708 -
89709 [ NULL ] 89709 -
89710 [ NULL ] 89710 -
89711 [ NULL ] 89711 -
89712 [ NULL ] 89712 -
89713 [ NULL ] 89713 -
89714 [ NULL ] 89714 -
89715 [ NULL ] 89715 -
89716 [ NULL ] 89716 -
89717 [ NULL ] 89717 -
89718 [ NULL ] 89718 -
89719 [ NULL ] 89719 -
89720 [ NULL ] 89720 -
89721 [ 1067 ] 89721 -
89722 [ 1226 ] 89722 -
89723 [ 1272 ] 89723 -
89724 [ 1325 ] 89724 -
89725 [ 1371 ] 89725 -
89726 [ 1411 ] 89726 -
89727 [ 1622 ] 89727 -
89728 [ 1714 ] 89728 -
89729 [ 1828 ] 89729 -
89730 [ 1861 ] 89730 -
89731 [ 1918 ] 89731 -
89732 [ 1964 ] 89732 -
89733 [ 2125 ] 89733 -
89734 [ 2165 ] 89734 -
89735 [ 2226 ] 89735 -
89736 [ 2264 ] 89736 -
89737 [ 2323 ] 89737 -
89738 [ 2476 ] 89738 -
89739 #SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222 89739 -
89740 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 89740 -
89741 # d, 89741 -
89742 # d-e, 89742 -
89743 # a+b*2+c*3, 89743 -
89744 # (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d) 89744 -
89745 # FROM t1 89745 -
89746 # WHERE c>d 89746 -
89747 # OR d NOT BETWEEN 110 AND 150 89747 -
89748 # OR a>b 89748 -
89749 #; 89749 -
89750 % ., .t1, ., ., . # table_name 89750 -
89751 # .L2, .t1, .L5, .L7, .L14 # table_name 89751 -
89752 % L, d, L, L, L # name 89752 -
89753 # L2, d, L5, L7, L14 # name 89753 -
89754 % smallint, int, bigint, hugeint, bigint # type 89754 -
89755 % 3, 3, 2, 4, 1 # length 89755 -
89756 [ 555, 101, NULL, NULL, 0 ] 89756 -
89757 [ 333, 108, -1, 635, 0 ] 89757 -
89758 [ 333, 116, -1, NULL, 0 ] 89758 -
89759 [ 333, 122, NULL, 738, 0 ] 89759 -
89760 [ 444, 133, 1, 793, 0 ] 89760 -
89761 [ 111, 136, 1, 827, 0 ] 89761 -
89762 [ 111, 140, -4, 851, 0 ] 89762 -
89763 [ 555, NULL, NULL, 880, 0 ] 89763 -
89764 [ 555, NULL, NULL, 905, 0 ] 89764 -
89765 [ 555, NULL, NULL, 940, 0 ] 89765 -
89766 [ 333, 164, 2, 966, 0 ] 89766 -
89767 [ 555, NULL, NULL, 1000, 0 ] 89767 -
89768 [ 555, 171, -2, 1030, 0 ] 89768 -
89769 [ 555, NULL, NULL, 1057, 0 ] 89769 -
89770 [ 333, 183, 3, 1096, 0 ] 89770 -
89771 [ 444, 185, -4, 1121, 0 ] 89771 -
89772 [ 444, 190, -2, 1158, 0 ] 89772 -
89773 [ 555, 196, -1, 1180, 0 ] 89773 -
89774 [ 222, 203, -1, NULL, 0 ] 89774 -
89775 [ 555, 207, NULL, NULL, 0 ] 89775 -
89776 [ 222, 212, 2, 1277, 0 ] 89776 -
89777 [ 333, 217, -2, 1297, 0 ] 89777 -
89778 [ 444, 222, 1, 1338, 0 ] 89778 -
89779 [ 555, 226, -1, 1360, 0 ] 89779 -
89780 [ 555, 233, 3, 1391, 0 ] 89780 -
89781 [ 555, 238, 1, NULL, 0 ] 89781 -
89782 [ 222, NULL, NULL, 1455, 0 ] 89782 -
89783 [ 444, 248, 2, 1484, 0 ] 89783 -
89784 #SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222 89784 -
89785 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 89785 -
89786 # d, 89786 -
89787 # d-e, 89787 -
89788 # a+b*2+c*3, 89788 -
89789 # (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d) 89789 -
89790 # FROM t1 89790 -
89791 # WHERE c>d 89791 -
89792 # OR d NOT BETWEEN 110 AND 150 89792 -
89793 # OR a>b 89793 -
89794 # ORDER BY 3,5,2 89794 -
89795 #; 89795 -
89796 % ., .t1, ., ., . # table_name 89796 -
89797 # .L2, .t1, .L5, .L7, .L14 # table_name 89797 -
89798 % L, d, L, L, L # name 89798 -
89799 # L2, d, L5, L7, L14 # name 89799 -
89800 % smallint, int, bigint, hugeint, bigint # type 89800 -
89801 % 3, 3, 2, 4, 1 # length 89801 -
89802 [ 555, NULL, NULL, 880, 0 ] 89802 -
89803 [ 555, NULL, NULL, 905, 0 ] 89803 -
89804 [ 555, NULL, NULL, 940, 0 ] 89804 -
89805 [ 555, NULL, NULL, 1000, 0 ] 89805 -
89806 [ 555, NULL, NULL, 1057, 0 ] 89806 -
89807 [ 222, NULL, NULL, 1455, 0 ] 89807 -
89808 [ 555, 101, NULL, NULL, 0 ] 89808 -
89809 [ 333, 122, NULL, 738, 0 ] 89809 -
89810 [ 555, 207, NULL, NULL, 0 ] 89810 -
89811 [ 111, 140, -4, 851, 0 ] 89811 -
89812 [ 444, 185, -4, 1121, 0 ] 89812 -
89813 [ 555, 171, -2, 1030, 0 ] 89813 -
89814 [ 444, 190, -2, 1158, 0 ] 89814 -
89815 [ 333, 217, -2, 1297, 0 ] 89815 -
89816 [ 333, 108, -1, 635, 0 ] 89816 -
89817 [ 333, 116, -1, NULL, 0 ] 89817 -
89818 [ 555, 196, -1, 1180, 0 ] 89818 -
89819 [ 222, 203, -1, NULL, 0 ] 89819 -
89820 [ 555, 226, -1, 1360, 0 ] 89820 -
89821 [ 444, 133, 1, 793, 0 ] 89821 -
89822 [ 111, 136, 1, 827, 0 ] 89822 -
89823 [ 444, 222, 1, 1338, 0 ] 89823 -
89824 [ 555, 238, 1, NULL, 0 ] 89824 -
89825 [ 333, 164, 2, 966, 0 ] 89825 -
89826 [ 222, 212, 2, 1277, 0 ] 89826 -
89827 [ 444, 248, 2, 1484, 0 ] 89827 -
89828 [ 333, 183, 3, 1096, 0 ] 89828 -
89829 [ 555, 233, 3, 1391, 0 ] 89829 -
89830 #SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222 89830 -
89831 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 89831 -
89832 # d, 89832 -
89833 # d-e, 89833 -
89834 # a+b*2+c*3, 89834 -
89835 # (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d) 89835 -
89836 # FROM t1 89836 -
89837 # WHERE a>b 89837 -
89838 # OR d NOT BETWEEN 110 AND 150 89838 -
89839 # OR c>d 89839 -
89840 #; 89840 -
89841 % ., .t1, ., ., . # table_name 89841 -
89842 # .L2, .t1, .L5, .L7, .L14 # table_name 89842 -
89843 % L, d, L, L, L # name 89843 -
89844 # L2, d, L5, L7, L14 # name 89844 -
89845 % smallint, int, bigint, hugeint, bigint # type 89845 -
89846 % 3, 3, 2, 4, 1 # length 89846 -
89847 [ 555, 101, NULL, NULL, 0 ] 89847 -
89848 [ 333, 108, -1, 635, 0 ] 89848 -
89849 [ 333, 116, -1, NULL, 0 ] 89849 -
89850 [ 333, 122, NULL, 738, 0 ] 89850 -
89851 [ 444, 133, 1, 793, 0 ] 89851 -
89852 [ 111, 136, 1, 827, 0 ] 89852 -
89853 [ 111, 140, -4, 851, 0 ] 89853 -
89854 [ 555, NULL, NULL, 880, 0 ] 89854 -
89855 [ 555, NULL, NULL, 905, 0 ] 89855 -
89856 [ 555, NULL, NULL, 940, 0 ] 89856 -
89857 [ 333, 164, 2, 966, 0 ] 89857 -
89858 [ 555, NULL, NULL, 1000, 0 ] 89858 -
89859 [ 555, 171, -2, 1030, 0 ] 89859 -
89860 [ 555, NULL, NULL, 1057, 0 ] 89860 -
89861 [ 333, 183, 3, 1096, 0 ] 89861 -
89862 [ 444, 185, -4, 1121, 0 ] 89862 -
89863 [ 444, 190, -2, 1158, 0 ] 89863 -
89864 [ 555, 196, -1, 1180, 0 ] 89864 -
89865 [ 222, 203, -1, NULL, 0 ] 89865 -
89866 [ 555, 207, NULL, NULL, 0 ] 89866 -
89867 [ 222, 212, 2, 1277, 0 ] 89867 -
89868 [ 333, 217, -2, 1297, 0 ] 89868 -
89869 [ 444, 222, 1, 1338, 0 ] 89869 -
89870 [ 555, 226, -1, 1360, 0 ] 89870 -
89871 [ 555, 233, 3, 1391, 0 ] 89871 -
89872 [ 555, 238, 1, NULL, 0 ] 89872 -
89873 [ 222, NULL, NULL, 1455, 0 ] 89873 -
89874 [ 444, 248, 2, 1484, 0 ] 89874 -
89875 #SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222 89875 -
89876 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 89876 -
89877 # d, 89877 -
89878 # d-e, 89878 -
89879 # a+b*2+c*3, 89879 -
89880 # (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d) 89880 -
89881 # FROM t1 89881 -
89882 # WHERE a>b 89882 -
89883 # OR d NOT BETWEEN 110 AND 150 89883 -
89884 # OR c>d 89884 -
89885 # ORDER BY 4,3,2,5,1 89885 -
89886 #; 89886 -
89887 % ., .t1, ., ., . # table_name 89887 -
89888 # .L2, .t1, .L5, .L7, .L14 # table_name 89888 -
89889 % L, d, L, L, L # name 89889 -
89890 # L2, d, L5, L7, L14 # name 89890 -
89891 % smallint, int, bigint, hugeint, bigint # type 89891 -
89892 % 3, 3, 2, 4, 1 # length 89892 -
89893 [ 555, 101, NULL, NULL, 0 ] 89893 -
89894 [ 555, 207, NULL, NULL, 0 ] 89894 -
89895 [ 333, 116, -1, NULL, 0 ] 89895 -
89896 [ 222, 203, -1, NULL, 0 ] 89896 -
89897 [ 555, 238, 1, NULL, 0 ] 89897 -
89898 [ 333, 108, -1, 635, 0 ] 89898 -
89899 [ 333, 122, NULL, 738, 0 ] 89899 -
89900 [ 444, 133, 1, 793, 0 ] 89900 -
89901 [ 111, 136, 1, 827, 0 ] 89901 -
89902 [ 111, 140, -4, 851, 0 ] 89902 -
89903 [ 555, NULL, NULL, 880, 0 ] 89903 -
89904 [ 555, NULL, NULL, 905, 0 ] 89904 -
89905 [ 555, NULL, NULL, 940, 0 ] 89905 -
89906 [ 333, 164, 2, 966, 0 ] 89906 -
89907 [ 555, NULL, NULL, 1000, 0 ] 89907 -
89908 [ 555, 171, -2, 1030, 0 ] 89908 -
89909 [ 555, NULL, NULL, 1057, 0 ] 89909 -
89910 [ 333, 183, 3, 1096, 0 ] 89910 -
89911 [ 444, 185, -4, 1121, 0 ] 89911 -
89912 [ 444, 190, -2, 1158, 0 ] 89912 -
89913 [ 555, 196, -1, 1180, 0 ] 89913 -
89914 [ 222, 212, 2, 1277, 0 ] 89914 -
89915 [ 333, 217, -2, 1297, 0 ] 89915 -
89916 [ 444, 222, 1, 1338, 0 ] 89916 -
89917 [ 555, 226, -1, 1360, 0 ] 89917 -
89918 [ 555, 233, 3, 1391, 0 ] 89918 -
89919 [ 222, NULL, NULL, 1455, 0 ] 89919 -
89920 [ 444, 248, 2, 1484, 0 ] 89920 -
89921 #SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222 89921 -
89922 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 89922 -
89923 # d, 89923 -
89924 # d-e, 89924 -
89925 # a+b*2+c*3, 89925 -
89926 # (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d) 89926 -
89927 # FROM t1 89927 -
89928 # WHERE a>b 89928 -
89929 # OR c>d 89929 -
89930 # OR d NOT BETWEEN 110 AND 150 89930 -
89931 #; 89931 -
89932 % ., .t1, ., ., . # table_name 89932 -
89933 # .L2, .t1, .L5, .L7, .L14 # table_name 89933 -
89934 % L, d, L, L, L # name 89934 -
89935 # L2, d, L5, L7, L14 # name 89935 -
89936 % smallint, int, bigint, hugeint, bigint # type 89936 -
89937 % 3, 3, 2, 4, 1 # length 89937 -
89938 [ 555, 101, NULL, NULL, 0 ] 89938 -
89939 [ 333, 108, -1, 635, 0 ] 89939 -
89940 [ 333, 116, -1, NULL, 0 ] 89940 -
89941 [ 333, 122, NULL, 738, 0 ] 89941 -
89942 [ 444, 133, 1, 793, 0 ] 89942 -
89943 [ 111, 136, 1, 827, 0 ] 89943 -
89944 [ 111, 140, -4, 851, 0 ] 89944 -
89945 [ 555, NULL, NULL, 880, 0 ] 89945 -
89946 [ 555, NULL, NULL, 905, 0 ] 89946 -
89947 [ 555, NULL, NULL, 940, 0 ] 89947 -
89948 [ 333, 164, 2, 966, 0 ] 89948 -
89949 [ 555, NULL, NULL, 1000, 0 ] 89949 -
89950 [ 555, 171, -2, 1030, 0 ] 89950 -
89951 [ 555, NULL, NULL, 1057, 0 ] 89951 -
89952 [ 333, 183, 3, 1096, 0 ] 89952 -
89953 [ 444, 185, -4, 1121, 0 ] 89953 -
89954 [ 444, 190, -2, 1158, 0 ] 89954 -
89955 [ 555, 196, -1, 1180, 0 ] 89955 -
89956 [ 222, 203, -1, NULL, 0 ] 89956 -
89957 [ 555, 207, NULL, NULL, 0 ] 89957 -
89958 [ 222, 212, 2, 1277, 0 ] 89958 -
89959 [ 333, 217, -2, 1297, 0 ] 89959 -
89960 [ 444, 222, 1, 1338, 0 ] 89960 -
89961 [ 555, 226, -1, 1360, 0 ] 89961 -
89962 [ 555, 233, 3, 1391, 0 ] 89962 -
89963 [ 555, 238, 1, NULL, 0 ] 89963 -
89964 [ 222, NULL, NULL, 1455, 0 ] 89964 -
89965 [ 444, 248, 2, 1484, 0 ] 89965 -
89966 #SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222 89966 -
89967 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 89967 -
89968 # d, 89968 -
89969 # d-e, 89969 -
89970 # a+b*2+c*3, 89970 -
89971 # (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d) 89971 -
89972 # FROM t1 89972 -
89973 # WHERE a>b 89973 -
89974 # OR c>d 89974 -
89975 # OR d NOT BETWEEN 110 AND 150 89975 -
89976 # ORDER BY 5,1 89976 -
89977 #; 89977 -
89978 % ., .t1, ., ., . # table_name 89978 -
89979 # .L2, .t1, .L5, .L7, .L14 # table_name 89979 -
89980 % L, d, L, L, L # name 89980 -
89981 # L2, d, L5, L7, L14 # name 89981 -
89982 % smallint, int, bigint, hugeint, bigint # type 89982 -
89983 % 3, 3, 2, 4, 1 # length 89983 -
89984 [ 111, 136, 1, 827, 0 ] 89984 -
89985 [ 111, 140, -4, 851, 0 ] 89985 -
89986 [ 222, 203, -1, NULL, 0 ] 89986 -
89987 [ 222, 212, 2, 1277, 0 ] 89987 -
89988 [ 222, NULL, NULL, 1455, 0 ] 89988 -
89989 [ 333, 108, -1, 635, 0 ] 89989 -
89990 [ 333, 116, -1, NULL, 0 ] 89990 -
89991 [ 333, 122, NULL, 738, 0 ] 89991 -
89992 [ 333, 164, 2, 966, 0 ] 89992 -
89993 [ 333, 183, 3, 1096, 0 ] 89993 -
89994 [ 333, 217, -2, 1297, 0 ] 89994 -
89995 [ 444, 133, 1, 793, 0 ] 89995 -
89996 [ 444, 185, -4, 1121, 0 ] 89996 -
89997 [ 444, 190, -2, 1158, 0 ] 89997 -
89998 [ 444, 222, 1, 1338, 0 ] 89998 -
89999 [ 444, 248, 2, 1484, 0 ] 89999 -
90000 [ 555, 101, NULL, NULL, 0 ] 90000 -
90001 [ 555, NULL, NULL, 880, 0 ] 90001 -
90002 [ 555, NULL, NULL, 905, 0 ] 90002 -
90003 [ 555, NULL, NULL, 940, 0 ] 90003 -
90004 [ 555, NULL, NULL, 1000, 0 ] 90004 -
90005 [ 555, 171, -2, 1030, 0 ] 90005 -
90006 [ 555, NULL, NULL, 1057, 0 ] 90006 -
90007 [ 555, 196, -1, 1180, 0 ] 90007 -
90008 [ 555, 207, NULL, NULL, 0 ] 90008 -
90009 [ 555, 226, -1, 1360, 0 ] 90009 -
90010 [ 555, 233, 3, 1391, 0 ] 90010 -
90011 [ 555, 238, 1, NULL, 0 ] 90011 -
90012 #SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222 90012 -
90013 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 90013 -
90014 # d, 90014 -
90015 # d-e, 90015 -
90016 # a+b*2+c*3, 90016 -
90017 # (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d) 90017 -
90018 # FROM t1 90018 -
90019 # WHERE c>d 90019 -
90020 # OR a>b 90020 -
90021 # OR d NOT BETWEEN 110 AND 150 90021 -
90022 #; 90022 -
90023 % ., .t1, ., ., . # table_name 90023 -
90024 # .L2, .t1, .L5, .L7, .L14 # table_name 90024 -
90025 % L, d, L, L, L # name 90025 -
90026 # L2, d, L5, L7, L14 # name 90026 -
90027 % smallint, int, bigint, hugeint, bigint # type 90027 -
90028 % 3, 3, 2, 4, 1 # length 90028 -
90029 [ 555, 101, NULL, NULL, 0 ] 90029 -
90030 [ 333, 108, -1, 635, 0 ] 90030 -
90031 [ 333, 116, -1, NULL, 0 ] 90031 -
90032 [ 333, 122, NULL, 738, 0 ] 90032 -
90033 [ 444, 133, 1, 793, 0 ] 90033 -
90034 [ 111, 136, 1, 827, 0 ] 90034 -
90035 [ 111, 140, -4, 851, 0 ] 90035 -
90036 [ 555, NULL, NULL, 880, 0 ] 90036 -
90037 [ 555, NULL, NULL, 905, 0 ] 90037 -
90038 [ 555, NULL, NULL, 940, 0 ] 90038 -
90039 [ 333, 164, 2, 966, 0 ] 90039 -
90040 [ 555, NULL, NULL, 1000, 0 ] 90040 -
90041 [ 555, 171, -2, 1030, 0 ] 90041 -
90042 [ 555, NULL, NULL, 1057, 0 ] 90042 -
90043 [ 333, 183, 3, 1096, 0 ] 90043 -
90044 [ 444, 185, -4, 1121, 0 ] 90044 -
90045 [ 444, 190, -2, 1158, 0 ] 90045 -
90046 [ 555, 196, -1, 1180, 0 ] 90046 -
90047 [ 222, 203, -1, NULL, 0 ] 90047 -
90048 [ 555, 207, NULL, NULL, 0 ] 90048 -
90049 [ 222, 212, 2, 1277, 0 ] 90049 -
90050 [ 333, 217, -2, 1297, 0 ] 90050 -
90051 [ 444, 222, 1, 1338, 0 ] 90051 -
90052 [ 555, 226, -1, 1360, 0 ] 90052 -
90053 [ 555, 233, 3, 1391, 0 ] 90053 -
90054 [ 555, 238, 1, NULL, 0 ] 90054 -
90055 [ 222, NULL, NULL, 1455, 0 ] 90055 -
90056 [ 444, 248, 2, 1484, 0 ] 90056 -
90057 #SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222 90057 -
90058 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 90058 -
90059 # d, 90059 -
90060 # d-e, 90060 -
90061 # a+b*2+c*3, 90061 -
90062 # (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d) 90062 -
90063 # FROM t1 90063 -
90064 # WHERE c>d 90064 -
90065 # OR a>b 90065 -
90066 # OR d NOT BETWEEN 110 AND 150 90066 -
90067 # ORDER BY 3,1,2,5 90067 -
90068 #; 90068 -
90069 % ., .t1, ., ., . # table_name 90069 -
90070 # .L2, .t1, .L5, .L7, .L14 # table_name 90070 -
90071 % L, d, L, L, L # name 90071 -
90072 # L2, d, L5, L7, L14 # name 90072 -
90073 % smallint, int, bigint, hugeint, bigint # type 90073 -
90074 % 3, 3, 2, 4, 1 # length 90074 -
90075 [ 222, NULL, NULL, 1455, 0 ] 90075 -
90076 [ 333, 122, NULL, 738, 0 ] 90076 -
90077 [ 555, NULL, NULL, 880, 0 ] 90077 -
90078 [ 555, NULL, NULL, 905, 0 ] 90078 -
90079 [ 555, NULL, NULL, 940, 0 ] 90079 -
90080 [ 555, NULL, NULL, 1000, 0 ] 90080 -
90081 [ 555, NULL, NULL, 1057, 0 ] 90081 -
90082 [ 555, 101, NULL, NULL, 0 ] 90082 -
90083 [ 555, 207, NULL, NULL, 0 ] 90083 -
90084 [ 111, 140, -4, 851, 0 ] 90084 -
90085 [ 444, 185, -4, 1121, 0 ] 90085 -
90086 [ 333, 217, -2, 1297, 0 ] 90086 -
90087 [ 444, 190, -2, 1158, 0 ] 90087 -
90088 [ 555, 171, -2, 1030, 0 ] 90088 -
90089 [ 222, 203, -1, NULL, 0 ] 90089 -
90090 [ 333, 108, -1, 635, 0 ] 90090 -
90091 [ 333, 116, -1, NULL, 0 ] 90091 -
90092 [ 555, 196, -1, 1180, 0 ] 90092 -
90093 [ 555, 226, -1, 1360, 0 ] 90093 -
90094 [ 111, 136, 1, 827, 0 ] 90094 -
90095 [ 444, 133, 1, 793, 0 ] 90095 -
90096 [ 444, 222, 1, 1338, 0 ] 90096 -
90097 [ 555, 238, 1, NULL, 0 ] 90097 -
90098 [ 222, 212, 2, 1277, 0 ] 90098 -
90099 [ 333, 164, 2, 966, 0 ] 90099 -
90100 [ 444, 248, 2, 1484, 0 ] 90100 -
90101 [ 333, 183, 3, 1096, 0 ] 90101 -
90102 [ 555, 233, 3, 1391, 0 ] 90102 -
90103 #SELECT b, 90103 -
90104 # b-c, 90104 -
90105 # a-b, 90105 -
90106 # e, 90106 -
90107 # c-d, 90107 -
90108 # a+b*2, 90108 -
90109 # abs(b-c) 90109 -
90110 # FROM t1 90110 -
90111 # WHERE c>d 90111 -
90112 #; 90112 -
90113 % sys.t1, sys., sys., sys.t1, sys., sys., sys. # table_name 90113 -
90114 # sys.t1, sys.L3, sys.L5, sys.t1, sys.L10, sys.L12, sys.L14 # table_name 90114 -
90115 % b, L, L, e, L, L, L # name 90115 -
90116 # b, L3, L5, e, L10, L12, L14 # name 90116 -
90117 % int, bigint, bigint, int, bigint, bigint, bigint # type 90117 -
90118 % 3, 2, 2, 3, 1, 3, 1 # length 90118 -
90119 [ NULL, NULL, NULL, NULL, 1, NULL, NULL ] 90119 -
90120 [ NULL, NULL, NULL, 117, 3, NULL, NULL ] 90120 -
90121 [ 124, 1, -3, NULL, 1, 369, 1 ] 90121 -
90122 [ 130, -4, 1, 132, 1, 391, 4 ] 90122 -
90123 [ 139, 2, -1, 135, 1, 416, 2 ] 90123 -
90124 [ 143, 2, -1, 144, 1, 428, 2 ] 90124 -
90125 [ 170, -2, 4, 173, 1, 514, 2 ] 90125 -
90126 [ 181, -3, 1, 180, 1, 544, 3 ] 90126 -
90127 [ 186, -1, 2, 189, 2, 560, 1 ] 90127 -
90128 [ 194, 1, -3, 192, 3, 579, 1 ] 90128 -
90129 [ 206, -2, NULL, NULL, 1, NULL, 2 ] 90129 -
90130 [ 211, -3, 2, 210, 2, 635, 3 ] 90130 -
90131 [ 223, -1, -3, 221, 2, 666, 1 ] 90131 -
90132 #SELECT b, 90132 -
90133 # b-c, 90133 -
90134 # a-b, 90134 -
90135 # e, 90135 -
90136 # c-d, 90136 -
90137 # a+b*2, 90137 -
90138 # abs(b-c) 90138 -
90139 # FROM t1 90139 -
90140 # WHERE c>d 90140 -
90141 # ORDER BY 3,1,2,7,5,6 90141 -
90142 #; 90142 -
90143 % sys.t1, sys., sys., sys.t1, sys., sys., sys. # table_name 90143 -
90144 # sys.t1, sys.L3, sys.L5, sys.t1, sys.L10, sys.L12, sys.L14 # table_name 90144 -
90145 % b, L, L, e, L, L, L # name 90145 -
90146 # b, L3, L5, e, L10, L12, L14 # name 90146 -
90147 % int, bigint, bigint, int, bigint, bigint, bigint # type 90147 -
90148 % 3, 2, 2, 3, 1, 3, 1 # length 90148 -
90149 [ NULL, NULL, NULL, NULL, 1, NULL, NULL ] 90149 -
90150 [ NULL, NULL, NULL, 117, 3, NULL, NULL ] 90150 -
90151 [ 206, -2, NULL, NULL, 1, NULL, 2 ] 90151 -
90152 [ 124, 1, -3, NULL, 1, 369, 1 ] 90152 -
90153 [ 194, 1, -3, 192, 3, 579, 1 ] 90153 -
90154 [ 223, -1, -3, 221, 2, 666, 1 ] 90154 -
90155 [ 139, 2, -1, 135, 1, 416, 2 ] 90155 -
90156 [ 143, 2, -1, 144, 1, 428, 2 ] 90156 -
90157 [ 130, -4, 1, 132, 1, 391, 4 ] 90157 -
90158 [ 181, -3, 1, 180, 1, 544, 3 ] 90158 -
90159 [ 186, -1, 2, 189, 2, 560, 1 ] 90159 -
90160 [ 211, -3, 2, 210, 2, 635, 3 ] 90160 -
90161 [ 170, -2, 4, 173, 1, 514, 2 ] 90161 -
90162 #SELECT b-c, 90162 -
90163 # b, 90163 -
90164 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 90164 -
90165 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END 90165 -
90166 # FROM t1 90166 -
90167 # WHERE a>b 90167 -
90168 # AND d NOT BETWEEN 110 AND 150 90168 -
90169 # AND (e>a AND e<b) 90169 -
90170 #; 90170 -
90171 % sys., sys.t1, sys. # table_name 90171 -
90172 # sys.L2, sys.t1, sys.L5 # table_name 90172 -
90173 % L, b, L # name 90173 -
90174 # L2, b, L5 # name 90174 -
90175 % bigint, int, smallint # type 90175 -
90176 % 1, 1, 1 # length 90176 -
90177 #SELECT b-c, 90177 -
90178 # b, 90178 -
90179 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 90179 -
90180 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END 90180 -
90181 # FROM t1 90181 -
90182 # WHERE a>b 90182 -
90183 # AND d NOT BETWEEN 110 AND 150 90183 -
90184 # AND (e>a AND e<b) 90184 -
90185 # ORDER BY 2,3 90185 -
90186 #; 90186 -
90187 % sys., sys.t1, sys. # table_name 90187 -
90188 # sys.L2, sys.t1, sys.L5 # table_name 90188 -
90189 % L, b, L # name 90189 -
90190 # L2, b, L5 # name 90190 -
90191 % bigint, int, smallint # type 90191 -
90192 % 1, 1, 1 # length 90192 -
90193 #SELECT b-c, 90193 -
90194 # b, 90194 -
90195 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 90195 -
90196 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END 90196 -
90197 # FROM t1 90197 -
90198 # WHERE (e>a AND e<b) 90198 -
90199 # AND a>b 90199 -
90200 # AND d NOT BETWEEN 110 AND 150 90200 -
90201 #; 90201 -
90202 % sys., sys.t1, sys. # table_name 90202 -
90203 # sys.L2, sys.t1, sys.L5 # table_name 90203 -
90204 % L, b, L # name 90204 -
90205 # L2, b, L5 # name 90205 -
90206 % bigint, int, smallint # type 90206 -
90207 % 1, 1, 1 # length 90207 -
90208 #SELECT b-c, 90208 -
90209 # b, 90209 -
90210 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 90210 -
90211 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END 90211 -
90212 # FROM t1 90212 -
90213 # WHERE (e>a AND e<b) 90213 -
90214 # AND a>b 90214 -
90215 # AND d NOT BETWEEN 110 AND 150 90215 -
90216 # ORDER BY 3,1 90216 -
90217 #; 90217 -
90218 % sys., sys.t1, sys. # table_name 90218 -
90219 # sys.L2, sys.t1, sys.L5 # table_name 90219 -
90220 % L, b, L # name 90220 -
90221 # L2, b, L5 # name 90221 -
90222 % bigint, int, smallint # type 90222 -
90223 % 1, 1, 1 # length 90223 -
90224 #SELECT b-c, 90224 -
90225 # b, 90225 -
90226 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 90226 -
90227 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END 90227 -
90228 # FROM t1 90228 -
90229 # WHERE d NOT BETWEEN 110 AND 150 90229 -
90230 # AND (e>a AND e<b)