[BUG] Virtual field in export

[expired user #10782]'s profile image [expired user #10782] posted 7 years ago in General Permalink

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's profile image kalvaro posted 7 years ago Permalink

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.

[expired user #10782]'s profile image [expired user #10782] posted 7 years ago Permalink

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's profile image kalvaro posted 7 years ago Permalink

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.