bad performance of LIMIT/OFFSET
SELECT col1 FROM tbl WHERE col1 = 1 ; is executed in 5 ms. Table has 1 billion rows, resultset is about 350 rows. Same statement, but with LIMIT/OFFSET SELECT col1 FROM tbl WHERE col1 = 1 LIMIT 1 OFFSET 0 ; is executed in 1,03 s. Can't believe that subsetting from 350 to 1 takes 1 second.
Forgot to append the EXPLAIN output: EXPLAIN SELECT vkont FROM sapsr3.dfkkop WHERE vkont = '000802037649' ; mal -------------------------------------------------------------------------------------------------------------------------------------- function user.s9_3{autoCommit=true}(A0:str):void; X_3 := sql.mvc(); X_7 := sql.bind(X_3,"sapsr3","dfkkop","vkont",0); X_4:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop"); X_39 := algebra.subselect(X_7,X_4,A0,A0,true,true,false); (X_10,r1_10) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2); X_40 := algebra.subselect(r1_10,A0,A0,true,true,false); X_13 := sql.bind(X_3,"sapsr3","dfkkop","vkont",1); X_41 := algebra.subselect(X_13,X_4,A0,A0,true,true,false); X_15 := sql.subdelta(X_39,X_4,X_10,X_40,X_41); X_17 := sql.projectdelta(X_15,X_7,X_10,r1_10,X_13); X_18 := sql.resultSet(1,1,X_17); sql.rsColumn(X_18,"sapsr3.dfkkop","vkont","varchar",12,0,X_17); X_23 := io.stdout(); sql.exportResult(X_23,X_18); end s9_3; # querylog.define("explain\nselect\n\tvkont\nfrom\n\tsapsr3.dfkkop\nwhere\n\t--1=1 and\n\tvkont = \\'000802037649\\';","default_pipe") # optimizer.mitosis() # optimizer.dataflow() EXPLAIN SELECT vkont FROM sapsr3.dfkkop WHERE vkont = '000802037649' LIMIT 1 OFFSET 0 ; mal -------------------------------------------------------------------------------------------------------------------------------------------------------- function user.s10_3{autoCommit=true}(A0:str):void; barrier X_696 := language.dataflow(); X_3 := sql.mvc(); X_88:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,0,24); X_39:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",0,24); X_259 := algebra.subselect(X_88,X_39,A0,A0,true,true,false); (X_138:bat[:oid,:oid] ,X_139:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,0,24); X_307 := algebra.subselect(X_139,A0,A0,true,true,false); X_355 := sql.subdelta(X_259,X_39,X_138,X_307); X_403 := sql.projectdelta(X_355,X_88,X_138,X_139); X_452 := algebra.subslice(X_403,0:wrd,0:wrd); X_90:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,1,24); X_41:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",1,24); X_261 := algebra.subselect(X_90,X_41,A0,A0,true,true,false); (X_141:bat[:oid,:oid] ,X_142:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,1,24); X_309 := algebra.subselect(X_142,A0,A0,true,true,false); X_357 := sql.subdelta(X_261,X_41,X_141,X_309); X_405 := sql.projectdelta(X_357,X_90,X_141,X_142); X_453 := algebra.subslice(X_405,0:wrd,0:wrd); X_92:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,2,24); X_43:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",2,24); X_263 := algebra.subselect(X_92,X_43,A0,A0,true,true,false); (X_144:bat[:oid,:oid] ,X_145:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,2,24); X_311 := algebra.subselect(X_145,A0,A0,true,true,false); X_359 := sql.subdelta(X_263,X_43,X_144,X_311); X_407 := sql.projectdelta(X_359,X_92,X_144,X_145); X_454 := algebra.subslice(X_407,0:wrd,0:wrd); X_94:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,3,24); X_45:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",3,24); X_265 := algebra.subselect(X_94,X_45,A0,A0,true,true,false); (X_147:bat[:oid,:oid] ,X_148:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,3,24); X_313 := algebra.subselect(X_148,A0,A0,true,true,false); X_361 := sql.subdelta(X_265,X_45,X_147,X_313); X_409 := sql.projectdelta(X_361,X_94,X_147,X_148); X_455 := algebra.subslice(X_409,0:wrd,0:wrd); X_96:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,4,24); X_47:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",4,24); X_267 := algebra.subselect(X_96,X_47,A0,A0,true,true,false); (X_150:bat[:oid,:oid] ,X_151:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,4,24); X_315 := algebra.subselect(X_151,A0,A0,true,true,false); X_363 := sql.subdelta(X_267,X_47,X_150,X_315); X_411 := sql.projectdelta(X_363,X_96,X_150,X_151); X_456 := algebra.subslice(X_411,0:wrd,0:wrd); X_98:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,5,24); X_49:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",5,24); X_269 := algebra.subselect(X_98,X_49,A0,A0,true,true,false); (X_153:bat[:oid,:oid] ,X_154:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,5,24); X_317 := algebra.subselect(X_154,A0,A0,true,true,false); X_365 := sql.subdelta(X_269,X_49,X_153,X_317); X_413 := sql.projectdelta(X_365,X_98,X_153,X_154); X_457 := algebra.subslice(X_413,0:wrd,0:wrd); X_100:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,6,24); X_51:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",6,24); X_271 := algebra.subselect(X_100,X_51,A0,A0,true,true,false); (X_156:bat[:oid,:oid] ,X_157:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,6,24); X_319 := algebra.subselect(X_157,A0,A0,true,true,false); X_367 := sql.subdelta(X_271,X_51,X_156,X_319); X_415 := sql.projectdelta(X_367,X_100,X_156,X_157); X_458 := algebra.subslice(X_415,0:wrd,0:wrd); X_102:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,7,24); X_53:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",7,24); X_273 := algebra.subselect(X_102,X_53,A0,A0,true,true,false); (X_159:bat[:oid,:oid] ,X_160:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,7,24); X_321 := algebra.subselect(X_160,A0,A0,true,true,false); X_369 := sql.subdelta(X_273,X_53,X_159,X_321); X_417 := sql.projectdelta(X_369,X_102,X_159,X_160); X_459 := algebra.subslice(X_417,0:wrd,0:wrd); X_105:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,8,24); X_55:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",8,24); X_275 := algebra.subselect(X_105,X_55,A0,A0,true,true,false); (X_162:bat[:oid,:oid] ,X_163:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,8,24); X_323 := algebra.subselect(X_163,A0,A0,true,true,false); X_371 := sql.subdelta(X_275,X_55,X_162,X_323); X_419 := sql.projectdelta(X_371,X_105,X_162,X_163); X_460 := algebra.subslice(X_419,0:wrd,0:wrd); X_107:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,9,24); X_57:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",9,24); X_277 := algebra.subselect(X_107,X_57,A0,A0,true,true,false); (X_165:bat[:oid,:oid] ,X_166:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,9,24); X_325 := algebra.subselect(X_166,A0,A0,true,true,false); X_373 := sql.subdelta(X_277,X_57,X_165,X_325); X_421 := sql.projectdelta(X_373,X_107,X_165,X_166); X_461 := algebra.subslice(X_421,0:wrd,0:wrd); X_109:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,10,24); X_59:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",10,24); X_279 := algebra.subselect(X_109,X_59,A0,A0,true,true,false); (X_168:bat[:oid,:oid] ,X_169:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,10,24); X_327 := algebra.subselect(X_169,A0,A0,true,true,false); X_375 := sql.subdelta(X_279,X_59,X_168,X_327); X_423 := sql.projectdelta(X_375,X_109,X_168,X_169); X_462 := algebra.subslice(X_423,0:wrd,0:wrd); X_111:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,11,24); X_61:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",11,24); X_281 := algebra.subselect(X_111,X_61,A0,A0,true,true,false); (X_172:bat[:oid,:oid] ,X_173:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,11,24); X_329 := algebra.subselect(X_173,A0,A0,true,true,false); X_377 := sql.subdelta(X_281,X_61,X_172,X_329); X_425 := sql.projectdelta(X_377,X_111,X_172,X_173); X_463 := algebra.subslice(X_425,0:wrd,0:wrd); X_113:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,12,24); X_63:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",12,24); X_283 := algebra.subselect(X_113,X_63,A0,A0,true,true,false); (X_175:bat[:oid,:oid] ,X_176:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,12,24); X_331 := algebra.subselect(X_176,A0,A0,true,true,false); X_379 := sql.subdelta(X_283,X_63,X_175,X_331); X_427 := sql.projectdelta(X_379,X_113,X_175,X_176); X_464 := algebra.subslice(X_427,0:wrd,0:wrd); X_115:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,13,24); X_65:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",13,24); X_285 := algebra.subselect(X_115,X_65,A0,A0,true,true,false); (X_178:bat[:oid,:oid] ,X_179:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,13,24); X_333 := algebra.subselect(X_179,A0,A0,true,true,false); X_381 := sql.subdelta(X_285,X_65,X_178,X_333); X_429 := sql.projectdelta(X_381,X_115,X_178,X_179); X_465 := algebra.subslice(X_429,0:wrd,0:wrd); X_117:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,14,24); X_67:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",14,24); X_287 := algebra.subselect(X_117,X_67,A0,A0,true,true,false); (X_181:bat[:oid,:oid] ,X_182:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,14,24); X_335 := algebra.subselect(X_182,A0,A0,true,true,false); X_383 := sql.subdelta(X_287,X_67,X_181,X_335); X_431 := sql.projectdelta(X_383,X_117,X_181,X_182); X_466 := algebra.subslice(X_431,0:wrd,0:wrd); X_119:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,15,24); X_69:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",15,24); X_289 := algebra.subselect(X_119,X_69,A0,A0,true,true,false); (X_184:bat[:oid,:oid] ,X_185:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,15,24); X_337 := algebra.subselect(X_185,A0,A0,true,true,false); X_385 := sql.subdelta(X_289,X_69,X_184,X_337); X_433 := sql.projectdelta(X_385,X_119,X_184,X_185); X_467 := algebra.subslice(X_433,0:wrd,0:wrd); X_121:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,16,24); X_72:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",16,24); X_291 := algebra.subselect(X_121,X_72,A0,A0,true,true,false); (X_187:bat[:oid,:oid] ,X_188:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,16,24); X_339 := algebra.subselect(X_188,A0,A0,true,true,false); X_387 := sql.subdelta(X_291,X_72,X_187,X_339); X_435 := sql.projectdelta(X_387,X_121,X_187,X_188); X_468 := algebra.subslice(X_435,0:wrd,0:wrd); X_123:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,17,24); X_74:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",17,24); X_293 := algebra.subselect(X_123,X_74,A0,A0,true,true,false); (X_190:bat[:oid,:oid] ,X_191:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,17,24); X_341 := algebra.subselect(X_191,A0,A0,true,true,false); X_389 := sql.subdelta(X_293,X_74,X_190,X_341); X_437 := sql.projectdelta(X_389,X_123,X_190,X_191); X_469 := algebra.subslice(X_437,0:wrd,0:wrd); X_125:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,18,24); X_76:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",18,24); X_295 := algebra.subselect(X_125,X_76,A0,A0,true,true,false); (X_193:bat[:oid,:oid] ,X_194:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,18,24); X_343 := algebra.subselect(X_194,A0,A0,true,true,false); X_391 := sql.subdelta(X_295,X_76,X_193,X_343); X_439 := sql.projectdelta(X_391,X_125,X_193,X_194); X_470 := algebra.subslice(X_439,0:wrd,0:wrd); X_127:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,19,24); X_78:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",19,24); X_297 := algebra.subselect(X_127,X_78,A0,A0,true,true,false); (X_196:bat[:oid,:oid] ,X_197:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,19,24); X_345 := algebra.subselect(X_197,A0,A0,true,true,false); X_393 := sql.subdelta(X_297,X_78,X_196,X_345); X_441 := sql.projectdelta(X_393,X_127,X_196,X_197); X_471 := algebra.subslice(X_441,0:wrd,0:wrd); X_129:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,20,24); X_80:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",20,24); X_299 := algebra.subselect(X_129,X_80,A0,A0,true,true,false); (X_199:bat[:oid,:oid] ,X_200:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,20,24); X_347 := algebra.subselect(X_200,A0,A0,true,true,false); X_395 := sql.subdelta(X_299,X_80,X_199,X_347); X_443 := sql.projectdelta(X_395,X_129,X_199,X_200); X_472 := algebra.subslice(X_443,0:wrd,0:wrd); X_131:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,21,24); X_82:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",21,24); X_301 := algebra.subselect(X_131,X_82,A0,A0,true,true,false); (X_202:bat[:oid,:oid] ,X_203:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,21,24); X_349 := algebra.subselect(X_203,A0,A0,true,true,false); X_397 := sql.subdelta(X_301,X_82,X_202,X_349); X_445 := sql.projectdelta(X_397,X_131,X_202,X_203); X_473 := algebra.subslice(X_445,0:wrd,0:wrd); X_133:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,22,24); X_84:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",22,24); X_303 := algebra.subselect(X_133,X_84,A0,A0,true,true,false); (X_206:bat[:oid,:oid] ,X_207:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,22,24); X_351 := algebra.subselect(X_207,A0,A0,true,true,false); X_399 := sql.subdelta(X_303,X_84,X_206,X_351); X_447 := sql.projectdelta(X_399,X_133,X_206,X_207); X_474 := algebra.subslice(X_447,0:wrd,0:wrd); X_135:bat[:oid,:str] := sql.bind(X_3,"sapsr3","dfkkop","vkont",0,23,24); X_86:bat[:oid,:oid] := sql.tid(X_3,"sapsr3","dfkkop",23,24); X_305 := algebra.subselect(X_135,X_86,A0,A0,true,true,false); (X_209:bat[:oid,:oid] ,X_210:bat[:oid,:str] ) := sql.bind(X_3,"sapsr3","dfkkop","vkont",2,23,24); X_353 := algebra.subselect(X_210,A0,A0,true,true,false); X_9 := sql.bind(X_3,"sapsr3","dfkkop","vkont",1); X_36 := algebra.subselect(X_9,X_86,A0,A0,true,true,false); X_401 := sql.subdelta(X_305,X_86,X_209,X_353,X_36); X_449 := sql.projectdelta(X_401,X_135,X_209,X_210,X_9); X_475 := algebra.subslice(X_449,0:wrd,0:wrd); X_502 := mat.packIncrement(X_452,24); X_504 := mat.packIncrement(X_502,X_453); X_505 := mat.packIncrement(X_504,X_454); X_506 := mat.packIncrement(X_505,X_455); X_507 := mat.packIncrement(X_506,X_456); X_508 := mat.packIncrement(X_507,X_457); X_509 := mat.packIncrement(X_508,X_458); X_510 := mat.packIncrement(X_509,X_459); X_511 := mat.packIncrement(X_510,X_460); X_512 := mat.packIncrement(X_511,X_461); X_513 := mat.packIncrement(X_512,X_462); X_514 := mat.packIncrement(X_513,X_463); X_515 := mat.packIncrement(X_514,X_464); X_516 := mat.packIncrement(X_515,X_465); X_517 := mat.packIncrement(X_516,X_466); X_518 := mat.packIncrement(X_517,X_467); X_519 := mat.packIncrement(X_518,X_468); X_520 := mat.packIncrement(X_519,X_469); X_521 := mat.packIncrement(X_520,X_470); X_522 := mat.packIncrement(X_521,X_471); X_523 := mat.packIncrement(X_522,X_472); X_524 := mat.packIncrement(X_523,X_473); X_525 := mat.packIncrement(X_524,X_474); X_476 := mat.packIncrement(X_525,X_475); X_13 := algebra.subslice(X_476,0:wrd,0:wrd); X_478 := algebra.leftfetchjoin(X_452,X_403); X_479 := algebra.leftfetchjoin(X_453,X_405); X_480 := algebra.leftfetchjoin(X_454,X_407); X_481 := algebra.leftfetchjoin(X_455,X_409); X_482 := algebra.leftfetchjoin(X_456,X_411); X_483 := algebra.leftfetchjoin(X_457,X_413); X_484 := algebra.leftfetchjoin(X_458,X_415); X_485 := algebra.leftfetchjoin(X_459,X_417); X_486 := algebra.leftfetchjoin(X_460,X_419); X_487 := algebra.leftfetchjoin(X_461,X_421); X_488 := algebra.leftfetchjoin(X_462,X_423); X_489 := algebra.leftfetchjoin(X_463,X_425); X_490 := algebra.leftfetchjoin(X_464,X_427); X_491 := algebra.leftfetchjoin(X_465,X_429); X_492 := algebra.leftfetchjoin(X_466,X_431); X_493 := algebra.leftfetchjoin(X_467,X_433); X_494 := algebra.leftfetchjoin(X_468,X_435); X_495 := algebra.leftfetchjoin(X_469,X_437); X_496 := algebra.leftfetchjoin(X_470,X_439); X_497 := algebra.leftfetchjoin(X_471,X_441); X_498 := algebra.leftfetchjoin(X_472,X_443); X_499 := algebra.leftfetchjoin(X_473,X_445); X_500 := algebra.leftfetchjoin(X_474,X_447); X_501 := algebra.leftfetchjoin(X_475,X_449); X_527 := mat.packIncrement(X_478,24); X_528 := mat.packIncrement(X_527,X_479); X_529 := mat.packIncrement(X_528,X_480); X_530 := mat.packIncrement(X_529,X_481); X_531 := mat.packIncrement(X_530,X_482); X_532 := mat.packIncrement(X_531,X_483); X_533 := mat.packIncrement(X_532,X_484); X_534 := mat.packIncrement(X_533,X_485); X_535 := mat.packIncrement(X_534,X_486); X_536 := mat.packIncrement(X_535,X_487); X_537 := mat.packIncrement(X_536,X_488); X_538 := mat.packIncrement(X_537,X_489); X_539 := mat.packIncrement(X_538,X_490); X_540 := mat.packIncrement(X_539,X_491); X_541 := mat.packIncrement(X_540,X_492); X_542 := mat.packIncrement(X_541,X_493); X_543 := mat.packIncrement(X_542,X_494); X_544 := mat.packIncrement(X_543,X_495); X_545 := mat.packIncrement(X_544,X_496); X_546 := mat.packIncrement(X_545,X_497); X_547 := mat.packIncrement(X_546,X_498); X_548 := mat.packIncrement(X_547,X_499); X_549 := mat.packIncrement(X_548,X_500); X_477 := mat.packIncrement(X_549,X_501); X_14 := algebra.leftfetchjoin(X_13,X_477); language.pass(X_39); language.pass(X_88); language.pass(X_138); language.pass(X_139); language.pass(X_41); language.pass(X_90); language.pass(X_141); language.pass(X_142); language.pass(X_43); language.pass(X_92); language.pass(X_144); language.pass(X_145); language.pass(X_45); language.pass(X_94); language.pass(X_147); language.pass(X_148); language.pass(X_47); language.pass(X_96); language.pass(X_150); language.pass(X_151); language.pass(X_49); language.pass(X_98); language.pass(X_153); language.pass(X_154); language.pass(X_51); language.pass(X_100); language.pass(X_156); language.pass(X_157); language.pass(X_53); language.pass(X_102); language.pass(X_159); language.pass(X_160); language.pass(X_55); language.pass(X_105); language.pass(X_162); language.pass(X_163); language.pass(X_57); language.pass(X_107); language.pass(X_165); language.pass(X_166); language.pass(X_59); language.pass(X_109); language.pass(X_168); language.pass(X_169); language.pass(X_61); language.pass(X_111); language.pass(X_172); language.pass(X_173); language.pass(X_63); language.pass(X_113); language.pass(X_175); language.pass(X_176); language.pass(X_65); language.pass(X_115); language.pass(X_178); language.pass(X_179); language.pass(X_67); language.pass(X_117); language.pass(X_181); language.pass(X_182); language.pass(X_69); language.pass(X_119); language.pass(X_184); language.pass(X_185); language.pass(X_72); language.pass(X_121); language.pass(X_187); language.pass(X_188); language.pass(X_74); language.pass(X_123); language.pass(X_190); language.pass(X_191); language.pass(X_76); language.pass(X_125); language.pass(X_193); language.pass(X_194); language.pass(X_78); language.pass(X_127); language.pass(X_196); language.pass(X_197); language.pass(X_80); language.pass(X_129); language.pass(X_199); language.pass(X_200); language.pass(X_82); language.pass(X_131); language.pass(X_202); language.pass(X_203); language.pass(X_84); language.pass(X_133); language.pass(X_206); language.pass(X_207); language.pass(X_86); language.pass(X_135); language.pass(X_209); language.pass(X_210); language.pass(X_9); language.pass(X_452); language.pass(X_403); language.pass(X_453); language.pass(X_405); language.pass(X_454); language.pass(X_407); language.pass(X_455); language.pass(X_409); language.pass(X_456); language.pass(X_411); language.pass(X_457); language.pass(X_413); language.pass(X_458); language.pass(X_415); language.pass(X_459); language.pass(X_417); language.pass(X_460); language.pass(X_419); language.pass(X_461); language.pass(X_421); language.pass(X_462); language.pass(X_423); language.pass(X_463); language.pass(X_425); language.pass(X_464); language.pass(X_427); language.pass(X_465); language.pass(X_429); language.pass(X_466); language.pass(X_431); language.pass(X_467); language.pass(X_433); language.pass(X_468); language.pass(X_435); language.pass(X_469); language.pass(X_437); language.pass(X_470); language.pass(X_439); language.pass(X_471); language.pass(X_441); language.pass(X_472); language.pass(X_443); language.pass(X_473); language.pass(X_445); language.pass(X_474); language.pass(X_447); language.pass(X_475); language.pass(X_449); exit X_696; X_15 := sql.resultSet(1,1,X_14); sql.rsColumn(X_15,"sapsr3.dfkkop","vkont","varchar",12,0,X_14); X_20 := io.stdout(); sql.exportResult(X_20,X_15); end s10_3; # querylog.define("explain\nselect\n\tvkont\nfrom\n\tsapsr3.dfkkop\nwhere\n\t--1=1 and\n\tvkont = \\'000802037649\\'\nlimit 1 offset 0;","default_pipe")
participants (2)
-
gms_xy＠gmx.de -
Robert Koch