Skip to content

Bug 35950582 - /INSERT GENERATES EXTRA FK COLUMN #4

@vadim-tropashko

Description

@vadim-tropashko

quicksql input producing the wrong insert statement with an extra column:

team_members
   username
projects /insert 10
   name
   project_lead /nn /references team_members

It generates the following insert statement (I ignored the before and after, as just want to focus on the insert that is broken):

...
insert into projects (
    id,
    team_member_id,
    name,
    project_lead
) values (
    1,
    94,
    'Augusta Wilkerson',
    'N/A'
);
...

Please note there is an extra generated column called team_member_id. project_lead is the fk, and should have the random IDs, and team_member_id should not be there.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions