MySQL Bugs: #110876: While creating table I wrongly get Error Code: 1118 Row size too large (> 8126)

Bug #110876	While creating table I wrongly get Error Code: 1118 Row size too large (> 8126)
Submitted:	1 May 2023 15:49	Modified:	2 May 2023 12:40
Reporter:	Filipe Cruz	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Errors	Severity:	S3 (Non-critical)
Version:		OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	Error 1118

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
While creating a table with 300 columns of VARCHAR(25) I get an error code 1118 saying row size is too large.

300 * 25 is 7500 which is less than 8126.

I have ENGINE=InnoDB DEFAULT CHARSET=utf8mb.

I have tired row format as Dynamic and also compressed. Same error.

How to repeat:
CREATE TABLE `ai_location` (
`TimeStamp` datetime DEFAULT NULL,
`AI001` varchar(25) DEFAULT NULL,
`AI002` varchar(25) DEFAULT NULL,
.
.
.

`AI299` varchar(25) DEFAULT NULL,
`AI300` varchar(25) DEFAULT NULL)
ENGINE=InnoDB DEFAULT CHARSET=utf8mb;

Hello Filipe,

Thank you for the bug report.
Imho this is duplicate of Bug #79941, please see Bug #79941.

Regards,
Ashwini Patil