dolthub / dolthub/dolt

Confirmation messages for `insert` and `alter` missing info regarding records, duplicates, and warnings

Open
#9,607 0 comments 0 reactions 0 assignees View on GitHub
cli
Dominant language
Go
Stars
24.4k
Forks
873
Avg merge
1d 8h
Merged PRs (30d)
120

Description

dolt
```
tmp/main*> insert into set_table values(0, 'abc,def'),(1,'def'),(2,'ghi');
Query OK, 3 rows affected (0.01 sec)
tmp/main*> alter table set_table modify column c0 varchar(100);
Query OK, 0 rows affected (0.01 sec)
```

mysql
```
mysql> insert into set_table values (0, 'abc,def'),(1, 'def'),(2,'ghi');
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> alter table set_table modify column c0 varchar(100);
Query OK, 3 rows affected (0.03 sec)
Records: 3 Duplicates: 0 Warnings: 0
```

Note that the number of rows affected for the `alter` statement is also different (filed as separate issue in #9606)

Contributor guide

No contributing guide indexed for this repository

Research direction

No files, tests, or entry points are named. Start by locating the code that formats confirmation messages for INSERT and ALTER TABLE statements, then compare its output with the MySQL examples; done means both messages report Records, Duplicates, and Warnings while preserving the separate row-count issue in #9606.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, mysql
Domain
database
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.