bug: missing index

[expired user #7833]'s profile image [expired user #7833] posted 10 years ago in General Permalink
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's profile image ansgar posted 10 years ago Permalink
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.
Code modification/commit from ansgar.becker, 10 years ago, revision 8.3.0.4718
Do not ignore primary keys with KEY_BLOCK_SIZE=xyz. See http://www.heidisql.com/forum.php?t=15049
ansgar's profile image ansgar posted 10 years ago Permalink
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.
[expired user #7833]'s profile image [expired user #7833] posted 10 years ago Permalink
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's profile image ansgar posted 10 years ago Permalink
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:

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
[expired user #7833]'s profile image [expired user #7833] posted 10 years ago Permalink
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's profile image ansgar posted 10 years ago Permalink
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.