aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/bigdate/table_io.sql
blob: b3a3f2cd656f1d8dadb51e6814a19dc42c0d02f1 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
/* postgres can not */
use plato;

select * from BigDates order by row;

insert into @Output with truncate
select * from BigDates
where row > -100
order by row;

commit;

select * from @Output order by row;

select row, cast(d32 as string), cast(dt64 as string), cast(ts64 as string), cast(i64 as string)
from BigDates
order by row;