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

bug: missing index

luc7v posted 10 months 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.

Please repair this.
ansgar posted 10 months 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 10 months 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 10 months 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 10 months 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 10 months ago
I know, you are covered :)

But who reads readme files? :)

It's just a better practice to avoid this. The program can create the settings file when it's missing.
ansgar posted 10 months ago
As said above - if you start heidisql.exe without that file, it runs in "normal" mode, and does not create that portable settings file automatically.

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