-
-
Notifications
You must be signed in to change notification settings - Fork 567
Open
dolthub/go-mysql-server
#3055Labels
correctnessWe don't return the same result as MySQLWe don't return the same result as MySQLgood reproEasily reproducible bugsEasily reproducible bugssqlIssue with SQLIssue with SQL
Description
MySQL:
mysql> create table t (i int, j int);
Query OK, 0 rows affected (0.0187 sec)
mysql> insert into t(i, j) values ();
ERROR: 1136: Column count doesn't match value count at row 1
mysql> insert into t(j) values ();
ERROR: 1136: Column count doesn't match value count at row 1
mysql> insert into t(i) values ();
ERROR: 1136: Column count doesn't match value count at row 1
mysql> select * from t;
Empty set (0.0029 sec)
Dolt:
tmp/main*> create table t1 (i int, j int);
tmp/main*> insert into t1 values ();
Query OK, 1 row affected (0.00 sec)
tmp/main*> insert into t1(i,j) values ();
Query OK, 1 row affected (0.00 sec)
tmp/main*> insert into t1(j) values ();
Query OK, 1 row affected (0.00 sec)
tmp/main*> insert into t1(i) values ();
Query OK, 1 row affected (0.00 sec)
tmp/main*> select * from t;
+-----+
| i |
+-----+
| 123 |
+-----+
1 row in set (0.00 sec)
Metadata
Metadata
Assignees
Labels
correctnessWe don't return the same result as MySQLWe don't return the same result as MySQLgood reproEasily reproducible bugsEasily reproducible bugssqlIssue with SQLIssue with SQL