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

Table and column names with hyphens are not handled properly for SQLite queries #892

Open
jalcam opened this issue Oct 31, 2024 · 0 comments
Assignees
Labels
bug 🪲 Something isn't working SQLite 🪶

Comments

@jalcam
Copy link

jalcam commented Oct 31, 2024

Describe the bug
When performing queries such as UPDATE or INSERT using the GUI, errors occur because by default Antares does not apply quotation marks to table or column names that have hyphens in their name.

Message: SqliteError: near "-" : syntax error

This can be corrected manually by putting the quotes and executing the query.

To Reproduce

Insert a new row into a table with column names that have hyphens in their name using the GUI tool.

  1. Go to 'Insert rows'
  2. Fill the data to be inserted
  3. Click "insert"
  4. See error

Expected behavior
The query should run without errors, as long as table or column names with hyphens in the name are enclosed in quotation marks.

Screenshots
Screenshots are attached.

Screenshot from 2024-10-31 12-28-05
Screenshot from 2024-10-31 12-28-46

Example with quotation marks:

Screenshot from 2024-10-31 12-33-33

Application (please complete the following information):

  • App client: Antares
  • App version: 0.7.29
  • Installation source: Snap

Environment (please complete the following information):

  • OS name: Ubuntu 24.04 x86_64 Linux kernel 6.8.0-48-generic
  • DB name: SQLite
  • DB version: 3.45.1
@Fabio286 Fabio286 added bug 🪲 Something isn't working SQLite 🪶 labels Nov 2, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug 🪲 Something isn't working SQLite 🪶
Projects
None yet
Development

No branches or pull requests

2 participants