Project

General

Profile

« Previous | Next » 

Revision 2407

sql.py: put_table(): Add pkey on returned pkeys table to enable fast joins

View differences:

lib/sql.py
948 948
            {row_num_col: sql_gen.join_same_not_null})]
949 949
        run_query_into_pkeys(*mk_select(db, pkey_joins, pkeys_names, start=0))
950 950
    
951
    db.log_debug("Adding pkey on returned pkeys table to enable fast joins")
952
    index_pkey(db, pkeys)
953
    
951 954
    db.log_debug("Setting missing rows' pkeys to NULL")
952 955
    missing_rows_joins = input_joins+[sql_gen.Join(pkeys,
953 956
        {in_pkey: sql_gen.join_same_not_null}, sql_gen.filter_out)]

Also available in: Unified diff