blob: f0de353ebc98a2f18f9eed086609db48b983109c [file] [log] [blame]
CREATE VIEW v2 AS SELECT * FROM typeall_l;
CREATE TEMPORARY TABLE temp_tbl_v2 PARTITION BY ( col_chr ) AS SELECT * FROM v2;
SELECT col_int, col_chr, col_vrchr1, col_vrchr2, col_dt, col_bln FROM temp_tbl_v2;
DROP TABLE temp_tbl_v2;
DROP VIEW v2;