Lines Matching refs:table1
12 table1 = (('id', 'colour'),
22 table3 = join_impl(table1, table2, key='id')
30 table4 = join_impl(table1, table2)
79 table1 = (('id', 'colour'),
89 table3 = join_impl(table1, table2, key='id')
99 table1 = (('id', 'colour'),
104 table3 = join_impl(table1, table2, key='id')
108 table1 = (('id', 'colour'),)
113 table3 = join_impl(table1, table2, key='id')
120 table1 = (('id', 'colour'),
133 actual = join_impl(table1, table2, key='id')
135 actual = join_impl(cut(table1, 'id'), table2, key='id')
137 actual = join_impl(table1, cut(table2, 'id'), key='id')
139 actual = join_impl(cut(table1, 'id'), cut(table2, 'id'), key='id')
145 table1 = (('id', 'colour'),
154 table3 = join_impl(table1, table2, key='id', lprefix='l_', rprefix='r_')
163 table1 = (('id', 'colour'),
172 table3 = join_impl(table1, table2, lkey='id', rkey='identifier')
181 table1 = (('id', 'color', 'cost'),
197 actual = join_impl(table1, table2, key='id')
227 table1 = (('id', 'colour'),
237 table3 = leftjoin_impl(table1, table2, key='id')
248 table4 = leftjoin_impl(table1, table2)
255 table1 = (('id', 'colour'),
264 table3 = leftjoin_impl(table1, table2, key='id')
275 table4 = leftjoin_impl(table1, table2)
282 table1 = (('id', 'colour'),
291 table3 = leftjoin_impl(table1, table2, key='id')
300 table4 = leftjoin_impl(table1, table2)
326 table1 = (('id', 'colour'),
333 table3 = leftjoin_impl(table1, table2, key='id')
345 table1 = (('id', 'colour'),
362 actual = leftjoin_impl(table1, table2, key='id')
364 actual = leftjoin_impl(cut(table1, 'id'), table2, key='id')
366 actual = leftjoin_impl(table1, cut(table2, 'id'), key='id')
368 actual = leftjoin_impl(cut(table1, 'id'), cut(table2, 'id'), key='id')
374 table1 = (('id', 'color', 'cost'),
390 actual = leftjoin_impl(table1, table2, key='id')
405 table1 = (('id', 'colour'),
415 table3 = leftjoin_impl(table1, table2, key='id', lprefix='l_', rprefix='r_')
426 table1 = (('id', 'colour'),
436 table3 = leftjoin_impl(table1, table2, lkey='id', rkey='identifier')
464 table1 = (('id', 'colour'),
474 table3 = rightjoin_impl(table1, table2, key='id')
485 table4 = rightjoin_impl(table1, table2)
492 table1 = (('id', 'colour'),
503 table3 = rightjoin_impl(table1, table2, key='id')
512 table4 = rightjoin_impl(table1, table2)
519 table1 = (('id', 'colour'),
530 table3 = rightjoin_impl(table1, table2, key='id')
541 table4 = rightjoin_impl(table1, table2)
548 table1 = (('id', 'colour'),)
555 table3 = rightjoin_impl(table1, table2, key='id')
566 table1 = (('id', 'colour'),
583 actual = rightjoin_impl(table1, table2, key='id')
585 actual = rightjoin_impl(cut(table1, 'id'), table2, key='id')
587 actual = rightjoin_impl(table1, cut(table2, 'id'), key='id')
589 actual = rightjoin_impl(cut(table1, 'id'), cut(table2, 'id'), key='id')
594 table1 = (('id', 'colour'),
604 table3 = rightjoin_impl(table1, table2, key='id', lprefix='l_',
616 table1 = (('id', 'colour'),
626 table3 = rightjoin_impl(table1, table2, lkey='id', rkey='identifier')
638 table1 = (('id', 'color', 'cost'),
654 actual = rightjoin_impl(table1, table2, key='id')
688 table1 = (('id', 'colour'),
699 table3 = outerjoin(table1, table2, key='id')
712 table4 = outerjoin(table1, table2)
719 table1 = (('id', 'colour'),
729 table3 = outerjoin(table1, table2, key='id')
741 table4 = outerjoin(table1, table2)
748 table1 = (('colour', 'id'),
756 table3 = outerjoin(table1, table2, key='id')
768 table1 = (('id', 'colour'),
776 table3 = outerjoin(table1, table2, key='id')
788 table1 = (('id', 'colour'),
807 actual = outerjoin(table1, table2, key='id')
809 actual = outerjoin(cut(table1, 'id'), table2, key='id')
811 actual = outerjoin(table1, cut(table2, 'id'), key='id')
813 actual = outerjoin(cut(table1, 'id'), cut(table2, 'id'), key='id')
819 table1 = (('id', 'colour'),
830 table3 = outerjoin(table1, table2, key='id', lprefix='l_', rprefix='r_')
845 table1 = (('id', 'colour'),
856 table3 = outerjoin(table1, table2, lkey='id', rkey='identifier')
871 table1 = (('id', 'color', 'cost'),
887 actual = outerjoin(table1, table2, key='id')
905 table1 = (('id', 'colour'),
911 table3 = crossjoin(table1, table2)
922 table1 = (('id', 'colour'),
926 table3 = crossjoin(table1, table2)
932 table1 = (('id', 'colour'),
943 actual = crossjoin(table1, table2, key='id')
945 actual = crossjoin(cut(table1, 'id'), table2, key='id')
947 actual = crossjoin(table1, cut(table2, 'id'), key='id')
949 actual = crossjoin(cut(table1, 'id'), cut(table2, 'id'), key='id')
955 table1 = (('id', 'colour'),
961 table3 = crossjoin(table1, table2, prefix=True)
972 table1 = (('id', 'colour'),
981 table3 = antijoin_impl(table1, table2, key='id')
989 table4 = antijoin_impl(table1, table2)
996 table1 = (('id', 'colour'),
1003 actual = antijoin_impl(table1, table2, key='id')
1004 expect = table1
1009 table1 = (('id', 'colour'),
1023 actual = antijoin_impl(table1, table2, key='id')
1025 actual = antijoin_impl(cut(table1, 'id'), table2, key='id')
1027 actual = antijoin_impl(table1, cut(table2, 'id'), key='id')
1029 actual = antijoin_impl(cut(table1, 'id'), cut(table2, 'id'), key='id')
1035 table1 = (('id', 'colour'),
1044 table3 = antijoin_impl(table1, table2, lkey='id', rkey='identifier')
1066 table1 = (('id', 'color', 'cost'),
1076 actual = lookupjoin_impl(table1, table2, key='id')
1085 actual = lookupjoin_impl(table1, table2)
1096 table1 = (('id', 'color', 'cost'),
1109 actual = lookupjoin_impl(table1, table2, key='id')
1120 table1 = (('id', 'color', 'cost'),
1130 actual = lookupjoin_impl(table1, table2, key='id', lprefix='l_',
1141 table1 = (('id', 'color', 'cost'),
1151 actual = lookupjoin_impl(table1, table2, lkey='id', rkey='identifier')
1160 table1 = (('id', 'color', 'cost'),
1172 actual = lookupjoin_impl(table1, table2, key='id')
1174 actual = lookupjoin_impl(cut(table1, 'id'), table2, key='id')
1176 actual = lookupjoin_impl(table1, cut(table2, 'id'), key='id')
1178 actual = lookupjoin_impl(cut(table1, 'id'), cut(table2, 'id'), key='id')
1218 table1 = (('foo', 'bar'),
1231 left, right = unjoin(table1, 'bar')