⚡ Sangsakala Proxy 🏠 Home
Skip to content

fix bug in CREATE TABLE - #642

Merged
mrigger merged 1 commit into
sqlancer:masterfrom
bajinsheng:master
Dec 16, 2022
Merged

mrigger merged 1 commit into
sqlancer:masterfrom
bajinsheng:master

Conversation

@bajinsheng

Copy link
Copy Markdown
Collaborator

The assertion error should not happen when executing EXPLAIN CREATE TABLE statement.

@bajinsheng
bajinsheng requested a review from mrigger December 16, 2022 08:54
@bajinsheng bajinsheng linked an issue Dec 16, 2022 that may be closed by this pull request

@mrigger 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.

Interesting, I didn't know that it was possible to execute a statement like EXPLAIN CREATE TABLE t0(c0 INT);. Does only SQLite support this from the database systems that you tested?

@bajinsheng

Copy link
Copy Markdown
Collaborator Author

SQLite supports this feature: https://github.com/sqlancer/sqlancer/blob/master/src/sqlancer/sqlite3/gen/SQLite3ExplainGenerator.java#L22

After EXPLAIN, any statement is possible

@bajinsheng
bajinsheng enabled auto-merge (squash) December 16, 2022 09:11
@bajinsheng bajinsheng self-assigned this Dec 16, 2022
@mrigger
mrigger disabled auto-merge December 16, 2022 09:35
@mrigger
mrigger merged commit cdcfdf8 into sqlancer:master Dec 16, 2022
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.

Support QPG

2 participants