Project

General

Profile

« Previous | Next » 

Revision 3298

sql.mk_select() calls: Removed no longer needed start=0 to turn off missing WHERE, LIMIT, or OFFSET clause warning

View differences:

sql_io.py
91 91
            -- Insert the value and error for *each* source column.
92 92
            FOR "column" IN
93 93
'''+sql.mk_select(db, sql_gen.NamedValues('c', None, [[c.name] for c in srcs]),
94
    order_by=None, start=0)+'''
94
    order_by=None)+'''
95 95
            LOOP
96 96
                BEGIN
97 97
'''+sql.mk_insert_select(db, errors_table, errors_table_cols,
......
276 276
    # Place in new table for speed and so don't modify input if values edited
277 277
    in_table = sql_gen.Table('in')
278 278
    mapping = dicts.join(mapping, sql.flatten(db, in_table, input_joins,
279
        in_cols, preserve=[in_pkey_col], start=0))
279
        in_cols, preserve=[in_pkey_col]))
280 280
    input_joins = [in_table]
281 281
    db.log_debug('Temp table: '+strings.as_tt(in_table.to_str(db)), level=2)
282 282
    
......
299 299
        full_in_table_cols.append(default)
300 300
        default = sql_gen.with_table(default, full_in_table)
301 301
    sql.run_query_into(db, sql.mk_select(db, in_table, full_in_table_cols,
302
        order_by=None, start=0), into=full_in_table)
302
        order_by=None), into=full_in_table)
303 303
    sql.add_pkey(db, full_in_table)
304 304
    
305 305
    pkeys_names = [in_pkey, out_pkey]
......
310 310
        distinct_on = []
311 311
        if distinct: distinct_on=[in_pkey_col]
312 312
        query = sql.mk_select(db, joins, cols, distinct_on=distinct_on,
313
            order_by=None, start=0)
313
            order_by=None)
314 314
        
315 315
        if pkeys_table_exists_ref[0]:
316 316
            sql.insert_select(db, into, pkeys_names, query, **kw_args)
......
326 326
    def mk_main_select(joins, cols):
327 327
        conds_ = [(sql_gen.with_table(k, insert_in_table), v) for k, v in conds]
328 328
        return sql.mk_select(db, joins, cols, conds_, limit=limit_ref[0],
329
            order_by=None, start=0)
329
            order_by=None)
330 330
    
331 331
    exc_strs = set()
332 332
    def log_exc(e):

Also available in: Unified diff