distal-attribute
distal-attribute
distal-attribute
distal-attribute

Tables containing long enum lists cause application crash

chabberwock posted 2 months ago in General

Trying to open tables containing long enum list as one of the fields will crash HeidiSQL

2 attachment(s):
ansgar posted 2 months ago

Ok, how long is long, in your case, roughly?

chabberwock posted 2 months ago

Ok, how long is long, in your case, roughly? Well i havent tested exact length when it starts to crash, but table schema in 'crashes.txt' is long enough :)

ansgar posted 2 months ago

I made some tests and found out that not the number of enum elements is what is causing this issue, but the length of the definition between parentheses as a whole. E.g.

  • ENUM ('val1',...'val200') works
  • ENUM ('loremipsumloremipsum1',...,'loremipsumloremipsum200') crashes

The barrier is somewhere between 3666 and 3771. Strange thing.

Please login to leave a reply, or register at first.