typeCoercion/native/arrayJoin.sql

0001 SELECT array_join(array(true, false), ', ');
0002 SELECT array_join(array(2Y, 1Y), ', ');
0003 SELECT array_join(array(2S, 1S), ', ');
0004 SELECT array_join(array(2, 1), ', ');
0005 SELECT array_join(array(2L, 1L), ', ');
0006 SELECT array_join(array(9223372036854775809, 9223372036854775808), ', ');
0007 SELECT array_join(array(2.0D, 1.0D), ', ');
0008 SELECT array_join(array(float(2.0), float(1.0)), ', ');
0009 SELECT array_join(array(date '2016-03-14', date '2016-03-13'), ', ');
0010 SELECT array_join(array(timestamp '2016-11-15 20:54:00.000', timestamp '2016-11-12 20:54:00.000'), ', ');
0011 SELECT array_join(array('a', 'b'), ', ');