mysql virtual column incoherence wrt from_unixtime()
Got a table with a virtual column using from_unixtime(): CREATE TABLE aa ( id int NOT NULL AUTO_INCREMENT, epochmillis bigint, session_dt DATETIME(3) generated always as (from_unixtime(epochmillis/1000)), -- utc DATETIME(3) generated always as (convert_tz(from_unixtime(epochmillis/1000), @@time_zone, 'UTC')), PRIMARY KEY (`id`)); I can't…