@Test public void testLiteral() { checkLiteral("DATE '1978-05-02'"); checkLiteral2("DATE '1978-5-2'", "DATE '1978-05-02'"); checkLiteral("TIME '12:34:56'"); checkLiteral("TIME '12:34:56.78'"); checkLiteral2("TIME '1:4:6.080'", "TIME '01:04:06.080'"); checkLiteral("TIMESTAMP '1978-05-02 12:34:56.78'"); checkLiteral2("TIMESTAMP '1978-5-2 2:4:6.80'", "TIMESTAMP '1978-05-02 02:04:06.80'"); checkLiteral("'I can''t explain'"); checkLiteral("''"); checkLiteral("TRUE"); checkLiteral("123"); checkLiteral("123.45"); checkLiteral("-123.45"); checkLiteral("INTERVAL '1-2' YEAR TO MONTH"); checkLiteral("INTERVAL -'1-2' YEAR TO MONTH"); checkLiteral("INTERVAL '12-11' YEAR TO MONTH"); checkLiteral("INTERVAL '1' YEAR"); checkLiteral("INTERVAL '1' MONTH"); checkLiteral("INTERVAL '12' DAY"); checkLiteral("INTERVAL -'12' DAY"); checkLiteral2("INTERVAL '1 2' DAY TO HOUR", "INTERVAL '1 02' DAY TO HOUR"); checkLiteral2("INTERVAL '1 2:3:5.070' DAY TO SECOND", "INTERVAL '1 02:03:05.07' DAY TO SECOND"); checkLiteral("INTERVAL '1:23' HOUR TO MINUTE"); checkLiteral("INTERVAL '1:02' HOUR TO MINUTE"); checkLiteral("INTERVAL -'1:02' HOUR TO MINUTE");
@Test public void testLiteral() { checkLiteral("DATE '1978-05-02'"); checkLiteral2("DATE '1978-5-2'", "DATE '1978-05-02'"); checkLiteral("TIME '12:34:56'"); checkLiteral("TIME '12:34:56.78'"); checkLiteral2("TIME '1:4:6.080'", "TIME '01:04:06.080'"); checkLiteral("TIMESTAMP '1978-05-02 12:34:56.78'"); checkLiteral2("TIMESTAMP '1978-5-2 2:4:6.80'", "TIMESTAMP '1978-05-02 02:04:06.80'"); checkLiteral("'I can''t explain'"); checkLiteral("''"); checkLiteral("TRUE"); checkLiteral("123"); checkLiteral("123.45"); checkLiteral("-123.45"); checkLiteral("INTERVAL '1-2' YEAR TO MONTH"); checkLiteral("INTERVAL -'1-2' YEAR TO MONTH"); checkLiteral("INTERVAL '12-11' YEAR TO MONTH"); checkLiteral("INTERVAL '1' YEAR"); checkLiteral("INTERVAL '1' MONTH"); checkLiteral("INTERVAL '12' DAY"); checkLiteral("INTERVAL -'12' DAY"); checkLiteral2("INTERVAL '1 2' DAY TO HOUR", "INTERVAL '1 02' DAY TO HOUR"); checkLiteral2("INTERVAL '1 2:3:5.070' DAY TO SECOND", "INTERVAL '1 02:03:05.07' DAY TO SECOND"); checkLiteral("INTERVAL '1:23' HOUR TO MINUTE"); checkLiteral("INTERVAL '1:02' HOUR TO MINUTE"); checkLiteral("INTERVAL -'1:02' HOUR TO MINUTE");