Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Duplicate
-
1.0.9
-
None
-
AWS CentOS 7
Description
The maximum of all selected fields within the SELECT statement has a limit in 65535 bytes. It is not a common ERROR 1118 (42000), it is not file format related and can't be reproduced on the regular MariaDB with the same InnoDB_version. It seems that you materialize the SELECT output into TEMP table or something like this, not sure.
The issue can be easily reproduced in following ways:
1.
select * from (select cast(123 AS CHAR(21845)) as f,cast(123 AS CHAR(21845)) as g,cast(123 AS CHAR(21845)) as h) m1; |
2.
CREATE TABLE `t1` ( |
`c1` varchar(32765) NOT NULL, |
`c2` varchar(32766) NOT NULL |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
|
insert into t1 select '123','123'; |
|
select c1,c2,c1 from t1; |
|
ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs |
The same perfectly works on 10.1.22-MariaDB.
Attachments
Issue Links
- duplicates
-
MCOL-713 Some functions return "The maximum row size" error when TEXT/LONGTEXT is used in a table
- Closed