Tables containing long enum lists cause application crash

[expired user #10647]'s profile image [expired user #10647] posted 7 years ago in General Permalink

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

2 attachment(s):
ansgar's profile image ansgar posted 7 years ago Permalink

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

[expired user #10647]'s profile image [expired user #10647] posted 7 years ago Permalink

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's profile image ansgar posted 7 years ago Permalink

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.