Project

General

Profile

« Previous | Next » 

Revision 4928

sql_io.py: cleanup_table(): Fixed bug where couldn't run any update statement when no columns are text

View differences:

lib/sql_io.py
25 25
    cols = [sql_gen.as_Col(strings.ustr(c), table)
26 26
        for c in sql.table_cols(db, table)]
27 27
    cols = filter(lambda c: sql_gen.is_text_col(db, c), cols)
28
    if not cols: return
28 29
    
29 30
    expr = 'trim(both from %s)'
30 31
    for null in null_strs: expr = 'nullif('+expr+', '+db.esc_value(null)+')'

Also available in: Unified diff