Revision 2354
Added by Aaron Marcuse-Kubitza over 12 years ago
| sql.py | ||
|---|---|---|
| 861 | 861 |
|
| 862 | 862 |
db.log_debug("Setting missing rows' pkeys to NULL")
|
| 863 | 863 |
missing_rows_joins = input_joins+[sql_gen.Join(pkeys_ref[0], |
| 864 |
{in_pkey: sql_gen.CompareCond(in_pkey_col, '~=')},
|
|
| 865 |
sql_gen.filter_out)] # must use '~=' or query will take forever
|
|
| 864 |
{in_pkey: sql_gen.join_same_not_null}, sql_gen.filter_out)]
|
|
| 865 |
# must use join_same_not_null or query will take forever
|
|
| 866 | 866 |
run_query_into_pkeys(*mk_select(db, missing_rows_joins, |
| 867 | 867 |
[in_pkey_col, sql_gen.NamedCol(out_pkey, None)], start=0)) |
| 868 | 868 |
|
Also available in: Unified diff
sql.py: put_table(): Setting missing rows' pkeys to NULL: Use new sql_gen.join_same_not_null