trace select kind from temp_associations where exists (select 1 from temp_assoc_counts tc where tc.xtrsrc_id = temp_associations.xtrsrc_id and tc.assoc_count = 1); +------+ | kind | +======+ | null | | null | +------+ 2 tuples (7.467ms) +-------+-------------------------------------------------------------------------------------------------------+ | ticks | stmt | +=======+=======================================================================================================+ | 3 | X_63 := nil:bat[:oid,:int]; | | 4 | X_4 := sql.mvc(); | | 8 | X_52:bat[:oid,:int] =[2] := sql.bind(X_4=0,"sys","temp_associations","xtrsrc_id",0); | | 6 | X_11:bat[:oid,:int] =[0] := sql.bind(X_4=0,"sys","temp_associations","kind",1); | | 2 | X_14:bat[:oid,:int] =[2] := sql.bind(X_4=0,"sys","temp_associations","kind",0); | | 2 | X_24:bat[:oid,:int] =[4] := sql.bind(X_4=0,"sys","temp_assoc_counts","xtrsrc_id",0); | | 10 | X_20:bat[:oid,:int] =[0] := sql.bind(X_4=0,"sys","temp_assoc_counts","xtrsrc_id",1); | | 3 | X_31:bat[:oid,:int] =[0] := sql.bind(X_4=0,"sys","temp_assoc_counts","assoc_count",1); | | 5 | X_12:bat[:oid,:int] =[0] := sql.bind(X_4=0,"sys","temp_associations","kind",2); | | 3 | X_29:bat[:oid,:oid] =[0] := sql.bind_dbat(X_4=0,"sys","temp_assoc_counts",1); | | 3 | X_30=[0] := bat.reverse(X_29=nil:bat[:oid,:oid]); | | 26 | X_32=[0] := algebra.uselect(X_31=nil:bat[:oid,:int],A1=1); | | 3 | X_36:bat[:oid,:int] =[4] := sql.bind(X_4=0,"sys","temp_assoc_counts","assoc_count",0); | | 8 | X_37=[4] := algebra.uselect(X_36=nil:bat[:oid,:int],A1=1); | | 3 | X_33:bat[:oid,:int] =[0] := sql.bind(X_4=0,"sys","temp_assoc_counts","assoc_count",2); | | 9 | X_38=[4] := algebra.kdifference(X_37=nil,X_33=:bat[:oid,:int][0]); | | 3 | X_23:bat[:oid,:int] =[0] := sql.bind(X_4=0,"sys","temp_assoc_counts","xtrsrc_id",2); | | 6 | X_7:bat[:oid,:oid] =[0] := sql.bind_dbat(X_4=0,"sys","temp_associations",1); | | 10 | X_16=[2] := algebra.kdifference(X_14=nil:bat[:oid,:int],X_12=:bat[:oid,:int][0]); | | 23 | X_35=[0] := algebra.uselect(X_33=nil:bat[:oid,:int],A1=1); | | 10 | X_25=[4] := algebra.kdifference(X_24=nil:bat[:oid,:int],X_23=:bat[:oid,:int][0]); | | 2 | X_10=[0] := bat.reverse(X_7=nil:bat[:oid,:oid]); | | 8 | X_49:bat[:oid,:int] =[0] := sql.bind(X_4=0,"sys","temp_associations","xtrsrc_id",1); | | 21 | X_39=[4] := algebra.kunion(X_38=nil,X_35=nil); | | 27 | X_17=[2] := algebra.kunion(X_16=nil,X_12=nil:bat[:oid,:int]); | | 15 | X_26=[4] := algebra.kunion(X_25=nil,X_23=nil:bat[:oid,:int]); | | 3 | X_50:bat[:oid,:int] =[0] := sql.bind(X_4=0,"sys","temp_associations","xtrsrc_id",2); | | 18 | X_40=[4] := algebra.kunion(X_39=nil,X_32=nil); | | 13 | X_18=[2] := algebra.kunion(X_17=nil,X_11=nil:bat[:oid,:int]); | | 19 | X_27=[4] := algebra.kunion(X_26=nil,X_20=nil:bat[:oid,:int]); | | 18 | X_54=[2] := algebra.kdifference(X_52=nil:bat[:oid,:int],X_50=:bat[:oid,:int][0]); | | 23 | X_41=[4] := algebra.kdifference(X_40=nil,X_30=nil); | | 19 | X_55=[2] := algebra.kunion(X_54=nil,X_50=nil:bat[:oid,:int]); | | 18 | X_42=[4] := algebra.markT(X_41=nil,0@0:oid); | | 26 | X_56=[2] := algebra.kunion(X_55=nil,X_49=nil:bat[:oid,:int]); | | 1 | X_43=[4] := bat.reverse(X_42=nil); | | 29 | X_57=[2] := algebra.kdifference(X_56=nil,X_10=[0]); | | 71 | X_44=[4] := algebra.leftjoin(X_43=nil,X_27=nil); | | 18 | X_19=[2] := algebra.kdifference(X_18=nil,X_10=nil); | | 2 | X_45=[4] := bat.reverse(X_44=nil); | | 13 | X_58=[2] := algebra.join(X_57=[2],X_45=nil); | | 4 | X_59=[2] := algebra.markT(X_58=nil,0@0:oid); | | 10 | X_60=[2] := algebra.semijoin(X_57=nil,X_59=nil); | | 5 | X_61=[2] := algebra.markT(X_60=nil,0@0:oid); | | 2 | X_62=[2] := bat.reverse(X_61=nil); | | 15 | X_63=[2] := algebra.leftjoin(X_62=nil,X_19=nil); | | 2325 | barrier X_92 := language.dataflow(); | | 6 | X_64 := sql.resultSet(1,1,X_63=[2]); | | 6 | sql.rsColumn(X_64=0,"sys.temp_associations","kind","int",32,0,X_63=nil); | | 1 | X_70 := io.stdout(); | | 20 | sql.exportResult(X_70=="10792176":streams,X_64=0); | | 2642 | X_5:void := user.s1_1(1:bte,1); | +-------+-------------------------------------------------------------------------------------------------------+ 52 tuples (7.520ms) trace select kind from temp_associations where kind is null; +------+ | kind | +======+ | null | | null | +------+ 2 tuples (5.297ms) +-------+------------------------------------------------------------------------------------------------------+ | ticks | stmt | +=======+======================================================================================================+ | 2 | X_2 := sql.mvc(); | | 9 | X_10:bat[:oid,:int] =[2] := sql.bind(X_2=0,"sys","temp_associations","kind",0); | | 3 | X_8:bat[:oid,:int] =[0] := sql.bind(X_2=0,"sys","temp_associations","kind",2); | | 16 | X_12=[2] := algebra.kdifference(X_10=nil:bat[:oid,:int],X_8=:bat[:oid,:int][0]); | | 15 | X_13=[2] := algebra.kunion(X_12=nil,X_8=nil:bat[:oid,:int]); | | 4 | X_5:bat[:oid,:int] =[0] := sql.bind(X_2=0,"sys","temp_associations","kind",1); | | 8 | X_14=[2] := algebra.kunion(X_13=nil,X_5=nil:bat[:oid,:int]); | | 4 | X_15:bat[:oid,:oid] =[0] := sql.bind_dbat(X_2=0,"sys","temp_associations",1); | | 4 | X_16=[0] := bat.reverse(X_15=nil:bat[:oid,:oid]); | | 7 | X_17=[2] := algebra.kdifference(X_14=[2],X_16=nil); | | 10 | X_18:bat[:oid,:bit] =[2] := batcalc.isnil(X_17=nil); | | 10 | X_19=[2] := algebra.uselect(X_18=nil:bat[:oid,:bit],true:bit); | | 7 | X_20=[2] := algebra.markT(X_19=nil,0@0:oid); | | 2 | X_21=[2] := bat.reverse(X_20=nil); | | 30 | X_22=[2] := algebra.leftjoin(X_21=nil,X_14=nil); | | 5 | X_23 := sql.resultSet(1,1,X_22=[2]); | | 6 | sql.rsColumn(X_23=2,"sys.temp_associations","kind","int",32,0,X_22=nil); | | 1 | X_28 := io.stdout(); | | 19 | sql.exportResult(X_28=="10792176":streams,X_23=2); | | 1009 | X_5:void := user.s2_1(); | +-------+------------------------------------------------------------------------------------------------------+ trace select kind from temp_associations where kind is null and exists (select 1 from temp_assoc_counts tc where tc.xtrsrc_id = temp_associations.xtrsrc_id and tc.assoc_count = 1); 20 tuples (5.327ms) +------+ | kind | +======+ +------+ 0 tuples (7.560ms) +-------+-------------------------------------------------------------------------------------------------------+ | ticks | stmt | +=======+=======================================================================================================+ | 2 | X_67:bat[:oid,:int] := nil:bat[:oid,:int]; | | 3 | X_4 := sql.mvc(); | | 11 | X_12:bat[:oid,:int] =[2] := sql.bind(X_4=0,"sys","temp_associations","kind",0); | | 19 | X_24:bat[:oid,:int] =[0] := sql.bind(X_4=0,"sys","temp_assoc_counts","xtrsrc_id",1); | | 15 | X_27:bat[:oid,:int] =[0] := sql.bind(X_4=0,"sys","temp_assoc_counts","xtrsrc_id",2); | | 7 | X_28:bat[:oid,:int] =[4] := sql.bind(X_4=0,"sys","temp_assoc_counts","xtrsrc_id",0); | | 16 | X_29=[4] := algebra.kdifference(X_28=nil:bat[:oid,:int],X_27=:bat[:oid,:int][0]); | | 3 | X_42:bat[:oid,:int] =[4] := sql.bind(X_4=0,"sys","temp_assoc_counts","assoc_count",0); | | 4 | X_39:bat[:oid,:int] =[0] := sql.bind(X_4=0,"sys","temp_assoc_counts","assoc_count",2); | | 3 | X_33:bat[:oid,:oid] =[0] := sql.bind_dbat(X_4=0,"sys","temp_assoc_counts",1); | | 3 | X_37:bat[:oid,:int] =[0] := sql.bind(X_4=0,"sys","temp_assoc_counts","assoc_count",1); | | 12 | X_44=[4] := algebra.uselect(X_42=nil:bat[:oid,:int],A1=1); | | 24 | X_38=[0] := algebra.uselect(X_37=nil:bat[:oid,:int],A1=1); | | 4 | X_36=[0] := bat.reverse(X_33=nil:bat[:oid,:oid]); | | 24 | X_30=[4] := algebra.kunion(X_29=nil,X_27=nil:bat[:oid,:int]); | | 6 | X_45=[4] := algebra.kdifference(X_44=nil,X_39=:bat[:oid,:int][0]); | | 36 | X_31=[4] := algebra.kunion(X_30=nil,X_24=nil:bat[:oid,:int]); | | 3 | X_57:bat[:oid,:int] =[2] := sql.bind(X_4=0,"sys","temp_associations","xtrsrc_id",0); | | 2 | X_17:bat[:oid,:oid] =[0] := sql.bind_dbat(X_4=0,"sys","temp_associations",1); | | 38 | X_41=[0] := algebra.uselect(X_39=nil:bat[:oid,:int],A1=1); | | 5 | X_56:bat[:oid,:int] =[0] := sql.bind(X_4=0,"sys","temp_associations","xtrsrc_id",2); | | 7 | X_55:bat[:oid,:int] =[0] := sql.bind(X_4=0,"sys","temp_associations","xtrsrc_id",1); | | 2 | X_18=[0] := bat.reverse(X_17=nil:bat[:oid,:oid]); | | 23 | X_46=[4] := algebra.kunion(X_45=nil,X_41=nil); | | 18 | X_58=[2] := algebra.kdifference(X_57=nil:bat[:oid,:int],X_56=:bat[:oid,:int][0]); | | 4 | X_7:bat[:oid,:int] =[0] := sql.bind(X_4=0,"sys","temp_associations","kind",1); | | 3 | X_10:bat[:oid,:int] =[0] := sql.bind(X_4=0,"sys","temp_associations","kind",2); | | 21 | X_47=[4] := algebra.kunion(X_46=nil,X_38=nil); | | 9 | X_59=[2] := algebra.kunion(X_58=nil,X_56=nil:bat[:oid,:int]); | | 16 | X_14=[2] := algebra.kdifference(X_12=nil:bat[:oid,:int],X_10=:bat[:oid,:int][0]); | | 26 | X_48=[4] := algebra.kdifference(X_47=nil,X_36=nil); | | 19 | X_60=[2] := algebra.kunion(X_59=nil,X_55=nil:bat[:oid,:int]); | | 14 | X_15=[2] := algebra.kunion(X_14=nil,X_10=nil:bat[:oid,:int]); | | 19 | X_49=[4] := algebra.markT(X_48=nil,0@0:oid); | | 26 | X_16=[2] := algebra.kunion(X_15=nil,X_7=nil:bat[:oid,:int]); | | 2 | X_50=[4] := bat.reverse(X_49=nil); | | 17 | X_19=[2] := algebra.kdifference(X_16=[2],X_18=nil); | | 7 | X_20:bat[:oid,:bit] =[2] := batcalc.isnil(X_19=nil); | | 43 | X_51=[4] := algebra.leftjoin(X_50=nil,X_31=nil); | | 6 | X_21=[2] := algebra.uselect(X_20=nil:bat[:oid,:bit],true:bit); | | 2 | X_52=[4] := bat.reverse(X_51=nil); | | 16 | X_22=[2] := algebra.markT(X_21=nil,0@0:oid); | | 2 | X_23=[2] := bat.reverse(X_22=nil); | | 12 | X_61=[2] := algebra.leftjoin(X_23=[2],X_60=nil); | | 11 | X_62=[0] := algebra.join(X_61=[2],X_52=nil); | | 3 | X_63=[0] := algebra.markT(X_62=nil,0@0:oid); | | 9 | X_64=[0] := algebra.semijoin(X_61=nil,X_63=nil); | | 4 | X_65=[0] := algebra.markT(X_64=nil,0@0:oid); | | 2 | X_66=[0] := bat.reverse(X_65=nil); | | 16 | X_67:bat[:oid,:int] =[0] := algebra.leftjoinPath(X_66=nil,X_23=nil,X_16=nil); | | 2401 | barrier X_99 := language.dataflow(); | | 6 | X_68 := sql.resultSet(1,1,X_67=:bat[:oid,:int][0]); | | 6 | sql.rsColumn(X_68=4,"sys.temp_associations","kind","int",32,0,X_67=nil:bat[:oid,:int]); | | 2 | X_76 := io.stdout(); | | 16 | sql.exportResult(X_76=="10792176":streams,X_68=4); | | 2709 | X_5:void := user.s3_1(1:bte,1); | +-------+-------------------------------------------------------------------------------------------------------+ 56 tuples (7.576ms)