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

[BUG] Virtual field in export

pmml-md posted 2 months ago in General

Hello,

Just to validate if this in intended or a bug. When exporting a table with a virtual field, it seems that the insert statements contain the value(s) of the virtual field but shouldn't.

This might be intended but causes the export to fail.

Regards,

kalvaro posted 2 months ago

It may be entirely possible that HeidiSQL does not really support virtual columns in MySQL (the developer can confirm that). In 2011 it added support for virtual columns in MariaDB. Some time later MySQL itself added the feature, but eventually used a different syntax—not sure whether HeidiSQL caught up.

pmml-md posted 1 month ago

Hello, It does suport virtual columns in MySQL. My point is rather that values of virtual columns shouldn't be exported (as far as data is concerned).

Regards :)

kalvaro posted 1 month ago

Don't worry, your point clear. It's just I'm still attached to old MySQL versions and can't test this stuff myself.

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