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

[bug] the table cannot be created because the reserved word is incorrectly set #7444

Closed
Nliver opened this issue Jan 17, 2024 · 2 comments
Closed
Assignees
Labels
enhancement New feature or request SQL
Milestone

Comments

@Nliver
Copy link

Nliver commented Jan 17, 2024

Describe the bug
the table cannot be created because the reserved word is incorrectly set
image
image

Software versions

  • MonetDB version number:Jun2023 Feature Release (11.47.3)
  • OS and version: Ubuntu 20.06
  • self-installed and compiled
@mvdvm mvdvm added enhancement New feature or request SQL labels Jan 18, 2024
@mvdvm
Copy link
Contributor

mvdvm commented Jan 18, 2024

The SQL parser currently treats greatest as a special keyword, because it is also a built-in function name.
We need to further investigate if it should be accepted or treated as a reserved keyword.
This also applies to least.

As a workaround you can enclose the column name with double quotes i.e.:
create table ttt("greatest" int);
select "greatest" from ttt;

@njnes njnes self-assigned this Jan 24, 2024
@njnes njnes added this to the NEXTRELEASE milestone Jan 24, 2024
@njnes
Copy link
Contributor

njnes commented Jan 24, 2024

pushed a fix to the dec2023 branch

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request SQL
Projects
None yet
Development

No branches or pull requests

4 participants