Page History

-- Given a table t ($rowtime TIMESTAMP_LTZ(3), i INT, s STRING).
-- Catalog should not expose system column when queried for t. It should expose the physical column.
-- Ideally, we should support two columns with the same name but this is currently not supported in Flink.
-- If we support two columns with the same name in the future, the physical column should have precedence during a SELECT *.
 
SELECT * FROM t;
-- returns ($rowtime TIMESTAMP_LTZ(3), i INT, s STRING)

-- Given a table t (custom_ts TIMESTAMP_LTZ(3) METADATA VIRTUAL FROM '$rowtime', i INT, s STRING).
 
SELECT * FROM t;
-- returns (custom_ts TIMESTAMP_LTZ(3), i INT, s STRING) asbecause "custom_ts" 
-- uses an alias and potentially a different data type to which the system 
-- column is casted.