sql-tests/inputs/misc-functions.sql

0001 -- test for misc functions
0002
0003 -- typeof
0004 select typeof(null);
0005 select typeof(true);
0006 select typeof(1Y), typeof(1S), typeof(1), typeof(1L);
0007 select typeof(cast(1.0 as float)), typeof(1.0D), typeof(1.2);
0008 select typeof(date '1986-05-23'),  typeof(timestamp '1986-05-23'), typeof(interval '23 days');
0009 select typeof(x'ABCD'), typeof('SPARK');
0010 select typeof(array(1, 2)), typeof(map(1, 2)), typeof(named_struct('a', 1, 'b', 'spark'));