@Test public void testLiteral() { checkExpSame("'foo'"); checkExpSame("100"); check( "select 1 as one, 'x' as x, null as n from emp", "SELECT 1 AS `ONE`, 'x' AS `X`, NULL AS `N`\n" + "FROM `EMP`"); // Even though it looks like a date, it's just a string. checkExp("'2004-06-01'", "'2004-06-01'"); checkExp("-.25", "-0.25"); checkExpSame("TIMESTAMP '2004-06-01 15:55:55'"); checkExpSame("TIMESTAMP '2004-06-01 15:55:55.900'"); checkExp( "TIMESTAMP '2004-06-01 15:55:55.1234'", "TIMESTAMP '2004-06-01 15:55:55.123'"); checkExp( "TIMESTAMP '2004-06-01 15:55:55.1236'", "TIMESTAMP '2004-06-01 15:55:55.124'"); checkExp( "TIMESTAMP '2004-06-01 15:55:55.9999'", "TIMESTAMP '2004-06-01 15:55:56.000'"); checkExpSame("NULL"); }
@Test public void testLiteral() { checkExpSame("'foo'"); checkExpSame("100"); check( "select 1 as one, 'x' as x, null as n from emp", "SELECT 1 AS `ONE`, 'x' AS `X`, NULL AS `N`\n" + "FROM `EMP`"); // Even though it looks like a date, it's just a string. checkExp("'2004-06-01'", "'2004-06-01'"); checkExp("-.25", "-0.25"); checkExpSame("TIMESTAMP '2004-06-01 15:55:55'"); checkExpSame("TIMESTAMP '2004-06-01 15:55:55.900'"); checkExp( "TIMESTAMP '2004-06-01 15:55:55.1234'", "TIMESTAMP '2004-06-01 15:55:55.123'"); checkExp( "TIMESTAMP '2004-06-01 15:55:55.1236'", "TIMESTAMP '2004-06-01 15:55:55.124'"); checkExp( "TIMESTAMP '2004-06-01 15:55:55.9999'", "TIMESTAMP '2004-06-01 15:55:56.000'"); checkExpSame("NULL"); }
"TIMESTAMP '2004-12-01 12:01:01.'", "TIMESTAMP '2004-12-01 12:01:01'"); checkExpSame("TIMESTAMP '2004-12-01 12:01:01.1'");
"TIMESTAMP '2004-12-01 12:01:01.'", "TIMESTAMP '2004-12-01 12:01:01'"); checkExpSame("TIMESTAMP '2004-12-01 12:01:01.1'");