[MDEV-14492] Record size greater than 64k Created: 2017-11-24  Updated: 2017-11-24  Resolved: 2017-11-24

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Data Definition - Procedure, Storage Engine - InnoDB
Affects Version/s: N/A
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: MariaDB/MySQL user Assignee: Sergei Golubchik
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Windows NT 6.3


 Description   

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 ma
nual. You have to change some columns to TEXT or BLOBs

I don't want use blobs for long varbinary fields because there is possibility to index by them. The user in their CMS has possibility to "alter table add column" to configure their database. The length exceeded today 65535 and system is blocked. I retested the system on Windows. I don;t know what error is issued on production version.

This bug probably by compatibility is present also in MariaDB.

 Comments   
Comment by Sergei Golubchik [ 2017-11-24 ]

This is not a bug, but expected behavior. Use blobs instead of long varchars to reduce the record size. indexes on long varchars are not very useful anyway.

Generated at Thu Feb 08 08:14:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.