Not able to parse two queries at once
- Dominant language
- Go
- Stars
- 24.4k
- Forks
- 873
- Avg merge
- 1d 8h
- Merged PRs (30d)
- 120
Description
In MySQL, I'm able to provide two queries at the same time and MySQL executes them in sequence. In Dolt, I get a parse error (Dolt is able to execute the queries if provided separately).
MySQL
```
mysql> drop table t0; create table t0(c0 int);
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
```
Dolt
```
tmp/main*> drop table t0; create table t0(c0 int);
syntax error at position 22 near 'create'
tmp/main*> drop table t0;
Query OK, 0 rows affected (0.01 sec)
tmp/main*> create table t0(c0 int);
Query OK, 0 rows affected (0.01 sec)
```
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reproducing the combined DROP TABLE and CREATE TABLE statements in the Dolt SQL prompt, then compare with running them separately as shown. Done means Dolt accepts both statements in one input and executes them in sequence without a parse error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, mysql, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100