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

bug: missing index

User, date Message
Written by luc7v
5 months ago
Category: General
5 posts since Sun, 02 Mar 14
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.
Written by ansgar
5 months ago
4940 posts since Fri, 07 Apr 06
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.
Written by ansgar
5 months ago
4940 posts since Fri, 07 Apr 06
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.
Written by luc7v
5 months ago
5 posts since Sun, 02 Mar 14
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.
Written by ansgar
5 months ago
4940 posts since Fri, 07 Apr 06
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

Written by luc7v
5 months ago
5 posts since Sun, 02 Mar 14
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.
Written by ansgar
5 months ago
4940 posts since Fri, 07 Apr 06
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.