order_by=None, limit=limit, start=start, table_is_esc=table_is_esc,

            default_table=in_tables0)

    # Do inserts and selects

    out_pkeys_ref = ['out_pkeys_'+temp_suffix]

    while True:

            break # insert successful

        except DuplicateKeyException, e:

            join_cols = util.dict_subset_right_join(mapping, e.cols)

            select_joins = insert_joins + [(out_table, join_cols)]

            # Get pkeys of already existing rows

            out_col, = e.cols

            try: in_col = mapping[out_col]

            except KeyError: # no mapping for missing col, so every row invalid

                run_query_into_pkeys(*mk_select(db, insert_joins,

                    [in_pkey_col, sql_gen.NamedCode(out_pkey, None)],

                    order_by=None, start=0, table_is_esc=table_is_esc))

                break

            else:

                conds[in_col] = sql_gen.CompareCond(None, '!=')

                # rerun loop with additional constraints

        except FunctionValueException, e:

            assert e.name == sql_gen.unescape_table(out_table)

            out_col = 'value' # assume function param was named "value"

            in_col = mapping[out_col]

            # rerun loop with additional constraints

    return (pkeys_ref[0], out_pkey)