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.
bug: missing index
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
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:
Also, you can pass a custom settings file with the --psettings command line switch:
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
Please login to leave a reply, or register at first.