FazBrowse GitHub Viewer | Trending |
URL:
| Home
Tools: [Download Repo ZIP]   [Original HTTPS Page]

Add initial QuestDB support with simple SELECT generator (Fixes #457) by Swastik092 · Pull Request #1277 · sqlancer/sqlancer · GitHub

Add initial QuestDB support with simple SELECT generator (Fixes #457) - #1277

Open
Swastik092 wants to merge 4 commits into
sqlancer:mainfrom
Swastik092:questdb-support-fix
Open

Add initial QuestDB support with simple SELECT generator (Fixes #457)#1277
Swastik092 wants to merge 4 commits into
sqlancer:mainfrom
Swastik092:questdb-support-fix

Conversation

Copy link
Copy Markdown

This PR adds initial support for QuestDB in SQLancer.

Changes included:

  • Created QuestDBQueryGenerator.java to generate simple SELECT queries.
  • Updated QuestDBProvider.java to use the new generator.
  • Ensured queries are executed against a running QuestDB instance.
  • Limited multi-threading (--num-threads 1) for stability during testing.

Currently, only basic SELECT queries are supported. INSERT, DELETE, and more complex queries will be added in future iterations.

This addresses Issue #457 and lays the foundation for full QuestDB testing support.

mrigger left a comment

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Choose a reason Spam Abuse Off Topic Outdated Duplicate Resolved Low Quality

Thanks, this is great! We currently don't have a CI/CD test for QuestDB. Do you think it would be possible to add one first before adding new features?

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Choose a reason Spam Abuse Off Topic Outdated Duplicate Resolved Low Quality

Seems like an accidental commit.

errors.add("missing required column");
errors.add("table does not exist");
errors.add("permission denied");
errors.add("syntax error in INSERT statement");

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Choose a reason Spam Abuse Off Topic Outdated Duplicate Resolved Low Quality

Syntax errors are always unexpected, so we should fix this in the generator.

return r.getInteger(0, 3);
case TRUNCATE:
return r.getInteger(0, 5);
case UPDATE:

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Choose a reason Spam Abuse Off Topic Outdated Duplicate Resolved Low Quality

I think we should only add new features once we have a CI/CD that works for a given QuestDB version.

This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants


Back | FazBrowse Home | New Git URL