Persistant field not show in HeidiSQL

jflietstra's profile image jflietstra posted 8 years ago in General Permalink

Hi,

I use the Virtuality options in MariaDB (10.1) for a long time and i see that HeidiSql did not show it in the table overview.

When i add this option manual in Heidisql and save it i see that the option is executed but in the list is it cleared directly!!

When i add a record in the database the persistant field is correct calculated by my expression...

When i look at the CREATE TaABLE tab in HeidiSQL i see tha creation code without my expression!!!

ansgar's profile image ansgar posted 8 years ago Permalink

I recently fixed some stuff for virtual columns. Please ensure you are using the latest build and report back if the problem persists.

jflietstra's profile image jflietstra posted 8 years ago Permalink

I have the latest version :(

ansgar's profile image ansgar posted 8 years ago Permalink

Ok, then please post the CREATE TABLE code from a SHOW CREATE TABLE yourtable here, so I can reproduce that.

jflietstra's profile image jflietstra posted 8 years ago Permalink
CREATE TABLE `osodossier` (
    `OSODossierID` BIGINT(20) NOT NULL AUTO_INCREMENT,
    `Aanmaakdatum` DATETIME NULL DEFAULT NULL,
    `Omschrijving` VARCHAR(255) NULL DEFAULT NULL COLLATE 'latin1_general_ci',
    `Type` VARCHAR(35) NULL DEFAULT NULL COLLATE 'latin1_general_ci',
    `XMLAntwoord` LONGTEXT NULL COLLATE 'latin1_general_ci',
    `XMLVraag` LONGTEXT NULL COLLATE 'latin1_general_ci',
    `BronBrin` VARCHAR(10) NULL DEFAULT NULL COLLATE 'latin1_general_ci',
    `DoelBrin` VARCHAR(10) NULL DEFAULT NULL COLLATE 'latin1_general_ci',
    `BSN` VARCHAR(9) NULL DEFAULT NULL COLLATE 'latin1_general_ci',
    `AanmaakdatumDESC` BIGINT(20) NULL,
    `Status` VARCHAR(1) NULL DEFAULT NULL COLLATE 'latin1_general_ci',
    PRIMARY KEY (`OSODossierID`)
)
COLLATE='latin1_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=2
;

On the field AanmaakdatumDESC is a formula Aanmaakdatum * -1 PERSISTANT

Code modification/commit from ansgarbecker, 8 years ago, revision 9.3.0.5037
Fix detection of virtual columns without "GENERATED ALWAYS" clause. See http://www.heidisql.com/forum.php?t=20248
ansgar's profile image ansgar posted 8 years ago Permalink

r5037 fixes the issue. HeidiSQL expected a space character where there is none in most cases.

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