Confirmation messages for `insert` and `alter` missing info regarding records, duplicates, and warnings
- 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