Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

Recognize generated columns in data table

JürgenNiesner's profile image JürgenNiesner posted 6 months ago in General

Hi,

when there is generated column in an table, the corresponding column in the data tabview should not be enabled to edit.

Example for my table:

CREATE TABLE `t1` (
    `ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `full_name` VARCHAR(255) AS (concat(`first_name`,_utf8mb3' ',`last_name`)) VIRTUAL,
    `first_name` VARCHAR(10) NULL DEFAULT NULL,
    `last_name` VARCHAR(10) NULL DEFAULT NULL,
    PRIMARY KEY (`ID`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;

Jürgen

ansgar's profile image ansgar posted 6 months ago

Please post this in the bugtracker.

JürgenNiesner's profile image JürgenNiesner posted 6 months ago

posted in Bugtracker: Issue #462

timpaines's profile image timpaines posted 6 months ago

I dont think there is an issue with this code

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