[...] added to result column when content is 265 characters long

halvor07's profile image halvor07 posted 7 years ago in Running SQL scripts Permalink

I have a problem where HeidiSQL adds "[...]" at the end of the column when it contains exactly 256 characters. It only happens in UI in the Query tab when doing a SELECT, so it is not saved to the DB unless you edit and save the column without removing it first. But it makes it look like the column ends with "[...]" when it actually doesn't.

HeidiSQL version: 9.4.0.5152 (64 Bit) Reproduced on MySQL 5.7.14 on Windows 10 and MySQL 5.5.52 on Debian.

How to reproduce:

  1. Create a table with one TEXT column.
  2. Insert a row with 256 characters.
  3. Go to the query tab and SELECT * from the table.
  4. Try to edit the text and find that the "[...]" remains.
ansgar's profile image ansgar posted 7 years ago Permalink

I cannot reproduce that here. No matter if I have a value with 256 or 296 characters. Probably that "[...]" is stored in your row?

halvor07's profile image halvor07 posted 7 years ago Permalink

I just noticed that you have to have at least one whitespace to reproduce the problem.

"[...]" is NOT stored. It shows up in the "Data" tab too, but here it disappears when I try to edit the column. Please see attached gif.

1 attachment(s):
  • HeidiSQL_dotdotdot_bug
kalvaro's profile image kalvaro posted 7 years ago Permalink

In my copy of HeidiSQL I can't even see any [...] anywhere. It uses just ... as ellipsis marker (without square brackets).

:-?

ansgar's profile image ansgar posted 7 years ago Permalink

Hm, I can't see it. Could you post your CREATE TABLE code plus some INSERT rows so I can probably reproduce it?

ansgar's profile image ansgar posted 7 years ago Permalink

Oh, now I can suddenly reproduce it. Not sure why it was different yesterday, but now when I have exactly 256 characters in a TEXT column, the thingy appears. Will check why that happens.

Code modification/commit e74ccec from ansgarbecker, 7 years ago, revision 5154
Prevent inserting cell text ellipsis in query tab. See https://www.heidisql.com/forum.php?t=23353
ansgar's profile image ansgar posted 7 years ago Permalink

Fixed that, in r5154.

halvor07's profile image halvor07 posted 7 years ago Permalink

Nice! Thanks!

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