dolthub / dolthub/dolt

Not able to parse two queries at once

Open
#10,436 0 comments 1 reaction 0 assignees View on GitHub
bug enhancement
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.