You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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?
Not sure why this happens. But iirc, maybe this shouldn’t be run using multiple threads(at least I didn’t do that)? I can have a quick check later.
可用于iOS的myMail发送
2023年1月29日 星期日 +0800 下午1:53 发件人 ***@***.*** ***@***.***>:
I think it would be useful to analyze which statements are failing. The rate definitely seems low. @SuriZhang , do you have any idea?
—
Reply to this email directly, view it on GitHub , or unsubscribe .
You are receiving this because you were mentioned. Message ID: <sqlancer/sqlancer/issues/457/1407569950 @ github . com>
@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.
Activity
MingCheng991129 commentedon Jan 29, 2023
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 questdbIs it actually an issue?
mrigger commentedon 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 commentedon Jan 29, 2023
mrigger commentedon Jan 29, 2023
@MingCheng991129 discovered that the number of tables referenced in queries is very high, so that might be the issue.
SuriZhang commentedon 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.