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

Add support for QuestDB #457

Open
mrigger opened this issue Jan 18, 2022 · 5 comments
Open

Add support for QuestDB #457

mrigger opened this issue Jan 18, 2022 · 5 comments
Assignees
Labels
good first issue Good for newcomers

Comments

@mrigger
Copy link
Contributor

mrigger commented Jan 18, 2022

See questdb/questdb#595.

@mrigger mrigger added help wanted Extra attention is needed good first issue Good for newcomers and removed help wanted Extra attention is needed labels Jan 18, 2022
@MingCheng991129
Copy link
Contributor

I ran the code of QuestDB and found that the correctness rate (successful statements) of generated queries are very low (around 5%).
[2023/01/29 00:35:33] Executed 9 queries (1 queries/s; 0.40/s dbs, successful statements: 4%). Threads shut down: 1.
The running command I use: java -jar sqlancer-*.jar --num-threads 4 questdb
Is it actually an issue?

@mrigger
Copy link
Contributor Author

mrigger commented Jan 29, 2023

I think it would be useful to analyze which statements are failing. The rate definitely seems low. @SuriZhang, do you have any idea?

@SuriZhang
Copy link
Collaborator

SuriZhang commented Jan 29, 2023 via email

@mrigger
Copy link
Contributor Author

mrigger commented Jan 29, 2023

@MingCheng991129 discovered that the number of tables referenced in queries is very high, so that might be the issue.

@SuriZhang
Copy link
Collaborator

SuriZhang commented Jan 30, 2023

@MingCheng991129 pls see #712 . this might give you some ideas on the limitation of the current (and very preliminary) version of support of questDB in sqlancer.
I talked with Manuel offline, we believe the tables might not be the cause. also we checked the queries generated are syntax-correct.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
good first issue Good for newcomers
Projects
None yet
Development

No branches or pull requests

3 participants