Statistics about stdout of test 'rewrite_like_into_likesubselect.Bug-3179` in directory 'sql/test/BugTracker-2012`: 217 lines, 1250 words, 15581 chars in lines not matching '^$|^(\| |)#|^=` = 217 lines, 1250 words, 15581 chars in lines not matching '^$|^(\| |)#` # 467 lines, 2447 words, 23617 chars in all lines stdout of test 'rewrite_like_into_likesubselect.Bug-3179` in directory 'sql/test/BugTracker-2012` itself: # 20:40:52 > # 20:40:52 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=LAB03" "--port=37344" # 20:40:52 > #set optimizer='sequential_pipe'; #start transaction; #explain select name,func from functions where name like '%optimizers%'; % .explain # table_name % mal # name % clob # type % 146 # length function user.main():void; X_1:void := querylog.define("explain select name,func from functions where name like \\'%optimizers%\\';":str, "sequential_pipe":str, 27:int); X_37:bat[:str] := bat.pack("sys.functions":str, "sys.functions":str); X_38:bat[:str] := bat.pack("name":str, "func":str); X_39:bat[:str] := bat.pack("varchar":str, "varchar":str); X_40:bat[:int] := bat.pack(256:int, 8196:int); X_41:bat[:int] := bat.pack(0:int, 0:int); X_4:int := sql.mvc(); X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 0:int); C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str); C_83:bat[:oid] := algebra.likeselect(X_17:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, false:bit); (X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 2:int); C_84:bat[:oid] := algebra.likeselect(X_20:bat[:str], nil:bat[:oid], "%optimizers%":str, "":str, false:bit); X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 1:int); C_86:bat[:oid] := algebra.likeselect(X_18:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, false:bit); C_32:bat[:oid] := sql.subdelta(C_83:bat[:oid], C_5:bat[:oid], X_19:bat[:oid], C_84:bat[:oid], C_86:bat[:oid]); X_34:bat[:str] := sql.projectdelta(C_32:bat[:oid], X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); X_22:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 0:int); (X_25:bat[:oid], X_26:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 2:int); X_24:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 1:int); X_35:bat[:str] := sql.projectdelta(C_32:bat[:oid], X_22:bat[:str], X_25:bat[:oid], X_26:bat[:str], X_24:bat[:str]); sql.resultSet(X_37:bat[:str], X_38:bat[:str], X_39:bat[:str], X_40:bat[:int], X_41:bat[:int], X_34:bat[:str], X_35:bat[:str]); end user.main; #inline actions= 0 time=0 usec #remap actions= 0 time=0 usec #costmodel actions= 1 time=0 usec #coercion actions= 0 time=0 usec #aliases actions= 2 time=0 usec #evaluate actions= 0 time=0 usec #emptybind actions= 0 time=0 usec #pushselect actions= 2 time=0 usec #aliases actions= 0 time=0 usec #mergetable actions= 0 time=0 usec #deadcode actions= 6 time=0 usec #aliases actions= 0 time=0 usec #constants actions= 2 time=0 usec #commonTerms actions= 0 time=0 usec #projectionpath actions= 0 time=0 usec #deadcode actions= 0 time=0 usec #reorder actions= 1 time=0 usec #matpack actions= 0 time=0 usec #multiplex actions= 0 time=0 usec #profiler actions= 1 time=0 usec #candidates actions= 1 time=0 usec #deadcode actions= 0 time=0 usec #postfix actions= 0 time=0 usec #wlc actions= 0 time=0 usec #garbagecollector actions= 1 time=0 usec #total actions=27 time=0 usec #explain select name,func from functions where name not like '%optimizers%'; % .explain # table_name % mal # name % clob # type % 150 # length function user.main():void; X_1:void := querylog.define("explain select name,func from functions where name not like \\'%optimizers%\\';":str, "sequential_pipe":str, 27:int); X_37:bat[:str] := bat.pack("sys.functions":str, "sys.functions":str); X_38:bat[:str] := bat.pack("name":str, "func":str); X_39:bat[:str] := bat.pack("varchar":str, "varchar":str); X_40:bat[:int] := bat.pack(256:int, 8196:int); X_41:bat[:int] := bat.pack(0:int, 0:int); X_4:int := sql.mvc(); X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 0:int); C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str); C_83:bat[:oid] := algebra.likeselect(X_17:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, true:bit); (X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 2:int); C_84:bat[:oid] := algebra.likeselect(X_20:bat[:str], nil:bat[:oid], "%optimizers%":str, "":str, true:bit); X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 1:int); C_86:bat[:oid] := algebra.likeselect(X_18:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, true:bit); C_32:bat[:oid] := sql.subdelta(C_83:bat[:oid], C_5:bat[:oid], X_19:bat[:oid], C_84:bat[:oid], C_86:bat[:oid]); X_34:bat[:str] := sql.projectdelta(C_32:bat[:oid], X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); X_22:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 0:int); (X_25:bat[:oid], X_26:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 2:int); X_24:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 1:int); X_35:bat[:str] := sql.projectdelta(C_32:bat[:oid], X_22:bat[:str], X_25:bat[:oid], X_26:bat[:str], X_24:bat[:str]); sql.resultSet(X_37:bat[:str], X_38:bat[:str], X_39:bat[:str], X_40:bat[:int], X_41:bat[:int], X_34:bat[:str], X_35:bat[:str]); end user.main; #inline actions= 0 time=0 usec #remap actions= 0 time=0 usec #costmodel actions= 1 time=0 usec #coercion actions= 0 time=0 usec #aliases actions= 2 time=0 usec #evaluate actions= 0 time=0 usec #emptybind actions= 0 time=0 usec #pushselect actions= 2 time=0 usec #aliases actions= 0 time=0 usec #mergetable actions= 0 time=0 usec #deadcode actions= 6 time=0 usec #aliases actions= 0 time=0 usec #constants actions= 2 time=0 usec #commonTerms actions= 0 time=0 usec #projectionpath actions= 0 time=0 usec #deadcode actions= 0 time=0 usec #reorder actions= 1 time=0 usec #matpack actions= 0 time=0 usec #multiplex actions= 0 time=0 usec #profiler actions= 1 time=0 usec #candidates actions= 1 time=0 usec #deadcode actions= 0 time=0 usec #postfix actions= 0 time=0 usec #wlc actions= 0 time=0 usec #garbagecollector actions= 1 time=0 usec #total actions=27 time=0 usec #explain select name,func from functions where name ilike '%optimizers%'; % .explain # table_name % mal # name % clob # type % 147 # length function user.main():void; X_1:void := querylog.define("explain select name,func from functions where name ilike \\'%optimizers%\\';":str, "sequential_pipe":str, 27:int); X_37:bat[:str] := bat.pack("sys.functions":str, "sys.functions":str); X_38:bat[:str] := bat.pack("name":str, "func":str); X_39:bat[:str] := bat.pack("varchar":str, "varchar":str); X_40:bat[:int] := bat.pack(256:int, 8196:int); X_41:bat[:int] := bat.pack(0:int, 0:int); X_4:int := sql.mvc(); X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 0:int); C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str); C_83:bat[:oid] := algebra.ilikeselect(X_17:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, false:bit); (X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 2:int); C_84:bat[:oid] := algebra.ilikeselect(X_20:bat[:str], nil:bat[:oid], "%optimizers%":str, "":str, false:bit); X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 1:int); C_86:bat[:oid] := algebra.ilikeselect(X_18:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, false:bit); C_32:bat[:oid] := sql.subdelta(C_83:bat[:oid], C_5:bat[:oid], X_19:bat[:oid], C_84:bat[:oid], C_86:bat[:oid]); X_34:bat[:str] := sql.projectdelta(C_32:bat[:oid], X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); X_22:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 0:int); (X_25:bat[:oid], X_26:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 2:int); X_24:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 1:int); X_35:bat[:str] := sql.projectdelta(C_32:bat[:oid], X_22:bat[:str], X_25:bat[:oid], X_26:bat[:str], X_24:bat[:str]); sql.resultSet(X_37:bat[:str], X_38:bat[:str], X_39:bat[:str], X_40:bat[:int], X_41:bat[:int], X_34:bat[:str], X_35:bat[:str]); end user.main; #inline actions= 0 time=0 usec #remap actions= 0 time=0 usec #costmodel actions= 1 time=0 usec #coercion actions= 0 time=0 usec #aliases actions= 2 time=0 usec #evaluate actions= 0 time=0 usec #emptybind actions= 0 time=0 usec #pushselect actions= 2 time=0 usec #aliases actions= 0 time=0 usec #mergetable actions= 0 time=0 usec #deadcode actions= 6 time=0 usec #aliases actions= 0 time=0 usec #constants actions= 2 time=0 usec #commonTerms actions= 0 time=0 usec #projectionpath actions= 0 time=0 usec #deadcode actions= 0 time=0 usec #reorder actions= 1 time=0 usec #matpack actions= 0 time=0 usec #multiplex actions= 0 time=0 usec #profiler actions= 1 time=0 usec #candidates actions= 1 time=0 usec #deadcode actions= 0 time=0 usec #postfix actions= 0 time=0 usec #wlc actions= 0 time=0 usec #garbagecollector actions= 1 time=0 usec #total actions=27 time=0 usec #explain select name,func from functions where name not ilike '%optimizers%'; % .explain # table_name % mal # name % clob # type % 151 # length function user.main():void; X_1:void := querylog.define("explain select name,func from functions where name not ilike \\'%optimizers%\\';":str, "sequential_pipe":str, 27:int); X_37:bat[:str] := bat.pack("sys.functions":str, "sys.functions":str); X_38:bat[:str] := bat.pack("name":str, "func":str); X_39:bat[:str] := bat.pack("varchar":str, "varchar":str); X_40:bat[:int] := bat.pack(256:int, 8196:int); X_41:bat[:int] := bat.pack(0:int, 0:int); X_4:int := sql.mvc(); X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 0:int); C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str); C_83:bat[:oid] := algebra.ilikeselect(X_17:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, true:bit); (X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 2:int); C_84:bat[:oid] := algebra.ilikeselect(X_20:bat[:str], nil:bat[:oid], "%optimizers%":str, "":str, true:bit); X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 1:int); C_86:bat[:oid] := algebra.ilikeselect(X_18:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, true:bit); C_32:bat[:oid] := sql.subdelta(C_83:bat[:oid], C_5:bat[:oid], X_19:bat[:oid], C_84:bat[:oid], C_86:bat[:oid]); X_34:bat[:str] := sql.projectdelta(C_32:bat[:oid], X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); X_22:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 0:int); (X_25:bat[:oid], X_26:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 2:int); X_24:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 1:int); X_35:bat[:str] := sql.projectdelta(C_32:bat[:oid], X_22:bat[:str], X_25:bat[:oid], X_26:bat[:str], X_24:bat[:str]); sql.resultSet(X_37:bat[:str], X_38:bat[:str], X_39:bat[:str], X_40:bat[:int], X_41:bat[:int], X_34:bat[:str], X_35:bat[:str]); end user.main; #inline actions= 0 time=0 usec #remap actions= 0 time=0 usec #costmodel actions= 1 time=0 usec #coercion actions= 0 time=0 usec #aliases actions= 2 time=0 usec #evaluate actions= 0 time=0 usec #emptybind actions= 0 time=0 usec #pushselect actions= 2 time=0 usec #aliases actions= 0 time=0 usec #mergetable actions= 0 time=0 usec #deadcode actions= 6 time=0 usec #aliases actions= 0 time=0 usec #constants actions= 2 time=0 usec #commonTerms actions= 0 time=0 usec #projectionpath actions= 0 time=0 usec #deadcode actions= 0 time=0 usec #reorder actions= 1 time=0 usec #matpack actions= 0 time=0 usec #multiplex actions= 0 time=0 usec #profiler actions= 1 time=0 usec #candidates actions= 1 time=0 usec #deadcode actions= 0 time=0 usec #postfix actions= 0 time=0 usec #wlc actions= 0 time=0 usec #garbagecollector actions= 1 time=0 usec #total actions=27 time=0 usec #create function contains(str string, substr string) #returns boolean #begin # return str like '%'||substr||'%'; #end; #create function not_contains(str string, substr string) #returns boolean #begin # return str not like '%'||substr||'%'; #end; #create function icontains(str string, substr string) #returns boolean #begin # return str ilike '%'||substr||'%'; #end; #create function not_icontains(str string, substr string) #returns boolean #begin # return str not ilike '%'||substr||'%'; #end; #explain select name,func from functions where contains(name, 'optimizers'); % .explain # table_name % mal # name % clob # type % 150 # length function user.main():void; X_1:void := querylog.define("explain select name,func from functions where contains(name, \\'optimizers\\');":str, "sequential_pipe":str, 28:int); X_40:bat[:str] := bat.pack("sys.functions":str, "sys.functions":str); X_41:bat[:str] := bat.pack("name":str, "func":str); X_42:bat[:str] := bat.pack("varchar":str, "varchar":str); X_43:bat[:int] := bat.pack(256:int, 8196:int); X_44:bat[:int] := bat.pack(0:int, 0:int); X_4:int := sql.mvc(); X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 0:int); C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str); C_131:bat[:oid] := algebra.likeselect(X_17:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, false:bit, false:bit); (X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 2:int); C_132:bat[:oid] := algebra.likeselect(X_20:bat[:str], nil:bat[:oid], "%optimizers%":str, "":str, false:bit, false:bit); X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 1:int); C_134:bat[:oid] := algebra.likeselect(X_18:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, false:bit, false:bit); C_35:bat[:oid] := sql.subdelta(C_131:bat[:oid], C_5:bat[:oid], X_19:bat[:oid], C_132:bat[:oid], C_134:bat[:oid]); X_37:bat[:str] := sql.projectdelta(C_35:bat[:oid], X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); X_22:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 0:int); (X_25:bat[:oid], X_26:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 2:int); X_24:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 1:int); X_38:bat[:str] := sql.projectdelta(C_35:bat[:oid], X_22:bat[:str], X_25:bat[:oid], X_26:bat[:str], X_24:bat[:str]); sql.resultSet(X_40:bat[:str], X_41:bat[:str], X_42:bat[:str], X_43:bat[:int], X_44:bat[:int], X_37:bat[:str], X_38:bat[:str]); end user.main; #inline actions= 0 time=0 usec #remap actions= 1 time=0 usec #costmodel actions= 1 time=0 usec #coercion actions= 0 time=0 usec #aliases actions= 7 time=0 usec #evaluate actions= 2 time=0 usec #emptybind actions= 0 time=0 usec #pushselect actions= 3 time=0 usec #aliases actions= 2 time=0 usec #mergetable actions= 0 time=0 usec #deadcode actions= 8 time=0 usec #aliases actions= 0 time=0 usec #constants actions= 3 time=0 usec #commonTerms actions= 0 time=0 usec #projectionpath actions= 0 time=0 usec #deadcode actions= 0 time=0 usec #reorder actions= 1 time=0 usec #matpack actions= 0 time=0 usec #multiplex actions= 0 time=0 usec #profiler actions= 1 time=0 usec #candidates actions= 1 time=0 usec #deadcode actions= 0 time=0 usec #postfix actions= 0 time=0 usec #wlc actions= 0 time=0 usec #garbagecollector actions= 1 time=0 usec #total actions=27 time=0 usec #explain select name,func from functions where not_contains(name, 'optimizers'); % .explain # table_name % mal # name % clob # type % 154 # length function user.main():void; X_1:void := querylog.define("explain select name,func from functions where not_contains(name, \\'optimizers\\');":str, "sequential_pipe":str, 28:int); X_40:bat[:str] := bat.pack("sys.functions":str, "sys.functions":str); X_41:bat[:str] := bat.pack("name":str, "func":str); X_42:bat[:str] := bat.pack("varchar":str, "varchar":str); X_43:bat[:int] := bat.pack(256:int, 8196:int); X_44:bat[:int] := bat.pack(0:int, 0:int); X_4:int := sql.mvc(); X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 0:int); C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str); C_131:bat[:oid] := algebra.likeselect(X_17:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, false:bit, true:bit); (X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 2:int); C_132:bat[:oid] := algebra.likeselect(X_20:bat[:str], nil:bat[:oid], "%optimizers%":str, "":str, false:bit, true:bit); X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 1:int); C_134:bat[:oid] := algebra.likeselect(X_18:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, false:bit, true:bit); C_35:bat[:oid] := sql.subdelta(C_131:bat[:oid], C_5:bat[:oid], X_19:bat[:oid], C_132:bat[:oid], C_134:bat[:oid]); X_37:bat[:str] := sql.projectdelta(C_35:bat[:oid], X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); X_22:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 0:int); (X_25:bat[:oid], X_26:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 2:int); X_24:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 1:int); X_38:bat[:str] := sql.projectdelta(C_35:bat[:oid], X_22:bat[:str], X_25:bat[:oid], X_26:bat[:str], X_24:bat[:str]); sql.resultSet(X_40:bat[:str], X_41:bat[:str], X_42:bat[:str], X_43:bat[:int], X_44:bat[:int], X_37:bat[:str], X_38:bat[:str]); end user.main; #inline actions= 0 time=0 usec #remap actions= 1 time=0 usec #costmodel actions= 1 time=0 usec #coercion actions= 0 time=0 usec #aliases actions= 7 time=0 usec #evaluate actions= 2 time=0 usec #emptybind actions= 0 time=0 usec #pushselect actions= 3 time=0 usec #aliases actions= 2 time=0 usec #mergetable actions= 0 time=0 usec #deadcode actions= 8 time=0 usec #aliases actions= 0 time=0 usec #constants actions= 3 time=0 usec #commonTerms actions= 0 time=0 usec #projectionpath actions= 0 time=0 usec #deadcode actions= 0 time=0 usec #reorder actions= 1 time=0 usec #matpack actions= 0 time=0 usec #multiplex actions= 0 time=0 usec #profiler actions= 1 time=0 usec #candidates actions= 1 time=0 usec #deadcode actions= 0 time=0 usec #postfix actions= 0 time=0 usec #wlc actions= 0 time=0 usec #garbagecollector actions= 1 time=0 usec #total actions=27 time=0 usec #explain select name,func from functions where icontains(name, 'optimizers'); % .explain # table_name % mal # name % clob # type % 151 # length function user.main():void; X_1:void := querylog.define("explain select name,func from functions where icontains(name, \\'optimizers\\');":str, "sequential_pipe":str, 28:int); X_40:bat[:str] := bat.pack("sys.functions":str, "sys.functions":str); X_41:bat[:str] := bat.pack("name":str, "func":str); X_42:bat[:str] := bat.pack("varchar":str, "varchar":str); X_43:bat[:int] := bat.pack(256:int, 8196:int); X_44:bat[:int] := bat.pack(0:int, 0:int); X_4:int := sql.mvc(); X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 0:int); C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str); C_131:bat[:oid] := algebra.likeselect(X_17:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, true:bit, false:bit); (X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 2:int); C_132:bat[:oid] := algebra.likeselect(X_20:bat[:str], nil:bat[:oid], "%optimizers%":str, "":str, true:bit, false:bit); X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 1:int); C_134:bat[:oid] := algebra.likeselect(X_18:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, true:bit, false:bit); C_35:bat[:oid] := sql.subdelta(C_131:bat[:oid], C_5:bat[:oid], X_19:bat[:oid], C_132:bat[:oid], C_134:bat[:oid]); X_37:bat[:str] := sql.projectdelta(C_35:bat[:oid], X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); X_22:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 0:int); (X_25:bat[:oid], X_26:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 2:int); X_24:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 1:int); X_38:bat[:str] := sql.projectdelta(C_35:bat[:oid], X_22:bat[:str], X_25:bat[:oid], X_26:bat[:str], X_24:bat[:str]); sql.resultSet(X_40:bat[:str], X_41:bat[:str], X_42:bat[:str], X_43:bat[:int], X_44:bat[:int], X_37:bat[:str], X_38:bat[:str]); end user.main; #inline actions= 0 time=0 usec #remap actions= 1 time=0 usec #costmodel actions= 1 time=0 usec #coercion actions= 0 time=0 usec #aliases actions= 7 time=0 usec #evaluate actions= 2 time=0 usec #emptybind actions= 0 time=0 usec #pushselect actions= 3 time=0 usec #aliases actions= 2 time=0 usec #mergetable actions= 0 time=0 usec #deadcode actions= 8 time=0 usec #aliases actions= 0 time=0 usec #constants actions= 3 time=0 usec #commonTerms actions= 0 time=0 usec #projectionpath actions= 0 time=0 usec #deadcode actions= 0 time=0 usec #reorder actions= 1 time=0 usec #matpack actions= 0 time=0 usec #multiplex actions= 0 time=0 usec #profiler actions= 1 time=0 usec #candidates actions= 1 time=0 usec #deadcode actions= 0 time=0 usec #postfix actions= 0 time=0 usec #wlc actions= 0 time=0 usec #garbagecollector actions= 1 time=0 usec #total actions=27 time=0 usec #explain select name,func from functions where not_icontains(name, 'optimizers'); % .explain # table_name % mal # name % clob # type % 155 # length function user.main():void; X_1:void := querylog.define("explain select name,func from functions where not_icontains(name, \\'optimizers\\');":str, "sequential_pipe":str, 28:int); X_40:bat[:str] := bat.pack("sys.functions":str, "sys.functions":str); X_41:bat[:str] := bat.pack("name":str, "func":str); X_42:bat[:str] := bat.pack("varchar":str, "varchar":str); X_43:bat[:int] := bat.pack(256:int, 8196:int); X_44:bat[:int] := bat.pack(0:int, 0:int); X_4:int := sql.mvc(); X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 0:int); C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str); C_131:bat[:oid] := algebra.likeselect(X_17:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, true:bit, true:bit); (X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 2:int); C_132:bat[:oid] := algebra.likeselect(X_20:bat[:str], nil:bat[:oid], "%optimizers%":str, "":str, true:bit, true:bit); X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 1:int); C_134:bat[:oid] := algebra.likeselect(X_18:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, true:bit, true:bit); C_35:bat[:oid] := sql.subdelta(C_131:bat[:oid], C_5:bat[:oid], X_19:bat[:oid], C_132:bat[:oid], C_134:bat[:oid]); X_37:bat[:str] := sql.projectdelta(C_35:bat[:oid], X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); X_22:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 0:int); (X_25:bat[:oid], X_26:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 2:int); X_24:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "func":str, 1:int); X_38:bat[:str] := sql.projectdelta(C_35:bat[:oid], X_22:bat[:str], X_25:bat[:oid], X_26:bat[:str], X_24:bat[:str]); sql.resultSet(X_40:bat[:str], X_41:bat[:str], X_42:bat[:str], X_43:bat[:int], X_44:bat[:int], X_37:bat[:str], X_38:bat[:str]); end user.main; #inline actions= 0 time=0 usec #remap actions= 1 time=0 usec #costmodel actions= 1 time=0 usec #coercion actions= 0 time=0 usec #aliases actions= 7 time=0 usec #evaluate actions= 2 time=0 usec #emptybind actions= 0 time=0 usec #pushselect actions= 3 time=0 usec #aliases actions= 2 time=0 usec #mergetable actions= 0 time=0 usec #deadcode actions= 8 time=0 usec #aliases actions= 0 time=0 usec #constants actions= 4 time=0 usec #commonTerms actions= 0 time=0 usec #projectionpath actions= 0 time=0 usec #deadcode actions= 0 time=0 usec #reorder actions= 1 time=0 usec #matpack actions= 0 time=0 usec #multiplex actions= 0 time=0 usec #profiler actions= 1 time=0 usec #candidates actions= 1 time=0 usec #deadcode actions= 0 time=0 usec #postfix actions= 0 time=0 usec #wlc actions= 0 time=0 usec #garbagecollector actions= 1 time=0 usec #total actions=27 time=0 usec #rollback; # 20:40:52 > # 20:40:52 > "Done." # 20:40:52 >