Project

General

Profile

« Previous | Next » 

Revision 2853

Added by Aaron Marcuse-Kubitza over 12 years ago

sql.py: mk_select(): Joins: Filtering on no match: Use '~=' sql_gen.CompareCond operator so that IS NULL is always used, regardless of the not-null column's nullability

View differences:

lib/sql.py
557 557 
        # Parse special values
558 558 
        if join_.type_ is sql_gen.filter_out: # filter no match
559 559 
            conds.append((sql_gen.Col(table_not_null_col(db, table), table),
560 
                None))
560 
                sql_gen.CompareCond(None, '~=')))
561 561
562 562 
        query += '\n'+join_.to_str(db, left_table)
563 563

Also available in: Unified diff