Test select3.test.sql (id 3c6cbe78e1fe) (err)
select3.test.stable.out.FILTERED 2019-09-08 13:27:14.813620400 +0200select3.test.test.out.FILTERED 2019-09-08 13:27:14.829298400 +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 63077 lines, 391896 words, 1421281 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 679 lines, 3214 words, 11151 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 63077 lines, 391896 words, 1421281 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 679 lines, 3214 words, 11151 chars in lines not matching '^$|^(\| |)#` 3
4 # 98916 lines, 559244 words, 2166089 chars in all lines 4 ! 4 # 1075 lines, 4896 words, 20311 chars in all lines 4
5 5 5 5
..................
#;
1081 [ 248 ] 1081 1075 [ 248 ] 1075
1082 #SELECT abs(a), 1082 -
1083 # (a+b+c+d+e)/5, 1083 -
1084 # a+b*2+c*3+d*4, 1084 -
1085 # c, 1085 -
1086 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 1086 -
1087 # a+b*2+c*3, 1087 -
1088 # a-b 1088 -
1089 # FROM t1 1089 -
1090 # WHERE a>b 1090 -
1091 #; 1091 -
1092 % sys., sys., sys., sys.t1, ., sys., sys. # table_name 1092 -
1093 # sys.L1, sys.L2, sys.L3, sys.t1, .L5, sys.L6, sys.L7 # table_name 1093 -
1094 % L, L, L, c, L, L, L # name 1094 -
1095 # L1, L2, L3, c, L5, L6, L7 # name 1095 -
1096 % int, bigint, bigint, int, bigint, bigint, bigint # type 1096 -
1097 % 3, 3, 4, 3, 2, 4, 1 # length 1097 -
1098 [ 107, 107, 1067, 106, 0, 635, 2 ] 1098 -
1099 [ 131, 132, 1325, 134, 4, 793, 1 ] 1099 -
1100 [ 149, NULL, NULL, 147, 7, 880, 4 ] 1100 -
1101 [ 153, NULL, NULL, 150, 8, 905, 2 ] 1101 -
1102 [ 159, NULL, NULL, 155, 9, 940, 1 ] 1102 -
1103 [ 163, 162, 1622, 161, 10, 966, 3 ] 1103 -
1104 [ 168, NULL, NULL, 166, 11, 1000, 1 ] 1104 -
1105 [ 174, 172, 1714, 172, 12, 1030, 4 ] 1105 -
1106 [ 179, NULL, NULL, 176, 13, 1057, 4 ] 1106 -
1107 [ 182, 182, 1828, 184, 14, 1096, 1 ] 1107 -
1108 [ 188, 187, 1861, 187, 15, 1121, 2 ] 1108 -
1109 [ 199, 197, 1964, 195, 17, 1180, 1 ] 1109 -
1110 [ 213, 212, 2125, 214, 19, 1277, 2 ] 1110 -
1111 [ 229, 227, 2264, 225, 22, 1360, 1 ] 1111 -
1112 [ 234, 232, 2323, 231, 23, 1391, 2 ] 1112 -
1113 [ 239, NULL, NULL, NULL, 24, NULL, 3 ] 1113 -
1114 [ 243, NULL, NULL, 244, 25, 1455, 3 ] 1114 -
1115 #SELECT abs(a), 1115 -
1116 # (a+b+c+d+e)/5, 1116 -
1117 # a+b*2+c*3+d*4, 1117 -
1118 # c, 1118 -
1119 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 1119 -
1120 # a+b*2+c*3, 1120 -
1121 # a-b 1121 -
1122 # FROM t1 1122 -
1123 # WHERE a>b 1123 -
1124 # ORDER BY 7,3,5,1,6 1124 -
1125 #; 1125 -
1126 % sys., sys., sys., sys.t1, ., sys., sys. # table_name 1126 -
1127 # sys.L1, sys.L2, sys.L3, sys.t1, .L5, sys.L6, sys.L7 # table_name 1127 -
1128 % L, L, L, c, L, L, L # name 1128 -
1129 # L1, L2, L3, c, L5, L6, L7 # name 1129 -
1130 % int, bigint, bigint, int, bigint, bigint, bigint # type 1130 -
1131 % 3, 3, 4, 3, 2, 4, 1 # length 1131 -
1132 [ 159, NULL, NULL, 155, 9, 940, 1 ] 1132 -
1133 [ 168, NULL, NULL, 166, 11, 1000, 1 ] 1133 -
1134 [ 131, 132, 1325, 134, 4, 793, 1 ] 1134 -
1135 [ 182, 182, 1828, 184, 14, 1096, 1 ] 1135 -
1136 [ 199, 197, 1964, 195, 17, 1180, 1 ] 1136 -
1137 [ 229, 227, 2264, 225, 22, 1360, 1 ] 1137 -
1138 [ 153, NULL, NULL, 150, 8, 905, 2 ] 1138 -
1139 [ 107, 107, 1067, 106, 0, 635, 2 ] 1139 -
1140 [ 188, 187, 1861, 187, 15, 1121, 2 ] 1140 -
1141 [ 213, 212, 2125, 214, 19, 1277, 2 ] 1141 -
1142 [ 234, 232, 2323, 231, 23, 1391, 2 ] 1142 -
1143 [ 239, NULL, NULL, NULL, 24, NULL, 3 ] 1143 -
1144 [ 243, NULL, NULL, 244, 25, 1455, 3 ] 1144 -
1145 [ 163, 162, 1622, 161, 10, 966, 3 ] 1145 -
1146 [ 149, NULL, NULL, 147, 7, 880, 4 ] 1146 -
1147 [ 179, NULL, NULL, 176, 13, 1057, 4 ] 1147 -
1148 [ 174, 172, 1714, 172, 12, 1030, 4 ] 1148 -
1149 #SELECT d, 1149 -
1150 # a, 1150 -
1151 # a+b*2+c*3+d*4+e*5 1151 -
1152 # FROM t1 1152 -
1153 #; 1153 -
1154 % sys.t1, sys.t1, sys. # table_name 1154 -
1155 # sys.t1, sys.t1, sys.L1 # table_name 1155 -
1156 % d, a, L # name 1156 -
1157 # d, a, L1 # name 1157 -
1158 % int, int, bigint # type 1158 -
1159 % 3, 3, 4 # length 1159 -
1160 [ 101, 104, NULL ] 1160 -
1161 [ 108, 107, 1612 ] 1161 -
1162 [ 114, NULL, NULL ] 1162 -
1163 [ 116, 115, NULL ] 1163 -
1164 [ 122, 121, NULL ] 1164 -
1165 [ 128, 127, 1902 ] 1165 -
1166 [ 133, 131, 1985 ] 1166 -
1167 [ 136, 138, 2046 ] 1167 -
1168 [ 140, 142, 2131 ] 1168 -
1169 [ NULL, 149, NULL ] 1169 -
1170 [ NULL, 153, NULL ] 1170 -
1171 [ NULL, 159, NULL ] 1171 -
1172 [ 164, 163, 2432 ] 1172 -
1173 [ NULL, 168, NULL ] 1173 -
1174 [ 171, 174, 2579 ] 1174 -
1175 [ NULL, 179, NULL ] 1175 -
1176 [ 183, 182, 2728 ] 1176 -
1177 [ 185, 188, 2806 ] 1177 -
1178 [ 190, 191, 2878 ] 1178 -
1179 [ 196, 199, 2949 ] 1179 -
1180 [ 203, 201, NULL ] 1180 -
1181 [ 207, NULL, NULL ] 1181 -
1182 [ 212, 213, 3175 ] 1182 -
1183 [ 217, 216, 3260 ] 1183 -
1184 [ 222, 220, 3331 ] 1184 -
1185 [ 226, 229, 3399 ] 1185 -
1186 [ 233, 234, 3473 ] 1186 -
1187 [ 238, 239, NULL ] 1187 -
1188 [ NULL, 243, NULL ] 1188 -
1189 [ 248, 245, 3706 ] 1189 -
1190 #SELECT d, 1190 -
1191 # a, 1191 -
1192 # a+b*2+c*3+d*4+e*5 1192 -
1193 # FROM t1 1193 -
1194 # ORDER BY 2,3 1194 -
1195 #; 1195 -
1196 % sys.t1, sys.t1, sys. # table_name 1196 -
1197 # sys.t1, sys.t1, sys.L1 # table_name 1197 -
1198 % d, a, L # name 1198 -
1199 # d, a, L1 # name 1199 -
1200 % int, int, bigint # type 1200 -
1201 % 3, 3, 4 # length 1201 -
1202 [ 114, NULL, NULL ] 1202 -
1203 [ 207, NULL, NULL ] 1203 -
1204 [ 101, 104, NULL ] 1204 -
1205 [ 108, 107, 1612 ] 1205 -
1206 [ 116, 115, NULL ] 1206 -
1207 [ 122, 121, NULL ] 1207 -
1208 [ 128, 127, 1902 ] 1208 -
1209 [ 133, 131, 1985 ] 1209 -
1210 [ 136, 138, 2046 ] 1210 -
1211 [ 140, 142, 2131 ] 1211 -
1212 [ NULL, 149, NULL ] 1212 -
1213 [ NULL, 153, NULL ] 1213 -
1214 [ NULL, 159, NULL ] 1214 -
1215 [ 164, 163, 2432 ] 1215 -
1216 [ NULL, 168, NULL ] 1216 -
1217 [ 171, 174, 2579 ] 1217 -
1218 [ NULL, 179, NULL ] 1218 -
1219 [ 183, 182, 2728 ] 1219 -
1220 [ 185, 188, 2806 ] 1220 -
1221 [ 190, 191, 2878 ] 1221 -
1222 [ 196, 199, 2949 ] 1222 -
1223 [ 203, 201, NULL ] 1223 -
1224 [ 212, 213, 3175 ] 1224 -
1225 [ 217, 216, 3260 ] 1225 -
1226 [ 222, 220, 3331 ] 1226 -
1227 [ 226, 229, 3399 ] 1227 -
1228 [ 233, 234, 3473 ] 1228 -
1229 [ 238, 239, NULL ] 1229 -
1230 [ NULL, 243, NULL ] 1230 -
1231 [ 248, 245, 3706 ] 1231 -
1232 #SELECT d-e, 1232 -
1233 # c-d, 1233 -
1234 # (a+b+c+d+e)/5 1234 -
1235 # FROM t1 1235 -
1236 # WHERE d NOT BETWEEN 110 AND 150 1236 -
1237 # OR e+d BETWEEN a+b-10 AND c+130 1237 -
1238 # OR b>c 1238 -
1239 #; 1239 -
1240 % sys., sys., sys. # table_name 1240 -
1241 # sys.L1, sys.L2, sys.L3 # table_name 1241 -
1242 % L, L, L # name 1242 -
1243 # L1, L2, L3 # name 1243 -
1244 % bigint, bigint, bigint # type 1244 -
1245 % 2, 2, 3 # length 1245 -
1246 [ NULL, 1, NULL ] 1246 -
1247 [ -1, -2, 107 ] 1247 -
1248 [ NULL, 1, NULL ] 1248 -
1249 [ 2, -3, 127 ] 1249 -
1250 [ 1, 1, 137 ] 1250 -
1251 [ -4, 1, 142 ] 1251 -
1252 [ NULL, NULL, NULL ] 1252 -
1253 [ NULL, NULL, NULL ] 1253 -
1254 [ 2, -3, 162 ] 1254 -
1255 [ NULL, NULL, NULL ] 1255 -
1256 [ -2, 1, 172 ] 1256 -
1257 [ 3, 1, 182 ] 1257 -
1258 [ -4, 2, 187 ] 1258 -
1259 [ -2, 3, 192 ] 1259 -
1260 [ -1, -1, 197 ] 1260 -
1261 [ -1, -1, NULL ] 1261 -
1262 [ NULL, 1, NULL ] 1262 -
1263 [ 2, 2, 212 ] 1263 -
1264 [ -2, -2, 217 ] 1264 -
1265 [ 1, 2, 222 ] 1265 -
1266 [ -1, -1, 227 ] 1266 -
1267 [ 3, -2, 232 ] 1267 -
1268 [ 1, NULL, NULL ] 1268 -
1269 [ 2, -1, 247 ] 1269 -
1270 #SELECT d-e, 1270 -
1271 # c-d, 1271 -
1272 # (a+b+c+d+e)/5 1272 -
1273 # FROM t1 1273 -
1274 # WHERE d NOT BETWEEN 110 AND 150 1274 -
1275 # OR e+d BETWEEN a+b-10 AND c+130 1275 -
1276 # OR b>c 1276 -
1277 # ORDER BY 2,1,3 1277 -
1278 #; 1278 -
1279 % sys., sys., sys. # table_name 1279 -
1280 # sys.L1, sys.L2, sys.L3 # table_name 1280 -
1281 % L, L, L # name 1281 -
1282 # L1, L2, L3 # name 1282 -
1283 % bigint, bigint, bigint # type 1283 -
1284 % 2, 2, 3 # length 1284 -
1285 [ NULL, NULL, NULL ] 1285 -
1286 [ NULL, NULL, NULL ] 1286 -
1287 [ NULL, NULL, NULL ] 1287 -
1288 [ 1, NULL, NULL ] 1288 -
1289 [ 2, -3, 127 ] 1289 -
1290 [ 2, -3, 162 ] 1290 -
1291 [ -2, -2, 217 ] 1291 -
1292 [ -1, -2, 107 ] 1292 -
1293 [ 3, -2, 232 ] 1293 -
1294 [ -1, -1, NULL ] 1294 -
1295 [ -1, -1, 197 ] 1295 -
1296 [ -1, -1, 227 ] 1296 -
1297 [ 2, -1, 247 ] 1297 -
1298 [ NULL, 1, NULL ] 1298 -
1299 [ NULL, 1, NULL ] 1299 -
1300 [ NULL, 1, NULL ] 1300 -
1301 [ -4, 1, 142 ] 1301 -
1302 [ -2, 1, 172 ] 1302 -
1303 [ 1, 1, 137 ] 1303 -
1304 [ 3, 1, 182 ] 1304 -
1305 [ -4, 2, 187 ] 1305 -
1306 [ 1, 2, 222 ] 1306 -
1307 [ 2, 2, 212 ] 1307 -
1308 [ -2, 3, 192 ] 1308 -
1309 #SELECT d-e, 1309 -
1310 # c-d, 1310 -
1311 # (a+b+c+d+e)/5 1311 -
1312 # FROM t1 1312 -
1313 # WHERE d NOT BETWEEN 110 AND 150 1313 -
1314 # OR b>c 1314 -
1315 # OR e+d BETWEEN a+b-10 AND c+130 1315 -
1316 #; 1316 -
1317 % sys., sys., sys. # table_name 1317 -
1318 # sys.L1, sys.L2, sys.L3 # table_name 1318 -
1319 % L, L, L # name 1319 -
1320 # L1, L2, L3 # name 1320 -
1321 % bigint, bigint, bigint # type 1321 -
1322 % 2, 2, 3 # length 1322 -
1323 [ NULL, 1, NULL ] 1323 -
1324 [ -1, -2, 107 ] 1324 -
1325 [ NULL, 1, NULL ] 1325 -
1326 [ 2, -3, 127 ] 1326 -
1327 [ 1, 1, 137 ] 1327 -
1328 [ -4, 1, 142 ] 1328 -
1329 [ NULL, NULL, NULL ] 1329 -
1330 [ NULL, NULL, NULL ] 1330 -
1331 [ 2, -3, 162 ] 1331 -
1332 [ NULL, NULL, NULL ] 1332 -
1333 [ -2, 1, 172 ] 1333 -
1334 [ 3, 1, 182 ] 1334 -
1335 [ -4, 2, 187 ] 1335 -
1336 [ -2, 3, 192 ] 1336 -
1337 [ -1, -1, 197 ] 1337 -
1338 [ -1, -1, NULL ] 1338 -
1339 [ NULL, 1, NULL ] 1339 -
1340 [ 2, 2, 212 ] 1340 -
1341 [ -2, -2, 217 ] 1341 -
1342 [ 1, 2, 222 ] 1342 -
1343 [ -1, -1, 227 ] 1343 -
1344 [ 3, -2, 232 ] 1344 -
1345 [ 1, NULL, NULL ] 1345 -
1346 [ 2, -1, 247 ] 1346 -
1347 #SELECT d-e, 1347 -
1348 # c-d, 1348 -
1349 # (a+b+c+d+e)/5 1349 -
1350 # FROM t1 1350 -
1351 # WHERE d NOT BETWEEN 110 AND 150 1351 -
1352 # OR b>c 1352 -
1353 # OR e+d BETWEEN a+b-10 AND c+130 1353 -
1354 # ORDER BY 2,1,3 1354 -
1355 #; 1355 -
1356 % sys., sys., sys. # table_name 1356 -
1357 # sys.L1, sys.L2, sys.L3 # table_name 1357 -
1358 % L, L, L # name 1358 -
1359 # L1, L2, L3 # name 1359 -
1360 % bigint, bigint, bigint # type 1360 -
1361 % 2, 2, 3 # length 1361 -
1362 [ NULL, NULL, NULL ] 1362 -
1363 [ NULL, NULL, NULL ] 1363 -
1364 [ NULL, NULL, NULL ] 1364 -
1365 [ 1, NULL, NULL ] 1365 -
1366 [ 2, -3, 127 ] 1366 -
1367 [ 2, -3, 162 ] 1367 -
1368 [ -2, -2, 217 ] 1368 -
1369 [ -1, -2, 107 ] 1369 -
1370 [ 3, -2, 232 ] 1370 -
1371 [ -1, -1, NULL ] 1371 -
1372 [ -1, -1, 197 ] 1372 -
1373 [ -1, -1, 227 ] 1373 -
1374 [ 2, -1, 247 ] 1374 -
1375 [ NULL, 1, NULL ] 1375 -
1376 [ NULL, 1, NULL ] 1376 -
1377 [ NULL, 1, NULL ] 1377 -
1378 [ -4, 1, 142 ] 1378 -
1379 [ -2, 1, 172 ] 1379 -
1380 [ 1, 1, 137 ] 1380 -
1381 [ 3, 1, 182 ] 1381 -
1382 [ -4, 2, 187 ] 1382 -
1383 [ 1, 2, 222 ] 1383 -
1384 [ 2, 2, 212 ] 1384 -
1385 [ -2, 3, 192 ] 1385 -
1386 #SELECT d-e, 1386 -
1387 # c-d, 1387 -
1388 # (a+b+c+d+e)/5 1388 -
1389 # FROM t1 1389 -
1390 # WHERE b>c 1390 -
1391 # OR d NOT BETWEEN 110 AND 150 1391 -
1392 # OR e+d BETWEEN a+b-10 AND c+130 1392 -
1393 #; 1393 -
1394 % sys., sys., sys. # table_name 1394 -
1395 # sys.L1, sys.L2, sys.L3 # table_name 1395 -
1396 % L, L, L # name 1396 -
1397 # L1, L2, L3 # name 1397 -
1398 % bigint, bigint, bigint # type 1398 -
1399 % 2, 2, 3 # length 1399 -
1400 [ NULL, 1, NULL ] 1400 -
1401 [ -1, -2, 107 ] 1401 -
1402 [ NULL, 1, NULL ] 1402 -
1403 [ 2, -3, 127 ] 1403 -
1404 [ 1, 1, 137 ] 1404 -
1405 [ -4, 1, 142 ] 1405 -
1406 [ NULL, NULL, NULL ] 1406 -
1407 [ NULL, NULL, NULL ] 1407 -
1408 [ 2, -3, 162 ] 1408 -
1409 [ NULL, NULL, NULL ] 1409 -
1410 [ -2, 1, 172 ] 1410 -
1411 [ 3, 1, 182 ] 1411 -
1412 [ -4, 2, 187 ] 1412 -
1413 [ -2, 3, 192 ] 1413 -
1414 [ -1, -1, 197 ] 1414 -
1415 [ -1, -1, NULL ] 1415 -
1416 [ NULL, 1, NULL ] 1416 -
1417 [ 2, 2, 212 ] 1417 -
1418 [ -2, -2, 217 ] 1418 -
1419 [ 1, 2, 222 ] 1419 -
1420 [ -1, -1, 227 ] 1420 -
1421 [ 3, -2, 232 ] 1421 -
1422 [ 1, NULL, NULL ] 1422 -
1423 [ 2, -1, 247 ] 1423 -
1424 #SELECT d-e, 1424 -
1425 # c-d, 1425 -
1426 # (a+b+c+d+e)/5 1426 -
1427 # FROM t1 1427 -
1428 # WHERE b>c 1428 -
1429 # OR d NOT BETWEEN 110 AND 150 1429 -
1430 # OR e+d BETWEEN a+b-10 AND c+130 1430 -
1431 # ORDER BY 2,3,1 1431 -
1432 #; 1432 -
1433 % sys., sys., sys. # table_name 1433 -
1434 # sys.L1, sys.L2, sys.L3 # table_name 1434 -
1435 % L, L, L # name 1435 -
1436 # L1, L2, L3 # name 1436 -
1437 % bigint, bigint, bigint # type 1437 -
1438 % 2, 2, 3 # length 1438 -
1439 [ NULL, NULL, NULL ] 1439 -
1440 [ NULL, NULL, NULL ] 1440 -
1441 [ NULL, NULL, NULL ] 1441 -
1442 [ 1, NULL, NULL ] 1442 -
1443 [ 2, -3, 127 ] 1443 -
1444 [ 2, -3, 162 ] 1444 -
1445 [ -1, -2, 107 ] 1445 -
1446 [ -2, -2, 217 ] 1446 -
1447 [ 3, -2, 232 ] 1447 -
1448 [ -1, -1, NULL ] 1448 -
1449 [ -1, -1, 197 ] 1449 -
1450 [ -1, -1, 227 ] 1450 -
1451 [ 2, -1, 247 ] 1451 -
1452 [ NULL, 1, NULL ] 1452 -
1453 [ NULL, 1, NULL ] 1453 -
1454 [ NULL, 1, NULL ] 1454 -
1455 [ 1, 1, 137 ] 1455 -
1456 [ -4, 1, 142 ] 1456 -
1457 [ -2, 1, 172 ] 1457 -
1458 [ 3, 1, 182 ] 1458 -
1459 [ -4, 2, 187 ] 1459 -
1460 [ 2, 2, 212 ] 1460 -
1461 [ 1, 2, 222 ] 1461 -
1462 [ -2, 3, 192 ] 1462 -
1463 #SELECT d-e, 1463 -
1464 # c-d, 1464 -
1465 # (a+b+c+d+e)/5 1465 -
1466 # FROM t1 1466 -
1467 # WHERE e+d BETWEEN a+b-10 AND c+130 1467 -
1468 # OR b>c 1468 -
1469 # OR d NOT BETWEEN 110 AND 150 1469 -
1470 #; 1470 -
1471 % sys., sys., sys. # table_name 1471 -
1472 # sys.L1, sys.L2, sys.L3 # table_name 1472 -
1473 % L, L, L # name 1473 -
1474 # L1, L2, L3 # name 1474 -
1475 % bigint, bigint, bigint # type 1475 -
1476 % 2, 2, 3 # length 1476 -
1477 [ NULL, 1, NULL ] 1477 -
1478 [ -1, -2, 107 ] 1478 -
1479 [ NULL, 1, NULL ] 1479 -
1480 [ 2, -3, 127 ] 1480 -
1481 [ 1, 1, 137 ] 1481 -
1482 [ -4, 1, 142 ] 1482 -
1483 [ NULL, NULL, NULL ] 1483 -
1484 [ NULL, NULL, NULL ] 1484 -
1485 [ 2, -3, 162 ] 1485 -
1486 [ NULL, NULL, NULL ] 1486 -
1487 [ -2, 1, 172 ] 1487 -
1488 [ 3, 1, 182 ] 1488 -
1489 [ -4, 2, 187 ] 1489 -
1490 [ -2, 3, 192 ] 1490 -
1491 [ -1, -1, 197 ] 1491 -
1492 [ -1, -1, NULL ] 1492 -
1493 [ NULL, 1, NULL ] 1493 -
1494 [ 2, 2, 212 ] 1494 -
1495 [ -2, -2, 217 ] 1495 -
1496 [ 1, 2, 222 ] 1496 -
1497 [ -1, -1, 227 ] 1497 -
1498 [ 3, -2, 232 ] 1498 -
1499 [ 1, NULL, NULL ] 1499 -
1500 [ 2, -1, 247 ] 1500 -
1501 #SELECT d-e, 1501 -
1502 # c-d, 1502 -
1503 # (a+b+c+d+e)/5 1503 -
1504 # FROM t1 1504 -
1505 # WHERE e+d BETWEEN a+b-10 AND c+130 1505 -
1506 # OR b>c 1506 -
1507 # OR d NOT BETWEEN 110 AND 150 1507 -
1508 # ORDER BY 1,2 1508 -
1509 #; 1509 -
1510 % sys., sys., sys. # table_name 1510 -
1511 # sys.L1, sys.L2, sys.L3 # table_name 1511 -
1512 % L, L, L # name 1512 -
1513 # L1, L2, L3 # name 1513 -
1514 % bigint, bigint, bigint # type 1514 -
1515 % 2, 2, 3 # length 1515 -
1516 [ NULL, NULL, NULL ] 1516 -
1517 [ NULL, NULL, NULL ] 1517 -
1518 [ NULL, NULL, NULL ] 1518 -
1519 [ NULL, 1, NULL ] 1519 -
1520 [ NULL, 1, NULL ] 1520 -
1521 [ NULL, 1, NULL ] 1521 -
1522 [ -4, 1, 142 ] 1522 -
1523 [ -4, 2, 187 ] 1523 -
1524 [ -2, -2, 217 ] 1524 -
1525 [ -2, 1, 172 ] 1525 -
1526 [ -2, 3, 192 ] 1526 -
1527 [ -1, -2, 107 ] 1527 -
1528 [ -1, -1, 197 ] 1528 -
1529 [ -1, -1, NULL ] 1529 -
1530 [ -1, -1, 227 ] 1530 -
1531 [ 1, NULL, NULL ] 1531 -
1532 [ 1, 1, 137 ] 1532 -
1533 [ 1, 2, 222 ] 1533 -
1534 [ 2, -3, 127 ] 1534 -
1535 [ 2, -3, 162 ] 1535 -
1536 [ 2, -1, 247 ] 1536 -
1537 [ 2, 2, 212 ] 1537 -
1538 [ 3, -2, 232 ] 1538 -
1539 [ 3, 1, 182 ] 1539 -
1540 #SELECT a+b*2+c*3, 1540 -
1541 # CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 1541 -
1542 # c, 1542 -
1543 # (a+b+c+d+e)/5, 1543 -
1544 # d-e, 1544 -
1545 # a+b*2+c*3+d*4+e*5 1545 -
1546 # FROM t1 1546 -
1547 #; 1547 -
1548 % sys., sys., sys.t1, sys., sys., sys. # table_name 1548 -
1549 # sys.L1, sys.L4, sys.t1, sys.L5, sys.L6, sys.L7 # table_name 1549 -
1550 % L, L, c, L, L, L # name 1550 -
1551 # L1, L4, c, L5, L6, L7 # name 1551 -
1552 % bigint, bigint, int, bigint, bigint, bigint # type 1552 -
1553 % 4, 4, 3, 3, 2, 4 # length 1553 -
1554 [ NULL, NULL, 102, NULL, NULL, NULL ] 1554 -
1555 [ 635, 1050, 106, 107, -1, 1612 ] 1555 -
1556 [ NULL, 1120, 113, NULL, 4, NULL ] 1556 -
1557 [ NULL, NULL, 119, NULL, -1, NULL ] 1557 -
1558 [ 738, 1240, 123, NULL, NULL, NULL ] 1558 -
1559 [ 760, 1290, 125, 127, 2, 1902 ] 1559 -
1560 [ 793, 1300, 134, 132, 1, 1985 ] 1560 -
1561 [ 827, 1390, 137, 137, 1, 2046 ] 1561 -
1562 [ 851, 1430, 141, 142, -4, 2131 ] 1562 -
1563 [ 880, 1450, 147, NULL, NULL, NULL ] 1563 -
1564 [ 905, 1510, 150, NULL, NULL, NULL ] 1564 -
1565 [ 940, 1580, 155, NULL, NULL, NULL ] 1565 -
1566 [ 966, 1600, 161, 162, 2, 2432 ] 1566 -
1567 [ 1000, 1670, 166, NULL, NULL, NULL ] 1567 -
1568 [ 1030, 1700, 172, 172, -2, 2579 ] 1568 -
1569 [ 1057, 358, 176, NULL, NULL, NULL ] 1569 -
1570 [ 1096, 364, 184, 182, 3, 2728 ] 1570 -
1571 [ 1121, 376, 187, 187, -4, 2806 ] 1571 -
1572 [ 1158, 382, 193, 192, -2, 2878 ] 1572 -
1573 [ 1180, 398, 195, 197, -1, 2949 ] 1573 -
1574 [ NULL, 402, 202, NULL, -1, NULL ] 1574 -
1575 [ NULL, NULL, 208, NULL, NULL, NULL ] 1575 -
1576 [ 1277, 426, 214, 212, 2, 3175 ] 1576 -
1577 [ 1297, 432, 215, 217, -2, 3260 ] 1577 -
1578 [ 1338, 440, 224, 222, 1, 3331 ] 1578 -
1579 [ 1360, 458, 225, 227, -1, 3399 ] 1579 -
1580 [ 1391, 468, 231, 232, 3, 3473 ] 1580 -
1581 [ NULL, 2360, NULL, NULL, 1, NULL ] 1581 -
1582 [ 1455, 486, 244, NULL, NULL, NULL ] 1582 -
1583 [ 1484, 490, 247, 247, 2, 3706 ] 1583 -
1584 #SELECT a+b*2+c*3, 1584 -
1585 # CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 1585 -
1586 # c, 1586 -
1587 # (a+b+c+d+e)/5, 1587 -
1588 # d-e, 1588 -
1589 # a+b*2+c*3+d*4+e*5 1589 -
1590 # FROM t1 1590 -
1591 # ORDER BY 4,5 1591 -
1592 #; 1592 -
1593 % sys., sys., sys.t1, sys., sys., sys. # table_name 1593 -
1594 # sys.L1, sys.L4, sys.t1, sys.L5, sys.L6, sys.L7 # table_name 1594 -
1595 % L, L, c, L, L, L # name 1595 -
1596 # L1, L4, c, L5, L6, L7 # name 1596 -
1597 % bigint, bigint, int, bigint, bigint, bigint # type 1597 -
1598 % 4, 4, 3, 3, 2, 4 # length 1598 -
1599 [ NULL, NULL, 102, NULL, NULL, NULL ] 1599 -
1600 [ 738, 1240, 123, NULL, NULL, NULL ] 1600 -
1601 [ 880, 1450, 147, NULL, NULL, NULL ] 1601 -
1602 [ 905, 1510, 150, NULL, NULL, NULL ] 1602 -
1603 [ 940, 1580, 155, NULL, NULL, NULL ] 1603 -
1604 [ 1000, 1670, 166, NULL, NULL, NULL ] 1604 -
1605 [ 1057, 358, 176, NULL, NULL, NULL ] 1605 -
1606 [ NULL, NULL, 208, NULL, NULL, NULL ] 1606 -
1607 [ 1455, 486, 244, NULL, NULL, NULL ] 1607 -
1608 [ NULL, NULL, 119, NULL, -1, NULL ] 1608 -
1609 [ NULL, 402, 202, NULL, -1, NULL ] 1609 -
1610 [ NULL, 2360, NULL, NULL, 1, NULL ] 1610 -
1611 [ NULL, 1120, 113, NULL, 4, NULL ] 1611 -
1612 [ 635, 1050, 106, 107, -1, 1612 ] 1612 -
1613 [ 760, 1290, 125, 127, 2, 1902 ] 1613 -
1614 [ 793, 1300, 134, 132, 1, 1985 ] 1614 -
1615 [ 827, 1390, 137, 137, 1, 2046 ] 1615 -
1616 [ 851, 1430, 141, 142, -4, 2131 ] 1616 -
1617 [ 966, 1600, 161, 162, 2, 2432 ] 1617 -
1618 [ 1030, 1700, 172, 172, -2, 2579 ] 1618 -
1619 [ 1096, 364, 184, 182, 3, 2728 ] 1619 -
1620 [ 1121, 376, 187, 187, -4, 2806 ] 1620 -
1621 [ 1158, 382, 193, 192, -2, 2878 ] 1621 -
1622 [ 1180, 398, 195, 197, -1, 2949 ] 1622 -
1623 [ 1277, 426, 214, 212, 2, 3175 ] 1623 -
1624 [ 1297, 432, 215, 217, -2, 3260 ] 1624 -
1625 [ 1338, 440, 224, 222, 1, 3331 ] 1625 -
1626 [ 1360, 458, 225, 227, -1, 3399 ] 1626 -
1627 [ 1391, 468, 231, 232, 3, 3473 ] 1627 -
1628 [ 1484, 490, 247, 247, 2, 3706 ] 1628 -
1629 #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 1629 -
1630 # WHEN a<b+3 THEN 333 ELSE 444 END, 1630 -
1631 # (a+b+c+d+e)/5, 1631 -
1632 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 1632 -
1633 # c-d, 1633 -
1634 # b-c, 1634 -
1635 # c 1635 -
1636 # FROM t1 1636 -
1637 # WHERE c>d 1637 -
1638 #; 1638 -
1639 % sys., sys., ., sys., sys., sys.t1 # table_name 1639 -
1640 # sys.L1, sys.L2, .L4, sys.L5, sys.L6, sys.t1 # table_name 1640 -
1641 % L, L, L, L, L, c # name 1641 -
1642 # L1, L2, L4, L5, L6, c # name 1642 -
1643 % smallint, bigint, bigint, bigint, bigint, int # type 1643 -
1644 % 3, 3, 2, 1, 2, 3 # length 1644 -
1645 [ 444, NULL, 0, 1, NULL, 102 ] 1645 -
1646 [ 222, NULL, 2, 1, 1, 123 ] 1646 -
1647 [ 444, NULL, 0, 3, NULL, 119 ] 1647 -
1648 [ 333, 132, 4, 1, -4, 134 ] 1648 -
1649 [ 222, 137, 5, 1, 2, 137 ] 1649 -
1650 [ 222, 142, 6, 1, 2, 141 ] 1650 -
1651 [ 444, 172, 12, 1, -2, 172 ] 1651 -
1652 [ 333, 182, 14, 1, -3, 184 ] 1652 -
1653 [ 333, 187, 15, 2, -1, 187 ] 1653 -
1654 [ 222, 192, 16, 3, 1, 193 ] 1654 -
1655 [ 444, NULL, 18, 1, -2, 208 ] 1655 -
1656 [ 333, 212, 19, 2, -3, 214 ] 1656 -
1657 [ 222, 222, 21, 2, -1, 224 ] 1657 -
1658 #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 1658 -
1659 # WHEN a<b+3 THEN 333 ELSE 444 END, 1659 -
1660 # (a+b+c+d+e)/5, 1660 -
1661 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 1661 -
1662 # c-d, 1662 -
1663 # b-c, 1663 -
1664 # c 1664 -
1665 # FROM t1 1665 -
1666 # WHERE c>d 1666 -
1667 # ORDER BY 1,5,3,2 1667 -
1668 #; 1668 -
1669 % sys., sys., ., sys., sys., sys.t1 # table_name 1669 -
1670 # sys.L1, sys.L2, .L4, sys.L5, sys.L6, sys.t1 # table_name 1670 -
1671 % L, L, L, L, L, c # name 1671 -
1672 # L1, L2, L4, L5, L6, c # name 1672 -
1673 % smallint, bigint, bigint, bigint, bigint, int # type 1673 -
1674 % 3, 3, 2, 1, 2, 3 # length 1674 -
1675 [ 222, 222, 21, 2, -1, 224 ] 1675 -
1676 [ 222, NULL, 2, 1, 1, 123 ] 1676 -
1677 [ 222, 192, 16, 3, 1, 193 ] 1677 -
1678 [ 222, 137, 5, 1, 2, 137 ] 1678 -
1679 [ 222, 142, 6, 1, 2, 141 ] 1679 -
1680 [ 333, 132, 4, 1, -4, 134 ] 1680 -
1681 [ 333, 182, 14, 1, -3, 184 ] 1681 -
1682 [ 333, 212, 19, 2, -3, 214 ] 1682 -
1683 [ 333, 187, 15, 2, -1, 187 ] 1683 -
1684 [ 444, NULL, 0, 1, NULL, 102 ] 1684 -
1685 [ 444, NULL, 0, 3, NULL, 119 ] 1685 -
1686 [ 444, 172, 12, 1, -2, 172 ] 1686 -
1687 [ 444, NULL, 18, 1, -2, 208 ] 1687 -
1688 #SELECT a+b*2+c*3+d*4, 1688 -
1689 # (a+b+c+d+e)/5 1689 -
1690 # FROM t1 1690 -
1691 # WHERE (e>c OR e<d) 1691 -
1692 # AND d>e 1692 -
1693 # AND d NOT BETWEEN 110 AND 150 1693 -
1694 #; 1694 -
1695 % sys., sys. # table_name 1695 -
1696 # sys.L1, sys.L2 # table_name 1696 -
1697 % L, L # name 1697 -
1698 # L1, L2 # name 1698 -
1699 % bigint, bigint # type 1699 -
1700 % 4, 3 # length 1700 -
1701 [ 1622, 162 ] 1701 -
1702 [ 1828, 182 ] 1702 -
1703 [ 2125, 212 ] 1703 -
1704 [ 2226, 222 ] 1704 -
1705 [ 2323, 232 ] 1705 -
1706 [ NULL, NULL ] 1706 -
1707 [ 2476, 247 ] 1707 -
1708 #SELECT a+b*2+c*3+d*4, 1708 -
1709 # (a+b+c+d+e)/5 1709 -
1710 # FROM t1 1710 -
1711 # WHERE (e>c OR e<d) 1711 -
1712 # AND d>e 1712 -
1713 # AND d NOT BETWEEN 110 AND 150 1713 -
1714 # ORDER BY 2,1 1714 -
1715 #; 1715 -
1716 % sys., sys. # table_name 1716 -
1717 # sys.L1, sys.L2 # table_name 1717 -
1718 % L, L # name 1718 -
1719 # L1, L2 # name 1719 -
1720 % bigint, bigint # type 1720 -
1721 % 4, 3 # length 1721 -
1722 [ NULL, NULL ] 1722 -
1723 [ 1622, 162 ] 1723 -
1724 [ 1828, 182 ] 1724 -
1725 [ 2125, 212 ] 1725 -
1726 [ 2226, 222 ] 1726 -
1727 [ 2323, 232 ] 1727 -
1728 [ 2476, 247 ] 1728 -
1729 #SELECT a+b*2+c*3+d*4, 1729 -
1730 # (a+b+c+d+e)/5 1730 -
1731 # FROM t1 1731 -
1732 # WHERE (e>c OR e<d) 1732 -
1733 # AND d NOT BETWEEN 110 AND 150 1733 -
1734 # AND d>e 1734 -
1735 #; 1735 -
1736 % sys., sys. # table_name 1736 -
1737 # sys.L1, sys.L2 # table_name 1737 -
1738 % L, L # name 1738 -
1739 # L1, L2 # name 1739 -
1740 % bigint, bigint # type 1740 -
1741 % 4, 3 # length 1741 -
1742 [ 1622, 162 ] 1742 -
1743 [ 1828, 182 ] 1743 -
1744 [ 2125, 212 ] 1744 -
1745 [ 2226, 222 ] 1745 -
1746 [ 2323, 232 ] 1746 -
1747 [ NULL, NULL ] 1747 -
1748 [ 2476, 247 ] 1748 -
1749 #SELECT a+b*2+c*3+d*4, 1749 -
1750 # (a+b+c+d+e)/5 1750 -
1751 # FROM t1 1751 -
1752 # WHERE (e>c OR e<d) 1752 -
1753 # AND d NOT BETWEEN 110 AND 150 1753 -
1754 # AND d>e 1754 -
1755 # ORDER BY 2,1 1755 -
1756 #; 1756 -
1757 % sys., sys. # table_name 1757 -
1758 # sys.L1, sys.L2 # table_name 1758 -
1759 % L, L # name 1759 -
1760 # L1, L2 # name 1760 -
1761 % bigint, bigint # type 1761 -
1762 % 4, 3 # length 1762 -
1763 [ NULL, NULL ] 1763 -
1764 [ 1622, 162 ] 1764 -
1765 [ 1828, 182 ] 1765 -
1766 [ 2125, 212 ] 1766 -
1767 [ 2226, 222 ] 1767 -
1768 [ 2323, 232 ] 1768 -
1769 [ 2476, 247 ] 1769 -
1770 #SELECT a+b*2+c*3+d*4, 1770 -
1771 # (a+b+c+d+e)/5 1771 -
1772 # FROM t1 1772 -
1773 # WHERE d NOT BETWEEN 110 AND 150 1773 -
1774 # AND (e>c OR e<d) 1774 -
1775 # AND d>e 1775 -
1776 #; 1776 -
1777 % sys., sys. # table_name 1777 -
1778 # sys.L1, sys.L2 # table_name 1778 -
1779 % L, L # name 1779 -
1780 # L1, L2 # name 1780 -
1781 % bigint, bigint # type 1781 -
1782 % 4, 3 # length 1782 -
1783 [ 1622, 162 ] 1783 -
1784 [ 1828, 182 ] 1784 -
1785 [ 2125, 212 ] 1785 -
1786 [ 2226, 222 ] 1786 -
1787 [ 2323, 232 ] 1787 -
1788 [ NULL, NULL ] 1788 -
1789 [ 2476, 247 ] 1789 -
1790 #SELECT a+b*2+c*3+d*4, 1790 -
1791 # (a+b+c+d+e)/5 1791 -
1792 # FROM t1 1792 -
1793 # WHERE d NOT BETWEEN 110 AND 150 1793 -
1794 # AND (e>c OR e<d) 1794 -
1795 # AND d>e 1795 -
1796 # ORDER BY 1,2 1796 -
1797 #; 1797 -
1798 % sys., sys. # table_name 1798 -
1799 # sys.L1, sys.L2 # table_name 1799 -
1800 % L, L # name 1800 -
1801 # L1, L2 # name 1801 -
1802 % bigint, bigint # type 1802 -
1803 % 4, 3 # length 1803 -
1804 [ NULL, NULL ] 1804 -
1805 [ 1622, 162 ] 1805 -
1806 [ 1828, 182 ] 1806 -
1807 [ 2125, 212 ] 1807 -
1808 [ 2226, 222 ] 1808 -
1809 [ 2323, 232 ] 1809 -
1810 [ 2476, 247 ] 1810 -
1811 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 1811 -
1812 # a+b*2+c*3, 1812 -
1813 # b-c, 1813 -
1814 # b, 1814 -
1815 # abs(a), 1815 -
1816 # a-b 1816 -
1817 # FROM t1 1817 -
1818 # WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 1818 -
1819 # AND d NOT BETWEEN 110 AND 150 1819 -
1820 # AND a>b 1820 -
1821 #; 1821 -
1822 % ., sys., sys., sys.t1, sys., sys. # table_name 1822 -
1823 # .L3, sys.L4, sys.L5, sys.t1, sys.L6, sys.L7 # table_name 1823 -
1824 % L, L, L, b, L, L # name 1824 -
1825 # L3, L4, L5, b, L6, L7 # name 1825 -
1826 % bigint, bigint, bigint, int, int, bigint # type 1826 -
1827 % 2, 4, 2, 3, 3, 1 # length 1827 -
1828 [ 10, 966, -1, 160, 163, 3 ] 1828 -
1829 [ 12, 1030, -2, 170, 174, 4 ] 1829 -
1830 [ 14, 1096, -3, 181, 182, 1 ] 1830 -
1831 [ 15, 1121, -1, 186, 188, 2 ] 1831 -
1832 [ 17, 1180, 3, 198, 199, 1 ] 1832 -
1833 [ 19, 1277, -3, 211, 213, 2 ] 1833 -
1834 [ 22, 1360, 3, 228, 229, 1 ] 1834 -
1835 [ 23, 1391, 1, 232, 234, 2 ] 1835 -
1836 [ 24, NULL, NULL, 236, 239, 3 ] 1836 -
1837 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 1837 -
1838 # a+b*2+c*3, 1838 -
1839 # b-c, 1839 -
1840 # b, 1840 -
1841 # abs(a), 1841 -
1842 # a-b 1842 -
1843 # FROM t1 1843 -
1844 # WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 1844 -
1845 # AND d NOT BETWEEN 110 AND 150 1845 -
1846 # AND a>b 1846 -
1847 # ORDER BY 5,1,3,4,2,6 1847 -
1848 #; 1848 -
1849 % ., sys., sys., sys.t1, sys., sys. # table_name 1849 -
1850 # .L3, sys.L4, sys.L5, sys.t1, sys.L6, sys.L7 # table_name 1850 -
1851 % L, L, L, b, L, L # name 1851 -
1852 # L3, L4, L5, b, L6, L7 # name 1852 -
1853 % bigint, bigint, bigint, int, int, bigint # type 1853 -
1854 % 2, 4, 2, 3, 3, 1 # length 1854 -
1855 [ 10, 966, -1, 160, 163, 3 ] 1855 -
1856 [ 12, 1030, -2, 170, 174, 4 ] 1856 -
1857 [ 14, 1096, -3, 181, 182, 1 ] 1857 -
1858 [ 15, 1121, -1, 186, 188, 2 ] 1858 -
1859 [ 17, 1180, 3, 198, 199, 1 ] 1859 -
1860 [ 19, 1277, -3, 211, 213, 2 ] 1860 -
1861 [ 22, 1360, 3, 228, 229, 1 ] 1861 -
1862 [ 23, 1391, 1, 232, 234, 2 ] 1862 -
1863 [ 24, NULL, NULL, 236, 239, 3 ] 1863 -
1864 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 1864 -
1865 # a+b*2+c*3, 1865 -
1866 # b-c, 1866 -
1867 # b, 1867 -
1868 # abs(a), 1868 -
1869 # a-b 1869 -
1870 # FROM t1 1870 -
1871 # WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 1871 -
1872 # AND a>b 1872 -
1873 # AND d NOT BETWEEN 110 AND 150 1873 -
1874 #; 1874 -
1875 % ., sys., sys., sys.t1, sys., sys. # table_name 1875 -
1876 # .L3, sys.L4, sys.L5, sys.t1, sys.L6, sys.L7 # table_name 1876 -
1877 % L, L, L, b, L, L # name 1877 -
1878 # L3, L4, L5, b, L6, L7 # name 1878 -
1879 % bigint, bigint, bigint, int, int, bigint # type 1879 -
1880 % 2, 4, 2, 3, 3, 1 # length 1880 -
1881 [ 10, 966, -1, 160, 163, 3 ] 1881 -
1882 [ 12, 1030, -2, 170, 174, 4 ] 1882 -
1883 [ 14, 1096, -3, 181, 182, 1 ] 1883 -
1884 [ 15, 1121, -1, 186, 188, 2 ] 1884 -
1885 [ 17, 1180, 3, 198, 199, 1 ] 1885 -
1886 [ 19, 1277, -3, 211, 213, 2 ] 1886 -
1887 [ 22, 1360, 3, 228, 229, 1 ] 1887 -
1888 [ 23, 1391, 1, 232, 234, 2 ] 1888 -
1889 [ 24, NULL, NULL, 236, 239, 3 ] 1889 -
1890 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 1890 -
1891 # a+b*2+c*3, 1891 -
1892 # b-c, 1892 -
1893 # b, 1893 -
1894 # abs(a), 1894 -
1895 # a-b 1895 -
1896 # FROM t1 1896 -
1897 # WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 1897 -
1898 # AND a>b 1898 -
1899 # AND d NOT BETWEEN 110 AND 150 1899 -
1900 # ORDER BY 6,5,1,2,4 1900 -
1901 #; 1901 -
1902 % ., sys., sys., sys.t1, sys., sys. # table_name 1902 -
1903 # .L3, sys.L4, sys.L5, sys.t1, sys.L6, sys.L7 # table_name 1903 -
1904 % L, L, L, b, L, L # name 1904 -
1905 # L3, L4, L5, b, L6, L7 # name 1905 -
1906 % bigint, bigint, bigint, int, int, bigint # type 1906 -
1907 % 2, 4, 2, 3, 3, 1 # length 1907 -
1908 [ 14, 1096, -3, 181, 182, 1 ] 1908 -
1909 [ 17, 1180, 3, 198, 199, 1 ] 1909 -
1910 [ 22, 1360, 3, 228, 229, 1 ] 1910 -
1911 [ 15, 1121, -1, 186, 188, 2 ] 1911 -
1912 [ 19, 1277, -3, 211, 213, 2 ] 1912 -
1913 [ 23, 1391, 1, 232, 234, 2 ] 1913 -
1914 [ 10, 966, -1, 160, 163, 3 ] 1914 -
1915 [ 24, NULL, NULL, 236, 239, 3 ] 1915 -
1916 [ 12, 1030, -2, 170, 174, 4 ] 1916 -
1917 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 1917 -
1918 # a+b*2+c*3, 1918 -
1919 # b-c, 1919 -
1920 # b, 1920 -
1921 # abs(a), 1921 -
1922 # a-b 1922 -
1923 # FROM t1 1923 -
1924 # WHERE a>b 1924 -
1925 # AND d NOT BETWEEN 110 AND 150 1925 -
1926 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 1926 -
1927 #; 1927 -
1928 % ., sys., sys., sys.t1, sys., sys. # table_name 1928 -
1929 # .L3, sys.L4, sys.L5, sys.t1, sys.L6, sys.L7 # table_name 1929 -
1930 % L, L, L, b, L, L # name 1930 -
1931 # L3, L4, L5, b, L6, L7 # name 1931 -
1932 % bigint, bigint, bigint, int, int, bigint # type 1932 -
1933 % 2, 4, 2, 3, 3, 1 # length 1933 -
1934 [ 10, 966, -1, 160, 163, 3 ] 1934 -
1935 [ 12, 1030, -2, 170, 174, 4 ] 1935 -
1936 [ 14, 1096, -3, 181, 182, 1 ] 1936 -
1937 [ 15, 1121, -1, 186, 188, 2 ] 1937 -
1938 [ 17, 1180, 3, 198, 199, 1 ] 1938 -
1939 [ 19, 1277, -3, 211, 213, 2 ] 1939 -
1940 [ 22, 1360, 3, 228, 229, 1 ] 1940 -
1941 [ 23, 1391, 1, 232, 234, 2 ] 1941 -
1942 [ 24, NULL, NULL, 236, 239, 3 ] 1942 -
1943 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 1943 -
1944 # a+b*2+c*3, 1944 -
1945 # b-c, 1945 -
1946 # b, 1946 -
1947 # abs(a), 1947 -
1948 # a-b 1948 -
1949 # FROM t1 1949 -
1950 # WHERE a>b 1950 -
1951 # AND d NOT BETWEEN 110 AND 150 1951 -
1952 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 1952 -
1953 # ORDER BY 1,2,3,4,6 1953 -
1954 #; 1954 -
1955 % ., sys., sys., sys.t1, sys., sys. # table_name 1955 -
1956 # .L3, sys.L4, sys.L5, sys.t1, sys.L6, sys.L7 # table_name 1956 -
1957 % L, L, L, b, L, L # name 1957 -
1958 # L3, L4, L5, b, L6, L7 # name 1958 -
1959 % bigint, bigint, bigint, int, int, bigint # type 1959 -
1960 % 2, 4, 2, 3, 3, 1 # length 1960 -
1961 [ 10, 966, -1, 160, 163, 3 ] 1961 -
1962 [ 12, 1030, -2, 170, 174, 4 ] 1962 -
1963 [ 14, 1096, -3, 181, 182, 1 ] 1963 -
1964 [ 15, 1121, -1, 186, 188, 2 ] 1964 -
1965 [ 17, 1180, 3, 198, 199, 1 ] 1965 -
1966 [ 19, 1277, -3, 211, 213, 2 ] 1966 -
1967 [ 22, 1360, 3, 228, 229, 1 ] 1967 -
1968 [ 23, 1391, 1, 232, 234, 2 ] 1968 -
1969 [ 24, NULL, NULL, 236, 239, 3 ] 1969 -
1970 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 1970 -
1971 # a+b*2+c*3, 1971 -
1972 # b-c, 1972 -
1973 # b, 1973 -
1974 # abs(a), 1974 -
1975 # a-b 1975 -
1976 # FROM t1 1976 -
1977 # WHERE d NOT BETWEEN 110 AND 150 1977 -
1978 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 1978 -
1979 # AND a>b 1979 -
1980 #; 1980 -
1981 % ., sys., sys., sys.t1, sys., sys. # table_name 1981 -
1982 # .L3, sys.L4, sys.L5, sys.t1, sys.L6, sys.L7 # table_name 1982 -
1983 % L, L, L, b, L, L # name 1983 -
1984 # L3, L4, L5, b, L6, L7 # name 1984 -
1985 % bigint, bigint, bigint, int, int, bigint # type 1985 -
1986 % 2, 4, 2, 3, 3, 1 # length 1986 -
1987 [ 10, 966, -1, 160, 163, 3 ] 1987 -
1988 [ 12, 1030, -2, 170, 174, 4 ] 1988 -
1989 [ 14, 1096, -3, 181, 182, 1 ] 1989 -
1990 [ 15, 1121, -1, 186, 188, 2 ] 1990 -
1991 [ 17, 1180, 3, 198, 199, 1 ] 1991 -
1992 [ 19, 1277, -3, 211, 213, 2 ] 1992 -
1993 [ 22, 1360, 3, 228, 229, 1 ] 1993 -
1994 [ 23, 1391, 1, 232, 234, 2 ] 1994 -
1995 [ 24, NULL, NULL, 236, 239, 3 ] 1995 -
1996 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 1996 -
1997 # a+b*2+c*3, 1997 -
1998 # b-c, 1998 -
1999 # b, 1999 -
2000 # abs(a), 2000 -
2001 # a-b 2001 -
2002 # FROM t1 2002 -
2003 # WHERE d NOT BETWEEN 110 AND 150 2003 -
2004 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2004 -
2005 # AND a>b 2005 -
2006 # ORDER BY 4,3,1 2006 -
2007 #; 2007 -
2008 % ., sys., sys., sys.t1, sys., sys. # table_name 2008 -
2009 # .L3, sys.L4, sys.L5, sys.t1, sys.L6, sys.L7 # table_name 2009 -
2010 % L, L, L, b, L, L # name 2010 -
2011 # L3, L4, L5, b, L6, L7 # name 2011 -
2012 % bigint, bigint, bigint, int, int, bigint # type 2012 -
2013 % 2, 4, 2, 3, 3, 1 # length 2013 -
2014 [ 10, 966, -1, 160, 163, 3 ] 2014 -
2015 [ 12, 1030, -2, 170, 174, 4 ] 2015 -
2016 [ 14, 1096, -3, 181, 182, 1 ] 2016 -
2017 [ 15, 1121, -1, 186, 188, 2 ] 2017 -
2018 [ 17, 1180, 3, 198, 199, 1 ] 2018 -
2019 [ 19, 1277, -3, 211, 213, 2 ] 2019 -
2020 [ 22, 1360, 3, 228, 229, 1 ] 2020 -
2021 [ 23, 1391, 1, 232, 234, 2 ] 2021 -
2022 [ 24, NULL, NULL, 236, 239, 3 ] 2022 -
2023 #SELECT a-b, 2023 -
2024 # d, 2024 -
2025 # c-d, 2025 -
2026 # a+b*2+c*3+d*4, 2026 -
2027 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 2027 -
2028 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END 2028 -
2029 # FROM t1 2029 -
2030 # WHERE (e>c OR e<d) 2030 -
2031 # OR b>c 2031 -
2032 #; 2032 -
2033 % sys., sys.t1, sys., sys., sys. # table_name 2033 -
2034 # sys.L1, sys.t1, sys.L2, sys.L3, sys.L4 # table_name 2034 -
2035 % L, d, L, L, L # name 2035 -
2036 # L1, d, L2, L3, L4 # name 2036 -
2037 % bigint, int, bigint, bigint, smallint # type 2037 -
2038 % 2, 3, 2, 4, 3 # length 2038 -
2039 [ 2, 108, -2, 1067, 333 ] 2039 -
2040 [ NULL, 114, -1, NULL, 555 ] 2040 -
2041 [ -3, 122, 1, 1226, 333 ] 2041 -
2042 [ -2, 128, -3, 1272, 333 ] 2042 -
2043 [ 1, 133, 1, 1325, 444 ] 2043 -
2044 [ -1, 136, 1, 1371, 111 ] 2044 -
2045 [ -1, 140, 1, 1411, 111 ] 2045 -
2046 [ 2, NULL, NULL, NULL, 555 ] 2046 -
2047 [ 1, NULL, NULL, NULL, 555 ] 2047 -
2048 [ 3, 164, -3, 1622, 333 ] 2048 -
2049 [ 1, NULL, NULL, NULL, 555 ] 2049 -
2050 [ 4, 171, 1, 1714, 555 ] 2050 -
2051 [ 4, NULL, NULL, NULL, 555 ] 2051 -
2052 [ 1, 183, 1, 1828, 333 ] 2052 -
2053 [ 2, 185, 2, 1861, 444 ] 2053 -
2054 [ -3, 190, 3, 1918, 444 ] 2054 -
2055 [ 1, 196, -1, 1964, 555 ] 2055 -
2056 [ NULL, 203, -1, NULL, 222 ] 2056 -
2057 [ 2, 212, 2, 2125, 222 ] 2057 -
2058 [ -2, 217, -2, 2165, 333 ] 2058 -
2059 [ -3, 222, 2, 2226, 444 ] 2059 -
2060 [ 1, 226, -1, 2264, 555 ] 2060 -
2061 [ 2, 233, -2, 2323, 555 ] 2061 -
2062 [ 3, 238, NULL, NULL, 555 ] 2062 -
2063 [ -4, 248, -1, 2476, 444 ] 2063 -
2064 #SELECT a-b, 2064 -
2065 # d, 2065 -
2066 # c-d, 2066 -
2067 # a+b*2+c*3+d*4, 2067 -
2068 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 2068 -
2069 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END 2069 -
2070 # FROM t1 2070 -
2071 # WHERE (e>c OR e<d) 2071 -
2072 # OR b>c 2072 -
2073 # ORDER BY 3,5,1,2 2073 -
2074 #; 2074 -
2075 % sys., sys.t1, sys., sys., sys. # table_name 2075 -
2076 # sys.L1, sys.t1, sys.L2, sys.L3, sys.L4 # table_name 2076 -
2077 % L, d, L, L, L # name 2077 -
2078 # L1, d, L2, L3, L4 # name 2078 -
2079 % bigint, int, bigint, bigint, smallint # type 2079 -
2080 % 2, 3, 2, 4, 3 # length 2080 -
2081 [ 1, NULL, NULL, NULL, 555 ] 2081 -
2082 [ 1, NULL, NULL, NULL, 555 ] 2082 -
2083 [ 2, NULL, NULL, NULL, 555 ] 2083 -
2084 [ 3, 238, NULL, NULL, 555 ] 2084 -
2085 [ 4, NULL, NULL, NULL, 555 ] 2085 -
2086 [ -2, 128, -3, 1272, 333 ] 2086 -
2087 [ 3, 164, -3, 1622, 333 ] 2087 -
2088 [ -2, 217, -2, 2165, 333 ] 2088 -
2089 [ 2, 108, -2, 1067, 333 ] 2089 -
2090 [ 2, 233, -2, 2323, 555 ] 2090 -
2091 [ NULL, 203, -1, NULL, 222 ] 2091 -
2092 [ -4, 248, -1, 2476, 444 ] 2092 -
2093 [ NULL, 114, -1, NULL, 555 ] 2093 -
2094 [ 1, 196, -1, 1964, 555 ] 2094 -
2095 [ 1, 226, -1, 2264, 555 ] 2095 -
2096 [ -1, 136, 1, 1371, 111 ] 2096 -
2097 [ -1, 140, 1, 1411, 111 ] 2097 -
2098 [ -3, 122, 1, 1226, 333 ] 2098 -
2099 [ 1, 183, 1, 1828, 333 ] 2099 -
2100 [ 1, 133, 1, 1325, 444 ] 2100 -
2101 [ 4, 171, 1, 1714, 555 ] 2101 -
2102 [ 2, 212, 2, 2125, 222 ] 2102 -
2103 [ -3, 222, 2, 2226, 444 ] 2103 -
2104 [ 2, 185, 2, 1861, 444 ] 2104 -
2105 [ -3, 190, 3, 1918, 444 ] 2105 -
2106 #SELECT a-b, 2106 -
2107 # d, 2107 -
2108 # c-d, 2108 -
2109 # a+b*2+c*3+d*4, 2109 -
2110 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 2110 -
2111 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END 2111 -
2112 # FROM t1 2112 -
2113 # WHERE b>c 2113 -
2114 # OR (e>c OR e<d) 2114 -
2115 #; 2115 -
2116 % sys., sys.t1, sys., sys., sys. # table_name 2116 -
2117 # sys.L1, sys.t1, sys.L2, sys.L3, sys.L4 # table_name 2117 -
2118 % L, d, L, L, L # name 2118 -
2119 # L1, d, L2, L3, L4 # name 2119 -
2120 % bigint, int, bigint, bigint, smallint # type 2120 -
2121 % 2, 3, 2, 4, 3 # length 2121 -
2122 [ 2, 108, -2, 1067, 333 ] 2122 -
2123 [ NULL, 114, -1, NULL, 555 ] 2123 -
2124 [ -3, 122, 1, 1226, 333 ] 2124 -
2125 [ -2, 128, -3, 1272, 333 ] 2125 -
2126 [ 1, 133, 1, 1325, 444 ] 2126 -
2127 [ -1, 136, 1, 1371, 111 ] 2127 -
2128 [ -1, 140, 1, 1411, 111 ] 2128 -
2129 [ 2, NULL, NULL, NULL, 555 ] 2129 -
2130 [ 1, NULL, NULL, NULL, 555 ] 2130 -
2131 [ 3, 164, -3, 1622, 333 ] 2131 -
2132 [ 1, NULL, NULL, NULL, 555 ] 2132 -
2133 [ 4, 171, 1, 1714, 555 ] 2133 -
2134 [ 4, NULL, NULL, NULL, 555 ] 2134 -
2135 [ 1, 183, 1, 1828, 333 ] 2135 -
2136 [ 2, 185, 2, 1861, 444 ] 2136 -
2137 [ -3, 190, 3, 1918, 444 ] 2137 -
2138 [ 1, 196, -1, 1964, 555 ] 2138 -
2139 [ NULL, 203, -1, NULL, 222 ] 2139 -
2140 [ 2, 212, 2, 2125, 222 ] 2140 -
2141 [ -2, 217, -2, 2165, 333 ] 2141 -
2142 [ -3, 222, 2, 2226, 444 ] 2142 -
2143 [ 1, 226, -1, 2264, 555 ] 2143 -
2144 [ 2, 233, -2, 2323, 555 ] 2144 -
2145 [ 3, 238, NULL, NULL, 555 ] 2145 -
2146 [ -4, 248, -1, 2476, 444 ] 2146 -
2147 #SELECT a-b, 2147 -
2148 # d, 2148 -
2149 # c-d, 2149 -
2150 # a+b*2+c*3+d*4, 2150 -
2151 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 2151 -
2152 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END 2152 -
2153 # FROM t1 2153 -
2154 # WHERE b>c 2154 -
2155 # OR (e>c OR e<d) 2155 -
2156 # ORDER BY 5,1,3 2156 -
2157 #; 2157 -
2158 % sys., sys.t1, sys., sys., sys. # table_name 2158 -
2159 # sys.L1, sys.t1, sys.L2, sys.L3, sys.L4 # table_name 2159 -
2160 % L, d, L, L, L # name 2160 -
2161 # L1, d, L2, L3, L4 # name 2161 -
2162 % bigint, int, bigint, bigint, smallint # type 2162 -
2163 % 2, 3, 2, 4, 3 # length 2163 -
2164 [ -1, 136, 1, 1371, 111 ] 2164 -
2165 [ -1, 140, 1, 1411, 111 ] 2165 -
2166 [ NULL, 203, -1, NULL, 222 ] 2166 -
2167 [ 2, 212, 2, 2125, 222 ] 2167 -
2168 [ -3, 122, 1, 1226, 333 ] 2168 -
2169 [ -2, 128, -3, 1272, 333 ] 2169 -
2170 [ -2, 217, -2, 2165, 333 ] 2170 -
2171 [ 1, 183, 1, 1828, 333 ] 2171 -
2172 [ 2, 108, -2, 1067, 333 ] 2172 -
2173 [ 3, 164, -3, 1622, 333 ] 2173 -
2174 [ -4, 248, -1, 2476, 444 ] 2174 -
2175 [ -3, 222, 2, 2226, 444 ] 2175 -
2176 [ -3, 190, 3, 1918, 444 ] 2176 -
2177 [ 1, 133, 1, 1325, 444 ] 2177 -
2178 [ 2, 185, 2, 1861, 444 ] 2178 -
2179 [ NULL, 114, -1, NULL, 555 ] 2179 -
2180 [ 1, NULL, NULL, NULL, 555 ] 2180 -
2181 [ 1, NULL, NULL, NULL, 555 ] 2181 -
2182 [ 1, 196, -1, 1964, 555 ] 2182 -
2183 [ 1, 226, -1, 2264, 555 ] 2183 -
2184 [ 2, NULL, NULL, NULL, 555 ] 2184 -
2185 [ 2, 233, -2, 2323, 555 ] 2185 -
2186 [ 3, 238, NULL, NULL, 555 ] 2186 -
2187 [ 4, NULL, NULL, NULL, 555 ] 2187 -
2188 [ 4, 171, 1, 1714, 555 ] 2188 -
2189 #SELECT d-e, 2189 -
2190 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 2190 -
2191 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 2191 -
2192 # a+b*2, 2192 -
2193 # a+b*2+c*3+d*4, 2193 -
2194 # b-c 2194 -
2195 # FROM t1 2195 -
2196 # WHERE (c<=d-2 OR c>=d+2) 2196 -
2197 #; 2197 -
2198 % sys., sys., sys., sys., sys. # table_name 2198 -
2199 # sys.L1, sys.L2, sys.L3, sys.L4, sys.L5 # table_name 2199 -
2200 % L, L, L, L, L # name 2200 -
2201 # L1, L2, L3, L4, L5 # name 2201 -
2202 % bigint, smallint, bigint, bigint, bigint # type 2202 -
2203 % 2, 3, 3, 4, 2 # length 2203 -
2204 [ -1, 333, 317, 1067, -1 ] 2204 -
2205 [ -1, 333, NULL, NULL, NULL ] 2205 -
2206 [ 2, 333, 385, 1272, 4 ] 2206 -
2207 [ 2, 333, 483, 1622, -1 ] 2207 -
2208 [ -4, 444, 560, 1861, -1 ] 2208 -
2209 [ -2, 444, 579, 1918, 1 ] 2209 -
2210 [ 2, 222, 635, 2125, -3 ] 2210 -
2211 [ -2, 333, 652, 2165, 3 ] 2211 -
2212 [ 1, 444, 666, 2226, -1 ] 2212 -
2213 [ 3, 555, 698, 2323, 1 ] 2213 -
2214 #SELECT d-e, 2214 -
2215 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 2215 -
2216 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 2216 -
2217 # a+b*2, 2217 -
2218 # a+b*2+c*3+d*4, 2218 -
2219 # b-c 2219 -
2220 # FROM t1 2220 -
2221 # WHERE (c<=d-2 OR c>=d+2) 2221 -
2222 # ORDER BY 3,1,4 2222 -
2223 #; 2223 -
2224 % sys., sys., sys., sys., sys. # table_name 2224 -
2225 # sys.L1, sys.L2, sys.L3, sys.L4, sys.L5 # table_name 2225 -
2226 % L, L, L, L, L # name 2226 -
2227 # L1, L2, L3, L4, L5 # name 2227 -
2228 % bigint, smallint, bigint, bigint, bigint # type 2228 -
2229 % 2, 3, 3, 4, 2 # length 2229 -
2230 [ -1, 333, NULL, NULL, NULL ] 2230 -
2231 [ -1, 333, 317, 1067, -1 ] 2231 -
2232 [ 2, 333, 385, 1272, 4 ] 2232 -
2233 [ 2, 333, 483, 1622, -1 ] 2233 -
2234 [ -4, 444, 560, 1861, -1 ] 2234 -
2235 [ -2, 444, 579, 1918, 1 ] 2235 -
2236 [ 2, 222, 635, 2125, -3 ] 2236 -
2237 [ -2, 333, 652, 2165, 3 ] 2237 -
2238 [ 1, 444, 666, 2226, -1 ] 2238 -
2239 [ 3, 555, 698, 2323, 1 ] 2239 -
2240 #SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 2240 -
2241 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 2241 -
2242 # abs(b-c) 2242 -
2243 # FROM t1 2243 -
2244 #; 2244 -
2245 % sys., ., sys. # table_name 2245 -
2246 # sys.L3, .L5, sys.L6 # table_name 2246 -
2247 % L, L, L # name 2247 -
2248 # L3, L5, L6 # name 2248 -
2249 % bigint, bigint, bigint # type 2249 -
2250 % 4, 2, 1 # length 2250 -
2251 [ 1120, 1, 1 ] 2251 -
2252 [ NULL, 0, NULL ] 2252 -
2253 [ 1050, 0, 1 ] 2253 -
2254 [ 1240, 2, 1 ] 2254 -
2255 [ 1290, 3, 4 ] 2255 -
2256 [ NULL, 0, NULL ] 2256 -
2257 [ 1300, 4, 4 ] 2257 -
2258 [ 1390, 5, 2 ] 2258 -
2259 [ 1430, 6, 2 ] 2259 -
2260 [ 1450, 7, 2 ] 2260 -
2261 [ 1510, 8, 1 ] 2261 -
2262 [ 1580, 9, 3 ] 2262 -
2263 [ 1600, 10, 1 ] 2263 -
2264 [ 1670, 11, 1 ] 2264 -
2265 [ 1700, 12, 2 ] 2265 -
2266 [ 358, 13, 1 ] 2266 -
2267 [ 364, 14, 3 ] 2267 -
2268 [ 376, 15, 1 ] 2268 -
2269 [ 382, 16, 1 ] 2269 -
2270 [ 398, 17, 3 ] 2270 -
2271 [ 402, 0, NULL ] 2271 -
2272 [ NULL, 18, 2 ] 2272 -
2273 [ 426, 19, 3 ] 2273 -
2274 [ 432, 20, 3 ] 2274 -
2275 [ 440, 21, 1 ] 2275 -
2276 [ 458, 22, 3 ] 2276 -
2277 [ 468, 23, 1 ] 2277 -
2278 [ 2360, 24, NULL ] 2278 -
2279 [ 486, 25, 4 ] 2279 -
2280 [ 490, 26, 2 ] 2280 -
2281 #SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 2281 -
2282 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 2282 -
2283 # abs(b-c) 2283 -
2284 # FROM t1 2284 -
2285 # ORDER BY 3,2,1 2285 -
2286 #; 2286 -
2287 % sys., ., sys. # table_name 2287 -
2288 # sys.L3, .L5, sys.L6 # table_name 2288 -
2289 % L, L, L # name 2289 -
2290 # L3, L5, L6 # name 2290 -
2291 % bigint, bigint, bigint # type 2291 -
2292 % 4, 2, 1 # length 2292 -
2293 [ NULL, 0, NULL ] 2293 -
2294 [ NULL, 0, NULL ] 2294 -
2295 [ 402, 0, NULL ] 2295 -
2296 [ 2360, 24, NULL ] 2296 -
2297 [ 1050, 0, 1 ] 2297 -
2298 [ 1120, 1, 1 ] 2298 -
2299 [ 1240, 2, 1 ] 2299 -
2300 [ 1510, 8, 1 ] 2300 -
2301 [ 1600, 10, 1 ] 2301 -
2302 [ 1670, 11, 1 ] 2302 -
2303 [ 358, 13, 1 ] 2303 -
2304 [ 376, 15, 1 ] 2304 -
2305 [ 382, 16, 1 ] 2305 -
2306 [ 440, 21, 1 ] 2306 -
2307 [ 468, 23, 1 ] 2307 -
2308 [ 1390, 5, 2 ] 2308 -
2309 [ 1430, 6, 2 ] 2309 -
2310 [ 1450, 7, 2 ] 2310 -
2311 [ 1700, 12, 2 ] 2311 -
2312 [ NULL, 18, 2 ] 2312 -
2313 [ 490, 26, 2 ] 2313 -
2314 [ 1580, 9, 3 ] 2314 -
2315 [ 364, 14, 3 ] 2315 -
2316 [ 398, 17, 3 ] 2316 -
2317 [ 426, 19, 3 ] 2317 -
2318 [ 432, 20, 3 ] 2318 -
2319 [ 458, 22, 3 ] 2319 -
2320 [ 1290, 3, 4 ] 2320 -
2321 [ 1300, 4, 4 ] 2321 -
2322 [ 486, 25, 4 ] 2322 -
2323 #SELECT a-b, 2323 -
2324 # a+b*2+c*3+d*4+e*5, 2324 -
2325 # b, 2325 -
2326 # abs(a), 2326 -
2327 # a 2327 -
2328 # FROM t1 2328 -
2329 # WHERE e+d BETWEEN a+b-10 AND c+130 2329 -
2330 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2330 -
2331 # AND b>c 2331 -
2332 #; 2332 -
2333 % sys., sys., sys.t1, sys., sys.t1 # table_name 2333 -
2334 # sys.L2, sys.L3, sys.t1, sys.L4, sys.t1 # table_name 2334 -
2335 % L, L, b, L, a # name 2335 -
2336 # L2, L3, b, L4, a # name 2336 -
2337 % bigint, bigint, int, int, int # type 2337 -
2338 % 2, 4, 3, 3, 3 # length 2338 -
2339 [ -2, 1902, 129, 127, 127 ] 2339 -
2340 #SELECT a-b, 2340 -
2341 # a+b*2+c*3+d*4+e*5, 2341 -
2342 # b, 2342 -
2343 # abs(a), 2343 -
2344 # a 2344 -
2345 # FROM t1 2345 -
2346 # WHERE e+d BETWEEN a+b-10 AND c+130 2346 -
2347 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2347 -
2348 # AND b>c 2348 -
2349 # ORDER BY 3,2,4,5 2349 -
2350 #; 2350 -
2351 % sys., sys., sys.t1, sys., sys.t1 # table_name 2351 -
2352 # sys.L2, sys.L3, sys.t1, sys.L4, sys.t1 # table_name 2352 -
2353 % L, L, b, L, a # name 2353 -
2354 # L2, L3, b, L4, a # name 2354 -
2355 % bigint, bigint, int, int, int # type 2355 -
2356 % 2, 4, 3, 3, 3 # length 2356 -
2357 [ -2, 1902, 129, 127, 127 ] 2357 -
2358 #SELECT a-b, 2358 -
2359 # a+b*2+c*3+d*4+e*5, 2359 -
2360 # b, 2360 -
2361 # abs(a), 2361 -
2362 # a 2362 -
2363 # FROM t1 2363 -
2364 # WHERE b>c 2364 -
2365 # AND e+d BETWEEN a+b-10 AND c+130 2365 -
2366 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2366 -
2367 #; 2367 -
2368 % sys., sys., sys.t1, sys., sys.t1 # table_name 2368 -
2369 # sys.L2, sys.L3, sys.t1, sys.L4, sys.t1 # table_name 2369 -
2370 % L, L, b, L, a # name 2370 -
2371 # L2, L3, b, L4, a # name 2371 -
2372 % bigint, bigint, int, int, int # type 2372 -
2373 % 2, 4, 3, 3, 3 # length 2373 -
2374 [ -2, 1902, 129, 127, 127 ] 2374 -
2375 #SELECT a-b, 2375 -
2376 # a+b*2+c*3+d*4+e*5, 2376 -
2377 # b, 2377 -
2378 # abs(a), 2378 -
2379 # a 2379 -
2380 # FROM t1 2380 -
2381 # WHERE b>c 2381 -
2382 # AND e+d BETWEEN a+b-10 AND c+130 2382 -
2383 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2383 -
2384 # ORDER BY 1,2,4 2384 -
2385 #; 2385 -
2386 % sys., sys., sys.t1, sys., sys.t1 # table_name 2386 -
2387 # sys.L2, sys.L3, sys.t1, sys.L4, sys.t1 # table_name 2387 -
2388 % L, L, b, L, a # name 2388 -
2389 # L2, L3, b, L4, a # name 2389 -
2390 % bigint, bigint, int, int, int # type 2390 -
2391 % 2, 4, 3, 3, 3 # length 2391 -
2392 [ -2, 1902, 129, 127, 127 ] 2392 -
2393 #SELECT a-b, 2393 -
2394 # a+b*2+c*3+d*4+e*5, 2394 -
2395 # b, 2395 -
2396 # abs(a), 2396 -
2397 # a 2397 -
2398 # FROM t1 2398 -
2399 # WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2399 -
2400 # AND b>c 2400 -
2401 # AND e+d BETWEEN a+b-10 AND c+130 2401 -
2402 #; 2402 -
2403 % sys., sys., sys.t1, sys., sys.t1 # table_name 2403 -
2404 # sys.L2, sys.L3, sys.t1, sys.L4, sys.t1 # table_name 2404 -
2405 % L, L, b, L, a # name 2405 -
2406 # L2, L3, b, L4, a # name 2406 -
2407 % bigint, bigint, int, int, int # type 2407 -
2408 % 2, 4, 3, 3, 3 # length 2408 -
2409 [ -2, 1902, 129, 127, 127 ] 2409 -
2410 #SELECT a-b, 2410 -
2411 # a+b*2+c*3+d*4+e*5, 2411 -
2412 # b, 2412 -
2413 # abs(a), 2413 -
2414 # a 2414 -
2415 # FROM t1 2415 -
2416 # WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2416 -
2417 # AND b>c 2417 -
2418 # AND e+d BETWEEN a+b-10 AND c+130 2418 -
2419 # ORDER BY 5,1,4,3,2 2419 -
2420 #; 2420 -
2421 % sys., sys., sys.t1, sys., sys.t1 # table_name 2421 -
2422 # sys.L2, sys.L3, sys.t1, sys.L4, sys.t1 # table_name 2422 -
2423 % L, L, b, L, a # name 2423 -
2424 # L2, L3, b, L4, a # name 2424 -
2425 % bigint, bigint, int, int, int # type 2425 -
2426 % 2, 4, 3, 3, 3 # length 2426 -
2427 [ -2, 1902, 129, 127, 127 ] 2427 -
2428 #SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 2428 -
2429 # b, 2429 -
2430 # c, 2430 -
2431 # a+b*2+c*3, 2431 -
2432 # a+b*2+c*3+d*4, 2432 -
2433 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 2433 -
2434 # e 2434 -
2435 # FROM t1 2435 -
2436 # WHERE d>e 2436 -
2437 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2437 -
2438 # AND d NOT BETWEEN 110 AND 150 2438 -
2439 #; 2439 -
2440 % sys., sys.t1, sys.t1, sys., sys., ., sys.t1 # table_name 2440 -
2441 # sys.L4, sys.t1, sys.t1, sys.L5, sys.L6, .L10, sys.t1 # table_name 2441 -
2442 % L, b, c, L, L, L, e # name 2442 -
2443 # L4, b, c, L5, L6, L10, e # name 2443 -
2444 % bigint, int, int, bigint, bigint, bigint, int # type 2444 -
2445 % 4, 3, 3, 4, 4, 2, 3 # length 2445 -
2446 [ 1600, 160, 161, 966, 1622, 10, 162 ] 2446 -
2447 [ 364, 181, 184, 1096, 1828, 14, 180 ] 2447 -
2448 [ 426, 211, 214, 1277, 2125, 19, 210 ] 2448 -
2449 [ 440, 223, 224, 1338, 2226, 21, 221 ] 2449 -
2450 [ 468, 232, 231, 1391, 2323, 23, 230 ] 2450 -
2451 [ 2360, 236, NULL, NULL, NULL, 24, 237 ] 2451 -
2452 [ 490, 249, 247, 1484, 2476, 26, 246 ] 2452 -
2453 #SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 2453 -
2454 # b, 2454 -
2455 # c, 2455 -
2456 # a+b*2+c*3, 2456 -
2457 # a+b*2+c*3+d*4, 2457 -
2458 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 2458 -
2459 # e 2459 -
2460 # FROM t1 2460 -
2461 # WHERE d>e 2461 -
2462 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2462 -
2463 # AND d NOT BETWEEN 110 AND 150 2463 -
2464 # ORDER BY 2,5,4,7,1,3 2464 -
2465 #; 2465 -
2466 % sys., sys.t1, sys.t1, sys., sys., ., sys.t1 # table_name 2466 -
2467 # sys.L4, sys.t1, sys.t1, sys.L5, sys.L6, .L10, sys.t1 # table_name 2467 -
2468 % L, b, c, L, L, L, e # name 2468 -
2469 # L4, b, c, L5, L6, L10, e # name 2469 -
2470 % bigint, int, int, bigint, bigint, bigint, int # type 2470 -
2471 % 4, 3, 3, 4, 4, 2, 3 # length 2471 -
2472 [ 1600, 160, 161, 966, 1622, 10, 162 ] 2472 -
2473 [ 364, 181, 184, 1096, 1828, 14, 180 ] 2473 -
2474 [ 426, 211, 214, 1277, 2125, 19, 210 ] 2474 -
2475 [ 440, 223, 224, 1338, 2226, 21, 221 ] 2475 -
2476 [ 468, 232, 231, 1391, 2323, 23, 230 ] 2476 -
2477 [ 2360, 236, NULL, NULL, NULL, 24, 237 ] 2477 -
2478 [ 490, 249, 247, 1484, 2476, 26, 246 ] 2478 -
2479 #SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 2479 -
2480 # b, 2480 -
2481 # c, 2481 -
2482 # a+b*2+c*3, 2482 -
2483 # a+b*2+c*3+d*4, 2483 -
2484 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 2484 -
2485 # e 2485 -
2486 # FROM t1 2486 -
2487 # WHERE d NOT BETWEEN 110 AND 150 2487 -
2488 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2488 -
2489 # AND d>e 2489 -
2490 #; 2490 -
2491 % sys., sys.t1, sys.t1, sys., sys., ., sys.t1 # table_name 2491 -
2492 # sys.L4, sys.t1, sys.t1, sys.L5, sys.L6, .L10, sys.t1 # table_name 2492 -
2493 % L, b, c, L, L, L, e # name 2493 -
2494 # L4, b, c, L5, L6, L10, e # name 2494 -
2495 % bigint, int, int, bigint, bigint, bigint, int # type 2495 -
2496 % 4, 3, 3, 4, 4, 2, 3 # length 2496 -
2497 [ 1600, 160, 161, 966, 1622, 10, 162 ] 2497 -
2498 [ 364, 181, 184, 1096, 1828, 14, 180 ] 2498 -
2499 [ 426, 211, 214, 1277, 2125, 19, 210 ] 2499 -
2500 [ 440, 223, 224, 1338, 2226, 21, 221 ] 2500 -
2501 [ 468, 232, 231, 1391, 2323, 23, 230 ] 2501 -
2502 [ 2360, 236, NULL, NULL, NULL, 24, 237 ] 2502 -
2503 [ 490, 249, 247, 1484, 2476, 26, 246 ] 2503 -
2504 #SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 2504 -
2505 # b, 2505 -
2506 # c, 2506 -
2507 # a+b*2+c*3, 2507 -
2508 # a+b*2+c*3+d*4, 2508 -
2509 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 2509 -
2510 # e 2510 -
2511 # FROM t1 2511 -
2512 # WHERE d NOT BETWEEN 110 AND 150 2512 -
2513 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2513 -
2514 # AND d>e 2514 -
2515 # ORDER BY 4,3,1 2515 -
2516 #; 2516 -
2517 % sys., sys.t1, sys.t1, sys., sys., ., sys.t1 # table_name 2517 -
2518 # sys.L4, sys.t1, sys.t1, sys.L5, sys.L6, .L10, sys.t1 # table_name 2518 -
2519 % L, b, c, L, L, L, e # name 2519 -
2520 # L4, b, c, L5, L6, L10, e # name 2520 -
2521 % bigint, int, int, bigint, bigint, bigint, int # type 2521 -
2522 % 4, 3, 3, 4, 4, 2, 3 # length 2522 -
2523 [ 2360, 236, NULL, NULL, NULL, 24, 237 ] 2523 -
2524 [ 1600, 160, 161, 966, 1622, 10, 162 ] 2524 -
2525 [ 364, 181, 184, 1096, 1828, 14, 180 ] 2525 -
2526 [ 426, 211, 214, 1277, 2125, 19, 210 ] 2526 -
2527 [ 440, 223, 224, 1338, 2226, 21, 221 ] 2527 -
2528 [ 468, 232, 231, 1391, 2323, 23, 230 ] 2528 -
2529 [ 490, 249, 247, 1484, 2476, 26, 246 ] 2529 -
2530 #SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 2530 -
2531 # b, 2531 -
2532 # c, 2532 -
2533 # a+b*2+c*3, 2533 -
2534 # a+b*2+c*3+d*4, 2534 -
2535 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 2535 -
2536 # e 2536 -
2537 # FROM t1 2537 -
2538 # WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2538 -
2539 # AND d NOT BETWEEN 110 AND 150 2539 -
2540 # AND d>e 2540 -
2541 #; 2541 -
2542 % sys., sys.t1, sys.t1, sys., sys., ., sys.t1 # table_name 2542 -
2543 # sys.L4, sys.t1, sys.t1, sys.L5, sys.L6, .L10, sys.t1 # table_name 2543 -
2544 % L, b, c, L, L, L, e # name 2544 -
2545 # L4, b, c, L5, L6, L10, e # name 2545 -
2546 % bigint, int, int, bigint, bigint, bigint, int # type 2546 -
2547 % 4, 3, 3, 4, 4, 2, 3 # length 2547 -
2548 [ 1600, 160, 161, 966, 1622, 10, 162 ] 2548 -
2549 [ 364, 181, 184, 1096, 1828, 14, 180 ] 2549 -
2550 [ 426, 211, 214, 1277, 2125, 19, 210 ] 2550 -
2551 [ 440, 223, 224, 1338, 2226, 21, 221 ] 2551 -
2552 [ 468, 232, 231, 1391, 2323, 23, 230 ] 2552 -
2553 [ 2360, 236, NULL, NULL, NULL, 24, 237 ] 2553 -
2554 [ 490, 249, 247, 1484, 2476, 26, 246 ] 2554 -
2555 #SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 2555 -
2556 # b, 2556 -
2557 # c, 2557 -
2558 # a+b*2+c*3, 2558 -
2559 # a+b*2+c*3+d*4, 2559 -
2560 # (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), 2560 -
2561 # e 2561 -
2562 # FROM t1 2562 -
2563 # WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2563 -
2564 # AND d NOT BETWEEN 110 AND 150 2564 -
2565 # AND d>e 2565 -
2566 # ORDER BY 5,4,2 2566 -
2567 #; 2567 -
2568 % sys., sys.t1, sys.t1, sys., sys., ., sys.t1 # table_name 2568 -
2569 # sys.L4, sys.t1, sys.t1, sys.L5, sys.L6, .L10, sys.t1 # table_name 2569 -
2570 % L, b, c, L, L, L, e # name 2570 -
2571 # L4, b, c, L5, L6, L10, e # name 2571 -
2572 % bigint, int, int, bigint, bigint, bigint, int # type 2572 -
2573 % 4, 3, 3, 4, 4, 2, 3 # length 2573 -
2574 [ 2360, 236, NULL, NULL, NULL, 24, 237 ] 2574 -
2575 [ 1600, 160, 161, 966, 1622, 10, 162 ] 2575 -
2576 [ 364, 181, 184, 1096, 1828, 14, 180 ] 2576 -
2577 [ 426, 211, 214, 1277, 2125, 19, 210 ] 2577 -
2578 [ 440, 223, 224, 1338, 2226, 21, 221 ] 2578 -
2579 [ 468, 232, 231, 1391, 2323, 23, 230 ] 2579 -
2580 [ 490, 249, 247, 1484, 2476, 26, 246 ] 2580 -
2581 #SELECT a, 2581 -
2582 # (a+b+c+d+e)/5, 2582 -
2583 # b 2583 -
2584 # FROM t1 2584 -
2585 # WHERE c>d 2585 -
2586 # AND (e>c OR e<d) 2586 -
2587 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2587 -
2588 #; 2588 -
2589 % sys.t1, sys., sys.t1 # table_name 2589 -
2590 # sys.t1, sys.L2, sys.t1 # table_name 2590 -
2591 % a, L, b # name 2591 -
2592 # a, L2, b # name 2592 -
2593 % int, bigint, int # type 2593 -
2594 % 3, 3, 3 # length 2594 -
2595 [ 131, 132, 130 ] 2595 -
2596 [ 138, 137, 139 ] 2596 -
2597 [ 142, 142, 143 ] 2597 -
2598 [ 174, 172, 170 ] 2598 -
2599 [ 182, 182, 181 ] 2599 -
2600 [ 188, 187, 186 ] 2600 -
2601 [ 213, 212, 211 ] 2601 -
2602 [ 220, 222, 223 ] 2602 -
2603 #SELECT a, 2603 -
2604 # (a+b+c+d+e)/5, 2604 -
2605 # b 2605 -
2606 # FROM t1 2606 -
2607 # WHERE c>d 2607 -
2608 # AND (e>c OR e<d) 2608 -
2609 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2609 -
2610 # ORDER BY 1,3 2610 -
2611 #; 2611 -
2612 % sys.t1, sys., sys.t1 # table_name 2612 -
2613 # sys.t1, sys.L2, sys.t1 # table_name 2613 -
2614 % a, L, b # name 2614 -
2615 # a, L2, b # name 2615 -
2616 % int, bigint, int # type 2616 -
2617 % 3, 3, 3 # length 2617 -
2618 [ 131, 132, 130 ] 2618 -
2619 [ 138, 137, 139 ] 2619 -
2620 [ 142, 142, 143 ] 2620 -
2621 [ 174, 172, 170 ] 2621 -
2622 [ 182, 182, 181 ] 2622 -
2623 [ 188, 187, 186 ] 2623 -
2624 [ 213, 212, 211 ] 2624 -
2625 [ 220, 222, 223 ] 2625 -
2626 #SELECT a, 2626 -
2627 # (a+b+c+d+e)/5, 2627 -
2628 # b 2628 -
2629 # FROM t1 2629 -
2630 # WHERE (e>c OR e<d) 2630 -
2631 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2631 -
2632 # AND c>d 2632 -
2633 #; 2633 -
2634 % sys.t1, sys., sys.t1 # table_name 2634 -
2635 # sys.t1, sys.L2, sys.t1 # table_name 2635 -
2636 % a, L, b # name 2636 -
2637 # a, L2, b # name 2637 -
2638 % int, bigint, int # type 2638 -
2639 % 3, 3, 3 # length 2639 -
2640 [ 131, 132, 130 ] 2640 -
2641 [ 138, 137, 139 ] 2641 -
2642 [ 142, 142, 143 ] 2642 -
2643 [ 174, 172, 170 ] 2643 -
2644 [ 182, 182, 181 ] 2644 -
2645 [ 188, 187, 186 ] 2645 -
2646 [ 213, 212, 211 ] 2646 -
2647 [ 220, 222, 223 ] 2647 -
2648 #SELECT a, 2648 -
2649 # (a+b+c+d+e)/5, 2649 -
2650 # b 2650 -
2651 # FROM t1 2651 -
2652 # WHERE (e>c OR e<d) 2652 -
2653 # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2653 -
2654 # AND c>d 2654 -
2655 # ORDER BY 3,1,2 2655 -
2656 #; 2656 -
2657 % sys.t1, sys., sys.t1 # table_name 2657 -
2658 # sys.t1, sys.L2, sys.t1 # table_name 2658 -
2659 % a, L, b # name 2659 -
2660 # a, L2, b # name 2660 -
2661 % int, bigint, int # type 2661 -
2662 % 3, 3, 3 # length 2662 -
2663 [ 131, 132, 130 ] 2663 -
2664 [ 138, 137, 139 ] 2664 -
2665 [ 142, 142, 143 ] 2665 -
2666 [ 174, 172, 170 ] 2666 -
2667 [ 182, 182, 181 ] 2667 -
2668 [ 188, 187, 186 ] 2668 -
2669 [ 213, 212, 211 ] 2669 -
2670 [ 220, 222, 223 ] 2670 -
2671 #SELECT a, 2671 -
2672 # (a+b+c+d+e)/5, 2672 -
2673 # b 2673 -
2674 # FROM t1 2674 -
2675 # WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2675 -
2676 # AND c>d 2676 -
2677 # AND (e>c OR e<d) 2677 -
2678 #; 2678 -
2679 % sys.t1, sys., sys.t1 # table_name 2679 -
2680 # sys.t1, sys.L2, sys.t1 # table_name 2680 -
2681 % a, L, b # name 2681 -
2682 # a, L2, b # name 2682 -
2683 % int, bigint, int # type 2683 -
2684 % 3, 3, 3 # length 2684 -
2685 [ 131, 132, 130 ] 2685 -
2686 [ 138, 137, 139 ] 2686 -
2687 [ 142, 142, 143 ] 2687 -
2688 [ 174, 172, 170 ] 2688 -
2689 [ 182, 182, 181 ] 2689 -
2690 [ 188, 187, 186 ] 2690 -
2691 [ 213, 212, 211 ] 2691 -
2692 [ 220, 222, 223 ] 2692 -
2693 #SELECT a, 2693 -
2694 # (a+b+c+d+e)/5, 2694 -
2695 # b 2695 -
2696 # FROM t1 2696 -
2697 # WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2697 -
2698 # AND c>d 2698 -
2699 # AND (e>c OR e<d) 2699 -
2700 # ORDER BY 2,1 2700 -
2701 #; 2701 -
2702 % sys.t1, sys., sys.t1 # table_name 2702 -
2703 # sys.t1, sys.L2, sys.t1 # table_name 2703 -
2704 % a, L, b # name 2704 -
2705 # a, L2, b # name 2705 -
2706 % int, bigint, int # type 2706 -
2707 % 3, 3, 3 # length 2707 -
2708 [ 131, 132, 130 ] 2708 -
2709 [ 138, 137, 139 ] 2709 -
2710 [ 142, 142, 143 ] 2710 -
2711 [ 174, 172, 170 ] 2711 -
2712 [ 182, 182, 181 ] 2712 -
2713 [ 188, 187, 186 ] 2713 -
2714 [ 213, 212, 211 ] 2714 -
2715 [ 220, 222, 223 ] 2715 -
2716 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d), 2716 -
2717 # a+b*2+c*3+d*4, 2717 -
2718 # d-e, 2718 -
2719 # e, 2719 -
2720 # CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 2720 -
2721 # abs(b-c), 2721 -
2722 # a+b*2+c*3 2722 -
2723 # FROM t1 2723 -
2724 # WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2724 -
2725 # OR b>c 2725 -
2726 #; 2726 -
2727 % ., ., ., .t1, ., ., . # table_name 2727 -
2728 # .L10, .L11, .L12, .t1, .L15, .L16, .L17 # table_name 2728 -
2729 % L, L, L, e, L, L, L # name 2729 -
2730 # L10, L11, L12, e, L15, L16, L17 # name 2730 -
2731 % bigint, bigint, bigint, int, bigint, bigint, bigint # type 2731 -
2732 % 1, 4, 2, 3, 4, 1, 4 # length 2732 -
2733 [ 0, NULL, 4, 110, 1120, 1, NULL ] 2733 -
2734 [ 0, 1226, NULL, NULL, 1240, 1, 738 ] 2734 -
2735 [ 0, 1272, 2, 126, 1290, 4, 760 ] 2735 -
2736 [ 0, 1325, 1, 132, 1300, 4, 793 ] 2736 -
2737 [ 0, 1371, 1, 135, 1390, 2, 827 ] 2737 -
2738 [ 0, 1411, -4, 144, 1430, 2, 851 ] 2738 -
2739 [ 0, NULL, NULL, 146, 1450, 2, 880 ] 2739 -
2740 [ 0, NULL, NULL, NULL, 1510, 1, 905 ] 2740 -
2741 [ 0, NULL, NULL, 157, 1580, 3, 940 ] 2741 -
2742 [ 0, 1622, 2, 162, 1600, 1, 966 ] 2742 -
2743 [ 0, NULL, NULL, 165, 1670, 1, 1000 ] 2743 -
2744 [ 0, 1714, -2, 173, 1700, 2, 1030 ] 2744 -
2745 [ 0, NULL, NULL, 177, 358, 1, 1057 ] 2745 -
2746 [ 0, 1828, 3, 180, 364, 3, 1096 ] 2746 -
2747 [ 0, 1861, -4, 189, 376, 1, 1121 ] 2747 -
2748 [ 0, 1918, -2, 192, 382, 1, 1158 ] 2748 -
2749 [ 0, 1964, -1, 197, 398, 3, 1180 ] 2749 -
2750 [ 0, NULL, NULL, NULL, NULL, 2, NULL ] 2750 -
2751 [ 0, 2125, 2, 210, 426, 3, 1277 ] 2751 -
2752 [ 0, 2165, -2, 219, 432, 3, 1297 ] 2752 -
2753 [ 0, 2226, 1, 221, 440, 1, 1338 ] 2753 -
2754 [ 0, 2264, -1, 227, 458, 3, 1360 ] 2754 -
2755 [ 0, 2323, 3, 230, 468, 1, 1391 ] 2755 -
2756 [ 0, NULL, 1, 237, 2360, NULL, NULL ] 2756 -
2757 [ 0, NULL, NULL, NULL, 486, 4, 1455 ] 2757 -
2758 [ 0, 2476, 2, 246, 490, 2, 1484 ] 2758 -
2759 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d), 2759 -
2760 # a+b*2+c*3+d*4, 2760 -
2761 # d-e, 2761 -
2762 # e, 2762 -
2763 # CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 2763 -
2764 # abs(b-c), 2764 -
2765 # a+b*2+c*3 2765 -
2766 # FROM t1 2766 -
2767 # WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2767 -
2768 # OR b>c 2768 -
2769 # ORDER BY 7,5,6 2769 -
2770 #; 2770 -
2771 % ., ., ., .t1, ., ., . # table_name 2771 -
2772 # .L10, .L11, .L12, .t1, .L15, .L16, .L17 # table_name 2772 -
2773 % L, L, L, e, L, L, L # name 2773 -
2774 # L10, L11, L12, e, L15, L16, L17 # name 2774 -
2775 % bigint, bigint, bigint, int, bigint, bigint, bigint # type 2775 -
2776 % 1, 4, 2, 3, 4, 1, 4 # length 2776 -
2777 [ 0, NULL, NULL, NULL, NULL, 2, NULL ] 2777 -
2778 [ 0, NULL, 4, 110, 1120, 1, NULL ] 2778 -
2779 [ 0, NULL, 1, 237, 2360, NULL, NULL ] 2779 -
2780 [ 0, 1226, NULL, NULL, 1240, 1, 738 ] 2780 -
2781 [ 0, 1272, 2, 126, 1290, 4, 760 ] 2781 -
2782 [ 0, 1325, 1, 132, 1300, 4, 793 ] 2782 -
2783 [ 0, 1371, 1, 135, 1390, 2, 827 ] 2783 -
2784 [ 0, 1411, -4, 144, 1430, 2, 851 ] 2784 -
2785 [ 0, NULL, NULL, 146, 1450, 2, 880 ] 2785 -
2786 [ 0, NULL, NULL, NULL, 1510, 1, 905 ] 2786 -
2787 [ 0, NULL, NULL, 157, 1580, 3, 940 ] 2787 -
2788 [ 0, 1622, 2, 162, 1600, 1, 966 ] 2788 -
2789 [ 0, NULL, NULL, 165, 1670, 1, 1000 ] 2789 -
2790 [ 0, 1714, -2, 173, 1700, 2, 1030 ] 2790 -
2791 [ 0, NULL, NULL, 177, 358, 1, 1057 ] 2791 -
2792 [ 0, 1828, 3, 180, 364, 3, 1096 ] 2792 -
2793 [ 0, 1861, -4, 189, 376, 1, 1121 ] 2793 -
2794 [ 0, 1918, -2, 192, 382, 1, 1158 ] 2794 -
2795 [ 0, 1964, -1, 197, 398, 3, 1180 ] 2795 -
2796 [ 0, 2125, 2, 210, 426, 3, 1277 ] 2796 -
2797 [ 0, 2165, -2, 219, 432, 3, 1297 ] 2797 -
2798 [ 0, 2226, 1, 221, 440, 1, 1338 ] 2798 -
2799 [ 0, 2264, -1, 227, 458, 3, 1360 ] 2799 -
2800 [ 0, 2323, 3, 230, 468, 1, 1391 ] 2800 -
2801 [ 0, NULL, NULL, NULL, 486, 4, 1455 ] 2801 -
2802 [ 0, 2476, 2, 246, 490, 2, 1484 ] 2802 -
2803 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d), 2803 -
2804 # a+b*2+c*3+d*4, 2804 -
2805 # d-e, 2805 -
2806 # e, 2806 -
2807 # CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 2807 -
2808 # abs(b-c), 2808 -
2809 # a+b*2+c*3 2809 -
2810 # FROM t1 2810 -
2811 # WHERE b>c 2811 -
2812 # OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2812 -
2813 #; 2813 -
2814 % ., ., ., .t1, ., ., . # table_name 2814 -
2815 # .L10, .L11, .L12, .t1, .L15, .L16, .L17 # table_name 2815 -
2816 % L, L, L, e, L, L, L # name 2816 -
2817 # L10, L11, L12, e, L15, L16, L17 # name 2817 -
2818 % bigint, bigint, bigint, int, bigint, bigint, bigint # type 2818 -
2819 % 1, 4, 2, 3, 4, 1, 4 # length 2819 -
2820 [ 0, 1226, NULL, NULL, 1240, 1, 738 ] 2820 -
2821 [ 0, 1272, 2, 126, 1290, 4, 760 ] 2821 -
2822 [ 0, 1371, 1, 135, 1390, 2, 827 ] 2822 -
2823 [ 0, 1411, -4, 144, 1430, 2, 851 ] 2823 -
2824 [ 0, NULL, NULL, NULL, 1510, 1, 905 ] 2824 -
2825 [ 0, NULL, NULL, 157, 1580, 3, 940 ] 2825 -
2826 [ 0, NULL, NULL, 165, 1670, 1, 1000 ] 2826 -
2827 [ 0, 1918, -2, 192, 382, 1, 1158 ] 2827 -
2828 [ 0, 1964, -1, 197, 398, 3, 1180 ] 2828 -
2829 [ 0, 2165, -2, 219, 432, 3, 1297 ] 2829 -
2830 [ 0, 2264, -1, 227, 458, 3, 1360 ] 2830 -
2831 [ 0, 2323, 3, 230, 468, 1, 1391 ] 2831 -
2832 [ 0, 2476, 2, 246, 490, 2, 1484 ] 2832 -
2833 [ 0, NULL, 4, 110, 1120, 1, NULL ] 2833 -
2834 [ 0, 1325, 1, 132, 1300, 4, 793 ] 2834 -
2835 [ 0, NULL, NULL, 146, 1450, 2, 880 ] 2835 -
2836 [ 0, 1622, 2, 162, 1600, 1, 966 ] 2836 -
2837 [ 0, 1714, -2, 173, 1700, 2, 1030 ] 2837 -
2838 [ 0, NULL, NULL, 177, 358, 1, 1057 ] 2838 -
2839 [ 0, 1828, 3, 180, 364, 3, 1096 ] 2839 -
2840 [ 0, 1861, -4, 189, 376, 1, 1121 ] 2840 -
2841 [ 0, NULL, NULL, NULL, NULL, 2, NULL ] 2841 -
2842 [ 0, 2125, 2, 210, 426, 3, 1277 ] 2842 -
2843 [ 0, 2226, 1, 221, 440, 1, 1338 ] 2843 -
2844 [ 0, NULL, 1, 237, 2360, NULL, NULL ] 2844 -
2845 [ 0, NULL, NULL, NULL, 486, 4, 1455 ] 2845 -
2846 #SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d), 2846 -
2847 # a+b*2+c*3+d*4, 2847 -
2848 # d-e, 2848 -
2849 # e, 2849 -
2850 # CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 2850 -
2851 # abs(b-c), 2851 -
2852 # a+b*2+c*3 2852 -
2853 # FROM t1 2853 -
2854 # WHERE b>c 2854 -
2855 # OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) 2855 -
2856 # ORDER BY 2,6,4,5,3,1,7 2856 -
2857 #; 2857 -
2858 % ., ., ., .t1, ., ., . # table_name 2858 -
2859 # .L10, .L11, .L12, .t1, .L15, .L16, .L17 # table_name 2859 -
2860 % L, L, L, e, L, L, L # name 2860 -
2861 # L10, L11, L12, e, L15, L16, L17 # name 2861 -
2862 % bigint, bigint, bigint, int, bigint, bigint, bigint # type 2862 -
2863 % 1, 4, 2, 3, 4, 1, 4 # length 2863 -
2864 [ 0, NULL, 1, 237, 2360, NULL, NULL ] 2864 -
2865 [ 0, NULL, NULL, NULL, 1510, 1, 905 ] 2865 -
2866 [ 0, NULL, 4, 110, 1120, 1, NULL ] 2866 -
2867 [ 0, NULL, NULL, 165, 1670, 1, 1000 ] 2867 -
2868 [ 0, NULL, NULL, 177, 358, 1, 1057 ] 2868 -
2869 [ 0, NULL, NULL, NULL, NULL, 2, NULL ] 2869 -
2870 [ 0, NULL, NULL, 146, 1450, 2, 880 ] 2870 -
2871 [ 0, NULL, NULL, 157, 1580, 3, 940 ] 2871 -
2872 [ 0, NULL, NULL, NULL, 486, 4, 1455 ] 2872 -
2873 [ 0, 1226, NULL, NULL, 1240, 1, 738 ] 2873 -
2874 [ 0, 1272, 2, 126, 1290, 4, 760 ] 2874 -
2875 [ 0, 1325, 1, 132, 1300, 4, 793 ] 2875 -
2876 [ 0, 1371, 1, 135, 1390, 2, 827 ] 2876 -
2877 [ 0, 1411, -4, 144, 1430, 2, 851 ] 2877 -
2878 [ 0, 1622, 2, 162, 1600, 1, 966 ] 2878 -
2879 [ 0, 1714, -2, 173, 1700, 2, 1030 ] 2879 -
2880 [ 0, 1828, 3, 180, 364, 3, 1096 ] 2880 -
2881 [ 0, 1861, -4, 189, 376, 1, 1121 ] 2881 -
2882 [ 0, 1918, -2, 192, 382, 1, 1158 ] 2882 -
2883 [ 0, 1964, -1, 197, 398, 3, 1180 ] 2883 -
2884 [ 0, 2125, 2, 210, 426, 3, 1277 ] 2884 -
2885 [ 0, 2165, -2, 219, 432, 3, 1297 ] 2885 -
2886 [ 0, 2226, 1, 221, 440, 1, 1338 ] 2886 -
2887 [ 0, 2264, -1, 227, 458, 3, 1360 ] 2887 -
2888 [ 0, 2323, 3, 230, 468, 1, 1391 ] 2888 -
2889 [ 0, 2476, 2, 246, 490, 2, 1484 ] 2889 -
2890 #SELECT a+b*2+c*3, 2890 -
2891 # (a+b+c+d+e)/5 2891 -
2892 # FROM t1 2892 -
2893 # WHERE (e>a AND e<b) 2893 -
2894 # AND b>c 2894 -
2895 # AND a>b 2895 -
2896 #; 2896 -
2897 % sys., sys. # table_name 2897 -
2898 # sys.L1, sys.L2 # table_name 2898 -
2899 % L, L # name 2899 -
2900 # L1, L2 # name 2900 -
2901 % bigint, bigint # type 2901 -
2902 % 1, 1 # length 2902 -
2903 #SELECT a+b*2+c*3, 2903 -
2904 # (a+b+c+d+e)/5 2904 -
2905 # FROM t1 2905 -
2906 # WHERE (e>a AND e<b) 2906 -
2907 # AND b>c 2907 -
2908 # AND a>b 2908 -
2909 # ORDER BY 2,1 2909 -
2910 #; 2910 -
2911 % sys., sys. # table_name 2911 -
2912 # sys.L1, sys.L2 # table_name 2912 -
2913 % L, L # name 2913 -
2914 # L1, L2 # name 2914 -
2915 % bigint, bigint # type 2915 -
2916 % 1, 1 # length 2916 -
2917 #SELECT a+b*2+c*3, 2917 -
2918 # (a+b+c+d+e)/5 2918 -
2919 # FROM t1 2919 -
2920 # WHERE b>c 2920 -
2921 # AND a>b 2921 -
2922 # AND (e>a AND e<b) 2922 -
2923 #; 2923 -
2924 % sys., sys. # table_name 2924 -
2925 # sys.L1, sys.L2 # table_name 2925 -
2926 % L, L # name 2926 -
2927 # L1, L2 # name 2927 -
2928 % bigint, bigint # type 2928 -
2929 % 1, 1 # length 2929 -
2930 #SELECT a+b*2+c*3, 2930 -
2931 # (a+b+c+d+e)/5 2931 -
2932 # FROM t1 2932 -
2933 # WHERE b>c 2933 -
2934 # AND a>b 2934 -
2935 # AND (e>a AND e<b) 2935 -
2936 # ORDER BY 1,2 2936 -
2937 #; 2937 -
2938 % sys., sys. # table_name 2938 -
2939 # sys.L1, sys.L2 # table_name 2939 -
2940 % L, L # name 2940 -
2941 # L1, L2 # name 2941 -
2942 % bigint, bigint # type 2942 -
2943 % 1, 1 # length 2943 -
2944 #SELECT a+b*2+c*3, 2944 -
2945 # (a+b+c+d+e)/5 2945 -
2946 # FROM t1 2946 -
2947 # WHERE b>c 2947 -
2948 # AND (e>a AND e<b) 2948 -
2949 # AND a>b 2949 -
2950 #; 2950 -
2951 % sys., sys. # table_name 2951 -
2952 # sys.L1, sys.L2 # table_name 2952 -
2953 % L, L # name 2953 -
2954 # L1, L2 # name 2954 -
2955 % bigint, bigint # type 2955 -
2956 % 1, 1 # length 2956 -
2957 #SELECT a+b*2+c*3, 2957 -
2958 # (a+b+c+d+e)/5 2958 -
2959 # FROM t1 2959 -
2960 # WHERE b>c 2960 -
2961 # AND (e>a AND e<b) 2961 -
2962 # AND a>b 2962 -
2963 # ORDER BY 2,1 2963 -
2964 #; 2964 -
2965 % sys., sys. # table_name 2965 -
2966 # sys.L1, sys.L2 # table_name 2966 -
2967 % L, L # name 2967 -
2968 # L1, L2 # name 2968 -
2969 % bigint, bigint # type 2969 -
2970 % 1, 1 # length 2970 -
2971 #SELECT a+b*2+c*3, 2971 -
2972 # abs(b-c), 2972 -
2973 # d, 2973 -
2974 # d-e 2974 -
2975 # FROM t1 2975 -
2976 # WHERE e+d BETWEEN a+b-10 AND c+130 2976 -
2977 # AND d NOT BETWEEN 110 AND 150 2977 -
2978 # AND (e>a AND e<b) 2978 -
2979 #; 2979 -
2980 % sys., sys., sys.t1, sys. # table_name 2980 -
2981 # sys.L1, sys.L2, sys.t1, sys.L3 # table_name 2981 -
2982 % L, L, d, L # name 2982 -
2983 # L1, L2, d, L3 # name 2983 -
2984 % bigint, bigint, int, bigint # type 2984 -
2985 % 1, 1, 1, 1 # length 2985 -
2986 #SELECT a+b*2+c*3, 2986 -
2987 # abs(b-c), 2987 -
2988 # d, 2988 -
2989 # d-e 2989 -
2990 # FROM t1 2990 -
2991 # WHERE e+d BETWEEN a+b-10 AND c+130 2991 -
2992 # AND d NOT BETWEEN 110 AND 150 2992 -
2993 # AND (e>a AND e<b) 2993 -
2994 # ORDER BY 3,1,4,2 2994 -
2995 #; 2995 -
2996 % sys., sys., sys.t1, sys. # table_name 2996 -
2997 # sys.L1, sys.L2, sys.t1, sys.L3 # table_name 2997 -
2998 % L, L, d, L # name 2998 -
2999 # L1, L2, d, L3 # name 2999 -
3000 % bigint, bigint, int, bigint # type 3000 -
3001 % 1, 1, 1, 1 # length 3001 -
3002 #SELECT a+b*2+c*3, 3002 -
3003 # abs(b-c), 3003 -
3004 # d, 3004 -
3005 # d-e 3005 -
3006 # FROM t1 3006 -
3007 # WHERE (e>a AND e<b) 3007 -
3008 # AND e+d BETWEEN a+b-10 AND c+130 3008 -
3009 # AND d NOT BETWEEN 110 AND 150 3009 -
3010 #; 3010 -
3011 % sys., sys., sys.t1, sys. # table_name 3011 -
3012 # sys.L1, sys.L2, sys.t1, sys.L3 # table_name 3012 -
3013 % L, L, d, L # name 3013 -
3014 # L1, L2, d, L3 # name 3014 -
3015 % bigint, bigint, int, bigint # type 3015 -
3016 % 1, 1, 1, 1 # length 3016 -
3017 #SELECT a+b*2+c*3, 3017 -
3018 # abs(b-c), 3018 -
3019 # d, 3019 -
3020 # d-e 3020 -
3021 # FROM t1 3021 -
3022 # WHERE (e>a AND e<b) 3022 -
3023 # AND e+d BETWEEN a+b-10 AND c+130 3023 -
3024 # AND d NOT BETWEEN 110 AND 150 3024 -
3025 # ORDER BY 1,2,4 3025 -
3026 #; 3026 -
3027 % sys., sys., sys.t1, sys. # table_name 3027 -
3028 # sys.L1, sys.L2, sys.t1, sys.L3 # table_name 3028 -
3029 % L, L, d, L # name 3029 -
3030 # L1, L2, d, L3 # name 3030 -
3031 % bigint, bigint, int, bigint # type 3031 -
3032 % 1, 1, 1, 1 # length 3032 -
3033 #SELECT a+b*2+c*3, 3033 -
3034 # abs(b-c), 3034 -
3035 # d, 3035 -
3036 # d-e 3036 -
3037 # FROM t1 3037 -
3038 # WHERE d NOT BETWEEN 110 AND 150 3038 -
3039 # AND e+d BETWEEN a+b-10 AND c+130 3039 -
3040 # AND (e>a AND e<b) 3040 -
3041 #; 3041 -
3042 % sys., sys., sys.t1, sys. # table_name 3042 -
3043 # sys.L1, sys.L2, sys.t1, sys.L3 # table_name 3043 -
3044 % L, L, d, L # name 3044 -
3045 # L1, L2, d, L3 # name 3045 -
3046 % bigint, bigint, int, bigint # type 3046 -
3047 % 1, 1, 1, 1 # length 3047 -
3048 #SELECT a+b*2+c*3, 3048 -
3049 # abs(b-c), 3049 -
3050 # d, 3050 -
3051 # d-e 3051 -
3052 # FROM t1 3052 -
3053 # WHERE d NOT BETWEEN 110 AND 150 3053 -
3054 # AND e+d BETWEEN a+b-10 AND c+130 3054 -
3055 # AND (e>a AND e<b) 3055 -
3056 # ORDER BY 3,4,1,2 3056 -
3057 #; 3057 -
3058 % sys., sys., sys.t1, sys. # table_name 3058 -
3059 # sys.L1, sys.L2, sys.t1, sys.L3 # table_name 3059 -
3060 % L, L, d, L # name 3060 -
3061 # L1, L2, d, L3 # name 3061 -
3062 % bigint, bigint, int, bigint # type 3062 -
3063 % 1, 1, 1, 1 # length 3063 -
3064 #SELECT a+b*2+c*3, 3064 -
3065 # abs(b-c), 3065 -
3066 # d, 3066 -
3067 # d-e 3067 -
3068 # FROM t1 3068 -
3069 # WHERE (e>a AND e<b) 3069 -
3070 # AND d NOT BETWEEN 110 AND 150 3070 -
3071 # AND e+d BETWEEN a+b-10 AND c+130 3071 -
3072 #; 3072 -
3073 % sys., sys., sys.t1, sys. # table_name 3073 -
3074 # sys.L1, sys.L2, sys.t1, sys.L3 # table_name 3074 -
3075 % L, L, d, L # name 3075 -
3076 # L1, L2, d, L3 # name 3076 -
3077 % bigint, bigint, int, bigint # type 3077 -
3078 % 1, 1, 1, 1 # length 3078 -
3079 #SELECT a+b*2+c*3, 3079 -
3080 # abs(b-c), 3080 -
3081 # d, 3081 -
3082 # d-e 3082 -
3083 # FROM t1 3083 -
3084 # WHERE (e>a AND e<b) 3084 -
3085 # AND d NOT BETWEEN 110 AND 150 3085 -
3086 # AND e+d BETWEEN a+b-10 AND c+130 3086 -
3087 # ORDER BY 1,3 3087 -
3088 #; 3088 -
3089 % sys., sys., sys.t1, sys. # table_name 3089 -
3090 # sys.L1, sys.L2, sys.t1, sys.L3 # table_name 3090 -
3091 % L, L, d, L # name 3091 -
3092 # L1, L2, d, L3 # name 3092 -
3093 % bigint, bigint, int, bigint # type 3093 -
3094 % 1, 1, 1, 1 # length 3094 -
3095 #SELECT b-c, 3095 -
3096 # b, 3096 -
3097 # a+b*2+c*3+d*4 3097 -
3098 # FROM t1 3098 -
3099 # WHERE (a>b-2 AND a<b+2) 3099 -
3100 # AND a>b 3100 -
3101 # AND (c<=d-2 OR c>=d+2) 3101 -
3102 #; 3102 -
3103 % sys., sys.t1, sys. # table_name 3103 -
3104 # sys.L1, sys.t1, sys.L2 # table_name 3104 -
3105 % L, b, L # name 3105 -
3106 # L1, b, L2 # name 3106 -
3107 % bigint, int, bigint # type 3107 -
3108 % 1, 1, 1 # length 3108 -
3109 #SELECT b-c, 3109 -
3110 # b, 3110 -
3111 # a+b*2+c*3+d*4 3111 -
3112 # FROM t1 3112 -
3113 # WHERE (a>b-2 AND a<b+2) 3113 -
3114 # AND a>b 3114 -
3115 # AND (c<=d-2 OR c>=d+2) 3115 -
3116 # ORDER BY 3,1,2 3116 -
3117 #; 3117 -
3118 % sys., sys.t1, sys. # table_name 3118 -
3119 # sys.L1, sys.t1, sys.L2 # table_name 3119 -
3120 % L, b, L # name 3120 -
3121 # L1, b, L2 # name 3121 -
3122 % bigint, int, bigint # type 3122 -
3123 % 1, 1, 1 # length 3123 -
3124 #SELECT b-c, 3124 -
3125 # b, 3125 -
3126 # a+b*2+c*3+d*4 3126 -
3127 # FROM t1 3127 -
3128 # WHERE (a>b-2 AND a<b+2) 3128 -
3129 # AND (c<=d-2 OR c>=d+2) 3129 -
3130 # AND a>b 3130 -
3131 #; 3131 -
3132 % sys., sys.t1, sys. # table_name 3132 -
3133 # sys.L1, sys.t1, sys.L2 # table_name 3133 -
3134 % L, b, L # name 3134 -
3135 # L1, b, L2 # name 3135 -
3136 % bigint, int, bigint # type 3136 -
3137 % 1, 1, 1 # length 3137 -
3138 #SELECT b-c, 3138 -
3139 # b, 3139 -
3140 # a+b*2+c*3+d*4 3140 -
3141 # FROM t1 3141 -
3142 # WHERE (a>b-2 AND a<b+2) 3142 -
3143 # AND (c<=d-2 OR c>=d+2) 3143 -
3144 # AND a>b 3144 -
3145 # ORDER BY 3,1 3145 -
3146 #; 3146 -
3147 % sys., sys.t1, sys. # table_name 3147 -
3148 # sys.L1, sys.t1, sys.L2 # table_name 3148 -
3149 % L, b, L # name 3149 -
3150 # L1, b, L2 # name 3150 -
3151 % bigint, int, bigint # type 3151 -
3152 % 1, 1, 1 # length 3152 -
3153 #SELECT b-c, 3153 -
3154 # b, 3154 -
3155 # a+b*2+c*3+d*4 3155 -
3156 # FROM t1 3156 -
3157 # WHERE (c<=d-2 OR c>=d+2) 3157 -
3158 # AND (a>b-2 AND a<b+2) 3158 -
3159 # AND a>b 3159 -
3160 #; 3160 -
3161 % sys., sys.t1, sys. # table_name 3161 -
3162 # sys.L1, sys.t1, sys.L2 # table_name 3162 -
3163 % L, b, L # name 3163 -
3164 # L1, b, L2 # name 3164 -
3165 % bigint, int, bigint # type 3165 -
3166 % 1, 1, 1 # length 3166 -
3167 #SELECT b-c, 3167 -
3168 # b, 3168 -
3169 # a+b*2+c*3+d*4 3169 -
3170 # FROM t1 3170 -
3171 # WHERE (c<=d-2 OR c>=d+2) 3171 -
3172 # AND (a>b-2 AND a<b+2) 3172 -
3173 # AND a>b 3173 -
3174 # ORDER BY 1,2,3 3174 -
3175 #; 3175 -
3176 % sys., sys.t1, sys. # table_name 3176 -
3177 # sys.L1, sys.t1, sys.L2 # table_name 3177 -
3178 % L, b, L # name 3178 -
3179 # L1, b, L2 # name 3179 -
3180 % bigint, int, bigint # type 3180 -
3181 % 1, 1, 1 # length 3181 -
3182 #SELECT b-c, 3182 -
3183 # b, 3183 -
3184 # a+b*2+c*3+d*4 3184 -
3185 # FROM t1 3185 -
3186 # WHERE a>b 3186 -
3187 # AND (c<=d-2 OR c>=d+2) 3187 -
3188 # AND (a>b-2 AND a<b+2) 3188 -
3189 #; 3189 -
3190 % sys., sys.t1, sys. # table_name 3190 -
3191 # sys.L1, sys.t1, sys.L2 # table_name 3191 -
3192 % L, b, L # name 3192 -
3193 # L1, b, L2 # name 3193 -
3194 % bigint, int, bigint # type 3194 -
3195 % 1, 1, 1 # length 3195 -
3196 #SELECT b-c, 3196 -
3197 # b, 3197 -
3198 # a+b*2+c*3+d*4 3198 -
3199 # FROM t1 3199 -
3200 # WHERE a>b 3200 -
3201 # AND (c<=d-2 OR c>=d+2) 3201 -
3202 # AND (a>b-2 AND a<b+2) 3202 -
3203 # ORDER BY 1,2,3 3203 -
3204 #; 3204 -
3205 % sys., sys.t1, sys. # table_name 3205 -
3206 # sys.L1, sys.t1, sys.L2 # table_name 3206 -
3207 % L, b, L # name 3207 -
3208 # L1, b, L2 # name 3208 -
3209 % bigint, int, bigint # type 3209 -
3210 % 1, 1, 1 # length 3210 -
3211 #SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222 3211 -
3212 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 3212 -
3213 # a-b, 3213 -
3214 # e, 3214 -
3215 # d-e, 3215 -
3216 # a+b*2+c*3+d*4+e*5 3216 -
3217 # FROM t1 3217 -
3218 # WHERE b>c 3218 -
3219 #; 3219 -
3220 % sys., sys., sys.t1, sys., sys. # table_name 3220 -
3221 # sys.L1, sys.L2, sys.t1, sys.L3, sys.L4 # table_name 3221 -
3222 % L, L, e, L, L # name 3222 -
3223 # L1, L2, e, L3, L4 # name 3223 -
3224 % smallint, bigint, int, bigint, bigint # type 3224 -
3225 % 3, 2, 3, 2, 4 # length 3225 -
3226 [ 333, -3, NULL, NULL, NULL ] 3226 -
3227 [ 333, -2, 126, 2, 1902 ] 3227 -
3228 [ 111, -1, 135, 1, 2046 ] 3228 -
3229 [ 111, -1, 144, -4, 2131 ] 3229 -
3230 [ 555, 2, NULL, NULL, NULL ] 3230 -
3231 [ 555, 1, 157, NULL, NULL ] 3231 -
3232 [ 555, 1, 165, NULL, NULL ] 3232 -
3233 [ 444, -3, 192, -2, 2878 ] 3233 -
3234 [ 555, 1, 197, -1, 2949 ] 3234 -
3235 [ 333, -2, 219, -2, 3260 ] 3235 -
3236 [ 555, 1, 227, -1, 3399 ] 3236 -
3237 [ 555, 2, 230, 3, 3473 ] 3237 -
3238 [ 444, -4, 246, 2, 3706 ] 3238 -
3239 #SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222 3239 -
3240 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 3240 -
3241 # a-b, 3241 -
3242 # e, 3242 -
3243 # d-e, 3243 -
3244 # a+b*2+c*3+d*4+e*5 3244 -
3245 # FROM t1 3245 -
3246 # WHERE b>c 3246 -
3247 # ORDER BY 2,3 3247 -
3248 #; 3248 -
3249 % sys., sys., sys.t1, sys., sys. # table_name 3249 -
3250 # sys.L1, sys.L2, sys.t1, sys.L3, sys.L4 # table_name 3250 -
3251 % L, L, e, L, L # name 3251 -
3252 # L1, L2, e, L3, L4 # name 3252 -
3253 % smallint, bigint, int, bigint, bigint # type 3253 -
3254 % 3, 2, 3, 2, 4 # length 3254 -
3255 [ 444, -4, 246, 2, 3706 ] 3255 -
3256 [ 333, -3, NULL, NULL, NULL ] 3256 -
3257 [ 444, -3, 192, -2, 2878 ] 3257 -
3258 [ 333, -2, 126, 2, 1902 ] 3258 -
3259 [ 333, -2, 219, -2, 3260 ] 3259 -
3260 [ 111, -1, 135, 1, 2046 ] 3260 -
3261 [ 111, -1, 144, -4, 2131 ] 3261 -
3262 [ 555, 1, 157, NULL, NULL ] 3262 -
3263 [ 555, 1, 165, NULL, NULL ] 3263 -
3264 [ 555, 1, 197, -1, 2949 ] 3264 -
3265 [ 555, 1, 227, -1, 3399 ] 3265 -
3266 [ 555, 2, NULL, NULL, NULL ] 3266 -
3267 [ 555, 2, 230, 3, 3473 ] 3267 -
3268 #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 3268 -
3269 # WHEN a<b+3 THEN 333 ELSE 444 END 3269 -
3270 # FROM t1 3270 -
3271 #; 3271 -
3272 % sys. # table_name 3272 -
3273 # sys.L1 # table_name 3273 -
3274 % L # name 3274 -
3275 # L1 # name 3275 -
3276 % smallint # type 3276 -
3277 % 3 # length 3277 -
3278 [ 444 ] 3278 -
3279 [ 333 ] 3279 -
3280 [ 444 ] 3280 -
3281 [ 444 ] 3281 -
3282 [ 222 ] 3282 -
3283 [ 222 ] 3283 -
3284 [ 333 ] 3284 -
3285 [ 222 ] 3285 -
3286 [ 222 ] 3286 -
3287 [ 444 ] 3287 -
3288 [ 333 ] 3288 -
3289 [ 333 ] 3289 -
3290 [ 444 ] 3290 -
3291 [ 333 ] 3291 -
3292 [ 444 ] 3292 -
3293 [ 444 ] 3293 -
3294 [ 333 ] 3294 -
3295 [ 333 ] 3295 -
3296 [ 222 ] 3296 -
3297 [ 333 ] 3297 -
3298 [ 444 ] 3298 -
3299 [ 444 ] 3299 -
3300 [ 333 ] 3300 -
3301 [ 222 ] 3301 -
3302 [ 222 ] 3302 -
3303 [ 333 ] 3303 -
3304 [ 333 ] 3304 -
3305 [ 444 ] 3305 -
3306 [ 444 ] 3306 -
3307 [ 111 ] 3307 -
3308 #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 3308 -
3309 # WHEN a<b+3 THEN 333 ELSE 444 END 3309 -
3310 # FROM t1 3310 -
3311 # ORDER BY 1 3311 -
3312 #; 3312 -
3313 % sys. # table_name 3313 -
3314 # sys.L1 # table_name 3314 -
3315 % L # name 3315 -
3316 # L1 # name 3316 -
3317 % smallint # type 3317 -
3318 % 3 # length 3318 -
3319 [ 111 ] 3319 -
3320 [ 222 ] 3320 -
3321 [ 222 ] 3321 -
3322 [ 222 ] 3322 -
3323 [ 222 ] 3323 -
3324 [ 222 ] 3324 -
3325 [ 222 ] 3325 -
3326 [ 222 ] 3326 -
3327 [ 333 ] 3327 -
3328 [ 333 ] 3328 -
3329 [ 333 ] 3329 -
3330 [ 333 ] 3330 -
3331 [ 333 ] 3331 -
3332 [ 333 ] 3332 -
3333 [ 333 ] 3333 -
3334 [ 333 ] 3334 -
3335 [ 333 ] 3335 -
3336 [ 333 ] 3336 -
3337 [ 333 ] 3337 -
3338 [ 444 ] 3338 -
3339 [ 444 ] 3339 -
3340 [ 444 ] 3340 -
3341 [ 444 ] 3341 -
3342 [ 444 ] 3342 -
3343 [ 444 ] 3343 -
3344 [ 444 ] 3344 -
3345 [ 444 ] 3345 -
3346 [ 444 ] 3346 -
3347 [ 444 ] 3347 -
3348 [ 444 ] 3348 -
3349 #SELECT a+b*2+c*3+d*4, 3349 -
3350 # a-b, 3350 -
3351 # abs(b-c), 3351 -
3352 # (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d), 3352 -
3353 # a+b*2+c*3, 3353 -
3354 # b-c 3354 -
3355 # FROM t1 3355 -
3356 # WHERE d>e 3356 -
3357 # OR (c<=d-2 OR c>=d+2) 3357 -
3358 #; 3358 -
3359 % sys., sys., sys., ., sys., sys. # table_name 3359 -
3360 # sys.L1, sys.L2, sys.L3, .L5, sys.L6, sys.L7 # table_name 3360 -
3361 % L, L, L, L, L, L # name 3361 -
3362 # L1, L2, L3, L5, L6, L7 # name 3362 -
3363 % bigint, bigint, bigint, bigint, bigint, bigint # type 3363 -
3364 % 4, 2, 1, 1, 4, 2 # length 3364 -
3365 [ 1067, 2, 1, 0, 635, -1 ] 3365 -
3366 [ NULL, NULL, 1, 0, NULL, -1 ] 3366 -
3367 [ NULL, NULL, NULL, 0, NULL, NULL ] 3367 -
3368 [ 1272, -2, 4, 0, 760, 4 ] 3368 -
3369 [ 1325, 1, 4, 0, 793, -4 ] 3369 -
3370 [ 1371, -1, 2, 0, 827, 2 ] 3370 -
3371 [ 1622, 3, 1, 0, 966, -1 ] 3371 -
3372 [ 1828, 1, 3, 0, 1096, -3 ] 3372 -
3373 [ 1861, 2, 1, 0, 1121, -1 ] 3373 -
3374 [ 1918, -3, 1, 0, 1158, 1 ] 3374 -
3375 [ 2125, 2, 3, 0, 1277, -3 ] 3375 -
3376 [ 2165, -2, 3, 0, 1297, 3 ] 3376 -
3377 [ 2226, -3, 1, 0, 1338, -1 ] 3377 -
3378 [ 2323, 2, 1, 0, 1391, 1 ] 3378 -
3379 [ NULL, 3, NULL, 0, NULL, NULL ] 3379 -
3380 [ 2476, -4, 2, 0, 1484, 2 ] 3380 -
3381 #SELECT a+b*2+c*3+d*4, 3381 -
3382 # a-b, 3382 -
3383 # abs(b-c), 3383 -
3384 # (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d), 3384 -
3385 # a+b*2+c*3, 3385 -
3386 # b-c 3386 -
3387 # FROM t1 3387 -
3388 # WHERE d>e 3388 -
3389 # OR (c<=d-2 OR c>=d+2) 3389 -
3390 # ORDER BY 6,5,3,4 3390 -
3391 #; 3391 -
3392 % sys., sys., sys., ., sys., sys. # table_name 3392 -
3393 # sys.L1, sys.L2, sys.L3, .L5, sys.L6, sys.L7 # table_name 3393 -
3394 % L, L, L, L, L, L # name 3394 -
3395 # L1, L2, L3, L5, L6, L7 # name 3395 -
3396 % bigint, bigint, bigint, bigint, bigint, bigint # type 3396 -
3397 % 4, 2, 1, 1, 4, 2 # length 3397 -
3398 [ NULL, NULL, NULL, 0, NULL, NULL ] 3398 -
3399 [ NULL, 3, NULL, 0, NULL, NULL ] 3399 -
3400 [ 1325, 1, 4, 0, 793, -4 ] 3400 -
3401 [ 1828, 1, 3, 0, 1096, -3 ] 3401 -
3402 [ 2125, 2, 3, 0, 1277, -3 ] 3402 -
3403 [ NULL, NULL, 1, 0, NULL, -1 ] 3403 -
3404 [ 1067, 2, 1, 0, 635, -1 ] 3404 -
3405 [ 1622, 3, 1, 0, 966, -1 ] 3405 -
3406 [ 1861, 2, 1, 0, 1121, -1 ] 3406 -
3407 [ 2226, -3, 1, 0, 1338, -1 ] 3407 -
3408 [ 1918, -3, 1, 0, 1158, 1 ] 3408 -
3409 [ 2323, 2, 1, 0, 1391, 1 ] 3409 -
3410 [ 1371, -1, 2, 0, 827, 2 ] 3410 -
3411 [ 2476, -4, 2, 0, 1484, 2 ] 3411 -
3412 [ 2165, -2, 3, 0, 1297, 3 ] 3412 -
3413 [ 1272, -2, 4, 0, 760, 4 ] 3413 -
3414 #SELECT a-b, 3414 -
3415 # a, 3415 -
3416 # c 3416 -
3417 # FROM t1 3417 -
3418 # WHERE c BETWEEN b-2 AND d+2 3418 -
3419 # AND a>b 3419 -
3420 #; 3420 -
3421 % sys., sys.t1, sys.t1 # table_name 3421 -
3422 # sys.L1, sys.t1, sys.t1 # table_name 3422 -
3423 % L, a, c # name 3423 -
3424 # L1, a, c # name 3424 -
3425 % bigint, int, int # type 3425 -
3426 % 1, 3, 3 # length 3426 -
3427 [ 2, 107, 106 ] 3427 -
3428 [ 1, 131, 134 ] 3428 -
3429 [ 3, 163, 161 ] 3429 -
3430 [ 4, 174, 172 ] 3430 -
3431 [ 1, 182, 184 ] 3431 -
3432 [ 2, 188, 187 ] 3432 -
3433 [ 2, 213, 214 ] 3433 -
3434 [ 2, 234, 231 ] 3434 -
3435 #SELECT a-b, 3435 -
3436 # a, 3436 -
3437 # c 3437 -
3438 # FROM t1 3438 -
3439 # WHERE c BETWEEN b-2 AND d+2 3439 -
3440 # AND a>b 3440 -
3441 # ORDER BY 1,3,2 3441 -
3442 #; 3442 -
3443 % sys., sys.t1, sys.t1 # table_name 3443 -
3444 # sys.L1, sys.t1, sys.t1 # table_name 3444 -
3445 % L, a, c # name 3445 -
3446 # L1, a, c # name 3446 -
3447 % bigint, int, int # type 3447 -
3448 % 1, 3, 3 # length 3448 -
3449 [ 1, 131, 134 ] 3449 -
3450 [ 1, 182, 184 ] 3450 -
3451 [ 2, 107, 106 ] 3451 -
3452 [ 2, 188, 187 ] 3452 -
3453 [ 2, 213, 214 ] 3453 -
3454 [ 2, 234, 231 ] 3454 -
3455 [ 3, 163, 161 ] 3455 -
3456 [ 4, 174, 172 ] 3456 -
3457 #SELECT a-b, 3457 -
3458 # a, 3458 -
3459 # c 3459 -
3460 # FROM t1 3460 -
3461 # WHERE a>b 3461 -
3462 # AND c BETWEEN b-2 AND d+2 3462 -
3463 #; 3463 -
3464 % sys., sys.t1, sys.t1 # table_name 3464 -
3465 # sys.L1, sys.t1, sys.t1 # table_name 3465 -
3466 % L, a, c # name 3466 -
3467 # L1, a, c # name 3467 -
3468 % bigint, int, int # type 3468 -
3469 % 1, 3, 3 # length 3469 -
3470 [ 2, 107, 106 ] 3470 -
3471 [ 1, 131, 134 ] 3471 -
3472 [ 3, 163, 161 ] 3472 -
3473 [ 4, 174, 172 ] 3473 -
3474 [ 1, 182, 184 ] 3474 -
3475 [ 2, 188, 187 ] 3475 -
3476 [ 2, 213, 214 ] 3476 -
3477 [ 2, 234, 231 ] 3477 -
3478 #SELECT a-b, 3478 -
3479 # a, 3479 -
3480 # c 3480 -
3481 # FROM t1 3481 -
3482 # WHERE a>b 3482 -
3483 # AND c BETWEEN b-2 AND d+2 3483 -
3484 # ORDER BY 2,3,1 3484 -
3485 #; 3485 -
3486 % sys., sys.t1, sys.t1 # table_name 3486 -
3487 # sys.L1, sys.t1, sys.t1 # table_name 3487 -
3488 % L, a, c # name 3488 -
3489 # L1, a, c # name 3489 -
3490 % bigint, int, int # type 3490 -
3491 % 1, 3, 3 # length 3491 -
3492 [ 2, 107, 106 ] 3492 -
3493 [ 1, 131, 134 ] 3493 -
3494 [ 3, 163, 161 ] 3494 -
3495 [ 4, 174, 172 ] 3495 -
3496 [ 1, 182, 184 ] 3496 -
3497 [ 2, 188, 187 ] 3497 -
3498 [ 2, 213, 214 ] 3498 -
3499 [ 2, 234, 231 ] 3499 -
3500 #SELECT b-c, 3500 -
3501 # CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 3501 -
3502 # a+b*2+c*3, 3502 -
3503 # b, 3503 -
3504 # c-d, 3504 -
3505 # a+b*2 3505 -
3506 # FROM t1 3506 -
3507 #; 3507 -
3508 % sys., sys., sys., sys.t1, sys., sys. # table_name 3508 -
3509 # sys.L1, sys.L4, sys.L5, sys.t1, sys.L6, sys.L7 # table_name 3509 -
3510 % L, L, L, b, L, L # name 3510 -
3511 # L1, L4, L5, b, L6, L7 # name 3511 -
3512 % bigint, bigint, bigint, int, bigint, bigint # type 3512 -
3513 % 2, 4, 4, 3, 2, 3 # length 3513 -
3514 [ NULL, NULL, NULL, NULL, 1, NULL ] 3514 -
3515 [ -1, 1050, 635, 105, -2, 317 ] 3515 -
3516 [ -1, 1120, NULL, 112, -1, NULL ] 3516 -
3517 [ NULL, NULL, NULL, NULL, 3, NULL ] 3517 -
3518 [ 1, 1240, 738, 124, 1, 369 ] 3518 -
3519 [ 4, 1290, 760, 129, -3, 385 ] 3519 -
3520 [ -4, 1300, 793, 130, 1, 391 ] 3520 -
3521 [ 2, 1390, 827, 139, 1, 416 ] 3521 -
3522 [ 2, 1430, 851, 143, 1, 428 ] 3522 -
3523 [ -2, 1450, 880, 145, NULL, 439 ] 3523 -
3524 [ 1, 1510, 905, 151, NULL, 455 ] 3524 -
3525 [ 3, 1580, 940, 158, NULL, 475 ] 3525 -
3526 [ -1, 1600, 966, 160, -3, 483 ] 3526 -
3527 [ 1, 1670, 1000, 167, NULL, 502 ] 3527 -
3528 [ -2, 1700, 1030, 170, 1, 514 ] 3528 -
3529 [ -1, 358, 1057, 175, NULL, 529 ] 3529 -
3530 [ -3, 364, 1096, 181, 1, 544 ] 3530 -
3531 [ -1, 376, 1121, 186, 2, 560 ] 3531 -
3532 [ 1, 382, 1158, 194, 3, 579 ] 3532 -
3533 [ 3, 398, 1180, 198, -1, 595 ] 3533 -
3534 [ NULL, 402, NULL, NULL, -1, NULL ] 3534 -
3535 [ -2, NULL, NULL, 206, 1, NULL ] 3535 -
3536 [ -3, 426, 1277, 211, 2, 635 ] 3536 -
3537 [ 3, 432, 1297, 218, -2, 652 ] 3537 -
3538 [ -1, 440, 1338, 223, 2, 666 ] 3538 -
3539 [ 3, 458, 1360, 228, -1, 685 ] 3539 -
3540 [ 1, 468, 1391, 232, -2, 698 ] 3540 -
3541 [ NULL, 2360, NULL, 236, NULL, 711 ] 3541 -
3542 [ -4, 486, 1455, 240, NULL, 723 ] 3542 -
3543 [ 2, 490, 1484, 249, -1, 743 ] 3543 -
3544 #SELECT b-c, 3544 -
3545 # CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, 3545 -
3546 # a+b*2+c*3, 3546 -
3547 # b, 3547 -
3548 # c-d, 3548 -
3549 # a+b*2 3549 -
3550 # FROM t1 3550 -
3551 # ORDER BY 4,5,1,2,3 3551 -
3552 #; 3552 -
3553 % sys., sys., sys., sys.t1, sys., sys. # table_name 3553 -
3554 # sys.L1, sys.L4, sys.L5, sys.t1, sys.L6, sys.L7 # table_name 3554 -
3555 % L, L, L, b, L, L # name 3555 -
3556 # L1, L4, L5, b, L6, L7 # name 3556 -
3557 % bigint, bigint, bigint, int, bigint, bigint # type 3557 -
3558 % 2, 4, 4, 3, 2, 3 # length 3558 -
3559 [ NULL, 402, NULL, NULL, -1, NULL ] 3559 -
3560 [ NULL, NULL, NULL, NULL, 1, NULL ] 3560 -
3561 [ NULL, NULL, NULL, NULL, 3, NULL ] 3561 -
3562 [ -1, 1050, 635, 105, -2, 317 ] 3562 -
3563 [ -1, 1120, NULL, 112, -1, NULL ] 3563 -
3564 [ 1, 1240, 738, 124, 1, 369 ] 3564 -
3565 [ 4, 1290, 760, 129, -3, 385 ] 3565 -
3566 [ -4, 1300, 793, 130, 1, 391 ] 3566 -
3567 [ 2, 1390, 827, 139, 1, 416 ] 3567 -
3568 [ 2, 1430, 851, 143, 1, 428 ] 3568 -
3569 [ -2, 1450, 880, 145, NULL, 439 ] 3569 -
3570 [ 1, 1510, 905, 151, NULL, 455 ] 3570 -
3571 [ 3, 1580, 940, 158, NULL, 475 ] 3571 -
3572 [ -1, 1600, 966, 160, -3, 483 ] 3572 -
3573 [ 1, 1670, 1000, 167, NULL, 502 ] 3573 -
3574 [ -2, 1700, 1030, 170, 1, 514 ] 3574 -
3575 [ -1, 358, 1057, 175, NULL, 529 ] 3575 -
3576 [ -3, 364, 1096, 181, 1, 544 ] 3576 -
3577 [ -1, 376, 1121, 186, 2, 560 ] 3577 -
3578 [ 1, 382, 1158, 194, 3, 579 ] 3578 -
3579 [ 3, 398, 1180, 198, -1, 595 ] 3579 -
3580 [ -2, NULL, NULL, 206, 1, NULL ] 3580 -
3581 [ -3, 426, 1277, 211, 2, 635 ] 3581 -
3582 [ 3, 432, 1297, 218, -2, 652 ] 3582 -
3583 [ -1, 440, 1338, 223, 2, 666 ] 3583 -
3584 [ 3, 458, 1360, 228, -1, 685 ] 3584 -
3585 [ 1, 468, 1391, 232, -2, 698 ] 3585 -
3586 [ NULL, 2360, NULL, 236, NULL, 711 ] 3586 -
3587 [ -4, 486, 1455, 240, NULL, 723 ] 3587 -
3588 [ 2, 490, 1484, 249, -1, 743 ] 3588 -
3589 #SELECT d-e, 3589 -
3590 # a+b*2+c*3+d*4+e*5, 3590 -
3591 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 3591 -
3592 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 3592 -
3593 # a, 3593 -
3594 # a+b*2+c*3+d*4 3594 -
3595 # FROM t1 3595 -
3596 # WHERE e+d BETWEEN a+b-10 AND c+130 3596 -
3597 #; 3597 -
3598 % sys., sys., sys., sys.t1, sys. # table_name 3598 -
3599 # sys.L1, sys.L2, sys.L3, sys.t1, sys.L4 # table_name 3599 -
3600 % L, L, L, a, L # name 3600 -
3601 # L1, L2, L3, a, L4 # name 3601 -
3602 % bigint, bigint, smallint, int, bigint # type 3602 -
3603 % 2, 4, 3, 3, 4 # length 3603 -
3604 [ -1, 1612, 333, 107, 1067 ] 3604 -
3605 [ 2, 1902, 333, 127, 1272 ] 3605 -
3606 #SELECT d-e, 3606 -
3607 # a+b*2+c*3+d*4+e*5, 3607 -
3608 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 3608 -
3609 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 3609 -
3610 # a, 3610 -
3611 # a+b*2+c*3+d*4 3611 -
3612 # FROM t1 3612 -
3613 # WHERE e+d BETWEEN a+b-10 AND c+130 3613 -
3614 # ORDER BY 5,2,4 3614 -
3615 #; 3615 -
3616 % sys., sys., sys., sys.t1, sys. # table_name 3616 -
3617 # sys.L1, sys.L2, sys.L3, sys.t1, sys.L4 # table_name 3617 -
3618 % L, L, L, a, L # name 3618 -
3619 # L1, L2, L3, a, L4 # name 3619 -
3620 % bigint, bigint, smallint, int, bigint # type 3620 -
3621 % 2, 4, 3, 3, 4 # length 3621 -
3622 [ -1, 1612, 333, 107, 1067 ] 3622 -
3623 [ 2, 1902, 333, 127, 1272 ] 3623 -
3624 #SELECT a+b*2 3624 -
3625 # FROM t1 3625 -
3626 # WHERE e+d BETWEEN a+b-10 AND c+130 3626 -
3627 # OR a>b 3627 -
3628 #; 3628 -
3629 % sys. # table_name 3629 -
3630 # sys.L1 # table_name 3630 -
3631 % L # name 3631 -
3632 # L1 # name 3632 -
3633 % bigint # type 3633 -
3634 % 3 # length 3634 -
3635 [ 317 ] 3635 -
3636 [ 385 ] 3636 -
3637 [ 391 ] 3637 -
3638 [ 439 ] 3638 -
3639 [ 455 ] 3639 -
3640 [ 475 ] 3640 -
3641 [ 483 ] 3641 -
3642 [ 502 ] 3642 -
3643 [ 514 ] 3643 -
3644 [ 529 ] 3644 -
3645 [ 544 ] 3645 -
3646 [ 560 ] 3646 -
3647 [ 595 ] 3647 -
3648 [ 635 ] 3648 -
3649 [ 685 ] 3649 -
3650 [ 698 ] 3650 -
3651 [ 711 ] 3651 -
3652 [ 723 ] 3652 -
3653 #SELECT a+b*2 3653 -
3654 # FROM t1 3654 -
3655 # WHERE e+d BETWEEN a+b-10 AND c+130 3655 -
3656 # OR a>b 3656 -
3657 # ORDER BY 1 3657 -
3658 #; 3658 -
3659 % sys. # table_name 3659 -
3660 # sys.L1 # table_name 3660 -
3661 % L # name 3661 -
3662 # L1 # name 3662 -
3663 % bigint # type 3663 -
3664 % 3 # length 3664 -
3665 [ 317 ] 3665 -
3666 [ 385 ] 3666 -
3667 [ 391 ] 3667 -
3668 [ 439 ] 3668 -
3669 [ 455 ] 3669 -
3670 [ 475 ] 3670 -
3671 [ 483 ] 3671 -
3672 [ 502 ] 3672 -
3673 [ 514 ] 3673 -
3674 [ 529 ] 3674 -
3675 [ 544 ] 3675 -
3676 [ 560 ] 3676 -
3677 [ 595 ] 3677 -
3678 [ 635 ] 3678 -
3679 [ 685 ] 3679 -
3680 [ 698 ] 3680 -
3681 [ 711 ] 3681 -
3682 [ 723 ] 3682 -
3683 #SELECT a+b*2 3683 -
3684 # FROM t1 3684 -
3685 # WHERE a>b 3685 -
3686 # OR e+d BETWEEN a+b-10 AND c+130 3686 -
3687 #; 3687 -
3688 % sys. # table_name 3688 -
3689 # sys.L1 # table_name 3689 -
3690 % L # name 3690 -
3691 # L1 # name 3691 -
3692 % bigint # type 3692 -
3693 % 3 # length 3693 -
3694 [ 317 ] 3694 -
3695 [ 385 ] 3695 -
3696 [ 391 ] 3696 -
3697 [ 439 ] 3697 -
3698 [ 455 ] 3698 -
3699 [ 475 ] 3699 -
3700 [ 483 ] 3700 -
3701 [ 502 ] 3701 -
3702 [ 514 ] 3702 -
3703 [ 529 ] 3703 -
3704 [ 544 ] 3704 -
3705 [ 560 ] 3705 -
3706 [ 595 ] 3706 -
3707 [ 635 ] 3707 -
3708 [ 685 ] 3708 -
3709 [ 698 ] 3709 -
3710 [ 711 ] 3710 -
3711 [ 723 ] 3711 -
3712 #SELECT a+b*2 3712 -
3713 # FROM t1 3713 -
3714 # WHERE a>b 3714 -
3715 # OR e+d BETWEEN a+b-10 AND c+130 3715 -
3716 # ORDER BY 1 3716 -
3717 #; 3717 -
3718 % sys. # table_name 3718 -
3719 # sys.L1 # table_name 3719 -
3720 % L # name 3720 -
3721 # L1 # name 3721 -
3722 % bigint # type 3722 -
3723 % 3 # length 3723 -
3724 [ 317 ] 3724 -
3725 [ 385 ] 3725 -
3726 [ 391 ] 3726 -
3727 [ 439 ] 3727 -
3728 [ 455 ] 3728 -
3729 [ 475 ] 3729 -
3730 [ 483 ] 3730 -
3731 [ 502 ] 3731 -
3732 [ 514 ] 3732 -
3733 [ 529 ] 3733 -
3734 [ 544 ] 3734 -
3735 [ 560 ] 3735 -
3736 [ 595 ] 3736 -
3737 [ 635 ] 3737 -
3738 [ 685 ] 3738 -
3739 [ 698 ] 3739 -
3740 [ 711 ] 3740 -
3741 [ 723 ] 3741 -
3742 #SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222 3742 -
3743 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 3743 -
3744 # a+b*2+c*3+d*4+e*5, 3744 -
3745 # a+b*2, 3745 -
3746 # a, 3746 -
3747 # d-e, 3747 -
3748 # b 3748 -
3749 # FROM t1 3749 -
3750 # WHERE d>e 3750 -
3751 #; 3751 -
3752 % sys., sys., sys., sys.t1, sys., sys.t1 # table_name 3752 -
3753 # sys.L1, sys.L2, sys.L3, sys.t1, sys.L4, sys.t1 # table_name 3753 -
3754 % L, L, L, a, L, b # name 3754 -
3755 # L1, L2, L3, a, L4, b # name 3755 -
3756 % smallint, bigint, bigint, int, bigint, int # type 3756 -
3757 % 3, 4, 3, 3, 1, 3 # length 3757 -
3758 [ 555, NULL, NULL, NULL, 4, 112 ] 3758 -
3759 [ 333, 1902, 385, 127, 2, 129 ] 3759 -
3760 [ 444, 1985, 391, 131, 1, 130 ] 3760 -
3761 [ 111, 2046, 416, 138, 1, 139 ] 3761 -
3762 [ 333, 2432, 483, 163, 2, 160 ] 3762 -
3763 [ 333, 2728, 544, 182, 3, 181 ] 3763 -
3764 [ 222, 3175, 635, 213, 2, 211 ] 3764 -
3765 [ 444, 3331, 666, 220, 1, 223 ] 3765 -
3766 [ 555, 3473, 698, 234, 3, 232 ] 3766 -
3767 [ 555, NULL, 711, 239, 1, 236 ] 3767 -
3768 [ 444, 3706, 743, 245, 2, 249 ] 3768 -
3769 #SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222 3769 -
3770 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, 3770 -
3771 # a+b*2+c*3+d*4+e*5, 3771 -
3772 # a+b*2, 3772 -
3773 # a, 3773 -
3774 # d-e, 3774 -
3775 # b 3775 -
3776 # FROM t1 3776 -
3777 # WHERE d>e 3777 -
3778 # ORDER BY 6,2,1,4,5,3 3778 -
3779 #; 3779 -
3780 % sys., sys., sys., sys.t1, sys., sys.t1 # table_name 3780 -
3781 # sys.L1, sys.L2, sys.L3, sys.t1, sys.L4, sys.t1 # table_name 3781 -
3782 % L, L, L, a, L, b # name 3782 -
3783 # L1, L2, L3, a, L4, b # name 3783 -
3784 % smallint, bigint, bigint, int, bigint, int # type 3784 -
3785 % 3, 4, 3, 3, 1, 3 # length 3785 -
3786 [ 555, NULL, NULL, NULL, 4, 112 ] 3786 -
3787 [ 333, 1902, 385, 127, 2, 129 ] 3787 -
3788 [ 444, 1985, 391, 131, 1, 130 ] 3788 -
3789 [ 111, 2046, 416, 138, 1, 139 ] 3789 -
3790 [ 333, 2432, 483, 163, 2, 160 ] 3790 -
3791 [ 333, 2728, 544, 182, 3, 181 ] 3791 -
3792 [ 222, 3175, 635, 213, 2, 211 ] 3792 -
3793 [ 444, 3331, 666, 220, 1, 223 ] 3793 -
3794 [ 555, 3473, 698, 234, 3, 232 ] 3794 -
3795 [ 555, NULL, 711, 239, 1, 236 ] 3795 -
3796 [ 444, 3706, 743, 245, 2, 249 ] 3796 -
3797 #SELECT a+b*2+c*3+d*4+e*5, 3797 -
3798 # b-c, 3798 -
3799 # abs(a), 3799 -
3800 # abs(b-c), 3800 -
3801 # (a+b+c+d+e)/5, 3801 -
3802 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 3802 -
3803 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END 3803 -
3804 # FROM t1 3804 -
3805 # WHERE (e>a AND e<b) 3805 -
3806 # OR b>c 3806 -
3807 # OR (c<=d-2 OR c>=d+2) 3807 -
3808 #; 3808 -
3809 % sys., sys., sys., sys., sys., sys. # table_name 3809 -
3810 # sys.L1, sys.L2, sys.L3, sys.L4, sys.L5, sys.L6 # table_name 3810 -
3811 % L, L, L, L, L, L # name 3811 -
3812 # L1, L2, L3, L4, L5, L6 # name 3812 -
3813 % bigint, bigint, int, bigint, bigint, smallint # type 3813 -
3814 % 4, 2, 3, 1, 3, 3 # length 3814 -
3815 [ 1612, -1, 107, 1, 107, 333 ] 3815 -
3816 [ NULL, NULL, 115, NULL, NULL, 333 ] 3816 -
3817 [ NULL, 1, 121, 1, NULL, 333 ] 3817 -
3818 [ 1902, 4, 127, 4, 127, 333 ] 3818 -
3819 [ 2046, 2, 138, 2, 137, 111 ] 3819 -
3820 [ 2131, 2, 142, 2, 142, 111 ] 3820 -
3821 [ NULL, 1, 153, 1, NULL, 555 ] 3821 -
3822 [ NULL, 3, 159, 3, NULL, 555 ] 3822 -
3823 [ 2432, -1, 163, 1, 162, 333 ] 3823 -
3824 [ NULL, 1, 168, 1, NULL, 555 ] 3824 -
3825 [ 2806, -1, 188, 1, 187, 444 ] 3825 -
3826 [ 2878, 1, 191, 1, 192, 444 ] 3826 -
3827 [ 2949, 3, 199, 3, 197, 555 ] 3827 -
3828 [ 3175, -3, 213, 3, 212, 222 ] 3828 -
3829 [ 3260, 3, 216, 3, 217, 333 ] 3829 -
3830 [ 3331, -1, 220, 1, 222, 444 ] 3830 -
3831 [ 3399, 3, 229, 3, 227, 555 ] 3831 -
3832 [ 3473, 1, 234, 1, 232, 555 ] 3832 -
3833 [ 3706, 2, 245, 2, 247, 444 ] 3833 -
3834 #SELECT a+b*2+c*3+d*4+e*5, 3834 -
3835 # b-c, 3835 -
3836 # abs(a), 3836 -
3837 # abs(b-c), 3837 -
3838 # (a+b+c+d+e)/5, 3838 -
3839 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 3839 -
3840 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END 3840 -
3841 # FROM t1 3841 -
3842 # WHERE (e>a AND e<b) 3842 -
3843 # OR b>c 3843 -
3844 # OR (c<=d-2 OR c>=d+2) 3844 -
3845 # ORDER BY 2,4,5,3 3845 -
3846 #; 3846 -
3847 % sys., sys., sys., sys., sys., sys. # table_name 3847 -
3848 # sys.L1, sys.L2, sys.L3, sys.L4, sys.L5, sys.L6 # table_name 3848 -
3849 % L, L, L, L, L, L # name 3849 -
3850 # L1, L2, L3, L4, L5, L6 # name 3850 -
3851 % bigint, bigint, int, bigint, bigint, smallint # type 3851 -
3852 % 4, 2, 3, 1, 3, 3 # length 3852 -
3853 [ NULL, NULL, 115, NULL, NULL, 333 ] 3853 -
3854 [ 3175, -3, 213, 3, 212, 222 ] 3854 -
3855 [ 1612, -1, 107, 1, 107, 333 ] 3855 -
3856 [ 2432, -1, 163, 1, 162, 333 ] 3856 -
3857 [ 2806, -1, 188, 1, 187, 444 ] 3857 -
3858 [ 3331, -1, 220, 1, 222, 444 ] 3858 -
3859 [ NULL, 1, 121, 1, NULL, 333 ] 3859 -
3860 [ NULL, 1, 153, 1, NULL, 555 ] 3860 -
3861 [ NULL, 1, 168, 1, NULL, 555 ] 3861 -
3862 [ 2878, 1, 191, 1, 192, 444 ] 3862 -
3863 [ 3473, 1, 234, 1, 232, 555 ] 3863 -
3864 [ 2046, 2, 138, 2, 137, 111 ] 3864 -
3865 [ 2131, 2, 142, 2, 142, 111 ] 3865 -
3866 [ 3706, 2, 245, 2, 247, 444 ] 3866 -
3867 [ NULL, 3, 159, 3, NULL, 555 ] 3867 -
3868 [ 2949, 3, 199, 3, 197, 555 ] 3868 -
3869 [ 3260, 3, 216, 3, 217, 333 ] 3869 -
3870 [ 3399, 3, 229, 3, 227, 555 ] 3870 -
3871 [ 1902, 4, 127, 4, 127, 333 ] 3871 -
3872 #SELECT a+b*2+c*3+d*4+e*5, 3872 -
3873 # b-c, 3873 -
3874 # abs(a), 3874 -
3875 # abs(b-c), 3875 -
3876 # (a+b+c+d+e)/5, 3876 -
3877 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 3877 -
3878 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END 3878 -
3879 # FROM t1 3879 -
3880 # WHERE (c<=d-2 OR c>=d+2) 3880 -
3881 # OR b>c 3881 -
3882 # OR (e>a AND e<b) 3882 -
3883 #; 3883 -
3884 % sys., sys., sys., sys., sys., sys. # table_name 3884 -
3885 # sys.L1, sys.L2, sys.L3, sys.L4, sys.L5, sys.L6 # table_name 3885 -
3886 % L, L, L, L, L, L # name 3886 -
3887 # L1, L2, L3, L4, L5, L6 # name 3887 -
3888 % bigint, bigint, int, bigint, bigint, smallint # type 3888 -
3889 % 4, 2, 3, 1, 3, 3 # length 3889 -
3890 [ 1612, -1, 107, 1, 107, 333 ] 3890 -
3891 [ NULL, NULL, 115, NULL, NULL, 333 ] 3891 -
3892 [ NULL, 1, 121, 1, NULL, 333 ] 3892 -
3893 [ 1902, 4, 127, 4, 127, 333 ] 3893 -
3894 [ 2046, 2, 138, 2, 137, 111 ] 3894 -
3895 [ 2131, 2, 142, 2, 142, 111 ] 3895 -
3896 [ NULL, 1, 153, 1, NULL, 555 ] 3896 -
3897 [ NULL, 3, 159, 3, NULL, 555 ] 3897 -
3898 [ 2432, -1, 163, 1, 162, 333 ] 3898 -
3899 [ NULL, 1, 168, 1, NULL, 555 ] 3899 -
3900 [ 2806, -1, 188, 1, 187, 444 ] 3900 -
3901 [ 2878, 1, 191, 1, 192, 444 ] 3901 -
3902 [ 2949, 3, 199, 3, 197, 555 ] 3902 -
3903 [ 3175, -3, 213, 3, 212, 222 ] 3903 -
3904 [ 3260, 3, 216, 3, 217, 333 ] 3904 -
3905 [ 3331, -1, 220, 1, 222, 444 ] 3905 -
3906 [ 3399, 3, 229, 3, 227, 555 ] 3906 -
3907 [ 3473, 1, 234, 1, 232, 555 ] 3907 -
3908 [ 3706, 2, 245, 2, 247, 444 ] 3908 -
3909 #SELECT a+b*2+c*3+d*4+e*5, 3909 -
3910 # b-c, 3910 -
3911 # abs(a), 3911 -
3912 # abs(b-c), 3912 -
3913 # (a+b+c+d+e)/5, 3913 -
3914 # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 3914 -
3915 # WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END 3915 -
3916 # FROM t1 3916 -
3917 # WHERE (c<=d-2 OR c>=d+2) 3917 -
3918 # OR b>c 3918 -
3919 # OR (e>a AND e<b) 3919 -
3920 # ORDER BY 3,4,6,1,5 3920 -
3921 #; 3921 -
3922 % sys., sys., sys., sys., sys., sys. # table_name 3922 -
3923 # sys.L1, sys.L2, sys.L3, sys.L4, sys.L5, sys.L6 # table_name 3923 -
3924 % L, L, L, L, L, L # name 3924 -
3925 # L1, L2, L3, L4, L5, L6 # name 3925 -
3926 % bigint, bigint, int, bigint, bigint, smallint # type 3926 -
3927 % 4, 2, 3, 1, 3, 3 # length 3927 -
3928 [ 1612, -1, 107, 1, 107, 333 ] 3928 -
3929 [ NULL, NULL, 115, NULL, NULL, 333 ] 3929 -
3930 [ NULL, 1, 121, 1, NULL, 333 ] 3930 -
3931 [ 1902, 4, 127, 4, 127, 333 ] 3931 -
3932 [ 2046, 2, 138, 2, 137, 111 ] 3932 -
3933 [ 2131, 2, 142, 2, 142, 111 ] 3933 -
3934 [ NULL, 1, 153, 1, NULL, 555 ] 3934 -
3935 [ NULL, 3, 159, 3, NULL, 555 ] 3935 -
3936 [ 2432, -1, 163, 1, 162, 333 ] 3936 -
3937 [ NULL, 1, 168, 1, NULL, 555 ] 3937 -
3938 [ 2806, -1, 188, 1, 187, 444 ] 3938 -
3939 [ 2878, 1, 191, 1, 192, 444 ] 3939 -
3940 [ 2949, 3, 199, 3, 197, 555 ] 3940 -
3941 [ 3175, -3, 213, 3, 212, 222 ] 3941 -
3942 [ 3260, 3, 216, 3, 217, 333 ] 3942 -
3943 [ 3331, -1, 220, 1, 222, 444 ] 3943 -
3944 [ 3399, 3, 229, 3, 227, 555 ] 3944 -
3945 [ 3473, 1, 234, 1, 232, 555 ] 3945 -
3946 [ 3706, 2, 245, 2, 247, 444 ] 3946 -
3947 #SELECT e, 3947 -
3948 # a+b*2+c*3+d*4, 3948 -
3949 # a+b*2+c*3+d*4+e*5 3949 -
3950 # FROM t1 3950 -
3951 # WHERE (e>a AND e<b) 3951 -
3952 # OR (c<=d-2 OR c>=d+2) 3952 -
3953 #; 3953 -
3954 % sys.t1, sys., sys. # table_name 3954 -
3955 # sys.t1, sys.L1, sys.L2 # table_name 3955 -
3956 % e, L, L # name 3956 -
3957 # e, L1, L2 # name 3957 -
3958 % int, bigint, bigint # type 3958 -
3959 % 3, 4, 4 # length 3959 -
3960 [ 109, 1067, 1612 ] 3960 -
3961 [ 117, NULL, NULL ] 3961 -
3962 [ 126, 1272, 1902 ] 3962 -
3963 [ 162, 1622, 2432 ] 3963 -
3964 [ 189, 1861, 2806 ] 3964 -
3965 [ 192, 1918, 2878 ] 3965 -
3966 [ 210, 2125, 3175 ] 3966 -
3967 [ 219, 2165, 3260 ] 3967 -
3968 [ 221, 2226, 3331 ] 3968 -
3969 [ 230, 2323, 3473 ] 3969 -
3970 [ 246, 2476, 3706 ] 3970 -
3971 #SELECT e, 3971 -
3972 # a+b*2+c*3+d*4, 3972 -
3973 # a+b*2+c*3+d*4+e*5 3973 -
3974 # FROM t1 3974 -
3975 # WHERE (e>a AND e<b) 3975 -
3976 # OR (c<=d-2 OR c>=d+2) 3976 -
3977 # ORDER BY 2,1 3977 -
3978 #; 3978 -
3979 % sys.t1, sys., sys. # table_name 3979 -
3980 # sys.t1, sys.L1, sys.L2 # table_name 3980 -
3981 % e, L, L # name 3981 -
3982 # e, L1, L2 # name 3982 -
3983 % int, bigint, bigint # type 3983 -
3984 % 3, 4, 4 # length 3984 -
3985 [ 117, NULL, NULL ] 3985 -
3986 [ 109, 1067, 1612 ] 3986 -
3987 [ 126, 1272, 1902 ] 3987 -
3988 [ 162, 1622, 2432 ] 3988 -
3989 [ 189, 1861, 2806 ] 3989 -
3990 [ 192, 1918, 2878 ] 3990 -
3991 [ 210, 2125, 3175 ] 3991 -
3992 [ 219, 2165, 3260 ] 3992 -
3993 [ 221, 2226, 3331 ] 3993 -
3994 [ 230, 2323, 3473 ] 3994 -
3995 [ 246, 2476, 3706 ] 3995 -
3996 #SELECT e, 3996 -
3997 # a+b*2+c*3+d*4, 3997 -
3998 # a+b*2+c*3+d*4+e*5 3998 -
3999 # FROM t1 3999 -
4000 # WHERE (c<=d-2 OR c>=d+2) 4000 -
4001 # OR (e>a AND e<b) 4001 -
4002 #; 4002 -
4003 % sys.t1, sys., sys. # table_name 4003 -
4004 # sys.t1, sys.L1, sys.L2 # table_name 4004 -
4005 % e, L, L # name 4005 -
4006 # e, L1, L2 # name 4006 -
4007 % int, bigint, bigint # type 4007 -
4008 % 3, 4, 4 # length 4008 -
4009 [ 109, 1067, 1612 ] 4009 -
4010 [ 117, NULL, NULL ] 4010 -
4011 [ 126, 1272, 1902 ] 4011 -
4012 [ 162, 1622, 2432 ] 4012 -
4013 [ 189, 1861, 2806 ] 4013 -
4014 [ 192, 1918, 2878 ] 4014 -
4015 [ 210, 2125, 3175 ] 4015 -
4016 [ 219, 2165, 3260 ] 4016 -
4017 [ 221, 2226, 3331 ] 4017 -
4018 [ 230, 2323, 3473 ] 4018 -
4019 [ 246, 2476, 3706 ] 4019 -
4020 #SELECT e, 4020 -
4021 # a+b*2+c*3+d*4, 4021 -
4022 # a+b*2+c*3+d*4+e*5 4022 -
4023 # FROM t1 4023 -
4024 # WHERE (c<=d-2 OR c>=d+2) 4024 -
4025 # OR (e>a AND e<b) 4025 -
4026 # ORDER BY 2,1,3 4026 -
4027 #; 4027 -
4028 % sys.t1, sys., sys. # table_name 4028 -
4029 # sys.t1, sys.L1, sys.L2 # table_name 4029 -
4030 % e, L, L # name 4030 -
4031 # e, L1, L2 # name 4031 -
4032 % int, bigint, bigint # type 4032 -
4033 % 3, 4, 4 # length 4033 -
4034 [ 117, NULL, NULL ] 4034 -
4035 [ 109, 1067, 1612 ] 4035 -
4036 [ 126, 1272, 1902 ] 4036 -
4037 [ 162, 1622, 2432 ] 4037 -
4038 [ 189, 1861, 2806 ] 4038 -
4039 [ 192, 1918, 2878 ] 4039 -
4040 [ 210, 2125, 3175 ] 4040 -
4041 [ 219, 2165, 3260 ] 4041 -
4042 [ 221, 2226, 3331 ] 4042 -
4043 [ 230, 2323, 3473 ] 4043 -
4044 [ 246, 2476, 3706 ] 4044 -
4045 #SELECT (a+b+c+d+e)/5, 4045 -
4046 # d-e, 4046 -
4047 # d 4047 -
4048 # FROM t1 4048 -
4049 # WHERE d NOT BETWEEN 110 AND 150 4049 -
4050 # AND d>e 4050 -
4051 #; 4051 -
4052 % sys., sys., sys.t1 # table_name 4052 -
4053 # sys.L1, sys.L2, sys.t1 # table_name 4053 -
4054 % L, L, d # name 4054 -
4055 # L1, L2, d # name 4055 -
4056 % bigint, bigint, int # type 4056 -
4057 % 3, 1, 3 # length 4057 -
4058 [ 162, 2, 164 ] 4058 -
4059 [ 182, 3, 183 ] 4059 -
4060 [ 212, 2, 212 ] 4060 -
4061 [ 222, 1, 222 ] 4061 -
4062 [ 232, 3, 233 ] 4062 -
4063 [ NULL, 1, 238 ] 4063 -
4064 [ 247, 2, 248 ] 4064 -
4065 #SELECT (a+b+c+d+e)/5, 4065 -
4066 # d-e, 4066 -
4067 # d 4067 -
4068 # FROM t1 4068 -
4069 # WHERE d NOT BETWEEN 110 AND 150 4069 -
4070 # AND d>e 4070 -
4071 # ORDER BY 1,2,3 4071 -
4072 #; 4072 -
4073 % sys., sys., sys.t1 # table_name 4073 -
4074 # sys.L1, sys.L2, sys.t1 # table_name 4074 -
4075 % L, L, d # name 4075 -
4076 # L1, L2, d # name 4076 -
4077 % bigint, bigint, int # type 4077 -
4078 % 3, 1, 3 # length 4078 -
4079 [ NULL, 1, 238 ] 4079 -
4080 [ 162, 2, 164 ] 4080 -
4081 [ 182, 3, 183 ] 4081 -
4082 [ 212, 2, 212 ] 4082 -
4083 [ 222, 1, 222 ] 4083 -
4084 [ 232, 3, 233 ] 4084 -
4085 [ 247, 2, 248 ] 4085 -
4086 #SELECT (a+b+c+d+e)/5, 4086 -
4087 # d-e, 4087 -
4088 # d 4088 -
4089 # FROM t1 4089 -
4090 # WHERE d>e 4090 -
4091 # AND d NOT BETWEEN 110 AND 150 4091 -
4092 #; 4092 -
4093 % sys., sys., sys.t1 # table_name 4093 -
4094 # sys.L1, sys.L2, sys.t1 # table_name 4094 -
4095 % L, L, d # name 4095 -
4096 # L1, L2, d # name 4096 -
4097 % bigint, bigint, int # type 4097 -
4098 % 3, 1, 3 # length 4098 -
4099 [ 162, 2, 164 ] 4099 -
4100 [ 182, 3, 183 ] 4100 -
4101 [ 212, 2, 212 ] 4101 -
4102 [ 222, 1, 222 ] 4102 -
4103 [ 232, 3, 233 ] 4103 -
4104 [ NULL, 1, 238 ] 4104 -
4105 [ 247, 2, 248 ] 4105 -
4106 #SELECT (a+b+c+d+e)/5, 4106 -
4107 # d-e, 4107 -
4108 # d 4108 -
4109 # FROM t1 4109 -
4110 # WHERE d>e 4110 -
4111 # AND d NOT BETWEEN 110 AND 150 4111 -
4112 # ORDER BY 2,3,1 4112 -
4113 #; 4113 -
4114 % sys., sys., sys.t1 # table_name 4114 -
4115 # sys.L1, sys.L2, sys.t1 # table_name 4115 -
4116 % L, L, d # name 4116 -
4117 # L1, L2, d # name 4117 -
4118 % bigint, bigint, int # type 4118 -
4119 % 3, 1, 3 # length 4119 -
4120 [ 222, 1, 222 ] 4120 -
4121 [ NULL, 1, 238 ] 4121 -
4122 [ 162, 2, 164 ] 4122 -
4123 [ 212, 2, 212 ] 4123 -
4124 [ 247, 2, 248 ] 4124 -
4125 [ 182, 3, 183 ] 4125 -
4126 [ 232, 3, 233 ] 4126 -
4127 #SELECT a, 4127 -
4128 # b-c, 4128 -
4129 # CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 4129 -
4130 # WHEN a<b+3 THEN 333 ELSE 444 END 4130 -
4131 # FROM t1 4131 -
4132 #; 4132 -
4133 % sys.t1, sys., sys. # table_name 4133 -
4134 # sys.t1, sys.L1, sys.L2 # table_name 4134 -
4135 % a, L, L # name 4135 -
4136 # a, L1, L2 # name 4136 -
4137 % int, bigint, smallint # type 4137 -
4138 % 3, 2, 3 # length 4138 -
4139 [ 104, NULL, 444 ] 4139 -
4140 [ 107, -1, 333 ] 4140 -
4141 [ NULL, -1, 444 ] 4141 -
4142 [ 115, NULL, 444 ] 4142 -
4143 [ 121, 1, 222 ] 4143 -
4144 [ 127, 4, 222 ] 4144 -
4145 [ 131, -4, 333 ] 4145 -
4146 [ 138, 2, 222 ] 4146 -
4147 [ 142, 2, 222 ] 4147 -
4148 [ 149, -2, 444 ] 4148 -
4149 [ 153, 1, 333 ] 4149 -
4150 [ 159, 3, 333 ] 4150 -
4151 [ 163, -1, 444 ] 4151 -
4152 [ 168, 1, 333 ] 4152 -
4153 [ 174, -2, 444 ] 4153 -
4154 [ 179, -1, 444 ] 4154 -
4155 [ 182, -3, 333 ] 4155 -
4156 [ 188, -1, 333 ] 4156 -
4157 [ 191, 1, 222 ] 4157 -
4158 [ 199, 3, 333 ] 4158 -
4159 [ 201, NULL, 444 ] 4159 -
4160 [ NULL, -2, 444 ] 4160 -
4161 [ 213, -3, 333 ] 4161 -
4162 [ 216, 3, 222 ] 4162 -
4163 [ 220, -1, 222 ] 4163 -
4164 [ 229, 3, 333 ] 4164 -
4165 [ 234, 1, 333 ] 4165 -
4166 [ 239, NULL, 444 ] 4166 -
4167 [ 243, -4, 444 ] 4167 -
4168 [ 245, 2, 111 ] 4168 -
4169 #SELECT a, 4169 -
4170 # b-c, 4170 -
4171 # CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 4171 -
4172 # WHEN a<b+3 THEN 333 ELSE 444 END 4172 -
4173 # FROM t1 4173 -
4174 # ORDER BY 1,3 4174 -
4175 #; 4175 -
4176 % sys.t1, sys., sys. # table_name 4176 -
4177 # sys.t1, sys.L1, sys.L2 # table_name 4177 -
4178 % a, L, L # name 4178 -
4179 # a, L1, L2 # name 4179 -
4180 % int, bigint, smallint # type 4180 -
4181 % 3, 2, 3 # length 4181 -
4182 [ NULL, -1, 444 ] 4182 -
4183 [ NULL, -2, 444 ] 4183 -
4184 [ 104, NULL, 444 ] 4184 -
4185 [ 107, -1, 333 ] 4185 -
4186 [ 115, NULL, 444 ] 4186 -
4187 [ 121, 1, 222 ] 4187 -
4188 [ 127, 4, 222 ] 4188 -
4189 [ 131, -4, 333 ] 4189 -
4190 [ 138, 2, 222 ] 4190 -
4191 [ 142, 2, 222 ] 4191 -
4192 [ 149, -2, 444 ] 4192 -
4193 [ 153, 1, 333 ] 4193 -
4194 [ 159, 3, 333 ] 4194 -
4195 [ 163, -1, 444 ] 4195 -
4196 [ 168, 1, 333 ] 4196 -
4197 [ 174, -2, 444 ] 4197 -
4198 [ 179, -1, 444 ] 4198 -
4199 [ 182, -3, 333 ] 4199 -
4200 [ 188, -1, 333 ] 4