Details
Description
Maybe it should just go to documentation as a limitation. It is unfortunate however if it keeps returning "1" rather than some non-natural number.
CREATE OR REPLACE TABLE t (a CHAR(1)) VALUES ('a'),('b'),('foo'); |
10.4 69bd2c88 |
CREATE OR REPLACE TABLE t (a CHAR(1)) VALUES ('a'),('b'),('foo'); |
Warnings:
|
Warning 1406 Data too long for column 'a' at row 1 |
Consequently, ERROR_INDEX from MDEV-10075 is not calculated for table value constructors, either.
I"ve set affected versions to 10.3+ because that's where table value constructors were introduced, and surely the number is not calculated in 10.3 either; but the test case above is only applicable to 10.4+, 10.3 doesn't seem to allow to create table from a table value constructor.
Attachments
Issue Links
- is caused by
-
MDEV-10075 Provide index of error causing error in array INSERT
- Closed
- relates to
-
MDEV-26635 ROW_NUMBER is not 0 for errors not caused because of rows
- Closed