THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
Code Block | ||
---|---|---|
| ||
create table T2(
a int,
b as a + 1 virtual,
c bigint,
d as c - 1 stored,
e varchar
) with (
k1=v1,
k2=v2
); |
...
If T2 is used as a table scan(table source), the T2 column b would be computed in a projection right above the scan, the column d comes directly from the table T2 because it is stored. That means, we would do an equivalence conversion from the scan node to a project above the scan.
...