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

# bug: missing index

luc7v posted 1 year ago in General
I wanted to verify some indexes and, to my surprise, HeidiSQL doesn't show them.

SHOW CREATE TABLE returns it like this.

PRIMARY KEY (term) KEY_BLOCK_SIZE=1024

It seems KEY_BLOCK_SIZE confuses HeidiSQL.

Even more, because HeidiSQL doesn't detect the PRIMARY index, there are problems with editing the table in the grid.

ansgar posted 1 year ago
Yes, HeidiSQL does not expect a "KEY_BLOCK_SIZE" after the PK definition. I can fix that, but I'm failing to create a PK with a key block size - I have an InnoDB table with row format "compressed", and then add a PK with key_block_size=1024, but when I run SHOW CREATE TABLE compressed, the key_block_size is not there. Does that require a specific data type perhaps? I tried int and varchar yet.
ansgar posted 1 year ago
Please try out r4718. HeidiSQL expects (and ignores) the KEY_BLOCK_SIZE keyword now. Only I couldn't test that, due to the above mentioned problem.
luc7v posted 1 year ago
It seems OK now, thank you.

PS. I replaced my older portable version with the newest one and I lost all my settings. I think you should not include any setting file in the zip.
ansgar posted 1 year ago
The settings file is for those who do not have that file yet. If you run HeidiSQL without that file, then it runs in "normal" instead of "portable" mode. The readme file also says so:

readme wrote: When you download the portable zip, that "portable_settings.txt" needs to be manually
copied from your old directory, overwriting the empty default file.

Also, you can pass a custom settings file with the --psettings command line switch:

c:\path\to\heidisql.exe --psettings=c:\temp\p.txt

luc7v posted 1 year ago
I know, you are covered :)