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.