DROP TABLE IF EXISTS t1,tt1,tt2,tt3;
DROP VIEW IF EXISTS v1;

CREATE TABLE t1 (a int PRIMARY KEY, b varchar(50));

INSERT INTO t1 VALUES (1,'abc'), (2,'abc'), (3,'abc');

CREATE TEMPORARY TABLE tt1 SELECT a AS c, a, b FROM t1;
SELECT * FROM tt1;
CREATE OR REPLACE VIEW v1 AS SELECT * FROM t1;

CREATE TEMPORARY TABLE tt2 SELECT a AS c, a, b FROM v1;
CREATE TEMPORARY TABLE tt3 SELECT (a + 0) AS c, a, b FROM v1;