blob: 64454346dda6a5244ad9b450dabcc236005465f9 [file] [log] [blame]
CREATE OR REPLACE VIEW VW_ON_BLN_4 (c1,c2,c3) AS SELECT cast(columns[0] as int), cast(columns[1] as boolean), cast(columns[2] as char(2)) FROM `bools.csv`;
select count(c1),c2 from VW_ON_BLN_4 group by c2;
DROP VIEW VW_ON_BLN_4;