Hello Richard,
22.02.2025 16:55, Richard Guo wrote:
create table t (a int, b int);
create table vt (a int, b int generated always as (a * 2));
insert into t values (1, 1);
insert into vt values (1);
# select 1 from t t1 where exists (select 1 from vt where exists (select t1.a from t t2 where vt.b = 2));
ERROR: unexpected virtual generated column reference
I've discovered yet another way to trigger that error:
create table vt (a int, b int generated always as (a * 2), c int);
insert into vt values(1);
alter table vt alter column c type bigint using b + c;
ERROR: XX000: unexpected virtual generated column reference
LOCATION: CheckVarSlotCompatibility, execExprInterp.c:2410
Shouldn't this be expected/supported?
Best regards,
Alexander Lakhin
Neon (
https://neon.tech)
