Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Check for duplicate columns in insert statements #5419

Open
Dragonchu opened this issue Mar 21, 2023 · 0 comments
Open

Check for duplicate columns in insert statements #5419

Dragonchu opened this issue Mar 21, 2023 · 0 comments
Labels
type/feature req Type: feature request

Comments

@Dragonchu
Copy link

Is your feature request related to a problem? Please describe.

Using the same column at the insertion point will cause the previous value to be overwritten by the next value。
e.g.
given:
insert vertex player (name,name) values "dragonchu":("chuchu",null);
when:
fetch prop on player "dragonchu" yield properties(vertex);
then:
we will get NULL as name value but without any warning.

Describe the solution you'd like

Checking for duplicate columns in insert statements. It can prohibit this behavior like other databases or at least give some warning.

Additional context

We spent a day trying to troubleshoot this problem because my statements were automatically generated and the column names were not clear, resulting in two of the duplicate column names causing the inserted values to never meet expectations.

@Dragonchu Dragonchu added the type/feature req Type: feature request label Mar 21, 2023
@Dragonchu Dragonchu changed the title Checking for duplicate columns in insert statements Check for duplicate columns in insert statements Mar 22, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/feature req Type: feature request
Projects
None yet
Development

No branches or pull requests

1 participant