Tables containing long enum lists cause application crash

chabberwock posted 12 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 12 months ago

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

chabberwock posted 12 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 12 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.