Project

General

Profile

« Previous | Next » 

Revision 2460

sql_gen.py: Join.to_str(): Fixed bug where USING should be used if all columns are join_same_not_null, rather than join_same, because USING uses plain = for comparison. sql.py: put_table(): input_joins now can use sql_gen.join_same_not_null in order to use USING syntax.

View differences:

sql.py
875 875
    in_tables0 = in_tables_.pop(0) # first table is separate
876 876
    in_pkey = pkey(db, in_tables0, recover=True)
877 877
    in_pkey_col = sql_gen.as_Col(in_pkey, in_tables0)
878
    input_joins = [in_tables0]+[sql_gen.Join(v, {in_pkey: sql_gen.join_same})
879
        for v in in_tables_]
878
    input_joins = [in_tables0]+[sql_gen.Join(v,
879
        {in_pkey: sql_gen.join_same_not_null}) for v in in_tables_]
880 880
    
881 881
    log_debug('Joining together input tables')
882 882
    # Place in new table for speed and so don't modify input if values edited

Also available in: Unified diff