You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by jh...@apache.org on 2023/01/25 07:39:18 UTC
[calcite] 01/04: Factor interval tests out of SqlParserTest and SqlValidatorTest and into new class IntervalTest
This is an automated email from the ASF dual-hosted git repository.
jhyde pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/calcite.git
commit b623215e2f033a5303b3d4dc01be42ae9d942c8e
Author: Julian Hyde <jh...@apache.org>
AuthorDate: Fri Dec 9 01:48:32 2022 -0800
Factor interval tests out of SqlParserTest and SqlValidatorTest and into new class IntervalTest
This change allows interval tests to be shared between the
parser and validator test without maintaining duplicate
test code.
---
.../org/apache/calcite/test/SqlValidatorTest.java | 1797 +------------------
.../calcite/sql/parser/SqlParserFixture.java | 6 +-
.../apache/calcite/sql/parser/SqlParserTest.java | 1651 +-----------------
.../java/org/apache/calcite/test/IntervalTest.java | 1834 ++++++++++++++++++++
4 files changed, 1920 insertions(+), 3368 deletions(-)
diff --git a/core/src/test/java/org/apache/calcite/test/SqlValidatorTest.java b/core/src/test/java/org/apache/calcite/test/SqlValidatorTest.java
index 4dc72e96ae..05d3789076 100644
--- a/core/src/test/java/org/apache/calcite/test/SqlValidatorTest.java
+++ b/core/src/test/java/org/apache/calcite/test/SqlValidatorTest.java
@@ -793,10 +793,10 @@ public class SqlValidatorTest extends SqlValidatorTestCase {
.fails(ANY);
}
- // FIXME jvs 2-Feb-2005: all collation-related tests are disabled due to
- // dtbug 280
+ // FIXME jvs 2-Feb-2005:
- public void _testSimpleCollate() {
+ @Disabled("all collation-related tests are disabled due to dtbug 280")
+ void testSimpleCollate() {
expr("'s' collate latin1$en$1").ok();
expr("'s' collate latin1$en$1")
.columnType("CHAR(1)");
@@ -808,19 +808,22 @@ public class SqlValidatorTest extends SqlValidatorTestCase {
is(SqlCollation.Coercibility.EXPLICIT));
}
- public void _testCharsetAndCollateMismatch() {
+ @Disabled("all collation-related tests are disabled due to dtbug 280")
+ void testCharsetAndCollateMismatch() {
// todo
expr("_UTF16's' collate latin1$en$1")
.fails("?");
}
- public void _testDyadicCollateCompare() {
+ @Disabled("all collation-related tests are disabled due to dtbug 280")
+ void testDyadicCollateCompare() {
expr("'s' collate latin1$en$1 < 't'").ok();
expr("'t' > 's' collate latin1$en$1").ok();
expr("'s' collate latin1$en$1 <> 't' collate latin1$en$1").ok();
}
- public void _testDyadicCompareCollateFails() {
+ @Disabled("all collation-related tests are disabled due to dtbug 280")
+ void testDyadicCompareCollateFails() {
// two different explicit collations. difference in strength
expr("'s' collate latin1$en$1 <= 't' collate latin1$en$2")
.fails("(?s).*Two explicit different collations.*are illegal.*");
@@ -830,7 +833,8 @@ public class SqlValidatorTest extends SqlValidatorTestCase {
.fails("(?s).*Two explicit different collations.*are illegal.*");
}
- public void _testDyadicCollateOperator() {
+ @Disabled("all collation-related tests are disabled due to dtbug 280")
+ void testDyadicCollateOperator() {
sql("'a' || 'b'")
.assertCollation(is("ISO-8859-1$en_US$primary"),
is(SqlCollation.Coercibility.COERCIBLE));
@@ -911,7 +915,8 @@ public class SqlValidatorTest extends SqlValidatorTestCase {
.fails("(?s).*not comparable to each other.*");
}
- public void _testConvertAndTranslate() {
+ @Disabled
+ void testConvertAndTranslate() {
expr("convert('abc' using conversion)").ok();
expr("translate('abc' using translation)").ok();
}
@@ -1053,7 +1058,8 @@ public class SqlValidatorTest extends SqlValidatorTestCase {
.columnType("BOOLEAN NOT NULL");
}
- public void _testLikeAndSimilarFails() {
+ @Disabled
+ void testLikeAndSimilarFails() {
expr("'a' like _UTF16'b' escape 'c'")
.fails("(?s).*Operands _ISO-8859-1.a. COLLATE ISO-8859-1.en_US.primary,"
+ " _SHIFT_JIS.b..*");
@@ -2181,1700 +2187,6 @@ public class SqlValidatorTest extends SqlValidatorTestCase {
.assertInterval(is(3_903_123L));
}
- /**
- * Runs tests for INTERVAL... YEAR that should pass both parser and
- * validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- void subTestIntervalYearPositive() {
- // default precision
- expr("INTERVAL '1' YEAR")
- .columnType("INTERVAL YEAR NOT NULL");
- expr("INTERVAL '99' YEAR")
- .columnType("INTERVAL YEAR NOT NULL");
-
- // explicit precision equal to default
- expr("INTERVAL '1' YEAR(2)")
- .columnType("INTERVAL YEAR(2) NOT NULL");
- expr("INTERVAL '99' YEAR(2)")
- .columnType("INTERVAL YEAR(2) NOT NULL");
-
- // max precision
- expr("INTERVAL '2147483647' YEAR(10)")
- .columnType("INTERVAL YEAR(10) NOT NULL");
-
- // min precision
- expr("INTERVAL '0' YEAR(1)")
- .columnType("INTERVAL YEAR(1) NOT NULL");
-
- // alternate precision
- expr("INTERVAL '1234' YEAR(4)")
- .columnType("INTERVAL YEAR(4) NOT NULL");
-
- // sign
- expr("INTERVAL '+1' YEAR")
- .columnType("INTERVAL YEAR NOT NULL");
- expr("INTERVAL '-1' YEAR")
- .columnType("INTERVAL YEAR NOT NULL");
- expr("INTERVAL +'1' YEAR")
- .columnType("INTERVAL YEAR NOT NULL");
- expr("INTERVAL +'+1' YEAR")
- .columnType("INTERVAL YEAR NOT NULL");
- expr("INTERVAL +'-1' YEAR")
- .columnType("INTERVAL YEAR NOT NULL");
- expr("INTERVAL -'1' YEAR")
- .columnType("INTERVAL YEAR NOT NULL");
- expr("INTERVAL -'+1' YEAR")
- .columnType("INTERVAL YEAR NOT NULL");
- expr("INTERVAL -'-1' YEAR")
- .columnType("INTERVAL YEAR NOT NULL");
- }
-
- /**
- * Runs tests for INTERVAL... YEAR TO MONTH that should pass both parser and
- * validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- void subTestIntervalYearToMonthPositive() {
- // default precision
- expr("INTERVAL '1-2' YEAR TO MONTH")
- .columnType("INTERVAL YEAR TO MONTH NOT NULL");
- expr("INTERVAL '99-11' YEAR TO MONTH")
- .columnType("INTERVAL YEAR TO MONTH NOT NULL");
- expr("INTERVAL '99-0' YEAR TO MONTH")
- .columnType("INTERVAL YEAR TO MONTH NOT NULL");
-
- // explicit precision equal to default
- expr("INTERVAL '1-2' YEAR(2) TO MONTH")
- .columnType("INTERVAL YEAR(2) TO MONTH NOT NULL");
- expr("INTERVAL '99-11' YEAR(2) TO MONTH")
- .columnType("INTERVAL YEAR(2) TO MONTH NOT NULL");
- expr("INTERVAL '99-0' YEAR(2) TO MONTH")
- .columnType("INTERVAL YEAR(2) TO MONTH NOT NULL");
-
- // max precision
- expr("INTERVAL '2147483647-11' YEAR(10) TO MONTH")
- .columnType("INTERVAL YEAR(10) TO MONTH NOT NULL");
-
- // min precision
- expr("INTERVAL '0-0' YEAR(1) TO MONTH")
- .columnType("INTERVAL YEAR(1) TO MONTH NOT NULL");
-
- // alternate precision
- expr("INTERVAL '2006-2' YEAR(4) TO MONTH")
- .columnType("INTERVAL YEAR(4) TO MONTH NOT NULL");
-
- // sign
- expr("INTERVAL '-1-2' YEAR TO MONTH")
- .columnType("INTERVAL YEAR TO MONTH NOT NULL");
- expr("INTERVAL '+1-2' YEAR TO MONTH")
- .columnType("INTERVAL YEAR TO MONTH NOT NULL");
- expr("INTERVAL +'1-2' YEAR TO MONTH")
- .columnType("INTERVAL YEAR TO MONTH NOT NULL");
- expr("INTERVAL +'-1-2' YEAR TO MONTH")
- .columnType("INTERVAL YEAR TO MONTH NOT NULL");
- expr("INTERVAL +'+1-2' YEAR TO MONTH")
- .columnType("INTERVAL YEAR TO MONTH NOT NULL");
- expr("INTERVAL -'1-2' YEAR TO MONTH")
- .columnType("INTERVAL YEAR TO MONTH NOT NULL");
- expr("INTERVAL -'-1-2' YEAR TO MONTH")
- .columnType("INTERVAL YEAR TO MONTH NOT NULL");
- expr("INTERVAL -'+1-2' YEAR TO MONTH")
- .columnType("INTERVAL YEAR TO MONTH NOT NULL");
- }
-
- /**
- * Runs tests for INTERVAL... MONTH that should pass both parser and
- * validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- void subTestIntervalMonthPositive() {
- // default precision
- expr("INTERVAL '1' MONTH")
- .columnType("INTERVAL MONTH NOT NULL");
- expr("INTERVAL '99' MONTH")
- .columnType("INTERVAL MONTH NOT NULL");
-
- // explicit precision equal to default
- expr("INTERVAL '1' MONTH(2)")
- .columnType("INTERVAL MONTH(2) NOT NULL");
- expr("INTERVAL '99' MONTH(2)")
- .columnType("INTERVAL MONTH(2) NOT NULL");
-
- // max precision
- expr("INTERVAL '2147483647' MONTH(10)")
- .columnType("INTERVAL MONTH(10) NOT NULL");
-
- // min precision
- expr("INTERVAL '0' MONTH(1)")
- .columnType("INTERVAL MONTH(1) NOT NULL");
-
- // alternate precision
- expr("INTERVAL '1234' MONTH(4)")
- .columnType("INTERVAL MONTH(4) NOT NULL");
-
- // sign
- expr("INTERVAL '+1' MONTH")
- .columnType("INTERVAL MONTH NOT NULL");
- expr("INTERVAL '-1' MONTH")
- .columnType("INTERVAL MONTH NOT NULL");
- expr("INTERVAL +'1' MONTH")
- .columnType("INTERVAL MONTH NOT NULL");
- expr("INTERVAL +'+1' MONTH")
- .columnType("INTERVAL MONTH NOT NULL");
- expr("INTERVAL +'-1' MONTH")
- .columnType("INTERVAL MONTH NOT NULL");
- expr("INTERVAL -'1' MONTH")
- .columnType("INTERVAL MONTH NOT NULL");
- expr("INTERVAL -'+1' MONTH")
- .columnType("INTERVAL MONTH NOT NULL");
- expr("INTERVAL -'-1' MONTH")
- .columnType("INTERVAL MONTH NOT NULL");
- }
-
- /**
- * Runs tests for INTERVAL... DAY that should pass both parser and
- * validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- void subTestIntervalDayPositive() {
- // default precision
- expr("INTERVAL '1' DAY")
- .columnType("INTERVAL DAY NOT NULL");
- expr("INTERVAL '99' DAY")
- .columnType("INTERVAL DAY NOT NULL");
-
- // explicit precision equal to default
- expr("INTERVAL '1' DAY(2)")
- .columnType("INTERVAL DAY(2) NOT NULL");
- expr("INTERVAL '99' DAY(2)")
- .columnType("INTERVAL DAY(2) NOT NULL");
-
- // max precision
- expr("INTERVAL '2147483647' DAY(10)")
- .columnType("INTERVAL DAY(10) NOT NULL");
-
- // min precision
- expr("INTERVAL '0' DAY(1)")
- .columnType("INTERVAL DAY(1) NOT NULL");
-
- // alternate precision
- expr("INTERVAL '1234' DAY(4)")
- .columnType("INTERVAL DAY(4) NOT NULL");
-
- // sign
- expr("INTERVAL '+1' DAY")
- .columnType("INTERVAL DAY NOT NULL");
- expr("INTERVAL '-1' DAY")
- .columnType("INTERVAL DAY NOT NULL");
- expr("INTERVAL +'1' DAY")
- .columnType("INTERVAL DAY NOT NULL");
- expr("INTERVAL +'+1' DAY")
- .columnType("INTERVAL DAY NOT NULL");
- expr("INTERVAL +'-1' DAY")
- .columnType("INTERVAL DAY NOT NULL");
- expr("INTERVAL -'1' DAY")
- .columnType("INTERVAL DAY NOT NULL");
- expr("INTERVAL -'+1' DAY")
- .columnType("INTERVAL DAY NOT NULL");
- expr("INTERVAL -'-1' DAY")
- .columnType("INTERVAL DAY NOT NULL");
- }
-
- void subTestIntervalDayToHourPositive() {
- // default precision
- expr("INTERVAL '1 2' DAY TO HOUR")
- .columnType("INTERVAL DAY TO HOUR NOT NULL");
- expr("INTERVAL '99 23' DAY TO HOUR")
- .columnType("INTERVAL DAY TO HOUR NOT NULL");
- expr("INTERVAL '99 0' DAY TO HOUR")
- .columnType("INTERVAL DAY TO HOUR NOT NULL");
-
- // explicit precision equal to default
- expr("INTERVAL '1 2' DAY(2) TO HOUR")
- .columnType("INTERVAL DAY(2) TO HOUR NOT NULL");
- expr("INTERVAL '99 23' DAY(2) TO HOUR")
- .columnType("INTERVAL DAY(2) TO HOUR NOT NULL");
- expr("INTERVAL '99 0' DAY(2) TO HOUR")
- .columnType("INTERVAL DAY(2) TO HOUR NOT NULL");
-
- // max precision
- expr("INTERVAL '2147483647 23' DAY(10) TO HOUR")
- .columnType("INTERVAL DAY(10) TO HOUR NOT NULL");
-
- // min precision
- expr("INTERVAL '0 0' DAY(1) TO HOUR")
- .columnType("INTERVAL DAY(1) TO HOUR NOT NULL");
-
- // alternate precision
- expr("INTERVAL '2345 2' DAY(4) TO HOUR")
- .columnType("INTERVAL DAY(4) TO HOUR NOT NULL");
-
- // sign
- expr("INTERVAL '-1 2' DAY TO HOUR")
- .columnType("INTERVAL DAY TO HOUR NOT NULL");
- expr("INTERVAL '+1 2' DAY TO HOUR")
- .columnType("INTERVAL DAY TO HOUR NOT NULL");
- expr("INTERVAL +'1 2' DAY TO HOUR")
- .columnType("INTERVAL DAY TO HOUR NOT NULL");
- expr("INTERVAL +'-1 2' DAY TO HOUR")
- .columnType("INTERVAL DAY TO HOUR NOT NULL");
- expr("INTERVAL +'+1 2' DAY TO HOUR")
- .columnType("INTERVAL DAY TO HOUR NOT NULL");
- expr("INTERVAL -'1 2' DAY TO HOUR")
- .columnType("INTERVAL DAY TO HOUR NOT NULL");
- expr("INTERVAL -'-1 2' DAY TO HOUR")
- .columnType("INTERVAL DAY TO HOUR NOT NULL");
- expr("INTERVAL -'+1 2' DAY TO HOUR")
- .columnType("INTERVAL DAY TO HOUR NOT NULL");
- }
-
- /**
- * Runs tests for INTERVAL... DAY TO MINUTE that should pass both parser and
- * validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- void subTestIntervalDayToMinutePositive() {
- // default precision
- expr("INTERVAL '1 2:3' DAY TO MINUTE")
- .columnType("INTERVAL DAY TO MINUTE NOT NULL");
- expr("INTERVAL '99 23:59' DAY TO MINUTE")
- .columnType("INTERVAL DAY TO MINUTE NOT NULL");
- expr("INTERVAL '99 0:0' DAY TO MINUTE")
- .columnType("INTERVAL DAY TO MINUTE NOT NULL");
-
- // explicit precision equal to default
- expr("INTERVAL '1 2:3' DAY(2) TO MINUTE")
- .columnType("INTERVAL DAY(2) TO MINUTE NOT NULL");
- expr("INTERVAL '99 23:59' DAY(2) TO MINUTE")
- .columnType("INTERVAL DAY(2) TO MINUTE NOT NULL");
- expr("INTERVAL '99 0:0' DAY(2) TO MINUTE")
- .columnType("INTERVAL DAY(2) TO MINUTE NOT NULL");
-
- // max precision
- expr("INTERVAL '2147483647 23:59' DAY(10) TO MINUTE")
- .columnType("INTERVAL DAY(10) TO MINUTE NOT NULL");
-
- // min precision
- expr("INTERVAL '0 0:0' DAY(1) TO MINUTE")
- .columnType("INTERVAL DAY(1) TO MINUTE NOT NULL");
-
- // alternate precision
- expr("INTERVAL '2345 6:7' DAY(4) TO MINUTE")
- .columnType("INTERVAL DAY(4) TO MINUTE NOT NULL");
-
- // sign
- expr("INTERVAL '-1 2:3' DAY TO MINUTE")
- .columnType("INTERVAL DAY TO MINUTE NOT NULL");
- expr("INTERVAL '+1 2:3' DAY TO MINUTE")
- .columnType("INTERVAL DAY TO MINUTE NOT NULL");
- expr("INTERVAL +'1 2:3' DAY TO MINUTE")
- .columnType("INTERVAL DAY TO MINUTE NOT NULL");
- expr("INTERVAL +'-1 2:3' DAY TO MINUTE")
- .columnType("INTERVAL DAY TO MINUTE NOT NULL");
- expr("INTERVAL +'+1 2:3' DAY TO MINUTE")
- .columnType("INTERVAL DAY TO MINUTE NOT NULL");
- expr("INTERVAL -'1 2:3' DAY TO MINUTE")
- .columnType("INTERVAL DAY TO MINUTE NOT NULL");
- expr("INTERVAL -'-1 2:3' DAY TO MINUTE")
- .columnType("INTERVAL DAY TO MINUTE NOT NULL");
- expr("INTERVAL -'+1 2:3' DAY TO MINUTE")
- .columnType("INTERVAL DAY TO MINUTE NOT NULL");
- }
-
- /**
- * Runs tests for INTERVAL... DAY TO SECOND that should pass both parser and
- * validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- void subTestIntervalDayToSecondPositive() {
- // default precision
- expr("INTERVAL '1 2:3:4' DAY TO SECOND")
- .columnType("INTERVAL DAY TO SECOND NOT NULL");
- expr("INTERVAL '99 23:59:59' DAY TO SECOND")
- .columnType("INTERVAL DAY TO SECOND NOT NULL");
- expr("INTERVAL '99 0:0:0' DAY TO SECOND")
- .columnType("INTERVAL DAY TO SECOND NOT NULL");
- expr("INTERVAL '99 23:59:59.999999' DAY TO SECOND")
- .columnType("INTERVAL DAY TO SECOND NOT NULL");
- expr("INTERVAL '99 0:0:0.0' DAY TO SECOND")
- .columnType("INTERVAL DAY TO SECOND NOT NULL");
-
- // explicit precision equal to default
- expr("INTERVAL '1 2:3:4' DAY(2) TO SECOND")
- .columnType("INTERVAL DAY(2) TO SECOND NOT NULL");
- expr("INTERVAL '99 23:59:59' DAY(2) TO SECOND")
- .columnType("INTERVAL DAY(2) TO SECOND NOT NULL");
- expr("INTERVAL '99 0:0:0' DAY(2) TO SECOND")
- .columnType("INTERVAL DAY(2) TO SECOND NOT NULL");
- expr("INTERVAL '99 23:59:59.999999' DAY TO SECOND(6)")
- .columnType("INTERVAL DAY TO SECOND(6) NOT NULL");
- expr("INTERVAL '99 0:0:0.0' DAY TO SECOND(6)")
- .columnType("INTERVAL DAY TO SECOND(6) NOT NULL");
-
- // max precision
- expr("INTERVAL '2147483647 23:59:59' DAY(10) TO SECOND")
- .columnType("INTERVAL DAY(10) TO SECOND NOT NULL");
- expr("INTERVAL '2147483647 23:59:59.999999999' DAY(10) TO SECOND(9)")
- .columnType("INTERVAL DAY(10) TO SECOND(9) NOT NULL");
-
- // min precision
- expr("INTERVAL '0 0:0:0' DAY(1) TO SECOND")
- .columnType("INTERVAL DAY(1) TO SECOND NOT NULL");
- expr("INTERVAL '0 0:0:0.0' DAY(1) TO SECOND(1)")
- .columnType("INTERVAL DAY(1) TO SECOND(1) NOT NULL");
-
- // alternate precision
- expr("INTERVAL '2345 6:7:8' DAY(4) TO SECOND")
- .columnType("INTERVAL DAY(4) TO SECOND NOT NULL");
- expr("INTERVAL '2345 6:7:8.9012' DAY(4) TO SECOND(4)")
- .columnType("INTERVAL DAY(4) TO SECOND(4) NOT NULL");
-
- // sign
- expr("INTERVAL '-1 2:3:4' DAY TO SECOND")
- .columnType("INTERVAL DAY TO SECOND NOT NULL");
- expr("INTERVAL '+1 2:3:4' DAY TO SECOND")
- .columnType("INTERVAL DAY TO SECOND NOT NULL");
- expr("INTERVAL +'1 2:3:4' DAY TO SECOND")
- .columnType("INTERVAL DAY TO SECOND NOT NULL");
- expr("INTERVAL +'-1 2:3:4' DAY TO SECOND")
- .columnType("INTERVAL DAY TO SECOND NOT NULL");
- expr("INTERVAL +'+1 2:3:4' DAY TO SECOND")
- .columnType("INTERVAL DAY TO SECOND NOT NULL");
- expr("INTERVAL -'1 2:3:4' DAY TO SECOND")
- .columnType("INTERVAL DAY TO SECOND NOT NULL");
- expr("INTERVAL -'-1 2:3:4' DAY TO SECOND")
- .columnType("INTERVAL DAY TO SECOND NOT NULL");
- expr("INTERVAL -'+1 2:3:4' DAY TO SECOND")
- .columnType("INTERVAL DAY TO SECOND NOT NULL");
- }
-
- /**
- * Runs tests for INTERVAL... HOUR that should pass both parser and
- * validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- void subTestIntervalHourPositive() {
- // default precision
- expr("INTERVAL '1' HOUR")
- .columnType("INTERVAL HOUR NOT NULL");
- expr("INTERVAL '99' HOUR")
- .columnType("INTERVAL HOUR NOT NULL");
-
- // explicit precision equal to default
- expr("INTERVAL '1' HOUR(2)")
- .columnType("INTERVAL HOUR(2) NOT NULL");
- expr("INTERVAL '99' HOUR(2)")
- .columnType("INTERVAL HOUR(2) NOT NULL");
-
- // max precision
- expr("INTERVAL '2147483647' HOUR(10)")
- .columnType("INTERVAL HOUR(10) NOT NULL");
-
- // min precision
- expr("INTERVAL '0' HOUR(1)")
- .columnType("INTERVAL HOUR(1) NOT NULL");
-
- // alternate precision
- expr("INTERVAL '1234' HOUR(4)")
- .columnType("INTERVAL HOUR(4) NOT NULL");
-
- // sign
- expr("INTERVAL '+1' HOUR")
- .columnType("INTERVAL HOUR NOT NULL");
- expr("INTERVAL '-1' HOUR")
- .columnType("INTERVAL HOUR NOT NULL");
- expr("INTERVAL +'1' HOUR")
- .columnType("INTERVAL HOUR NOT NULL");
- expr("INTERVAL +'+1' HOUR")
- .columnType("INTERVAL HOUR NOT NULL");
- expr("INTERVAL +'-1' HOUR")
- .columnType("INTERVAL HOUR NOT NULL");
- expr("INTERVAL -'1' HOUR")
- .columnType("INTERVAL HOUR NOT NULL");
- expr("INTERVAL -'+1' HOUR")
- .columnType("INTERVAL HOUR NOT NULL");
- expr("INTERVAL -'-1' HOUR")
- .columnType("INTERVAL HOUR NOT NULL");
- }
-
- /**
- * Runs tests for INTERVAL... HOUR TO MINUTE that should pass both parser
- * and validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- void subTestIntervalHourToMinutePositive() {
- // default precision
- expr("INTERVAL '2:3' HOUR TO MINUTE")
- .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
- expr("INTERVAL '23:59' HOUR TO MINUTE")
- .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
- expr("INTERVAL '99:0' HOUR TO MINUTE")
- .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
-
- // explicit precision equal to default
- expr("INTERVAL '2:3' HOUR(2) TO MINUTE")
- .columnType("INTERVAL HOUR(2) TO MINUTE NOT NULL");
- expr("INTERVAL '23:59' HOUR(2) TO MINUTE")
- .columnType("INTERVAL HOUR(2) TO MINUTE NOT NULL");
- expr("INTERVAL '99:0' HOUR(2) TO MINUTE")
- .columnType("INTERVAL HOUR(2) TO MINUTE NOT NULL");
-
- // max precision
- expr("INTERVAL '2147483647:59' HOUR(10) TO MINUTE")
- .columnType("INTERVAL HOUR(10) TO MINUTE NOT NULL");
-
- // min precision
- expr("INTERVAL '0:0' HOUR(1) TO MINUTE")
- .columnType("INTERVAL HOUR(1) TO MINUTE NOT NULL");
-
- // alternate precision
- expr("INTERVAL '2345:7' HOUR(4) TO MINUTE")
- .columnType("INTERVAL HOUR(4) TO MINUTE NOT NULL");
-
- // sign
- expr("INTERVAL '-1:3' HOUR TO MINUTE")
- .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
- expr("INTERVAL '+1:3' HOUR TO MINUTE")
- .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
- expr("INTERVAL +'2:3' HOUR TO MINUTE")
- .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
- expr("INTERVAL +'-2:3' HOUR TO MINUTE")
- .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
- expr("INTERVAL +'+2:3' HOUR TO MINUTE")
- .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
- expr("INTERVAL -'2:3' HOUR TO MINUTE")
- .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
- expr("INTERVAL -'-2:3' HOUR TO MINUTE")
- .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
- expr("INTERVAL -'+2:3' HOUR TO MINUTE")
- .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
- }
-
- /**
- * Runs tests for INTERVAL... HOUR TO SECOND that should pass both parser
- * and validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- void subTestIntervalHourToSecondPositive() {
- // default precision
- expr("INTERVAL '2:3:4' HOUR TO SECOND")
- .columnType("INTERVAL HOUR TO SECOND NOT NULL");
- expr("INTERVAL '23:59:59' HOUR TO SECOND")
- .columnType("INTERVAL HOUR TO SECOND NOT NULL");
- expr("INTERVAL '99:0:0' HOUR TO SECOND")
- .columnType("INTERVAL HOUR TO SECOND NOT NULL");
- expr("INTERVAL '23:59:59.999999' HOUR TO SECOND")
- .columnType("INTERVAL HOUR TO SECOND NOT NULL");
- expr("INTERVAL '99:0:0.0' HOUR TO SECOND")
- .columnType("INTERVAL HOUR TO SECOND NOT NULL");
-
- // explicit precision equal to default
- expr("INTERVAL '2:3:4' HOUR(2) TO SECOND")
- .columnType("INTERVAL HOUR(2) TO SECOND NOT NULL");
- expr("INTERVAL '99:59:59' HOUR(2) TO SECOND")
- .columnType("INTERVAL HOUR(2) TO SECOND NOT NULL");
- expr("INTERVAL '99:0:0' HOUR(2) TO SECOND")
- .columnType("INTERVAL HOUR(2) TO SECOND NOT NULL");
- expr("INTERVAL '99:59:59.999999' HOUR TO SECOND(6)")
- .columnType("INTERVAL HOUR TO SECOND(6) NOT NULL");
- expr("INTERVAL '99:0:0.0' HOUR TO SECOND(6)")
- .columnType("INTERVAL HOUR TO SECOND(6) NOT NULL");
-
- // max precision
- expr("INTERVAL '2147483647:59:59' HOUR(10) TO SECOND")
- .columnType("INTERVAL HOUR(10) TO SECOND NOT NULL");
- expr("INTERVAL '2147483647:59:59.999999999' HOUR(10) TO SECOND(9)")
- .columnType("INTERVAL HOUR(10) TO SECOND(9) NOT NULL");
-
- // min precision
- expr("INTERVAL '0:0:0' HOUR(1) TO SECOND")
- .columnType("INTERVAL HOUR(1) TO SECOND NOT NULL");
- expr("INTERVAL '0:0:0.0' HOUR(1) TO SECOND(1)")
- .columnType("INTERVAL HOUR(1) TO SECOND(1) NOT NULL");
-
- // alternate precision
- expr("INTERVAL '2345:7:8' HOUR(4) TO SECOND")
- .columnType("INTERVAL HOUR(4) TO SECOND NOT NULL");
- expr("INTERVAL '2345:7:8.9012' HOUR(4) TO SECOND(4)")
- .columnType("INTERVAL HOUR(4) TO SECOND(4) NOT NULL");
-
- // sign
- expr("INTERVAL '-2:3:4' HOUR TO SECOND")
- .columnType("INTERVAL HOUR TO SECOND NOT NULL");
- expr("INTERVAL '+2:3:4' HOUR TO SECOND")
- .columnType("INTERVAL HOUR TO SECOND NOT NULL");
- expr("INTERVAL +'2:3:4' HOUR TO SECOND")
- .columnType("INTERVAL HOUR TO SECOND NOT NULL");
- expr("INTERVAL +'-2:3:4' HOUR TO SECOND")
- .columnType("INTERVAL HOUR TO SECOND NOT NULL");
- expr("INTERVAL +'+2:3:4' HOUR TO SECOND")
- .columnType("INTERVAL HOUR TO SECOND NOT NULL");
- expr("INTERVAL -'2:3:4' HOUR TO SECOND")
- .columnType("INTERVAL HOUR TO SECOND NOT NULL");
- expr("INTERVAL -'-2:3:4' HOUR TO SECOND")
- .columnType("INTERVAL HOUR TO SECOND NOT NULL");
- expr("INTERVAL -'+2:3:4' HOUR TO SECOND")
- .columnType("INTERVAL HOUR TO SECOND NOT NULL");
- }
-
- /**
- * Runs tests for INTERVAL... MINUTE that should pass both parser and
- * validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- void subTestIntervalMinutePositive() {
- // default precision
- expr("INTERVAL '1' MINUTE")
- .columnType("INTERVAL MINUTE NOT NULL");
- expr("INTERVAL '99' MINUTE")
- .columnType("INTERVAL MINUTE NOT NULL");
-
- // explicit precision equal to default
- expr("INTERVAL '1' MINUTE(2)")
- .columnType("INTERVAL MINUTE(2) NOT NULL");
- expr("INTERVAL '99' MINUTE(2)")
- .columnType("INTERVAL MINUTE(2) NOT NULL");
-
- // max precision
- expr("INTERVAL '2147483647' MINUTE(10)")
- .columnType("INTERVAL MINUTE(10) NOT NULL");
-
- // min precision
- expr("INTERVAL '0' MINUTE(1)")
- .columnType("INTERVAL MINUTE(1) NOT NULL");
-
- // alternate precision
- expr("INTERVAL '1234' MINUTE(4)")
- .columnType("INTERVAL MINUTE(4) NOT NULL");
-
- // sign
- expr("INTERVAL '+1' MINUTE")
- .columnType("INTERVAL MINUTE NOT NULL");
- expr("INTERVAL '-1' MINUTE")
- .columnType("INTERVAL MINUTE NOT NULL");
- expr("INTERVAL +'1' MINUTE")
- .columnType("INTERVAL MINUTE NOT NULL");
- expr("INTERVAL +'+1' MINUTE")
- .columnType("INTERVAL MINUTE NOT NULL");
- expr("INTERVAL +'-1' MINUTE")
- .columnType("INTERVAL MINUTE NOT NULL");
- expr("INTERVAL -'1' MINUTE")
- .columnType("INTERVAL MINUTE NOT NULL");
- expr("INTERVAL -'+1' MINUTE")
- .columnType("INTERVAL MINUTE NOT NULL");
- expr("INTERVAL -'-1' MINUTE")
- .columnType("INTERVAL MINUTE NOT NULL");
- }
-
- /**
- * Runs tests for INTERVAL... MINUTE TO SECOND that should pass both parser
- * and validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- void subTestIntervalMinuteToSecondPositive() {
- // default precision
- expr("INTERVAL '2:4' MINUTE TO SECOND")
- .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
- expr("INTERVAL '59:59' MINUTE TO SECOND")
- .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
- expr("INTERVAL '99:0' MINUTE TO SECOND")
- .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
- expr("INTERVAL '59:59.999999' MINUTE TO SECOND")
- .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
- expr("INTERVAL '99:0.0' MINUTE TO SECOND")
- .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
-
- // explicit precision equal to default
- expr("INTERVAL '2:4' MINUTE(2) TO SECOND")
- .columnType("INTERVAL MINUTE(2) TO SECOND NOT NULL");
- expr("INTERVAL '99:59' MINUTE(2) TO SECOND")
- .columnType("INTERVAL MINUTE(2) TO SECOND NOT NULL");
- expr("INTERVAL '99:0' MINUTE(2) TO SECOND")
- .columnType("INTERVAL MINUTE(2) TO SECOND NOT NULL");
- expr("INTERVAL '99:59.999999' MINUTE TO SECOND(6)")
- .columnType("INTERVAL MINUTE TO SECOND(6) NOT NULL");
- expr("INTERVAL '99:0.0' MINUTE TO SECOND(6)")
- .columnType("INTERVAL MINUTE TO SECOND(6) NOT NULL");
-
- // max precision
- expr("INTERVAL '2147483647:59' MINUTE(10) TO SECOND")
- .columnType("INTERVAL MINUTE(10) TO SECOND NOT NULL");
- expr("INTERVAL '2147483647:59.999999999' MINUTE(10) TO SECOND(9)")
- .columnType("INTERVAL MINUTE(10) TO SECOND(9) NOT NULL");
-
- // min precision
- expr("INTERVAL '0:0' MINUTE(1) TO SECOND")
- .columnType("INTERVAL MINUTE(1) TO SECOND NOT NULL");
- expr("INTERVAL '0:0.0' MINUTE(1) TO SECOND(1)")
- .columnType("INTERVAL MINUTE(1) TO SECOND(1) NOT NULL");
-
- // alternate precision
- expr("INTERVAL '2345:8' MINUTE(4) TO SECOND")
- .columnType("INTERVAL MINUTE(4) TO SECOND NOT NULL");
- expr("INTERVAL '2345:7.8901' MINUTE(4) TO SECOND(4)")
- .columnType("INTERVAL MINUTE(4) TO SECOND(4) NOT NULL");
-
- // sign
- expr("INTERVAL '-3:4' MINUTE TO SECOND")
- .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
- expr("INTERVAL '+3:4' MINUTE TO SECOND")
- .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
- expr("INTERVAL +'3:4' MINUTE TO SECOND")
- .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
- expr("INTERVAL +'-3:4' MINUTE TO SECOND")
- .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
- expr("INTERVAL +'+3:4' MINUTE TO SECOND")
- .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
- expr("INTERVAL -'3:4' MINUTE TO SECOND")
- .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
- expr("INTERVAL -'-3:4' MINUTE TO SECOND")
- .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
- expr("INTERVAL -'+3:4' MINUTE TO SECOND")
- .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
- }
-
- /**
- * Runs tests for INTERVAL... SECOND that should pass both parser and
- * validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- void subTestIntervalSecondPositive() {
- // default precision
- expr("INTERVAL '1' SECOND")
- .columnType("INTERVAL SECOND NOT NULL");
- expr("INTERVAL '99' SECOND")
- .columnType("INTERVAL SECOND NOT NULL");
-
- // explicit precision equal to default
- expr("INTERVAL '1' SECOND(2)")
- .columnType("INTERVAL SECOND(2) NOT NULL");
- expr("INTERVAL '99' SECOND(2)")
- .columnType("INTERVAL SECOND(2) NOT NULL");
- expr("INTERVAL '1' SECOND(2, 6)")
- .columnType("INTERVAL SECOND(2, 6) NOT NULL");
- expr("INTERVAL '99' SECOND(2, 6)")
- .columnType("INTERVAL SECOND(2, 6) NOT NULL");
-
- // max precision
- expr("INTERVAL '2147483647' SECOND(10)")
- .columnType("INTERVAL SECOND(10) NOT NULL");
- expr("INTERVAL '2147483647.999999999' SECOND(10, 9)")
- .columnType("INTERVAL SECOND(10, 9) NOT NULL");
-
- // min precision
- expr("INTERVAL '0' SECOND(1)")
- .columnType("INTERVAL SECOND(1) NOT NULL");
- expr("INTERVAL '0.0' SECOND(1, 1)")
- .columnType("INTERVAL SECOND(1, 1) NOT NULL");
-
- // alternate precision
- expr("INTERVAL '1234' SECOND(4)")
- .columnType("INTERVAL SECOND(4) NOT NULL");
- expr("INTERVAL '1234.56789' SECOND(4, 5)")
- .columnType("INTERVAL SECOND(4, 5) NOT NULL");
-
- // sign
- expr("INTERVAL '+1' SECOND")
- .columnType("INTERVAL SECOND NOT NULL");
- expr("INTERVAL '-1' SECOND")
- .columnType("INTERVAL SECOND NOT NULL");
- expr("INTERVAL +'1' SECOND")
- .columnType("INTERVAL SECOND NOT NULL");
- expr("INTERVAL +'+1' SECOND")
- .columnType("INTERVAL SECOND NOT NULL");
- expr("INTERVAL +'-1' SECOND")
- .columnType("INTERVAL SECOND NOT NULL");
- expr("INTERVAL -'1' SECOND")
- .columnType("INTERVAL SECOND NOT NULL");
- expr("INTERVAL -'+1' SECOND")
- .columnType("INTERVAL SECOND NOT NULL");
- expr("INTERVAL -'-1' SECOND")
- .columnType("INTERVAL SECOND NOT NULL");
- }
-
- /**
- * Runs tests for INTERVAL... YEAR that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXNegative() tests.
- */
- void subTestIntervalYearNegative() {
- // Qualifier - field mismatches
- wholeExpr("INTERVAL '-' YEAR")
- .fails("Illegal interval literal format '-' for INTERVAL YEAR.*");
- wholeExpr("INTERVAL '1-2' YEAR")
- .fails("Illegal interval literal format '1-2' for INTERVAL YEAR.*");
- wholeExpr("INTERVAL '1.2' YEAR")
- .fails("Illegal interval literal format '1.2' for INTERVAL YEAR.*");
- wholeExpr("INTERVAL '1 2' YEAR")
- .fails("Illegal interval literal format '1 2' for INTERVAL YEAR.*");
- wholeExpr("INTERVAL '1-2' YEAR(2)")
- .fails("Illegal interval literal format '1-2' for INTERVAL YEAR\\(2\\)");
- wholeExpr("INTERVAL 'bogus text' YEAR")
- .fails("Illegal interval literal format 'bogus text' for INTERVAL YEAR.*");
-
- // negative field values
- wholeExpr("INTERVAL '--1' YEAR")
- .fails("Illegal interval literal format '--1' for INTERVAL YEAR.*");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- wholeExpr("INTERVAL '100' YEAR")
- .fails("Interval field value 100 exceeds precision of YEAR\\(2\\) field.*");
- wholeExpr("INTERVAL '100' YEAR(2)")
- .fails("Interval field value 100 exceeds precision of YEAR\\(2\\) field.*");
- wholeExpr("INTERVAL '1000' YEAR(3)")
- .fails("Interval field value 1,000 exceeds precision of YEAR\\(3\\) field.*");
- wholeExpr("INTERVAL '-1000' YEAR(3)")
- .fails("Interval field value -1,000 exceeds precision of YEAR\\(3\\) field.*");
- wholeExpr("INTERVAL '2147483648' YEAR(10)")
- .fails("Interval field value 2,147,483,648 exceeds precision of "
- + "YEAR\\(10\\) field.*");
- wholeExpr("INTERVAL '-2147483648' YEAR(10)")
- .fails("Interval field value -2,147,483,648 exceeds precision of "
- + "YEAR\\(10\\) field");
-
- // precision > maximum
- expr("INTERVAL '1' ^YEAR(11)^")
- .fails("Interval leading field precision '11' out of range for "
- + "INTERVAL YEAR\\(11\\)");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0' ^YEAR(0)^")
- .fails("Interval leading field precision '0' out of range for "
- + "INTERVAL YEAR\\(0\\)");
- }
-
- /**
- * Runs tests for INTERVAL... YEAR TO MONTH that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXNegative() tests.
- */
- void subTestIntervalYearToMonthNegative() {
- // Qualifier - field mismatches
- wholeExpr("INTERVAL '-' YEAR TO MONTH")
- .fails("Illegal interval literal format '-' for INTERVAL YEAR TO MONTH");
- wholeExpr("INTERVAL '1' YEAR TO MONTH")
- .fails("Illegal interval literal format '1' for INTERVAL YEAR TO MONTH");
- wholeExpr("INTERVAL '1:2' YEAR TO MONTH")
- .fails("Illegal interval literal format '1:2' for INTERVAL YEAR TO MONTH");
- wholeExpr("INTERVAL '1.2' YEAR TO MONTH")
- .fails("Illegal interval literal format '1.2' for INTERVAL YEAR TO MONTH");
- wholeExpr("INTERVAL '1 2' YEAR TO MONTH")
- .fails("Illegal interval literal format '1 2' for INTERVAL YEAR TO MONTH");
- wholeExpr("INTERVAL '1:2' YEAR(2) TO MONTH")
- .fails("Illegal interval literal format '1:2' for "
- + "INTERVAL YEAR\\(2\\) TO MONTH");
- wholeExpr("INTERVAL 'bogus text' YEAR TO MONTH")
- .fails("Illegal interval literal format 'bogus text' for "
- + "INTERVAL YEAR TO MONTH");
-
- // negative field values
- wholeExpr("INTERVAL '--1-2' YEAR TO MONTH")
- .fails("Illegal interval literal format '--1-2' for "
- + "INTERVAL YEAR TO MONTH");
- wholeExpr("INTERVAL '1--2' YEAR TO MONTH")
- .fails("Illegal interval literal format '1--2' for "
- + "INTERVAL YEAR TO MONTH");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- // plus >max value for mid/end fields
- wholeExpr("INTERVAL '100-0' YEAR TO MONTH")
- .fails("Interval field value 100 exceeds precision of YEAR\\(2\\) field.*");
- wholeExpr("INTERVAL '100-0' YEAR(2) TO MONTH")
- .fails("Interval field value 100 exceeds precision of YEAR\\(2\\) field.*");
- wholeExpr("INTERVAL '1000-0' YEAR(3) TO MONTH")
- .fails("Interval field value 1,000 exceeds precision of YEAR\\(3\\) field.*");
- wholeExpr("INTERVAL '-1000-0' YEAR(3) TO MONTH")
- .fails("Interval field value -1,000 exceeds precision of YEAR\\(3\\) field.*");
- wholeExpr("INTERVAL '2147483648-0' YEAR(10) TO MONTH")
- .fails("Interval field value 2,147,483,648 exceeds precision of YEAR\\(10\\) field.*");
- wholeExpr("INTERVAL '-2147483648-0' YEAR(10) TO MONTH")
- .fails("Interval field value -2,147,483,648 exceeds precision of YEAR\\(10\\) field.*");
- wholeExpr("INTERVAL '1-12' YEAR TO MONTH")
- .fails("Illegal interval literal format '1-12' for INTERVAL YEAR TO MONTH.*");
-
- // precision > maximum
- expr("INTERVAL '1-1' ^YEAR(11) TO MONTH^")
- .fails("Interval leading field precision '11' out of range for "
- + "INTERVAL YEAR\\(11\\) TO MONTH");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0-0' ^YEAR(0) TO MONTH^")
- .fails("Interval leading field precision '0' out of range for "
- + "INTERVAL YEAR\\(0\\) TO MONTH");
- }
-
- /**
- * Runs tests for INTERVAL... MONTH that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXNegative() tests.
- */
- void subTestIntervalMonthNegative() {
- // Qualifier - field mismatches
- wholeExpr("INTERVAL '-' MONTH")
- .fails("Illegal interval literal format '-' for INTERVAL MONTH.*");
- wholeExpr("INTERVAL '1-2' MONTH")
- .fails("Illegal interval literal format '1-2' for INTERVAL MONTH.*");
- wholeExpr("INTERVAL '1.2' MONTH")
- .fails("Illegal interval literal format '1.2' for INTERVAL MONTH.*");
- wholeExpr("INTERVAL '1 2' MONTH")
- .fails("Illegal interval literal format '1 2' for INTERVAL MONTH.*");
- wholeExpr("INTERVAL '1-2' MONTH(2)")
- .fails("Illegal interval literal format '1-2' for INTERVAL MONTH\\(2\\)");
- wholeExpr("INTERVAL 'bogus text' MONTH")
- .fails("Illegal interval literal format 'bogus text' for INTERVAL MONTH.*");
-
- // negative field values
- wholeExpr("INTERVAL '--1' MONTH")
- .fails("Illegal interval literal format '--1' for INTERVAL MONTH.*");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- wholeExpr("INTERVAL '100' MONTH")
- .fails("Interval field value 100 exceeds precision of MONTH\\(2\\) field.*");
- wholeExpr("INTERVAL '100' MONTH(2)")
- .fails("Interval field value 100 exceeds precision of MONTH\\(2\\) field.*");
- wholeExpr("INTERVAL '1000' MONTH(3)")
- .fails("Interval field value 1,000 exceeds precision of MONTH\\(3\\) field.*");
- wholeExpr("INTERVAL '-1000' MONTH(3)")
- .fails("Interval field value -1,000 exceeds precision of MONTH\\(3\\) field.*");
- wholeExpr("INTERVAL '2147483648' MONTH(10)")
- .fails("Interval field value 2,147,483,648 exceeds precision of MONTH\\(10\\) field.*");
- wholeExpr("INTERVAL '-2147483648' MONTH(10)")
- .fails("Interval field value -2,147,483,648 exceeds precision of MONTH\\(10\\) field.*");
-
- // precision > maximum
- expr("INTERVAL '1' ^MONTH(11)^")
- .fails("Interval leading field precision '11' out of range for "
- + "INTERVAL MONTH\\(11\\)");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0' ^MONTH(0)^")
- .fails("Interval leading field precision '0' out of range for "
- + "INTERVAL MONTH\\(0\\)");
- }
-
- /**
- * Runs tests for INTERVAL... DAY that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXNegative() tests.
- */
- void subTestIntervalDayNegative() {
- // Qualifier - field mismatches
- wholeExpr("INTERVAL '-' DAY")
- .fails("Illegal interval literal format '-' for INTERVAL DAY.*");
- wholeExpr("INTERVAL '1-2' DAY")
- .fails("Illegal interval literal format '1-2' for INTERVAL DAY.*");
- wholeExpr("INTERVAL '1.2' DAY")
- .fails("Illegal interval literal format '1.2' for INTERVAL DAY.*");
- wholeExpr("INTERVAL '1 2' DAY")
- .fails("Illegal interval literal format '1 2' for INTERVAL DAY.*");
- wholeExpr("INTERVAL '1:2' DAY")
- .fails("Illegal interval literal format '1:2' for INTERVAL DAY.*");
- wholeExpr("INTERVAL '1-2' DAY(2)")
- .fails("Illegal interval literal format '1-2' for INTERVAL DAY\\(2\\)");
- wholeExpr("INTERVAL 'bogus text' DAY")
- .fails("Illegal interval literal format 'bogus text' for INTERVAL DAY.*");
-
- // negative field values
- wholeExpr("INTERVAL '--1' DAY")
- .fails("Illegal interval literal format '--1' for INTERVAL DAY.*");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- wholeExpr("INTERVAL '100' DAY")
- .fails("Interval field value 100 exceeds precision of DAY\\(2\\) field.*");
- wholeExpr("INTERVAL '100' DAY(2)")
- .fails("Interval field value 100 exceeds precision of DAY\\(2\\) field.*");
- wholeExpr("INTERVAL '1000' DAY(3)")
- .fails("Interval field value 1,000 exceeds precision of DAY\\(3\\) field.*");
- wholeExpr("INTERVAL '-1000' DAY(3)")
- .fails("Interval field value -1,000 exceeds precision of DAY\\(3\\) field.*");
- wholeExpr("INTERVAL '2147483648' DAY(10)")
- .fails("Interval field value 2,147,483,648 exceeds precision of "
- + "DAY\\(10\\) field.*");
- wholeExpr("INTERVAL '-2147483648' DAY(10)")
- .fails("Interval field value -2,147,483,648 exceeds precision of "
- + "DAY\\(10\\) field.*");
-
- // precision > maximum
- expr("INTERVAL '1' ^DAY(11)^")
- .fails("Interval leading field precision '11' out of range for "
- + "INTERVAL DAY\\(11\\)");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0' ^DAY(0)^")
- .fails("Interval leading field precision '0' out of range for "
- + "INTERVAL DAY\\(0\\)");
- }
-
- /**
- * Runs tests for INTERVAL... DAY TO HOUR that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXNegative() tests.
- */
- void subTestIntervalDayToHourNegative() {
- // Qualifier - field mismatches
- wholeExpr("INTERVAL '-' DAY TO HOUR")
- .fails("Illegal interval literal format '-' for INTERVAL DAY TO HOUR");
- wholeExpr("INTERVAL '1' DAY TO HOUR")
- .fails("Illegal interval literal format '1' for INTERVAL DAY TO HOUR");
- wholeExpr("INTERVAL '1:2' DAY TO HOUR")
- .fails("Illegal interval literal format '1:2' for INTERVAL DAY TO HOUR");
- wholeExpr("INTERVAL '1.2' DAY TO HOUR")
- .fails("Illegal interval literal format '1.2' for INTERVAL DAY TO HOUR");
- wholeExpr("INTERVAL '1 x' DAY TO HOUR")
- .fails("Illegal interval literal format '1 x' for INTERVAL DAY TO HOUR");
- wholeExpr("INTERVAL ' ' DAY TO HOUR")
- .fails("Illegal interval literal format ' ' for INTERVAL DAY TO HOUR");
- wholeExpr("INTERVAL '1:2' DAY(2) TO HOUR")
- .fails("Illegal interval literal format '1:2' for "
- + "INTERVAL DAY\\(2\\) TO HOUR");
- wholeExpr("INTERVAL 'bogus text' DAY TO HOUR")
- .fails("Illegal interval literal format 'bogus text' for "
- + "INTERVAL DAY TO HOUR");
-
- // negative field values
- wholeExpr("INTERVAL '--1 1' DAY TO HOUR")
- .fails("Illegal interval literal format '--1 1' for INTERVAL DAY TO HOUR");
- wholeExpr("INTERVAL '1 -1' DAY TO HOUR")
- .fails("Illegal interval literal format '1 -1' for INTERVAL DAY TO HOUR");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- // plus >max value for mid/end fields
- wholeExpr("INTERVAL '100 0' DAY TO HOUR")
- .fails("Interval field value 100 exceeds precision of DAY\\(2\\) field.*");
- wholeExpr("INTERVAL '100 0' DAY(2) TO HOUR")
- .fails("Interval field value 100 exceeds precision of DAY\\(2\\) field.*");
- wholeExpr("INTERVAL '1000 0' DAY(3) TO HOUR")
- .fails("Interval field value 1,000 exceeds precision of DAY\\(3\\) field.*");
- wholeExpr("INTERVAL '-1000 0' DAY(3) TO HOUR")
- .fails("Interval field value -1,000 exceeds precision of DAY\\(3\\) field.*");
- wholeExpr("INTERVAL '2147483648 0' DAY(10) TO HOUR")
- .fails("Interval field value 2,147,483,648 exceeds precision of DAY\\(10\\) field.*");
- wholeExpr("INTERVAL '-2147483648 0' DAY(10) TO HOUR")
- .fails("Interval field value -2,147,483,648 exceeds precision of "
- + "DAY\\(10\\) field.*");
- wholeExpr("INTERVAL '1 24' DAY TO HOUR")
- .fails("Illegal interval literal format '1 24' for INTERVAL DAY TO HOUR.*");
-
- // precision > maximum
- expr("INTERVAL '1 1' ^DAY(11) TO HOUR^")
- .fails("Interval leading field precision '11' out of range for "
- + "INTERVAL DAY\\(11\\) TO HOUR");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0 0' ^DAY(0) TO HOUR^")
- .fails("Interval leading field precision '0' out of range for INTERVAL DAY\\(0\\) TO HOUR");
- }
-
- /**
- * Runs tests for INTERVAL... DAY TO MINUTE that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXNegative() tests.
- */
- void subTestIntervalDayToMinuteNegative() {
- // Qualifier - field mismatches
- wholeExpr("INTERVAL ' :' DAY TO MINUTE")
- .fails("Illegal interval literal format ' :' for INTERVAL DAY TO MINUTE");
- wholeExpr("INTERVAL '1' DAY TO MINUTE")
- .fails("Illegal interval literal format '1' for INTERVAL DAY TO MINUTE");
- wholeExpr("INTERVAL '1 2' DAY TO MINUTE")
- .fails("Illegal interval literal format '1 2' for INTERVAL DAY TO MINUTE");
- wholeExpr("INTERVAL '1:2' DAY TO MINUTE")
- .fails("Illegal interval literal format '1:2' for INTERVAL DAY TO MINUTE");
- wholeExpr("INTERVAL '1.2' DAY TO MINUTE")
- .fails("Illegal interval literal format '1.2' for INTERVAL DAY TO MINUTE");
- wholeExpr("INTERVAL 'x 1:1' DAY TO MINUTE")
- .fails("Illegal interval literal format 'x 1:1' for INTERVAL DAY TO MINUTE");
- wholeExpr("INTERVAL '1 x:1' DAY TO MINUTE")
- .fails("Illegal interval literal format '1 x:1' for INTERVAL DAY TO MINUTE");
- wholeExpr("INTERVAL '1 1:x' DAY TO MINUTE")
- .fails("Illegal interval literal format '1 1:x' for INTERVAL DAY TO MINUTE");
- wholeExpr("INTERVAL '1 1:2:3' DAY TO MINUTE")
- .fails("Illegal interval literal format '1 1:2:3' for INTERVAL DAY TO MINUTE");
- wholeExpr("INTERVAL '1 1:1:1.2' DAY TO MINUTE")
- .fails("Illegal interval literal format '1 1:1:1.2' for INTERVAL DAY TO MINUTE");
- wholeExpr("INTERVAL '1 1:2:3' DAY(2) TO MINUTE")
- .fails("Illegal interval literal format '1 1:2:3' for "
- + "INTERVAL DAY\\(2\\) TO MINUTE");
- wholeExpr("INTERVAL '1 1' DAY(2) TO MINUTE")
- .fails("Illegal interval literal format '1 1' for "
- + "INTERVAL DAY\\(2\\) TO MINUTE");
- wholeExpr("INTERVAL 'bogus text' DAY TO MINUTE")
- .fails("Illegal interval literal format 'bogus text' for "
- + "INTERVAL DAY TO MINUTE");
-
- // negative field values
- wholeExpr("INTERVAL '--1 1:1' DAY TO MINUTE")
- .fails("Illegal interval literal format '--1 1:1' for INTERVAL DAY TO MINUTE");
- wholeExpr("INTERVAL '1 -1:1' DAY TO MINUTE")
- .fails("Illegal interval literal format '1 -1:1' for INTERVAL DAY TO MINUTE");
- wholeExpr("INTERVAL '1 1:-1' DAY TO MINUTE")
- .fails("Illegal interval literal format '1 1:-1' for INTERVAL DAY TO MINUTE");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- // plus >max value for mid/end fields
- wholeExpr("INTERVAL '100 0:0' DAY TO MINUTE")
- .fails("Interval field value 100 exceeds precision of DAY\\(2\\) field.*");
- wholeExpr("INTERVAL '100 0:0' DAY(2) TO MINUTE")
- .fails("Interval field value 100 exceeds precision of DAY\\(2\\) field.*");
- wholeExpr("INTERVAL '1000 0:0' DAY(3) TO MINUTE")
- .fails("Interval field value 1,000 exceeds precision of DAY\\(3\\) field.*");
- wholeExpr("INTERVAL '-1000 0:0' DAY(3) TO MINUTE")
- .fails("Interval field value -1,000 exceeds precision of DAY\\(3\\) field.*");
- wholeExpr("INTERVAL '2147483648 0:0' DAY(10) TO MINUTE")
- .fails("Interval field value 2,147,483,648 exceeds precision of "
- + "DAY\\(10\\) field.*");
- wholeExpr("INTERVAL '-2147483648 0:0' DAY(10) TO MINUTE")
- .fails("Interval field value -2,147,483,648 exceeds precision of "
- + "DAY\\(10\\) field.*");
- wholeExpr("INTERVAL '1 24:1' DAY TO MINUTE")
- .fails("Illegal interval literal format '1 24:1' for "
- + "INTERVAL DAY TO MINUTE.*");
- wholeExpr("INTERVAL '1 1:60' DAY TO MINUTE")
- .fails("Illegal interval literal format '1 1:60' for INTERVAL DAY TO MINUTE.*");
-
- // precision > maximum
- expr("INTERVAL '1 1:1' ^DAY(11) TO MINUTE^")
- .fails("Interval leading field precision '11' out of range for "
- + "INTERVAL DAY\\(11\\) TO MINUTE");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0 0' ^DAY(0) TO MINUTE^")
- .fails("Interval leading field precision '0' out of range for "
- + "INTERVAL DAY\\(0\\) TO MINUTE");
- }
-
- /**
- * Runs tests for INTERVAL... DAY TO SECOND that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXNegative() tests.
- */
- void subTestIntervalDayToSecondNegative() {
- // Qualifier - field mismatches
- wholeExpr("INTERVAL ' ::' DAY TO SECOND")
- .fails("Illegal interval literal format ' ::' for INTERVAL DAY TO SECOND");
- wholeExpr("INTERVAL ' ::.' DAY TO SECOND")
- .fails("Illegal interval literal format ' ::\\.' for INTERVAL DAY TO SECOND");
- wholeExpr("INTERVAL '1' DAY TO SECOND")
- .fails("Illegal interval literal format '1' for INTERVAL DAY TO SECOND");
- wholeExpr("INTERVAL '1 2' DAY TO SECOND")
- .fails("Illegal interval literal format '1 2' for INTERVAL DAY TO SECOND");
- wholeExpr("INTERVAL '1:2' DAY TO SECOND")
- .fails("Illegal interval literal format '1:2' for "
- + "INTERVAL DAY TO SECOND");
- wholeExpr("INTERVAL '1.2' DAY TO SECOND")
- .fails("Illegal interval literal format '1\\.2' for "
- + "INTERVAL DAY TO SECOND");
- wholeExpr("INTERVAL '1 1:2' DAY TO SECOND")
- .fails("Illegal interval literal format '1 1:2' for "
- + "INTERVAL DAY TO SECOND");
- wholeExpr("INTERVAL '1 1:2:x' DAY TO SECOND")
- .fails("Illegal interval literal format '1 1:2:x' for "
- + "INTERVAL DAY TO SECOND");
- wholeExpr("INTERVAL '1:2:3' DAY TO SECOND")
- .fails("Illegal interval literal format '1:2:3' for "
- + "INTERVAL DAY TO SECOND");
- wholeExpr("INTERVAL '1:1:1.2' DAY TO SECOND")
- .fails("Illegal interval literal format '1:1:1\\.2' for "
- + "INTERVAL DAY TO SECOND");
- wholeExpr("INTERVAL '1 1:2' DAY(2) TO SECOND")
- .fails("Illegal interval literal format '1 1:2' for "
- + "INTERVAL DAY\\(2\\) TO SECOND");
- wholeExpr("INTERVAL '1 1' DAY(2) TO SECOND")
- .fails("Illegal interval literal format '1 1' for "
- + "INTERVAL DAY\\(2\\) TO SECOND");
- wholeExpr("INTERVAL 'bogus text' DAY TO SECOND")
- .fails("Illegal interval literal format 'bogus text' for "
- + "INTERVAL DAY TO SECOND");
- wholeExpr("INTERVAL '2345 6:7:8901' DAY TO SECOND(4)")
- .fails("Illegal interval literal format '2345 6:7:8901' for "
- + "INTERVAL DAY TO SECOND\\(4\\)");
-
- // negative field values
- wholeExpr("INTERVAL '--1 1:1:1' DAY TO SECOND")
- .fails("Illegal interval literal format '--1 1:1:1' for "
- + "INTERVAL DAY TO SECOND");
- wholeExpr("INTERVAL '1 -1:1:1' DAY TO SECOND")
- .fails("Illegal interval literal format '1 -1:1:1' for "
- + "INTERVAL DAY TO SECOND");
- wholeExpr("INTERVAL '1 1:-1:1' DAY TO SECOND")
- .fails("Illegal interval literal format '1 1:-1:1' for "
- + "INTERVAL DAY TO SECOND");
- wholeExpr("INTERVAL '1 1:1:-1' DAY TO SECOND")
- .fails("Illegal interval literal format '1 1:1:-1' for "
- + "INTERVAL DAY TO SECOND");
- wholeExpr("INTERVAL '1 1:1:1.-1' DAY TO SECOND")
- .fails("Illegal interval literal format '1 1:1:1.-1' for "
- + "INTERVAL DAY TO SECOND");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- // plus >max value for mid/end fields
- wholeExpr("INTERVAL '100 0' DAY TO SECOND")
- .fails("Illegal interval literal format '100 0' for "
- + "INTERVAL DAY TO SECOND.*");
- wholeExpr("INTERVAL '100 0' DAY(2) TO SECOND")
- .fails("Illegal interval literal format '100 0' for "
- + "INTERVAL DAY\\(2\\) TO SECOND.*");
- wholeExpr("INTERVAL '1000 0' DAY(3) TO SECOND")
- .fails("Illegal interval literal format '1000 0' for "
- + "INTERVAL DAY\\(3\\) TO SECOND.*");
- wholeExpr("INTERVAL '-1000 0' DAY(3) TO SECOND")
- .fails("Illegal interval literal format '-1000 0' for "
- + "INTERVAL DAY\\(3\\) TO SECOND.*");
- wholeExpr("INTERVAL '2147483648 1:1:0' DAY(10) TO SECOND")
- .fails("Interval field value 2,147,483,648 exceeds precision of "
- + "DAY\\(10\\) field.*");
- wholeExpr("INTERVAL '-2147483648 1:1:0' DAY(10) TO SECOND")
- .fails("Interval field value -2,147,483,648 exceeds precision of "
- + "DAY\\(10\\) field.*");
- wholeExpr("INTERVAL '2147483648 0' DAY(10) TO SECOND")
- .fails("Illegal interval literal format '2147483648 0' for "
- + "INTERVAL DAY\\(10\\) TO SECOND.*");
- wholeExpr("INTERVAL '-2147483648 0' DAY(10) TO SECOND")
- .fails("Illegal interval literal format '-2147483648 0' for "
- + "INTERVAL DAY\\(10\\) TO SECOND.*");
- wholeExpr("INTERVAL '1 24:1:1' DAY TO SECOND")
- .fails("Illegal interval literal format '1 24:1:1' for "
- + "INTERVAL DAY TO SECOND.*");
- wholeExpr("INTERVAL '1 1:60:1' DAY TO SECOND")
- .fails("Illegal interval literal format '1 1:60:1' for "
- + "INTERVAL DAY TO SECOND.*");
- wholeExpr("INTERVAL '1 1:1:60' DAY TO SECOND")
- .fails("Illegal interval literal format '1 1:1:60' for "
- + "INTERVAL DAY TO SECOND.*");
- wholeExpr("INTERVAL '1 1:1:1.0000001' DAY TO SECOND")
- .fails("Illegal interval literal format '1 1:1:1\\.0000001' for "
- + "INTERVAL DAY TO SECOND.*");
- wholeExpr("INTERVAL '1 1:1:1.0001' DAY TO SECOND(3)")
- .fails("Illegal interval literal format '1 1:1:1\\.0001' for "
- + "INTERVAL DAY TO SECOND\\(3\\).*");
-
- // precision > maximum
- expr("INTERVAL '1 1' ^DAY(11) TO SECOND^")
- .fails("Interval leading field precision '11' out of range for "
- + "INTERVAL DAY\\(11\\) TO SECOND");
- expr("INTERVAL '1 1' ^DAY TO SECOND(10)^")
- .fails("Interval fractional second precision '10' out of range for "
- + "INTERVAL DAY TO SECOND\\(10\\)");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0 0:0:0' ^DAY(0) TO SECOND^")
- .fails("Interval leading field precision '0' out of range for "
- + "INTERVAL DAY\\(0\\) TO SECOND");
- expr("INTERVAL '0 0:0:0' ^DAY TO SECOND(0)^")
- .fails("Interval fractional second precision '0' out of range for "
- + "INTERVAL DAY TO SECOND\\(0\\)");
- }
-
- /**
- * Runs tests for INTERVAL... HOUR that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXNegative() tests.
- */
- void subTestIntervalHourNegative() {
- // Qualifier - field mismatches
- wholeExpr("INTERVAL '-' HOUR")
- .fails("Illegal interval literal format '-' for INTERVAL HOUR.*");
- wholeExpr("INTERVAL '1-2' HOUR")
- .fails("Illegal interval literal format '1-2' for INTERVAL HOUR.*");
- wholeExpr("INTERVAL '1.2' HOUR")
- .fails("Illegal interval literal format '1.2' for INTERVAL HOUR.*");
- wholeExpr("INTERVAL '1 2' HOUR")
- .fails("Illegal interval literal format '1 2' for INTERVAL HOUR.*");
- wholeExpr("INTERVAL '1:2' HOUR")
- .fails("Illegal interval literal format '1:2' for INTERVAL HOUR.*");
- wholeExpr("INTERVAL '1-2' HOUR(2)")
- .fails("Illegal interval literal format '1-2' for INTERVAL HOUR\\(2\\)");
- wholeExpr("INTERVAL 'bogus text' HOUR")
- .fails("Illegal interval literal format 'bogus text' for "
- + "INTERVAL HOUR.*");
-
- // negative field values
- wholeExpr("INTERVAL '--1' HOUR")
- .fails("Illegal interval literal format '--1' for INTERVAL HOUR.*");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- wholeExpr("INTERVAL '100' HOUR")
- .fails("Interval field value 100 exceeds precision of "
- + "HOUR\\(2\\) field.*");
- wholeExpr("INTERVAL '100' HOUR(2)")
- .fails("Interval field value 100 exceeds precision of "
- + "HOUR\\(2\\) field.*");
- wholeExpr("INTERVAL '1000' HOUR(3)")
- .fails("Interval field value 1,000 exceeds precision of "
- + "HOUR\\(3\\) field.*");
- wholeExpr("INTERVAL '-1000' HOUR(3)")
- .fails("Interval field value -1,000 exceeds precision of "
- + "HOUR\\(3\\) field.*");
- wholeExpr("INTERVAL '2147483648' HOUR(10)")
- .fails("Interval field value 2,147,483,648 exceeds precision of "
- + "HOUR\\(10\\) field.*");
- wholeExpr("INTERVAL '-2147483648' HOUR(10)")
- .fails("Interval field value -2,147,483,648 exceeds precision of "
- + "HOUR\\(10\\) field.*");
-
- // precision > maximum
- expr("INTERVAL '1' ^HOUR(11)^")
- .fails("Interval leading field precision '11' out of range for "
- + "INTERVAL HOUR\\(11\\)");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0' ^HOUR(0)^")
- .fails("Interval leading field precision '0' out of range for "
- + "INTERVAL HOUR\\(0\\)");
- }
-
- /**
- * Runs tests for INTERVAL... HOUR TO MINUTE that should pass parser but
- * fail validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXNegative() tests.
- */
- void subTestIntervalHourToMinuteNegative() {
- // Qualifier - field mismatches
- wholeExpr("INTERVAL ':' HOUR TO MINUTE")
- .fails("Illegal interval literal format ':' for INTERVAL HOUR TO MINUTE");
- wholeExpr("INTERVAL '1' HOUR TO MINUTE")
- .fails("Illegal interval literal format '1' for INTERVAL HOUR TO MINUTE");
- wholeExpr("INTERVAL '1:x' HOUR TO MINUTE")
- .fails("Illegal interval literal format '1:x' for INTERVAL HOUR TO MINUTE");
- wholeExpr("INTERVAL '1.2' HOUR TO MINUTE")
- .fails("Illegal interval literal format '1.2' for INTERVAL HOUR TO MINUTE");
- wholeExpr("INTERVAL '1 2' HOUR TO MINUTE")
- .fails("Illegal interval literal format '1 2' for INTERVAL HOUR TO MINUTE");
- wholeExpr("INTERVAL '1:2:3' HOUR TO MINUTE")
- .fails("Illegal interval literal format '1:2:3' for INTERVAL HOUR TO MINUTE");
- wholeExpr("INTERVAL '1 2' HOUR(2) TO MINUTE")
- .fails("Illegal interval literal format '1 2' for "
- + "INTERVAL HOUR\\(2\\) TO MINUTE");
- wholeExpr("INTERVAL 'bogus text' HOUR TO MINUTE")
- .fails("Illegal interval literal format 'bogus text' for "
- + "INTERVAL HOUR TO MINUTE");
-
- // negative field values
- wholeExpr("INTERVAL '--1:1' HOUR TO MINUTE")
- .fails("Illegal interval literal format '--1:1' for INTERVAL HOUR TO MINUTE");
- wholeExpr("INTERVAL '1:-1' HOUR TO MINUTE")
- .fails("Illegal interval literal format '1:-1' for INTERVAL HOUR TO MINUTE");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- // plus >max value for mid/end fields
- wholeExpr("INTERVAL '100:0' HOUR TO MINUTE")
- .fails("Interval field value 100 exceeds precision of HOUR\\(2\\) field.*");
- wholeExpr("INTERVAL '100:0' HOUR(2) TO MINUTE")
- .fails("Interval field value 100 exceeds precision of HOUR\\(2\\) field.*");
- wholeExpr("INTERVAL '1000:0' HOUR(3) TO MINUTE")
- .fails("Interval field value 1,000 exceeds precision of HOUR\\(3\\) field.*");
- wholeExpr("INTERVAL '-1000:0' HOUR(3) TO MINUTE")
- .fails("Interval field value -1,000 exceeds precision of HOUR\\(3\\) field.*");
- wholeExpr("INTERVAL '2147483648:0' HOUR(10) TO MINUTE")
- .fails("Interval field value 2,147,483,648 exceeds precision of HOUR\\(10\\) field.*");
- wholeExpr("INTERVAL '-2147483648:0' HOUR(10) TO MINUTE")
- .fails("Interval field value -2,147,483,648 exceeds precision of HOUR\\(10\\) field.*");
- wholeExpr("INTERVAL '1:60' HOUR TO MINUTE")
- .fails("Illegal interval literal format '1:60' for INTERVAL HOUR TO MINUTE.*");
-
- // precision > maximum
- expr("INTERVAL '1:1' ^HOUR(11) TO MINUTE^")
- .fails("Interval leading field precision '11' out of range for "
- + "INTERVAL HOUR\\(11\\) TO MINUTE");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0:0' ^HOUR(0) TO MINUTE^")
- .fails("Interval leading field precision '0' out of range for "
- + "INTERVAL HOUR\\(0\\) TO MINUTE");
- }
-
- /**
- * Runs tests for INTERVAL... HOUR TO SECOND that should pass parser but
- * fail validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXNegative() tests.
- */
- void subTestIntervalHourToSecondNegative() {
- // Qualifier - field mismatches
- wholeExpr("INTERVAL '::' HOUR TO SECOND")
- .fails("Illegal interval literal format '::' for INTERVAL HOUR TO SECOND");
- wholeExpr("INTERVAL '::.' HOUR TO SECOND")
- .fails("Illegal interval literal format '::\\.' for INTERVAL HOUR TO SECOND");
- wholeExpr("INTERVAL '1' HOUR TO SECOND")
- .fails("Illegal interval literal format '1' for INTERVAL HOUR TO SECOND");
- wholeExpr("INTERVAL '1 2' HOUR TO SECOND")
- .fails("Illegal interval literal format '1 2' for INTERVAL HOUR TO SECOND");
- wholeExpr("INTERVAL '1:2' HOUR TO SECOND")
- .fails("Illegal interval literal format '1:2' for INTERVAL HOUR TO SECOND");
- wholeExpr("INTERVAL '1.2' HOUR TO SECOND")
- .fails("Illegal interval literal format '1\\.2' for INTERVAL HOUR TO SECOND");
- wholeExpr("INTERVAL '1 1:2' HOUR TO SECOND")
- .fails("Illegal interval literal format '1 1:2' for INTERVAL HOUR TO SECOND");
- wholeExpr("INTERVAL '1:2:x' HOUR TO SECOND")
- .fails("Illegal interval literal format '1:2:x' for INTERVAL HOUR TO SECOND");
- wholeExpr("INTERVAL '1:x:3' HOUR TO SECOND")
- .fails("Illegal interval literal format '1:x:3' for INTERVAL HOUR TO SECOND");
- wholeExpr("INTERVAL '1:1:1.x' HOUR TO SECOND")
- .fails("Illegal interval literal format '1:1:1\\.x' for INTERVAL HOUR TO SECOND");
- wholeExpr("INTERVAL '1 1:2' HOUR(2) TO SECOND")
- .fails("Illegal interval literal format '1 1:2' for INTERVAL HOUR\\(2\\) TO SECOND");
- wholeExpr("INTERVAL '1 1' HOUR(2) TO SECOND")
- .fails("Illegal interval literal format '1 1' for INTERVAL HOUR\\(2\\) TO SECOND");
- wholeExpr("INTERVAL 'bogus text' HOUR TO SECOND")
- .fails("Illegal interval literal format 'bogus text' for INTERVAL HOUR TO SECOND");
- wholeExpr("INTERVAL '6:7:8901' HOUR TO SECOND(4)")
- .fails("Illegal interval literal format '6:7:8901' for INTERVAL HOUR TO SECOND\\(4\\)");
-
- // negative field values
- wholeExpr("INTERVAL '--1:1:1' HOUR TO SECOND")
- .fails("Illegal interval literal format '--1:1:1' for INTERVAL HOUR TO SECOND");
- wholeExpr("INTERVAL '1:-1:1' HOUR TO SECOND")
- .fails("Illegal interval literal format '1:-1:1' for INTERVAL HOUR TO SECOND");
- wholeExpr("INTERVAL '1:1:-1' HOUR TO SECOND")
- .fails("Illegal interval literal format '1:1:-1' for INTERVAL HOUR TO SECOND");
- wholeExpr("INTERVAL '1:1:1.-1' HOUR TO SECOND")
- .fails("Illegal interval literal format '1:1:1\\.-1' for INTERVAL HOUR TO SECOND");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- // plus >max value for mid/end fields
- wholeExpr("INTERVAL '100:0:0' HOUR TO SECOND")
- .fails("Interval field value 100 exceeds precision of "
- + "HOUR\\(2\\) field.*");
- wholeExpr("INTERVAL '100:0:0' HOUR(2) TO SECOND")
- .fails("Interval field value 100 exceeds precision of "
- + "HOUR\\(2\\) field.*");
- wholeExpr("INTERVAL '1000:0:0' HOUR(3) TO SECOND")
- .fails("Interval field value 1,000 exceeds precision of "
- + "HOUR\\(3\\) field.*");
- wholeExpr("INTERVAL '-1000:0:0' HOUR(3) TO SECOND")
- .fails("Interval field value -1,000 exceeds precision of "
- + "HOUR\\(3\\) field.*");
- wholeExpr("INTERVAL '2147483648:0:0' HOUR(10) TO SECOND")
- .fails("Interval field value 2,147,483,648 exceeds precision of "
- + "HOUR\\(10\\) field.*");
- wholeExpr("INTERVAL '-2147483648:0:0' HOUR(10) TO SECOND")
- .fails("Interval field value -2,147,483,648 exceeds precision of "
- + "HOUR\\(10\\) field.*");
- wholeExpr("INTERVAL '1:60:1' HOUR TO SECOND")
- .fails("Illegal interval literal format '1:60:1' for "
- + "INTERVAL HOUR TO SECOND.*");
- wholeExpr("INTERVAL '1:1:60' HOUR TO SECOND")
- .fails("Illegal interval literal format '1:1:60' for "
- + "INTERVAL HOUR TO SECOND.*");
- wholeExpr("INTERVAL '1:1:1.0000001' HOUR TO SECOND")
- .fails("Illegal interval literal format '1:1:1\\.0000001' for "
- + "INTERVAL HOUR TO SECOND.*");
- wholeExpr("INTERVAL '1:1:1.0001' HOUR TO SECOND(3)")
- .fails("Illegal interval literal format '1:1:1\\.0001' for "
- + "INTERVAL HOUR TO SECOND\\(3\\).*");
-
- // precision > maximum
- expr("INTERVAL '1:1:1' ^HOUR(11) TO SECOND^")
- .fails("Interval leading field precision '11' out of range for "
- + "INTERVAL HOUR\\(11\\) TO SECOND");
- expr("INTERVAL '1:1:1' ^HOUR TO SECOND(10)^")
- .fails("Interval fractional second precision '10' out of range for "
- + "INTERVAL HOUR TO SECOND\\(10\\)");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0:0:0' ^HOUR(0) TO SECOND^")
- .fails("Interval leading field precision '0' out of range for "
- + "INTERVAL HOUR\\(0\\) TO SECOND");
- expr("INTERVAL '0:0:0' ^HOUR TO SECOND(0)^")
- .fails("Interval fractional second precision '0' out of range for "
- + "INTERVAL HOUR TO SECOND\\(0\\)");
- }
-
- /**
- * Runs tests for INTERVAL... MINUTE that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXNegative() tests.
- */
- void subTestIntervalMinuteNegative() {
- // Qualifier - field mismatches
- wholeExpr("INTERVAL '-' MINUTE")
- .fails("Illegal interval literal format '-' for INTERVAL MINUTE.*");
- wholeExpr("INTERVAL '1-2' MINUTE")
- .fails("Illegal interval literal format '1-2' for INTERVAL MINUTE.*");
- wholeExpr("INTERVAL '1.2' MINUTE")
- .fails("Illegal interval literal format '1.2' for INTERVAL MINUTE.*");
- wholeExpr("INTERVAL '1 2' MINUTE")
- .fails("Illegal interval literal format '1 2' for INTERVAL MINUTE.*");
- wholeExpr("INTERVAL '1:2' MINUTE")
- .fails("Illegal interval literal format '1:2' for INTERVAL MINUTE.*");
- wholeExpr("INTERVAL '1-2' MINUTE(2)")
- .fails("Illegal interval literal format '1-2' for INTERVAL MINUTE\\(2\\)");
- wholeExpr("INTERVAL 'bogus text' MINUTE")
- .fails("Illegal interval literal format 'bogus text' for INTERVAL MINUTE.*");
-
- // negative field values
- wholeExpr("INTERVAL '--1' MINUTE")
- .fails("Illegal interval literal format '--1' for INTERVAL MINUTE.*");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- wholeExpr("INTERVAL '100' MINUTE")
- .fails("Interval field value 100 exceeds precision of MINUTE\\(2\\) field.*");
- wholeExpr("INTERVAL '100' MINUTE(2)")
- .fails("Interval field value 100 exceeds precision of MINUTE\\(2\\) field.*");
- wholeExpr("INTERVAL '1000' MINUTE(3)")
- .fails("Interval field value 1,000 exceeds precision of MINUTE\\(3\\) field.*");
- wholeExpr("INTERVAL '-1000' MINUTE(3)")
- .fails("Interval field value -1,000 exceeds precision of MINUTE\\(3\\) field.*");
- wholeExpr("INTERVAL '2147483648' MINUTE(10)")
- .fails("Interval field value 2,147,483,648 exceeds precision of MINUTE\\(10\\) field.*");
- wholeExpr("INTERVAL '-2147483648' MINUTE(10)")
- .fails("Interval field value -2,147,483,648 exceeds precision of MINUTE\\(10\\) field.*");
-
- // precision > maximum
- expr("INTERVAL '1' ^MINUTE(11)^")
- .fails("Interval leading field precision '11' out of range for "
- + "INTERVAL MINUTE\\(11\\)");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0' ^MINUTE(0)^")
- .fails("Interval leading field precision '0' out of range for "
- + "INTERVAL MINUTE\\(0\\)");
- }
-
- /**
- * Runs tests for INTERVAL... MINUTE TO SECOND that should pass parser but
- * fail validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXNegative() tests.
- */
- void subTestIntervalMinuteToSecondNegative() {
- // Qualifier - field mismatches
- wholeExpr("INTERVAL ':' MINUTE TO SECOND")
- .fails("Illegal interval literal format ':' for INTERVAL MINUTE TO SECOND");
- wholeExpr("INTERVAL ':.' MINUTE TO SECOND")
- .fails("Illegal interval literal format ':\\.' for INTERVAL MINUTE TO SECOND");
- wholeExpr("INTERVAL '1' MINUTE TO SECOND")
- .fails("Illegal interval literal format '1' for INTERVAL MINUTE TO SECOND");
- wholeExpr("INTERVAL '1 2' MINUTE TO SECOND")
- .fails("Illegal interval literal format '1 2' for INTERVAL MINUTE TO SECOND");
- wholeExpr("INTERVAL '1.2' MINUTE TO SECOND")
- .fails("Illegal interval literal format '1\\.2' for INTERVAL MINUTE TO SECOND");
- wholeExpr("INTERVAL '1 1:2' MINUTE TO SECOND")
- .fails("Illegal interval literal format '1 1:2' for INTERVAL MINUTE TO SECOND");
- wholeExpr("INTERVAL '1:x' MINUTE TO SECOND")
- .fails("Illegal interval literal format '1:x' for INTERVAL MINUTE TO SECOND");
- wholeExpr("INTERVAL 'x:3' MINUTE TO SECOND")
- .fails("Illegal interval literal format 'x:3' for INTERVAL MINUTE TO SECOND");
- wholeExpr("INTERVAL '1:1.x' MINUTE TO SECOND")
- .fails("Illegal interval literal format '1:1\\.x' for INTERVAL MINUTE TO SECOND");
- wholeExpr("INTERVAL '1 1:2' MINUTE(2) TO SECOND")
- .fails("Illegal interval literal format '1 1:2' for INTERVAL MINUTE\\(2\\) TO SECOND");
- wholeExpr("INTERVAL '1 1' MINUTE(2) TO SECOND")
- .fails("Illegal interval literal format '1 1' for INTERVAL MINUTE\\(2\\) TO SECOND");
- wholeExpr("INTERVAL 'bogus text' MINUTE TO SECOND")
- .fails("Illegal interval literal format 'bogus text' for INTERVAL MINUTE TO SECOND");
- wholeExpr("INTERVAL '7:8901' MINUTE TO SECOND(4)")
- .fails("Illegal interval literal format '7:8901' for INTERVAL MINUTE TO SECOND\\(4\\)");
-
- // negative field values
- wholeExpr("INTERVAL '--1:1' MINUTE TO SECOND")
- .fails("Illegal interval literal format '--1:1' for INTERVAL MINUTE TO SECOND");
- wholeExpr("INTERVAL '1:-1' MINUTE TO SECOND")
- .fails("Illegal interval literal format '1:-1' for INTERVAL MINUTE TO SECOND");
- wholeExpr("INTERVAL '1:1.-1' MINUTE TO SECOND")
- .fails("Illegal interval literal format '1:1.-1' for INTERVAL MINUTE TO SECOND");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- // plus >max value for mid/end fields
- wholeExpr("INTERVAL '100:0' MINUTE TO SECOND")
- .fails("Interval field value 100 exceeds precision of MINUTE\\(2\\) field.*");
- wholeExpr("INTERVAL '100:0' MINUTE(2) TO SECOND")
- .fails("Interval field value 100 exceeds precision of MINUTE\\(2\\) field.*");
- wholeExpr("INTERVAL '1000:0' MINUTE(3) TO SECOND")
- .fails("Interval field value 1,000 exceeds precision of MINUTE\\(3\\) field.*");
- wholeExpr("INTERVAL '-1000:0' MINUTE(3) TO SECOND")
- .fails("Interval field value -1,000 exceeds precision of MINUTE\\(3\\) field.*");
- wholeExpr("INTERVAL '2147483648:0' MINUTE(10) TO SECOND")
- .fails("Interval field value 2,147,483,648 exceeds precision of MINUTE\\(10\\) field.*");
- wholeExpr("INTERVAL '-2147483648:0' MINUTE(10) TO SECOND")
- .fails("Interval field value -2,147,483,648 exceeds precision of MINUTE\\(10\\) field.*");
- wholeExpr("INTERVAL '1:60' MINUTE TO SECOND")
- .fails("Illegal interval literal format '1:60' for"
- + " INTERVAL MINUTE TO SECOND.*");
- wholeExpr("INTERVAL '1:1.0000001' MINUTE TO SECOND")
- .fails("Illegal interval literal format '1:1\\.0000001' for"
- + " INTERVAL MINUTE TO SECOND.*");
- wholeExpr("INTERVAL '1:1:1.0001' MINUTE TO SECOND(3)")
- .fails("Illegal interval literal format '1:1:1\\.0001' for"
- + " INTERVAL MINUTE TO SECOND\\(3\\).*");
-
- // precision > maximum
- expr("INTERVAL '1:1' ^MINUTE(11) TO SECOND^")
- .fails("Interval leading field precision '11' out of range for"
- + " INTERVAL MINUTE\\(11\\) TO SECOND");
- expr("INTERVAL '1:1' ^MINUTE TO SECOND(10)^")
- .fails("Interval fractional second precision '10' out of range for"
- + " INTERVAL MINUTE TO SECOND\\(10\\)");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0:0' ^MINUTE(0) TO SECOND^")
- .fails("Interval leading field precision '0' out of range for"
- + " INTERVAL MINUTE\\(0\\) TO SECOND");
- expr("INTERVAL '0:0' ^MINUTE TO SECOND(0)^")
- .fails("Interval fractional second precision '0' out of range for"
- + " INTERVAL MINUTE TO SECOND\\(0\\)");
- }
-
- /**
- * Runs tests for INTERVAL... SECOND that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlParserTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXNegative() tests.
- */
- void subTestIntervalSecondNegative() {
- // Qualifier - field mismatches
- wholeExpr("INTERVAL ':' SECOND")
- .fails("Illegal interval literal format ':' for INTERVAL SECOND.*");
- wholeExpr("INTERVAL '.' SECOND")
- .fails("Illegal interval literal format '\\.' for INTERVAL SECOND.*");
- wholeExpr("INTERVAL '1-2' SECOND")
- .fails("Illegal interval literal format '1-2' for INTERVAL SECOND.*");
- wholeExpr("INTERVAL '1.x' SECOND")
- .fails("Illegal interval literal format '1\\.x' for INTERVAL SECOND.*");
- wholeExpr("INTERVAL 'x.1' SECOND")
- .fails("Illegal interval literal format 'x\\.1' for INTERVAL SECOND.*");
- wholeExpr("INTERVAL '1 2' SECOND")
- .fails("Illegal interval literal format '1 2' for INTERVAL SECOND.*");
- wholeExpr("INTERVAL '1:2' SECOND")
- .fails("Illegal interval literal format '1:2' for INTERVAL SECOND.*");
- wholeExpr("INTERVAL '1-2' SECOND(2)")
- .fails("Illegal interval literal format '1-2' for INTERVAL SECOND\\(2\\)");
- wholeExpr("INTERVAL 'bogus text' SECOND")
- .fails("Illegal interval literal format 'bogus text' for INTERVAL SECOND.*");
-
- // negative field values
- wholeExpr("INTERVAL '--1' SECOND")
- .fails("Illegal interval literal format '--1' for INTERVAL SECOND.*");
- wholeExpr("INTERVAL '1.-1' SECOND")
- .fails("Illegal interval literal format '1.-1' for INTERVAL SECOND.*");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- wholeExpr("INTERVAL '100' SECOND")
- .fails("Interval field value 100 exceeds precision of SECOND\\(2\\) field.*");
- wholeExpr("INTERVAL '100' SECOND(2)")
- .fails("Interval field value 100 exceeds precision of SECOND\\(2\\) field.*");
- wholeExpr("INTERVAL '1000' SECOND(3)")
- .fails("Interval field value 1,000 exceeds precision of SECOND\\(3\\) field.*");
- wholeExpr("INTERVAL '-1000' SECOND(3)")
- .fails("Interval field value -1,000 exceeds precision of SECOND\\(3\\) field.*");
- wholeExpr("INTERVAL '2147483648' SECOND(10)")
- .fails("Interval field value 2,147,483,648 exceeds precision of SECOND\\(10\\) field.*");
- wholeExpr("INTERVAL '-2147483648' SECOND(10)")
- .fails("Interval field value -2,147,483,648 exceeds precision of SECOND\\(10\\) field.*");
- wholeExpr("INTERVAL '1.0000001' SECOND")
- .fails("Illegal interval literal format '1\\.0000001' for INTERVAL SECOND.*");
- wholeExpr("INTERVAL '1.0000001' SECOND(2)")
- .fails("Illegal interval literal format '1\\.0000001' for INTERVAL SECOND\\(2\\).*");
- wholeExpr("INTERVAL '1.0001' SECOND(2, 3)")
- .fails("Illegal interval literal format '1\\.0001' for INTERVAL SECOND\\(2, 3\\).*");
- wholeExpr("INTERVAL '1.0000000001' SECOND(2, 9)")
- .fails("Illegal interval literal format '1\\.0000000001' for"
- + " INTERVAL SECOND\\(2, 9\\).*");
-
- // precision > maximum
- expr("INTERVAL '1' ^SECOND(11)^")
- .fails("Interval leading field precision '11' out of range for"
- + " INTERVAL SECOND\\(11\\)");
- expr("INTERVAL '1.1' ^SECOND(1, 10)^")
- .fails("Interval fractional second precision '10' out of range for"
- + " INTERVAL SECOND\\(1, 10\\)");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0' ^SECOND(0)^")
- .fails("Interval leading field precision '0' out of range for"
- + " INTERVAL SECOND\\(0\\)");
- expr("INTERVAL '0' ^SECOND(1, 0)^")
- .fails("Interval fractional second precision '0' out of range for"
- + " INTERVAL SECOND\\(1, 0\\)");
- }
-
@Test void testDatetimePlusNullInterval() {
expr("TIME '8:8:8' + cast(NULL AS interval hour)").columnType("TIME(0)");
expr("TIME '8:8:8' + cast(NULL AS interval YEAR)").columnType("TIME(0)");
@@ -3907,46 +2219,34 @@ public class SqlValidatorTest extends SqlValidatorTestCase {
assertThat(typeName.getDefaultScale(), is(6));
}
- // Tests that should pass both parser and validator
- subTestIntervalYearPositive();
- subTestIntervalYearToMonthPositive();
- subTestIntervalMonthPositive();
- subTestIntervalDayPositive();
- subTestIntervalDayToHourPositive();
- subTestIntervalDayToMinutePositive();
- subTestIntervalDayToSecondPositive();
- subTestIntervalHourPositive();
- subTestIntervalHourToMinutePositive();
- subTestIntervalHourToSecondPositive();
- subTestIntervalMinutePositive();
- subTestIntervalMinuteToSecondPositive();
- subTestIntervalSecondPositive();
-
- // Tests that should pass parser but fail validator
- subTestIntervalYearNegative();
- subTestIntervalYearToMonthNegative();
- subTestIntervalMonthNegative();
- subTestIntervalDayNegative();
- subTestIntervalDayToHourNegative();
- subTestIntervalDayToMinuteNegative();
- subTestIntervalDayToSecondNegative();
- subTestIntervalHourNegative();
- subTestIntervalHourToMinuteNegative();
- subTestIntervalHourToSecondNegative();
- subTestIntervalMinuteNegative();
- subTestIntervalMinuteToSecondNegative();
- subTestIntervalSecondNegative();
-
- // Miscellaneous
- // fractional value is not OK, even if it is 0
- wholeExpr("INTERVAL '1.0' HOUR")
- .fails("Illegal interval literal format '1.0' for INTERVAL HOUR");
- // only seconds are allowed to have a fractional part
- expr("INTERVAL '1.0' SECOND")
- .columnType("INTERVAL SECOND NOT NULL");
- // leading zeros do not cause precision to be exceeded
- expr("INTERVAL '0999' MONTH(3)")
- .columnType("INTERVAL MONTH(3) NOT NULL");
+ final SqlValidatorFixture f = fixture();
+ final IntervalTest.Fixture intervalFixture = new IntervalTest.Fixture() {
+ @Override public IntervalTest.Fixture2 expr(String s) {
+ return getFixture2(f.withExpr(s));
+ }
+
+ @Override public IntervalTest.Fixture2 wholeExpr(String s) {
+ return getFixture2(f.withExpr(s).withWhole(true));
+ }
+
+ private IntervalTest.Fixture2 getFixture2(SqlValidatorFixture f2) {
+ return new IntervalTest.Fixture2() {
+ @Override public void fails(String message) {
+ f2.fails(message);
+ }
+
+ @Override public void columnType(String expectedType) {
+ f2.columnType(expectedType);
+ }
+
+ @Override public IntervalTest.Fixture2 assertParse(String expected) {
+ return this;
+ }
+ };
+ }
+ };
+
+ new IntervalTest(intervalFixture).testAll();
}
@Test void testIntervalExpression() {
@@ -4415,7 +2715,8 @@ public class SqlValidatorTest extends SqlValidatorTestCase {
}
// test window partition clause. See SQL 2003 specification for detail
- public void _testWinPartClause() {
+ @Disabled
+ void testWinPartClause() {
win("window w as (w2 order by deptno), w2 as (^rang^e 100 preceding)")
.fails("Referenced window cannot have framing declarations");
// Test specified collation, window clause syntax rule 4,5.
@@ -7589,8 +5890,8 @@ public class SqlValidatorTest extends SqlValidatorTestCase {
.fails("Expression 'EMP\\.EMPNO' is not being grouped");
}
- // todo: enable when correlating variables work
- public void _testGroupExpressionEquivalenceCorrelated() {
+ @Disabled("todo: enable when correlating variables work")
+ void testGroupExpressionEquivalenceCorrelated() {
// dname comes from dept, so it is constant within the sub-query, and
// is so is a valid expr in a group-by query
sql("select * from dept where exists ("
@@ -7599,8 +5900,8 @@ public class SqlValidatorTest extends SqlValidatorTestCase {
+ "select dname + empno + 1 from emp group by empno, dept.deptno)").ok();
}
- // todo: enable when params are implemented
- public void _testGroupExpressionEquivalenceParams() {
+ @Disabled("todo: enable when params are implemented")
+ void testGroupExpressionEquivalenceParams() {
sql("select cast(? as integer) from emp group by cast(? as integer)").ok();
}
diff --git a/testkit/src/main/java/org/apache/calcite/sql/parser/SqlParserFixture.java b/testkit/src/main/java/org/apache/calcite/sql/parser/SqlParserFixture.java
index a94f1471f9..34fc7ac114 100644
--- a/testkit/src/main/java/org/apache/calcite/sql/parser/SqlParserFixture.java
+++ b/testkit/src/main/java/org/apache/calcite/sql/parser/SqlParserFixture.java
@@ -72,17 +72,17 @@ public class SqlParserFixture {
}
public SqlParserFixture same() {
- return ok_(sap.sql);
+ return compare(sap.sql);
}
public SqlParserFixture ok(String expected) {
if (expected.equals(sap.sql)) {
throw new AssertionError("you should call same()");
}
- return ok_(expected);
+ return compare(expected);
}
- private SqlParserFixture ok_(String expected) {
+ public SqlParserFixture compare(String expected) {
final UnaryOperator<String> converter = SqlParserTest.linux(convertToLinux);
if (expression) {
tester.checkExp(factory, sap, converter, expected, parserChecker);
diff --git a/testkit/src/main/java/org/apache/calcite/sql/parser/SqlParserTest.java b/testkit/src/main/java/org/apache/calcite/sql/parser/SqlParserTest.java
index 6e1f83b76c..d6e449055f 100644
--- a/testkit/src/main/java/org/apache/calcite/sql/parser/SqlParserTest.java
+++ b/testkit/src/main/java/org/apache/calcite/sql/parser/SqlParserTest.java
@@ -37,6 +37,7 @@ import org.apache.calcite.sql.test.SqlTests;
import org.apache.calcite.sql.util.SqlShuttle;
import org.apache.calcite.sql.validate.SqlConformanceEnum;
import org.apache.calcite.test.DiffTestCase;
+import org.apache.calcite.test.IntervalTest;
import org.apache.calcite.tools.Hoist;
import org.apache.calcite.util.Bug;
import org.apache.calcite.util.ConversionUtil;
@@ -5258,10 +5259,8 @@ public class SqlParserTest {
expr("TIME '12:01:01.01023456789'").same();
// Timestamp literals
- expr("TIMESTAMP '2004-12-01 12:01:01'")
- .ok("TIMESTAMP '2004-12-01 12:01:01'");
- expr("TIMESTAMP '2004-12-01 12:01:01.1'")
- .ok("TIMESTAMP '2004-12-01 12:01:01.1'");
+ expr("TIMESTAMP '2004-12-01 12:01:01'").same();
+ expr("TIMESTAMP '2004-12-01 12:01:01.1'").same();
expr("TIMESTAMP '2004-12-01 12:01:01.'")
.ok("TIMESTAMP '2004-12-01 12:01:01'");
expr("TIMESTAMP '2004-12-01 12:01:01.010234567890'")
@@ -5834,952 +5833,6 @@ public class SqlParserTest {
.ok("(MAP[])");
}
- /**
- * Runs tests for INTERVAL... YEAR that should pass both parser and
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- public void subTestIntervalYearPositive() {
- // default precision
- expr("interval '1' year")
- .ok("INTERVAL '1' YEAR");
- expr("interval '99' year")
- .ok("INTERVAL '99' YEAR");
-
- // explicit precision equal to default
- expr("interval '1' year(2)")
- .ok("INTERVAL '1' YEAR(2)");
- expr("interval '99' year(2)")
- .ok("INTERVAL '99' YEAR(2)");
-
- // max precision
- expr("interval '2147483647' year(10)")
- .ok("INTERVAL '2147483647' YEAR(10)");
-
- // min precision
- expr("interval '0' year(1)")
- .ok("INTERVAL '0' YEAR(1)");
-
- // alternate precision
- expr("interval '1234' year(4)")
- .ok("INTERVAL '1234' YEAR(4)");
-
- // sign
- expr("interval '+1' year")
- .ok("INTERVAL '+1' YEAR");
- expr("interval '-1' year")
- .ok("INTERVAL '-1' YEAR");
- expr("interval +'1' year")
- .ok("INTERVAL '1' YEAR");
- expr("interval +'+1' year")
- .ok("INTERVAL '+1' YEAR");
- expr("interval +'-1' year")
- .ok("INTERVAL '-1' YEAR");
- expr("interval -'1' year")
- .ok("INTERVAL -'1' YEAR");
- expr("interval -'+1' year")
- .ok("INTERVAL -'+1' YEAR");
- expr("interval -'-1' year")
- .ok("INTERVAL -'-1' YEAR");
- }
-
- /**
- * Runs tests for INTERVAL... YEAR TO MONTH that should pass both parser and
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- public void subTestIntervalYearToMonthPositive() {
- // default precision
- expr("interval '1-2' year to month")
- .ok("INTERVAL '1-2' YEAR TO MONTH");
- expr("interval '99-11' year to month")
- .ok("INTERVAL '99-11' YEAR TO MONTH");
- expr("interval '99-0' year to month")
- .ok("INTERVAL '99-0' YEAR TO MONTH");
-
- // explicit precision equal to default
- expr("interval '1-2' year(2) to month")
- .ok("INTERVAL '1-2' YEAR(2) TO MONTH");
- expr("interval '99-11' year(2) to month")
- .ok("INTERVAL '99-11' YEAR(2) TO MONTH");
- expr("interval '99-0' year(2) to month")
- .ok("INTERVAL '99-0' YEAR(2) TO MONTH");
-
- // max precision
- expr("interval '2147483647-11' year(10) to month")
- .ok("INTERVAL '2147483647-11' YEAR(10) TO MONTH");
-
- // min precision
- expr("interval '0-0' year(1) to month")
- .ok("INTERVAL '0-0' YEAR(1) TO MONTH");
-
- // alternate precision
- expr("interval '2006-2' year(4) to month")
- .ok("INTERVAL '2006-2' YEAR(4) TO MONTH");
-
- // sign
- expr("interval '-1-2' year to month")
- .ok("INTERVAL '-1-2' YEAR TO MONTH");
- expr("interval '+1-2' year to month")
- .ok("INTERVAL '+1-2' YEAR TO MONTH");
- expr("interval +'1-2' year to month")
- .ok("INTERVAL '1-2' YEAR TO MONTH");
- expr("interval +'-1-2' year to month")
- .ok("INTERVAL '-1-2' YEAR TO MONTH");
- expr("interval +'+1-2' year to month")
- .ok("INTERVAL '+1-2' YEAR TO MONTH");
- expr("interval -'1-2' year to month")
- .ok("INTERVAL -'1-2' YEAR TO MONTH");
- expr("interval -'-1-2' year to month")
- .ok("INTERVAL -'-1-2' YEAR TO MONTH");
- expr("interval -'+1-2' year to month")
- .ok("INTERVAL -'+1-2' YEAR TO MONTH");
- }
-
- /**
- * Runs tests for INTERVAL... MONTH that should pass both parser and
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- public void subTestIntervalMonthPositive() {
- // default precision
- expr("interval '1' month")
- .ok("INTERVAL '1' MONTH");
- expr("interval '99' month")
- .ok("INTERVAL '99' MONTH");
-
- // explicit precision equal to default
- expr("interval '1' month(2)")
- .ok("INTERVAL '1' MONTH(2)");
- expr("interval '99' month(2)")
- .ok("INTERVAL '99' MONTH(2)");
-
- // max precision
- expr("interval '2147483647' month(10)")
- .ok("INTERVAL '2147483647' MONTH(10)");
-
- // min precision
- expr("interval '0' month(1)")
- .ok("INTERVAL '0' MONTH(1)");
-
- // alternate precision
- expr("interval '1234' month(4)")
- .ok("INTERVAL '1234' MONTH(4)");
-
- // sign
- expr("interval '+1' month")
- .ok("INTERVAL '+1' MONTH");
- expr("interval '-1' month")
- .ok("INTERVAL '-1' MONTH");
- expr("interval +'1' month")
- .ok("INTERVAL '1' MONTH");
- expr("interval +'+1' month")
- .ok("INTERVAL '+1' MONTH");
- expr("interval +'-1' month")
- .ok("INTERVAL '-1' MONTH");
- expr("interval -'1' month")
- .ok("INTERVAL -'1' MONTH");
- expr("interval -'+1' month")
- .ok("INTERVAL -'+1' MONTH");
- expr("interval -'-1' month")
- .ok("INTERVAL -'-1' MONTH");
- }
-
- /**
- * Runs tests for INTERVAL... DAY that should pass both parser and
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- public void subTestIntervalDayPositive() {
- // default precision
- expr("interval '1' day")
- .ok("INTERVAL '1' DAY");
- expr("interval '99' day")
- .ok("INTERVAL '99' DAY");
-
- // explicit precision equal to default
- expr("interval '1' day(2)")
- .ok("INTERVAL '1' DAY(2)");
- expr("interval '99' day(2)")
- .ok("INTERVAL '99' DAY(2)");
-
- // max precision
- expr("interval '2147483647' day(10)")
- .ok("INTERVAL '2147483647' DAY(10)");
-
- // min precision
- expr("interval '0' day(1)")
- .ok("INTERVAL '0' DAY(1)");
-
- // alternate precision
- expr("interval '1234' day(4)")
- .ok("INTERVAL '1234' DAY(4)");
-
- // sign
- expr("interval '+1' day")
- .ok("INTERVAL '+1' DAY");
- expr("interval '-1' day")
- .ok("INTERVAL '-1' DAY");
- expr("interval +'1' day")
- .ok("INTERVAL '1' DAY");
- expr("interval +'+1' day")
- .ok("INTERVAL '+1' DAY");
- expr("interval +'-1' day")
- .ok("INTERVAL '-1' DAY");
- expr("interval -'1' day")
- .ok("INTERVAL -'1' DAY");
- expr("interval -'+1' day")
- .ok("INTERVAL -'+1' DAY");
- expr("interval -'-1' day")
- .ok("INTERVAL -'-1' DAY");
- }
-
- /**
- * Runs tests for INTERVAL... DAY TO HOUR that should pass both parser and
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- public void subTestIntervalDayToHourPositive() {
- // default precision
- expr("interval '1 2' day to hour")
- .ok("INTERVAL '1 2' DAY TO HOUR");
- expr("interval '99 23' day to hour")
- .ok("INTERVAL '99 23' DAY TO HOUR");
- expr("interval '99 0' day to hour")
- .ok("INTERVAL '99 0' DAY TO HOUR");
-
- // explicit precision equal to default
- expr("interval '1 2' day(2) to hour")
- .ok("INTERVAL '1 2' DAY(2) TO HOUR");
- expr("interval '99 23' day(2) to hour")
- .ok("INTERVAL '99 23' DAY(2) TO HOUR");
- expr("interval '99 0' day(2) to hour")
- .ok("INTERVAL '99 0' DAY(2) TO HOUR");
-
- // max precision
- expr("interval '2147483647 23' day(10) to hour")
- .ok("INTERVAL '2147483647 23' DAY(10) TO HOUR");
-
- // min precision
- expr("interval '0 0' day(1) to hour")
- .ok("INTERVAL '0 0' DAY(1) TO HOUR");
-
- // alternate precision
- expr("interval '2345 2' day(4) to hour")
- .ok("INTERVAL '2345 2' DAY(4) TO HOUR");
-
- // sign
- expr("interval '-1 2' day to hour")
- .ok("INTERVAL '-1 2' DAY TO HOUR");
- expr("interval '+1 2' day to hour")
- .ok("INTERVAL '+1 2' DAY TO HOUR");
- expr("interval +'1 2' day to hour")
- .ok("INTERVAL '1 2' DAY TO HOUR");
- expr("interval +'-1 2' day to hour")
- .ok("INTERVAL '-1 2' DAY TO HOUR");
- expr("interval +'+1 2' day to hour")
- .ok("INTERVAL '+1 2' DAY TO HOUR");
- expr("interval -'1 2' day to hour")
- .ok("INTERVAL -'1 2' DAY TO HOUR");
- expr("interval -'-1 2' day to hour")
- .ok("INTERVAL -'-1 2' DAY TO HOUR");
- expr("interval -'+1 2' day to hour")
- .ok("INTERVAL -'+1 2' DAY TO HOUR");
- }
-
- /**
- * Runs tests for INTERVAL... DAY TO MINUTE that should pass both parser and
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- public void subTestIntervalDayToMinutePositive() {
- // default precision
- expr("interval '1 2:3' day to minute")
- .ok("INTERVAL '1 2:3' DAY TO MINUTE");
- expr("interval '99 23:59' day to minute")
- .ok("INTERVAL '99 23:59' DAY TO MINUTE");
- expr("interval '99 0:0' day to minute")
- .ok("INTERVAL '99 0:0' DAY TO MINUTE");
-
- // explicit precision equal to default
- expr("interval '1 2:3' day(2) to minute")
- .ok("INTERVAL '1 2:3' DAY(2) TO MINUTE");
- expr("interval '99 23:59' day(2) to minute")
- .ok("INTERVAL '99 23:59' DAY(2) TO MINUTE");
- expr("interval '99 0:0' day(2) to minute")
- .ok("INTERVAL '99 0:0' DAY(2) TO MINUTE");
-
- // max precision
- expr("interval '2147483647 23:59' day(10) to minute")
- .ok("INTERVAL '2147483647 23:59' DAY(10) TO MINUTE");
-
- // min precision
- expr("interval '0 0:0' day(1) to minute")
- .ok("INTERVAL '0 0:0' DAY(1) TO MINUTE");
-
- // alternate precision
- expr("interval '2345 6:7' day(4) to minute")
- .ok("INTERVAL '2345 6:7' DAY(4) TO MINUTE");
-
- // sign
- expr("interval '-1 2:3' day to minute")
- .ok("INTERVAL '-1 2:3' DAY TO MINUTE");
- expr("interval '+1 2:3' day to minute")
- .ok("INTERVAL '+1 2:3' DAY TO MINUTE");
- expr("interval +'1 2:3' day to minute")
- .ok("INTERVAL '1 2:3' DAY TO MINUTE");
- expr("interval +'-1 2:3' day to minute")
- .ok("INTERVAL '-1 2:3' DAY TO MINUTE");
- expr("interval +'+1 2:3' day to minute")
- .ok("INTERVAL '+1 2:3' DAY TO MINUTE");
- expr("interval -'1 2:3' day to minute")
- .ok("INTERVAL -'1 2:3' DAY TO MINUTE");
- expr("interval -'-1 2:3' day to minute")
- .ok("INTERVAL -'-1 2:3' DAY TO MINUTE");
- expr("interval -'+1 2:3' day to minute")
- .ok("INTERVAL -'+1 2:3' DAY TO MINUTE");
- }
-
- /**
- * Runs tests for INTERVAL... DAY TO SECOND that should pass both parser and
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- public void subTestIntervalDayToSecondPositive() {
- // default precision
- expr("interval '1 2:3:4' day to second")
- .ok("INTERVAL '1 2:3:4' DAY TO SECOND");
- expr("interval '99 23:59:59' day to second")
- .ok("INTERVAL '99 23:59:59' DAY TO SECOND");
- expr("interval '99 0:0:0' day to second")
- .ok("INTERVAL '99 0:0:0' DAY TO SECOND");
- expr("interval '99 23:59:59.999999' day to second")
- .ok("INTERVAL '99 23:59:59.999999' DAY TO SECOND");
- expr("interval '99 0:0:0.0' day to second")
- .ok("INTERVAL '99 0:0:0.0' DAY TO SECOND");
-
- // explicit precision equal to default
- expr("interval '1 2:3:4' day(2) to second")
- .ok("INTERVAL '1 2:3:4' DAY(2) TO SECOND");
- expr("interval '99 23:59:59' day(2) to second")
- .ok("INTERVAL '99 23:59:59' DAY(2) TO SECOND");
- expr("interval '99 0:0:0' day(2) to second")
- .ok("INTERVAL '99 0:0:0' DAY(2) TO SECOND");
- expr("interval '99 23:59:59.999999' day to second(6)")
- .ok("INTERVAL '99 23:59:59.999999' DAY TO SECOND(6)");
- expr("interval '99 0:0:0.0' day to second(6)")
- .ok("INTERVAL '99 0:0:0.0' DAY TO SECOND(6)");
-
- // max precision
- expr("interval '2147483647 23:59:59' day(10) to second")
- .ok("INTERVAL '2147483647 23:59:59' DAY(10) TO SECOND");
- expr("interval '2147483647 23:59:59.999999999' day(10) to second(9)")
- .ok("INTERVAL '2147483647 23:59:59.999999999' DAY(10) TO SECOND(9)");
-
- // min precision
- expr("interval '0 0:0:0' day(1) to second")
- .ok("INTERVAL '0 0:0:0' DAY(1) TO SECOND");
- expr("interval '0 0:0:0.0' day(1) to second(1)")
- .ok("INTERVAL '0 0:0:0.0' DAY(1) TO SECOND(1)");
-
- // alternate precision
- expr("interval '2345 6:7:8' day(4) to second")
- .ok("INTERVAL '2345 6:7:8' DAY(4) TO SECOND");
- expr("interval '2345 6:7:8.9012' day(4) to second(4)")
- .ok("INTERVAL '2345 6:7:8.9012' DAY(4) TO SECOND(4)");
-
- // sign
- expr("interval '-1 2:3:4' day to second")
- .ok("INTERVAL '-1 2:3:4' DAY TO SECOND");
- expr("interval '+1 2:3:4' day to second")
- .ok("INTERVAL '+1 2:3:4' DAY TO SECOND");
- expr("interval +'1 2:3:4' day to second")
- .ok("INTERVAL '1 2:3:4' DAY TO SECOND");
- expr("interval +'-1 2:3:4' day to second")
- .ok("INTERVAL '-1 2:3:4' DAY TO SECOND");
- expr("interval +'+1 2:3:4' day to second")
- .ok("INTERVAL '+1 2:3:4' DAY TO SECOND");
- expr("interval -'1 2:3:4' day to second")
- .ok("INTERVAL -'1 2:3:4' DAY TO SECOND");
- expr("interval -'-1 2:3:4' day to second")
- .ok("INTERVAL -'-1 2:3:4' DAY TO SECOND");
- expr("interval -'+1 2:3:4' day to second")
- .ok("INTERVAL -'+1 2:3:4' DAY TO SECOND");
- }
-
- /**
- * Runs tests for INTERVAL... HOUR that should pass both parser and
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- public void subTestIntervalHourPositive() {
- // default precision
- expr("interval '1' hour")
- .ok("INTERVAL '1' HOUR");
- expr("interval '99' hour")
- .ok("INTERVAL '99' HOUR");
-
- // explicit precision equal to default
- expr("interval '1' hour(2)")
- .ok("INTERVAL '1' HOUR(2)");
- expr("interval '99' hour(2)")
- .ok("INTERVAL '99' HOUR(2)");
-
- // max precision
- expr("interval '2147483647' hour(10)")
- .ok("INTERVAL '2147483647' HOUR(10)");
-
- // min precision
- expr("interval '0' hour(1)")
- .ok("INTERVAL '0' HOUR(1)");
-
- // alternate precision
- expr("interval '1234' hour(4)")
- .ok("INTERVAL '1234' HOUR(4)");
-
- // sign
- expr("interval '+1' hour")
- .ok("INTERVAL '+1' HOUR");
- expr("interval '-1' hour")
- .ok("INTERVAL '-1' HOUR");
- expr("interval +'1' hour")
- .ok("INTERVAL '1' HOUR");
- expr("interval +'+1' hour")
- .ok("INTERVAL '+1' HOUR");
- expr("interval +'-1' hour")
- .ok("INTERVAL '-1' HOUR");
- expr("interval -'1' hour")
- .ok("INTERVAL -'1' HOUR");
- expr("interval -'+1' hour")
- .ok("INTERVAL -'+1' HOUR");
- expr("interval -'-1' hour")
- .ok("INTERVAL -'-1' HOUR");
- }
-
- /**
- * Runs tests for INTERVAL... HOUR TO MINUTE that should pass both parser
- * and validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- public void subTestIntervalHourToMinutePositive() {
- // default precision
- expr("interval '2:3' hour to minute")
- .ok("INTERVAL '2:3' HOUR TO MINUTE");
- expr("interval '23:59' hour to minute")
- .ok("INTERVAL '23:59' HOUR TO MINUTE");
- expr("interval '99:0' hour to minute")
- .ok("INTERVAL '99:0' HOUR TO MINUTE");
-
- // explicit precision equal to default
- expr("interval '2:3' hour(2) to minute")
- .ok("INTERVAL '2:3' HOUR(2) TO MINUTE");
- expr("interval '23:59' hour(2) to minute")
- .ok("INTERVAL '23:59' HOUR(2) TO MINUTE");
- expr("interval '99:0' hour(2) to minute")
- .ok("INTERVAL '99:0' HOUR(2) TO MINUTE");
-
- // max precision
- expr("interval '2147483647:59' hour(10) to minute")
- .ok("INTERVAL '2147483647:59' HOUR(10) TO MINUTE");
-
- // min precision
- expr("interval '0:0' hour(1) to minute")
- .ok("INTERVAL '0:0' HOUR(1) TO MINUTE");
-
- // alternate precision
- expr("interval '2345:7' hour(4) to minute")
- .ok("INTERVAL '2345:7' HOUR(4) TO MINUTE");
-
- // sign
- expr("interval '-1:3' hour to minute")
- .ok("INTERVAL '-1:3' HOUR TO MINUTE");
- expr("interval '+1:3' hour to minute")
- .ok("INTERVAL '+1:3' HOUR TO MINUTE");
- expr("interval +'2:3' hour to minute")
- .ok("INTERVAL '2:3' HOUR TO MINUTE");
- expr("interval +'-2:3' hour to minute")
- .ok("INTERVAL '-2:3' HOUR TO MINUTE");
- expr("interval +'+2:3' hour to minute")
- .ok("INTERVAL '+2:3' HOUR TO MINUTE");
- expr("interval -'2:3' hour to minute")
- .ok("INTERVAL -'2:3' HOUR TO MINUTE");
- expr("interval -'-2:3' hour to minute")
- .ok("INTERVAL -'-2:3' HOUR TO MINUTE");
- expr("interval -'+2:3' hour to minute")
- .ok("INTERVAL -'+2:3' HOUR TO MINUTE");
- }
-
- /**
- * Runs tests for INTERVAL... HOUR TO SECOND that should pass both parser
- * and validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- public void subTestIntervalHourToSecondPositive() {
- // default precision
- expr("interval '2:3:4' hour to second")
- .ok("INTERVAL '2:3:4' HOUR TO SECOND");
- expr("interval '23:59:59' hour to second")
- .ok("INTERVAL '23:59:59' HOUR TO SECOND");
- expr("interval '99:0:0' hour to second")
- .ok("INTERVAL '99:0:0' HOUR TO SECOND");
- expr("interval '23:59:59.999999' hour to second")
- .ok("INTERVAL '23:59:59.999999' HOUR TO SECOND");
- expr("interval '99:0:0.0' hour to second")
- .ok("INTERVAL '99:0:0.0' HOUR TO SECOND");
-
- // explicit precision equal to default
- expr("interval '2:3:4' hour(2) to second")
- .ok("INTERVAL '2:3:4' HOUR(2) TO SECOND");
- expr("interval '99:59:59' hour(2) to second")
- .ok("INTERVAL '99:59:59' HOUR(2) TO SECOND");
- expr("interval '99:0:0' hour(2) to second")
- .ok("INTERVAL '99:0:0' HOUR(2) TO SECOND");
- expr("interval '23:59:59.999999' hour to second(6)")
- .ok("INTERVAL '23:59:59.999999' HOUR TO SECOND(6)");
- expr("interval '99:0:0.0' hour to second(6)")
- .ok("INTERVAL '99:0:0.0' HOUR TO SECOND(6)");
-
- // max precision
- expr("interval '2147483647:59:59' hour(10) to second")
- .ok("INTERVAL '2147483647:59:59' HOUR(10) TO SECOND");
- expr("interval '2147483647:59:59.999999999' hour(10) to second(9)")
- .ok("INTERVAL '2147483647:59:59.999999999' HOUR(10) TO SECOND(9)");
-
- // min precision
- expr("interval '0:0:0' hour(1) to second")
- .ok("INTERVAL '0:0:0' HOUR(1) TO SECOND");
- expr("interval '0:0:0.0' hour(1) to second(1)")
- .ok("INTERVAL '0:0:0.0' HOUR(1) TO SECOND(1)");
-
- // alternate precision
- expr("interval '2345:7:8' hour(4) to second")
- .ok("INTERVAL '2345:7:8' HOUR(4) TO SECOND");
- expr("interval '2345:7:8.9012' hour(4) to second(4)")
- .ok("INTERVAL '2345:7:8.9012' HOUR(4) TO SECOND(4)");
-
- // sign
- expr("interval '-2:3:4' hour to second")
- .ok("INTERVAL '-2:3:4' HOUR TO SECOND");
- expr("interval '+2:3:4' hour to second")
- .ok("INTERVAL '+2:3:4' HOUR TO SECOND");
- expr("interval +'2:3:4' hour to second")
- .ok("INTERVAL '2:3:4' HOUR TO SECOND");
- expr("interval +'-2:3:4' hour to second")
- .ok("INTERVAL '-2:3:4' HOUR TO SECOND");
- expr("interval +'+2:3:4' hour to second")
- .ok("INTERVAL '+2:3:4' HOUR TO SECOND");
- expr("interval -'2:3:4' hour to second")
- .ok("INTERVAL -'2:3:4' HOUR TO SECOND");
- expr("interval -'-2:3:4' hour to second")
- .ok("INTERVAL -'-2:3:4' HOUR TO SECOND");
- expr("interval -'+2:3:4' hour to second")
- .ok("INTERVAL -'+2:3:4' HOUR TO SECOND");
- }
-
- /**
- * Runs tests for INTERVAL... MINUTE that should pass both parser and
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- public void subTestIntervalMinutePositive() {
- // default precision
- expr("interval '1' minute")
- .ok("INTERVAL '1' MINUTE");
- expr("interval '99' minute")
- .ok("INTERVAL '99' MINUTE");
-
- // explicit precision equal to default
- expr("interval '1' minute(2)")
- .ok("INTERVAL '1' MINUTE(2)");
- expr("interval '99' minute(2)")
- .ok("INTERVAL '99' MINUTE(2)");
-
- // max precision
- expr("interval '2147483647' minute(10)")
- .ok("INTERVAL '2147483647' MINUTE(10)");
-
- // min precision
- expr("interval '0' minute(1)")
- .ok("INTERVAL '0' MINUTE(1)");
-
- // alternate precision
- expr("interval '1234' minute(4)")
- .ok("INTERVAL '1234' MINUTE(4)");
-
- // sign
- expr("interval '+1' minute")
- .ok("INTERVAL '+1' MINUTE");
- expr("interval '-1' minute")
- .ok("INTERVAL '-1' MINUTE");
- expr("interval +'1' minute")
- .ok("INTERVAL '1' MINUTE");
- expr("interval +'+1' minute")
- .ok("INTERVAL '+1' MINUTE");
- expr("interval +'+1' minute")
- .ok("INTERVAL '+1' MINUTE");
- expr("interval -'1' minute")
- .ok("INTERVAL -'1' MINUTE");
- expr("interval -'+1' minute")
- .ok("INTERVAL -'+1' MINUTE");
- expr("interval -'-1' minute")
- .ok("INTERVAL -'-1' MINUTE");
- }
-
- /**
- * Runs tests for INTERVAL... MINUTE TO SECOND that should pass both parser
- * and validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- public void subTestIntervalMinuteToSecondPositive() {
- // default precision
- expr("interval '2:4' minute to second")
- .ok("INTERVAL '2:4' MINUTE TO SECOND");
- expr("interval '59:59' minute to second")
- .ok("INTERVAL '59:59' MINUTE TO SECOND");
- expr("interval '99:0' minute to second")
- .ok("INTERVAL '99:0' MINUTE TO SECOND");
- expr("interval '59:59.999999' minute to second")
- .ok("INTERVAL '59:59.999999' MINUTE TO SECOND");
- expr("interval '99:0.0' minute to second")
- .ok("INTERVAL '99:0.0' MINUTE TO SECOND");
-
- // explicit precision equal to default
- expr("interval '2:4' minute(2) to second")
- .ok("INTERVAL '2:4' MINUTE(2) TO SECOND");
- expr("interval '59:59' minute(2) to second")
- .ok("INTERVAL '59:59' MINUTE(2) TO SECOND");
- expr("interval '99:0' minute(2) to second")
- .ok("INTERVAL '99:0' MINUTE(2) TO SECOND");
- expr("interval '99:59.999999' minute to second(6)")
- .ok("INTERVAL '99:59.999999' MINUTE TO SECOND(6)");
- expr("interval '99:0.0' minute to second(6)")
- .ok("INTERVAL '99:0.0' MINUTE TO SECOND(6)");
-
- // max precision
- expr("interval '2147483647:59' minute(10) to second")
- .ok("INTERVAL '2147483647:59' MINUTE(10) TO SECOND");
- expr("interval '2147483647:59.999999999' minute(10) to second(9)")
- .ok("INTERVAL '2147483647:59.999999999' MINUTE(10) TO SECOND(9)");
-
- // min precision
- expr("interval '0:0' minute(1) to second")
- .ok("INTERVAL '0:0' MINUTE(1) TO SECOND");
- expr("interval '0:0.0' minute(1) to second(1)")
- .ok("INTERVAL '0:0.0' MINUTE(1) TO SECOND(1)");
-
- // alternate precision
- expr("interval '2345:8' minute(4) to second")
- .ok("INTERVAL '2345:8' MINUTE(4) TO SECOND");
- expr("interval '2345:7.8901' minute(4) to second(4)")
- .ok("INTERVAL '2345:7.8901' MINUTE(4) TO SECOND(4)");
-
- // sign
- expr("interval '-3:4' minute to second")
- .ok("INTERVAL '-3:4' MINUTE TO SECOND");
- expr("interval '+3:4' minute to second")
- .ok("INTERVAL '+3:4' MINUTE TO SECOND");
- expr("interval +'3:4' minute to second")
- .ok("INTERVAL '3:4' MINUTE TO SECOND");
- expr("interval +'-3:4' minute to second")
- .ok("INTERVAL '-3:4' MINUTE TO SECOND");
- expr("interval +'+3:4' minute to second")
- .ok("INTERVAL '+3:4' MINUTE TO SECOND");
- expr("interval -'3:4' minute to second")
- .ok("INTERVAL -'3:4' MINUTE TO SECOND");
- expr("interval -'-3:4' minute to second")
- .ok("INTERVAL -'-3:4' MINUTE TO SECOND");
- expr("interval -'+3:4' minute to second")
- .ok("INTERVAL -'+3:4' MINUTE TO SECOND");
- }
-
- /**
- * Runs tests for INTERVAL... SECOND that should pass both parser and
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXPositive() tests.
- */
- public void subTestIntervalSecondPositive() {
- // default precision
- expr("interval '1' second")
- .ok("INTERVAL '1' SECOND");
- expr("interval '99' second")
- .ok("INTERVAL '99' SECOND");
-
- // explicit precision equal to default
- expr("interval '1' second(2)")
- .ok("INTERVAL '1' SECOND(2)");
- expr("interval '99' second(2)")
- .ok("INTERVAL '99' SECOND(2)");
- expr("interval '1' second(2,6)")
- .ok("INTERVAL '1' SECOND(2, 6)");
- expr("interval '99' second(2,6)")
- .ok("INTERVAL '99' SECOND(2, 6)");
-
- // max precision
- expr("interval '2147483647' second(10)")
- .ok("INTERVAL '2147483647' SECOND(10)");
- expr("interval '2147483647.999999999' second(9,9)")
- .ok("INTERVAL '2147483647.999999999' SECOND(9, 9)");
-
- // min precision
- expr("interval '0' second(1)")
- .ok("INTERVAL '0' SECOND(1)");
- expr("interval '0.0' second(1,1)")
- .ok("INTERVAL '0.0' SECOND(1, 1)");
-
- // alternate precision
- expr("interval '1234' second(4)")
- .ok("INTERVAL '1234' SECOND(4)");
- expr("interval '1234.56789' second(4,5)")
- .ok("INTERVAL '1234.56789' SECOND(4, 5)");
-
- // sign
- expr("interval '+1' second")
- .ok("INTERVAL '+1' SECOND");
- expr("interval '-1' second")
- .ok("INTERVAL '-1' SECOND");
- expr("interval +'1' second")
- .ok("INTERVAL '1' SECOND");
- expr("interval +'+1' second")
- .ok("INTERVAL '+1' SECOND");
- expr("interval +'-1' second")
- .ok("INTERVAL '-1' SECOND");
- expr("interval -'1' second")
- .ok("INTERVAL -'1' SECOND");
- expr("interval -'+1' second")
- .ok("INTERVAL -'+1' SECOND");
- expr("interval -'-1' second")
- .ok("INTERVAL -'-1' SECOND");
- }
-
- /**
- * Runs tests for INTERVAL... YEAR that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXFailsValidation() tests.
- */
- public void subTestIntervalYearFailsValidation() {
- // Qualifier - field mismatches
- expr("INTERVAL '-' YEAR").same();
- expr("INTERVAL '1-2' YEAR").same();
- expr("INTERVAL '1.2' YEAR").same();
- expr("INTERVAL '1 2' YEAR").same();
- expr("INTERVAL '1-2' YEAR(2)").same();
- expr("INTERVAL 'bogus text' YEAR").same();
-
- // negative field values
- expr("INTERVAL '--1' YEAR").same();
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- expr("INTERVAL '100' YEAR")
- .ok("INTERVAL '100' YEAR");
- expr("INTERVAL '100' YEAR(2)").same();
- expr("INTERVAL '1000' YEAR(3)").same();
- expr("INTERVAL '-1000' YEAR(3)").same();
- expr("INTERVAL '2147483648' YEAR(10)").same();
- expr("INTERVAL '-2147483648' YEAR(10)").same();
-
- // precision > maximum
- expr("INTERVAL '1' YEAR(11)").same();
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0' YEAR(0)").same();
- }
-
- /**
- * Runs tests for INTERVAL... YEAR TO MONTH that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXFailsValidation() tests.
- */
- public void subTestIntervalYearToMonthFailsValidation() {
- // Qualifier - field mismatches
- expr("INTERVAL '-' YEAR TO MONTH")
- .ok("INTERVAL '-' YEAR TO MONTH");
- expr("INTERVAL '1' YEAR TO MONTH")
- .ok("INTERVAL '1' YEAR TO MONTH");
- expr("INTERVAL '1:2' YEAR TO MONTH")
- .ok("INTERVAL '1:2' YEAR TO MONTH");
- expr("INTERVAL '1.2' YEAR TO MONTH")
- .ok("INTERVAL '1.2' YEAR TO MONTH");
- expr("INTERVAL '1 2' YEAR TO MONTH")
- .ok("INTERVAL '1 2' YEAR TO MONTH");
- expr("INTERVAL '1:2' YEAR(2) TO MONTH")
- .ok("INTERVAL '1:2' YEAR(2) TO MONTH");
- expr("INTERVAL 'bogus text' YEAR TO MONTH")
- .ok("INTERVAL 'bogus text' YEAR TO MONTH");
-
- // negative field values
- expr("INTERVAL '--1-2' YEAR TO MONTH")
- .ok("INTERVAL '--1-2' YEAR TO MONTH");
- expr("INTERVAL '1--2' YEAR TO MONTH")
- .ok("INTERVAL '1--2' YEAR TO MONTH");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- // plus >max value for mid/end fields
- expr("INTERVAL '100-0' YEAR TO MONTH")
- .ok("INTERVAL '100-0' YEAR TO MONTH");
- expr("INTERVAL '100-0' YEAR(2) TO MONTH")
- .ok("INTERVAL '100-0' YEAR(2) TO MONTH");
- expr("INTERVAL '1000-0' YEAR(3) TO MONTH")
- .ok("INTERVAL '1000-0' YEAR(3) TO MONTH");
- expr("INTERVAL '-1000-0' YEAR(3) TO MONTH")
- .ok("INTERVAL '-1000-0' YEAR(3) TO MONTH");
- expr("INTERVAL '2147483648-0' YEAR(10) TO MONTH")
- .ok("INTERVAL '2147483648-0' YEAR(10) TO MONTH");
- expr("INTERVAL '-2147483648-0' YEAR(10) TO MONTH")
- .ok("INTERVAL '-2147483648-0' YEAR(10) TO MONTH");
- expr("INTERVAL '1-12' YEAR TO MONTH")
- .ok("INTERVAL '1-12' YEAR TO MONTH");
-
- // precision > maximum
- expr("INTERVAL '1-1' YEAR(11) TO MONTH")
- .ok("INTERVAL '1-1' YEAR(11) TO MONTH");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0-0' YEAR(0) TO MONTH")
- .ok("INTERVAL '0-0' YEAR(0) TO MONTH");
- }
-
- /**
- * Runs tests for INTERVAL... MONTH that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXFailsValidation() tests.
- */
- public void subTestIntervalMonthFailsValidation() {
- // Qualifier - field mismatches
- expr("INTERVAL '-' MONTH")
- .ok("INTERVAL '-' MONTH");
- expr("INTERVAL '1-2' MONTH")
- .ok("INTERVAL '1-2' MONTH");
- expr("INTERVAL '1.2' MONTH")
- .ok("INTERVAL '1.2' MONTH");
- expr("INTERVAL '1 2' MONTH")
- .ok("INTERVAL '1 2' MONTH");
- expr("INTERVAL '1-2' MONTH(2)")
- .ok("INTERVAL '1-2' MONTH(2)");
- expr("INTERVAL 'bogus text' MONTH")
- .ok("INTERVAL 'bogus text' MONTH");
-
- // negative field values
- expr("INTERVAL '--1' MONTH")
- .ok("INTERVAL '--1' MONTH");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- expr("INTERVAL '100' MONTH")
- .ok("INTERVAL '100' MONTH");
- expr("INTERVAL '100' MONTH(2)")
- .ok("INTERVAL '100' MONTH(2)");
- expr("INTERVAL '1000' MONTH(3)")
- .ok("INTERVAL '1000' MONTH(3)");
- expr("INTERVAL '-1000' MONTH(3)")
- .ok("INTERVAL '-1000' MONTH(3)");
- expr("INTERVAL '2147483648' MONTH(10)")
- .ok("INTERVAL '2147483648' MONTH(10)");
- expr("INTERVAL '-2147483648' MONTH(10)")
- .ok("INTERVAL '-2147483648' MONTH(10)");
-
- // precision > maximum
- expr("INTERVAL '1' MONTH(11)")
- .ok("INTERVAL '1' MONTH(11)");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0' MONTH(0)")
- .ok("INTERVAL '0' MONTH(0)");
- }
-
- /**
- * Runs tests for INTERVAL... DAY that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXFailsValidation() tests.
- */
- public void subTestIntervalDayFailsValidation() {
- // Qualifier - field mismatches
- expr("INTERVAL '-' DAY")
- .ok("INTERVAL '-' DAY");
- expr("INTERVAL '1-2' DAY")
- .ok("INTERVAL '1-2' DAY");
- expr("INTERVAL '1.2' DAY")
- .ok("INTERVAL '1.2' DAY");
- expr("INTERVAL '1 2' DAY")
- .ok("INTERVAL '1 2' DAY");
- expr("INTERVAL '1:2' DAY")
- .ok("INTERVAL '1:2' DAY");
- expr("INTERVAL '1-2' DAY(2)")
- .ok("INTERVAL '1-2' DAY(2)");
- expr("INTERVAL 'bogus text' DAY")
- .ok("INTERVAL 'bogus text' DAY");
-
- // negative field values
- expr("INTERVAL '--1' DAY")
- .ok("INTERVAL '--1' DAY");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- expr("INTERVAL '100' DAY")
- .ok("INTERVAL '100' DAY");
- expr("INTERVAL '100' DAY(2)")
- .ok("INTERVAL '100' DAY(2)");
- expr("INTERVAL '1000' DAY(3)")
- .ok("INTERVAL '1000' DAY(3)");
- expr("INTERVAL '-1000' DAY(3)")
- .ok("INTERVAL '-1000' DAY(3)");
- expr("INTERVAL '2147483648' DAY(10)")
- .ok("INTERVAL '2147483648' DAY(10)");
- expr("INTERVAL '-2147483648' DAY(10)")
- .ok("INTERVAL '-2147483648' DAY(10)");
-
- // precision > maximum
- expr("INTERVAL '1' DAY(11)")
- .ok("INTERVAL '1' DAY(11)");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0' DAY(0)")
- .ok("INTERVAL '0' DAY(0)");
- }
-
@Test void testVisitSqlInsertWithSqlShuttle() {
final String sql = "insert into emps select * from emps";
final SqlNode sqlNode = sql(sql).node();
@@ -6840,646 +5893,6 @@ public class SqlParserTest {
assertNotSame(sqlNodeVisited, sqlNode);
}
- /**
- * Runs tests for INTERVAL... DAY TO HOUR that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXFailsValidation() tests.
- */
- public void subTestIntervalDayToHourFailsValidation() {
- // Qualifier - field mismatches
- expr("INTERVAL '-' DAY TO HOUR")
- .ok("INTERVAL '-' DAY TO HOUR");
- expr("INTERVAL '1' DAY TO HOUR")
- .ok("INTERVAL '1' DAY TO HOUR");
- expr("INTERVAL '1:2' DAY TO HOUR")
- .ok("INTERVAL '1:2' DAY TO HOUR");
- expr("INTERVAL '1.2' DAY TO HOUR")
- .ok("INTERVAL '1.2' DAY TO HOUR");
- expr("INTERVAL '1 x' DAY TO HOUR")
- .ok("INTERVAL '1 x' DAY TO HOUR");
- expr("INTERVAL ' ' DAY TO HOUR")
- .ok("INTERVAL ' ' DAY TO HOUR");
- expr("INTERVAL '1:2' DAY(2) TO HOUR")
- .ok("INTERVAL '1:2' DAY(2) TO HOUR");
- expr("INTERVAL 'bogus text' DAY TO HOUR")
- .ok("INTERVAL 'bogus text' DAY TO HOUR");
-
- // negative field values
- expr("INTERVAL '--1 1' DAY TO HOUR")
- .ok("INTERVAL '--1 1' DAY TO HOUR");
- expr("INTERVAL '1 -1' DAY TO HOUR")
- .ok("INTERVAL '1 -1' DAY TO HOUR");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- // plus >max value for mid/end fields
- expr("INTERVAL '100 0' DAY TO HOUR")
- .ok("INTERVAL '100 0' DAY TO HOUR");
- expr("INTERVAL '100 0' DAY(2) TO HOUR")
- .ok("INTERVAL '100 0' DAY(2) TO HOUR");
- expr("INTERVAL '1000 0' DAY(3) TO HOUR")
- .ok("INTERVAL '1000 0' DAY(3) TO HOUR");
- expr("INTERVAL '-1000 0' DAY(3) TO HOUR")
- .ok("INTERVAL '-1000 0' DAY(3) TO HOUR");
- expr("INTERVAL '2147483648 0' DAY(10) TO HOUR")
- .ok("INTERVAL '2147483648 0' DAY(10) TO HOUR");
- expr("INTERVAL '-2147483648 0' DAY(10) TO HOUR")
- .ok("INTERVAL '-2147483648 0' DAY(10) TO HOUR");
- expr("INTERVAL '1 24' DAY TO HOUR")
- .ok("INTERVAL '1 24' DAY TO HOUR");
-
- // precision > maximum
- expr("INTERVAL '1 1' DAY(11) TO HOUR")
- .ok("INTERVAL '1 1' DAY(11) TO HOUR");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0 0' DAY(0) TO HOUR")
- .ok("INTERVAL '0 0' DAY(0) TO HOUR");
- }
-
- /**
- * Runs tests for INTERVAL... DAY TO MINUTE that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXFailsValidation() tests.
- */
- public void subTestIntervalDayToMinuteFailsValidation() {
- // Qualifier - field mismatches
- expr("INTERVAL ' :' DAY TO MINUTE")
- .ok("INTERVAL ' :' DAY TO MINUTE");
- expr("INTERVAL '1' DAY TO MINUTE")
- .ok("INTERVAL '1' DAY TO MINUTE");
- expr("INTERVAL '1 2' DAY TO MINUTE")
- .ok("INTERVAL '1 2' DAY TO MINUTE");
- expr("INTERVAL '1:2' DAY TO MINUTE")
- .ok("INTERVAL '1:2' DAY TO MINUTE");
- expr("INTERVAL '1.2' DAY TO MINUTE")
- .ok("INTERVAL '1.2' DAY TO MINUTE");
- expr("INTERVAL 'x 1:1' DAY TO MINUTE")
- .ok("INTERVAL 'x 1:1' DAY TO MINUTE");
- expr("INTERVAL '1 x:1' DAY TO MINUTE")
- .ok("INTERVAL '1 x:1' DAY TO MINUTE");
- expr("INTERVAL '1 1:x' DAY TO MINUTE")
- .ok("INTERVAL '1 1:x' DAY TO MINUTE");
- expr("INTERVAL '1 1:2:3' DAY TO MINUTE")
- .ok("INTERVAL '1 1:2:3' DAY TO MINUTE");
- expr("INTERVAL '1 1:1:1.2' DAY TO MINUTE")
- .ok("INTERVAL '1 1:1:1.2' DAY TO MINUTE");
- expr("INTERVAL '1 1:2:3' DAY(2) TO MINUTE")
- .ok("INTERVAL '1 1:2:3' DAY(2) TO MINUTE");
- expr("INTERVAL '1 1' DAY(2) TO MINUTE")
- .ok("INTERVAL '1 1' DAY(2) TO MINUTE");
- expr("INTERVAL 'bogus text' DAY TO MINUTE")
- .ok("INTERVAL 'bogus text' DAY TO MINUTE");
-
- // negative field values
- expr("INTERVAL '--1 1:1' DAY TO MINUTE")
- .ok("INTERVAL '--1 1:1' DAY TO MINUTE");
- expr("INTERVAL '1 -1:1' DAY TO MINUTE")
- .ok("INTERVAL '1 -1:1' DAY TO MINUTE");
- expr("INTERVAL '1 1:-1' DAY TO MINUTE")
- .ok("INTERVAL '1 1:-1' DAY TO MINUTE");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- // plus >max value for mid/end fields
- expr("INTERVAL '100 0' DAY TO MINUTE")
- .ok("INTERVAL '100 0' DAY TO MINUTE");
- expr("INTERVAL '100 0' DAY(2) TO MINUTE")
- .ok("INTERVAL '100 0' DAY(2) TO MINUTE");
- expr("INTERVAL '1000 0' DAY(3) TO MINUTE")
- .ok("INTERVAL '1000 0' DAY(3) TO MINUTE");
- expr("INTERVAL '-1000 0' DAY(3) TO MINUTE")
- .ok("INTERVAL '-1000 0' DAY(3) TO MINUTE");
- expr("INTERVAL '2147483648 0' DAY(10) TO MINUTE")
- .ok("INTERVAL '2147483648 0' DAY(10) TO MINUTE");
- expr("INTERVAL '-2147483648 0' DAY(10) TO MINUTE")
- .ok("INTERVAL '-2147483648 0' DAY(10) TO MINUTE");
- expr("INTERVAL '1 24:1' DAY TO MINUTE")
- .ok("INTERVAL '1 24:1' DAY TO MINUTE");
- expr("INTERVAL '1 1:60' DAY TO MINUTE")
- .ok("INTERVAL '1 1:60' DAY TO MINUTE");
-
- // precision > maximum
- expr("INTERVAL '1 1' DAY(11) TO MINUTE")
- .ok("INTERVAL '1 1' DAY(11) TO MINUTE");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0 0' DAY(0) TO MINUTE")
- .ok("INTERVAL '0 0' DAY(0) TO MINUTE");
- }
-
- /**
- * Runs tests for INTERVAL... DAY TO SECOND that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXFailsValidation() tests.
- */
- public void subTestIntervalDayToSecondFailsValidation() {
- // Qualifier - field mismatches
- expr("INTERVAL ' ::' DAY TO SECOND")
- .ok("INTERVAL ' ::' DAY TO SECOND");
- expr("INTERVAL ' ::.' DAY TO SECOND")
- .ok("INTERVAL ' ::.' DAY TO SECOND");
- expr("INTERVAL '1' DAY TO SECOND")
- .ok("INTERVAL '1' DAY TO SECOND");
- expr("INTERVAL '1 2' DAY TO SECOND")
- .ok("INTERVAL '1 2' DAY TO SECOND");
- expr("INTERVAL '1:2' DAY TO SECOND")
- .ok("INTERVAL '1:2' DAY TO SECOND");
- expr("INTERVAL '1.2' DAY TO SECOND")
- .ok("INTERVAL '1.2' DAY TO SECOND");
- expr("INTERVAL '1 1:2' DAY TO SECOND")
- .ok("INTERVAL '1 1:2' DAY TO SECOND");
- expr("INTERVAL '1 1:2:x' DAY TO SECOND")
- .ok("INTERVAL '1 1:2:x' DAY TO SECOND");
- expr("INTERVAL '1:2:3' DAY TO SECOND")
- .ok("INTERVAL '1:2:3' DAY TO SECOND");
- expr("INTERVAL '1:1:1.2' DAY TO SECOND")
- .ok("INTERVAL '1:1:1.2' DAY TO SECOND");
- expr("INTERVAL '1 1:2' DAY(2) TO SECOND")
- .ok("INTERVAL '1 1:2' DAY(2) TO SECOND");
- expr("INTERVAL '1 1' DAY(2) TO SECOND")
- .ok("INTERVAL '1 1' DAY(2) TO SECOND");
- expr("INTERVAL 'bogus text' DAY TO SECOND")
- .ok("INTERVAL 'bogus text' DAY TO SECOND");
- expr("INTERVAL '2345 6:7:8901' DAY TO SECOND(4)")
- .ok("INTERVAL '2345 6:7:8901' DAY TO SECOND(4)");
-
- // negative field values
- expr("INTERVAL '--1 1:1:1' DAY TO SECOND")
- .ok("INTERVAL '--1 1:1:1' DAY TO SECOND");
- expr("INTERVAL '1 -1:1:1' DAY TO SECOND")
- .ok("INTERVAL '1 -1:1:1' DAY TO SECOND");
- expr("INTERVAL '1 1:-1:1' DAY TO SECOND")
- .ok("INTERVAL '1 1:-1:1' DAY TO SECOND");
- expr("INTERVAL '1 1:1:-1' DAY TO SECOND")
- .ok("INTERVAL '1 1:1:-1' DAY TO SECOND");
- expr("INTERVAL '1 1:1:1.-1' DAY TO SECOND")
- .ok("INTERVAL '1 1:1:1.-1' DAY TO SECOND");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- // plus >max value for mid/end fields
- expr("INTERVAL '100 0' DAY TO SECOND")
- .ok("INTERVAL '100 0' DAY TO SECOND");
- expr("INTERVAL '100 0' DAY(2) TO SECOND")
- .ok("INTERVAL '100 0' DAY(2) TO SECOND");
- expr("INTERVAL '1000 0' DAY(3) TO SECOND")
- .ok("INTERVAL '1000 0' DAY(3) TO SECOND");
- expr("INTERVAL '-1000 0' DAY(3) TO SECOND")
- .ok("INTERVAL '-1000 0' DAY(3) TO SECOND");
- expr("INTERVAL '2147483648 0' DAY(10) TO SECOND")
- .ok("INTERVAL '2147483648 0' DAY(10) TO SECOND");
- expr("INTERVAL '-2147483648 0' DAY(10) TO SECOND")
- .ok("INTERVAL '-2147483648 0' DAY(10) TO SECOND");
- expr("INTERVAL '1 24:1:1' DAY TO SECOND")
- .ok("INTERVAL '1 24:1:1' DAY TO SECOND");
- expr("INTERVAL '1 1:60:1' DAY TO SECOND")
- .ok("INTERVAL '1 1:60:1' DAY TO SECOND");
- expr("INTERVAL '1 1:1:60' DAY TO SECOND")
- .ok("INTERVAL '1 1:1:60' DAY TO SECOND");
- expr("INTERVAL '1 1:1:1.0000001' DAY TO SECOND")
- .ok("INTERVAL '1 1:1:1.0000001' DAY TO SECOND");
- expr("INTERVAL '1 1:1:1.0001' DAY TO SECOND(3)")
- .ok("INTERVAL '1 1:1:1.0001' DAY TO SECOND(3)");
-
- // precision > maximum
- expr("INTERVAL '1 1' DAY(11) TO SECOND")
- .ok("INTERVAL '1 1' DAY(11) TO SECOND");
- expr("INTERVAL '1 1' DAY TO SECOND(10)")
- .ok("INTERVAL '1 1' DAY TO SECOND(10)");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0 0:0:0' DAY(0) TO SECOND")
- .ok("INTERVAL '0 0:0:0' DAY(0) TO SECOND");
- expr("INTERVAL '0 0:0:0' DAY TO SECOND(0)")
- .ok("INTERVAL '0 0:0:0' DAY TO SECOND(0)");
- }
-
- /**
- * Runs tests for INTERVAL... HOUR that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXFailsValidation() tests.
- */
- public void subTestIntervalHourFailsValidation() {
- // Qualifier - field mismatches
- expr("INTERVAL '-' HOUR")
- .ok("INTERVAL '-' HOUR");
- expr("INTERVAL '1-2' HOUR")
- .ok("INTERVAL '1-2' HOUR");
- expr("INTERVAL '1.2' HOUR")
- .ok("INTERVAL '1.2' HOUR");
- expr("INTERVAL '1 2' HOUR")
- .ok("INTERVAL '1 2' HOUR");
- expr("INTERVAL '1:2' HOUR")
- .ok("INTERVAL '1:2' HOUR");
- expr("INTERVAL '1-2' HOUR(2)")
- .ok("INTERVAL '1-2' HOUR(2)");
- expr("INTERVAL 'bogus text' HOUR")
- .ok("INTERVAL 'bogus text' HOUR");
-
- // negative field values
- expr("INTERVAL '--1' HOUR")
- .ok("INTERVAL '--1' HOUR");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- expr("INTERVAL '100' HOUR")
- .ok("INTERVAL '100' HOUR");
- expr("INTERVAL '100' HOUR(2)")
- .ok("INTERVAL '100' HOUR(2)");
- expr("INTERVAL '1000' HOUR(3)")
- .ok("INTERVAL '1000' HOUR(3)");
- expr("INTERVAL '-1000' HOUR(3)")
- .ok("INTERVAL '-1000' HOUR(3)");
- expr("INTERVAL '2147483648' HOUR(10)")
- .ok("INTERVAL '2147483648' HOUR(10)");
- expr("INTERVAL '-2147483648' HOUR(10)")
- .ok("INTERVAL '-2147483648' HOUR(10)");
-
- // negative field values
- expr("INTERVAL '--1' HOUR")
- .ok("INTERVAL '--1' HOUR");
-
- // precision > maximum
- expr("INTERVAL '1' HOUR(11)")
- .ok("INTERVAL '1' HOUR(11)");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0' HOUR(0)")
- .ok("INTERVAL '0' HOUR(0)");
- }
-
- /**
- * Runs tests for INTERVAL... HOUR TO MINUTE that should pass parser but
- * fail validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXFailsValidation() tests.
- */
- public void subTestIntervalHourToMinuteFailsValidation() {
- // Qualifier - field mismatches
- expr("INTERVAL ':' HOUR TO MINUTE")
- .ok("INTERVAL ':' HOUR TO MINUTE");
- expr("INTERVAL '1' HOUR TO MINUTE")
- .ok("INTERVAL '1' HOUR TO MINUTE");
- expr("INTERVAL '1:x' HOUR TO MINUTE")
- .ok("INTERVAL '1:x' HOUR TO MINUTE");
- expr("INTERVAL '1.2' HOUR TO MINUTE")
- .ok("INTERVAL '1.2' HOUR TO MINUTE");
- expr("INTERVAL '1 2' HOUR TO MINUTE")
- .ok("INTERVAL '1 2' HOUR TO MINUTE");
- expr("INTERVAL '1:2:3' HOUR TO MINUTE")
- .ok("INTERVAL '1:2:3' HOUR TO MINUTE");
- expr("INTERVAL '1 2' HOUR(2) TO MINUTE")
- .ok("INTERVAL '1 2' HOUR(2) TO MINUTE");
- expr("INTERVAL 'bogus text' HOUR TO MINUTE")
- .ok("INTERVAL 'bogus text' HOUR TO MINUTE");
-
- // negative field values
- expr("INTERVAL '--1:1' HOUR TO MINUTE")
- .ok("INTERVAL '--1:1' HOUR TO MINUTE");
- expr("INTERVAL '1:-1' HOUR TO MINUTE")
- .ok("INTERVAL '1:-1' HOUR TO MINUTE");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- // plus >max value for mid/end fields
- expr("INTERVAL '100:0' HOUR TO MINUTE")
- .ok("INTERVAL '100:0' HOUR TO MINUTE");
- expr("INTERVAL '100:0' HOUR(2) TO MINUTE")
- .ok("INTERVAL '100:0' HOUR(2) TO MINUTE");
- expr("INTERVAL '1000:0' HOUR(3) TO MINUTE")
- .ok("INTERVAL '1000:0' HOUR(3) TO MINUTE");
- expr("INTERVAL '-1000:0' HOUR(3) TO MINUTE")
- .ok("INTERVAL '-1000:0' HOUR(3) TO MINUTE");
- expr("INTERVAL '2147483648:0' HOUR(10) TO MINUTE")
- .ok("INTERVAL '2147483648:0' HOUR(10) TO MINUTE");
- expr("INTERVAL '-2147483648:0' HOUR(10) TO MINUTE")
- .ok("INTERVAL '-2147483648:0' HOUR(10) TO MINUTE");
- expr("INTERVAL '1:24' HOUR TO MINUTE")
- .ok("INTERVAL '1:24' HOUR TO MINUTE");
-
- // precision > maximum
- expr("INTERVAL '1:1' HOUR(11) TO MINUTE")
- .ok("INTERVAL '1:1' HOUR(11) TO MINUTE");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0:0' HOUR(0) TO MINUTE")
- .ok("INTERVAL '0:0' HOUR(0) TO MINUTE");
- }
-
- /**
- * Runs tests for INTERVAL... HOUR TO SECOND that should pass parser but
- * fail validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXFailsValidation() tests.
- */
- public void subTestIntervalHourToSecondFailsValidation() {
- // Qualifier - field mismatches
- expr("INTERVAL '::' HOUR TO SECOND")
- .ok("INTERVAL '::' HOUR TO SECOND");
- expr("INTERVAL '::.' HOUR TO SECOND")
- .ok("INTERVAL '::.' HOUR TO SECOND");
- expr("INTERVAL '1' HOUR TO SECOND")
- .ok("INTERVAL '1' HOUR TO SECOND");
- expr("INTERVAL '1 2' HOUR TO SECOND")
- .ok("INTERVAL '1 2' HOUR TO SECOND");
- expr("INTERVAL '1:2' HOUR TO SECOND")
- .ok("INTERVAL '1:2' HOUR TO SECOND");
- expr("INTERVAL '1.2' HOUR TO SECOND")
- .ok("INTERVAL '1.2' HOUR TO SECOND");
- expr("INTERVAL '1 1:2' HOUR TO SECOND")
- .ok("INTERVAL '1 1:2' HOUR TO SECOND");
- expr("INTERVAL '1:2:x' HOUR TO SECOND")
- .ok("INTERVAL '1:2:x' HOUR TO SECOND");
- expr("INTERVAL '1:x:3' HOUR TO SECOND")
- .ok("INTERVAL '1:x:3' HOUR TO SECOND");
- expr("INTERVAL '1:1:1.x' HOUR TO SECOND")
- .ok("INTERVAL '1:1:1.x' HOUR TO SECOND");
- expr("INTERVAL '1 1:2' HOUR(2) TO SECOND")
- .ok("INTERVAL '1 1:2' HOUR(2) TO SECOND");
- expr("INTERVAL '1 1' HOUR(2) TO SECOND")
- .ok("INTERVAL '1 1' HOUR(2) TO SECOND");
- expr("INTERVAL 'bogus text' HOUR TO SECOND")
- .ok("INTERVAL 'bogus text' HOUR TO SECOND");
- expr("INTERVAL '6:7:8901' HOUR TO SECOND(4)")
- .ok("INTERVAL '6:7:8901' HOUR TO SECOND(4)");
-
- // negative field values
- expr("INTERVAL '--1:1:1' HOUR TO SECOND")
- .ok("INTERVAL '--1:1:1' HOUR TO SECOND");
- expr("INTERVAL '1:-1:1' HOUR TO SECOND")
- .ok("INTERVAL '1:-1:1' HOUR TO SECOND");
- expr("INTERVAL '1:1:-1' HOUR TO SECOND")
- .ok("INTERVAL '1:1:-1' HOUR TO SECOND");
- expr("INTERVAL '1:1:1.-1' HOUR TO SECOND")
- .ok("INTERVAL '1:1:1.-1' HOUR TO SECOND");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- // plus >max value for mid/end fields
- expr("INTERVAL '100:0:0' HOUR TO SECOND")
- .ok("INTERVAL '100:0:0' HOUR TO SECOND");
- expr("INTERVAL '100:0:0' HOUR(2) TO SECOND")
- .ok("INTERVAL '100:0:0' HOUR(2) TO SECOND");
- expr("INTERVAL '1000:0:0' HOUR(3) TO SECOND")
- .ok("INTERVAL '1000:0:0' HOUR(3) TO SECOND");
- expr("INTERVAL '-1000:0:0' HOUR(3) TO SECOND")
- .ok("INTERVAL '-1000:0:0' HOUR(3) TO SECOND");
- expr("INTERVAL '2147483648:0:0' HOUR(10) TO SECOND")
- .ok("INTERVAL '2147483648:0:0' HOUR(10) TO SECOND");
- expr("INTERVAL '-2147483648:0:0' HOUR(10) TO SECOND")
- .ok("INTERVAL '-2147483648:0:0' HOUR(10) TO SECOND");
- expr("INTERVAL '1:60:1' HOUR TO SECOND")
- .ok("INTERVAL '1:60:1' HOUR TO SECOND");
- expr("INTERVAL '1:1:60' HOUR TO SECOND")
- .ok("INTERVAL '1:1:60' HOUR TO SECOND");
- expr("INTERVAL '1:1:1.0000001' HOUR TO SECOND")
- .ok("INTERVAL '1:1:1.0000001' HOUR TO SECOND");
- expr("INTERVAL '1:1:1.0001' HOUR TO SECOND(3)")
- .ok("INTERVAL '1:1:1.0001' HOUR TO SECOND(3)");
-
- // precision > maximum
- expr("INTERVAL '1:1:1' HOUR(11) TO SECOND")
- .ok("INTERVAL '1:1:1' HOUR(11) TO SECOND");
- expr("INTERVAL '1:1:1' HOUR TO SECOND(10)")
- .ok("INTERVAL '1:1:1' HOUR TO SECOND(10)");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0:0:0' HOUR(0) TO SECOND")
- .ok("INTERVAL '0:0:0' HOUR(0) TO SECOND");
- expr("INTERVAL '0:0:0' HOUR TO SECOND(0)")
- .ok("INTERVAL '0:0:0' HOUR TO SECOND(0)");
- }
-
- /**
- * Runs tests for INTERVAL... MINUTE that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXFailsValidation() tests.
- */
- public void subTestIntervalMinuteFailsValidation() {
- // Qualifier - field mismatches
- expr("INTERVAL '-' MINUTE")
- .ok("INTERVAL '-' MINUTE");
- expr("INTERVAL '1-2' MINUTE")
- .ok("INTERVAL '1-2' MINUTE");
- expr("INTERVAL '1.2' MINUTE")
- .ok("INTERVAL '1.2' MINUTE");
- expr("INTERVAL '1 2' MINUTE")
- .ok("INTERVAL '1 2' MINUTE");
- expr("INTERVAL '1:2' MINUTE")
- .ok("INTERVAL '1:2' MINUTE");
- expr("INTERVAL '1-2' MINUTE(2)")
- .ok("INTERVAL '1-2' MINUTE(2)");
- expr("INTERVAL 'bogus text' MINUTE")
- .ok("INTERVAL 'bogus text' MINUTE");
-
- // negative field values
- expr("INTERVAL '--1' MINUTE")
- .ok("INTERVAL '--1' MINUTE");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- expr("INTERVAL '100' MINUTE")
- .ok("INTERVAL '100' MINUTE");
- expr("INTERVAL '100' MINUTE(2)")
- .ok("INTERVAL '100' MINUTE(2)");
- expr("INTERVAL '1000' MINUTE(3)")
- .ok("INTERVAL '1000' MINUTE(3)");
- expr("INTERVAL '-1000' MINUTE(3)")
- .ok("INTERVAL '-1000' MINUTE(3)");
- expr("INTERVAL '2147483648' MINUTE(10)")
- .ok("INTERVAL '2147483648' MINUTE(10)");
- expr("INTERVAL '-2147483648' MINUTE(10)")
- .ok("INTERVAL '-2147483648' MINUTE(10)");
-
- // precision > maximum
- expr("INTERVAL '1' MINUTE(11)")
- .ok("INTERVAL '1' MINUTE(11)");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0' MINUTE(0)")
- .ok("INTERVAL '0' MINUTE(0)");
- }
-
- /**
- * Runs tests for INTERVAL... MINUTE TO SECOND that should pass parser but
- * fail validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXFailsValidation() tests.
- */
- public void subTestIntervalMinuteToSecondFailsValidation() {
- // Qualifier - field mismatches
- expr("INTERVAL ':' MINUTE TO SECOND")
- .ok("INTERVAL ':' MINUTE TO SECOND");
- expr("INTERVAL ':.' MINUTE TO SECOND")
- .ok("INTERVAL ':.' MINUTE TO SECOND");
- expr("INTERVAL '1' MINUTE TO SECOND")
- .ok("INTERVAL '1' MINUTE TO SECOND");
- expr("INTERVAL '1 2' MINUTE TO SECOND")
- .ok("INTERVAL '1 2' MINUTE TO SECOND");
- expr("INTERVAL '1.2' MINUTE TO SECOND")
- .ok("INTERVAL '1.2' MINUTE TO SECOND");
- expr("INTERVAL '1 1:2' MINUTE TO SECOND")
- .ok("INTERVAL '1 1:2' MINUTE TO SECOND");
- expr("INTERVAL '1:x' MINUTE TO SECOND")
- .ok("INTERVAL '1:x' MINUTE TO SECOND");
- expr("INTERVAL 'x:3' MINUTE TO SECOND")
- .ok("INTERVAL 'x:3' MINUTE TO SECOND");
- expr("INTERVAL '1:1.x' MINUTE TO SECOND")
- .ok("INTERVAL '1:1.x' MINUTE TO SECOND");
- expr("INTERVAL '1 1:2' MINUTE(2) TO SECOND")
- .ok("INTERVAL '1 1:2' MINUTE(2) TO SECOND");
- expr("INTERVAL '1 1' MINUTE(2) TO SECOND")
- .ok("INTERVAL '1 1' MINUTE(2) TO SECOND");
- expr("INTERVAL 'bogus text' MINUTE TO SECOND")
- .ok("INTERVAL 'bogus text' MINUTE TO SECOND");
- expr("INTERVAL '7:8901' MINUTE TO SECOND(4)")
- .ok("INTERVAL '7:8901' MINUTE TO SECOND(4)");
-
- // negative field values
- expr("INTERVAL '--1:1' MINUTE TO SECOND")
- .ok("INTERVAL '--1:1' MINUTE TO SECOND");
- expr("INTERVAL '1:-1' MINUTE TO SECOND")
- .ok("INTERVAL '1:-1' MINUTE TO SECOND");
- expr("INTERVAL '1:1.-1' MINUTE TO SECOND")
- .ok("INTERVAL '1:1.-1' MINUTE TO SECOND");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- // plus >max value for mid/end fields
- expr("INTERVAL '100:0' MINUTE TO SECOND")
- .ok("INTERVAL '100:0' MINUTE TO SECOND");
- expr("INTERVAL '100:0' MINUTE(2) TO SECOND")
- .ok("INTERVAL '100:0' MINUTE(2) TO SECOND");
- expr("INTERVAL '1000:0' MINUTE(3) TO SECOND")
- .ok("INTERVAL '1000:0' MINUTE(3) TO SECOND");
- expr("INTERVAL '-1000:0' MINUTE(3) TO SECOND")
- .ok("INTERVAL '-1000:0' MINUTE(3) TO SECOND");
- expr("INTERVAL '2147483648:0' MINUTE(10) TO SECOND")
- .ok("INTERVAL '2147483648:0' MINUTE(10) TO SECOND");
- expr("INTERVAL '-2147483648:0' MINUTE(10) TO SECOND")
- .ok("INTERVAL '-2147483648:0' MINUTE(10) TO SECOND");
- expr("INTERVAL '1:60' MINUTE TO SECOND")
- .ok("INTERVAL '1:60' MINUTE TO SECOND");
- expr("INTERVAL '1:1.0000001' MINUTE TO SECOND")
- .ok("INTERVAL '1:1.0000001' MINUTE TO SECOND");
- expr("INTERVAL '1:1:1.0001' MINUTE TO SECOND(3)")
- .ok("INTERVAL '1:1:1.0001' MINUTE TO SECOND(3)");
-
- // precision > maximum
- expr("INTERVAL '1:1' MINUTE(11) TO SECOND")
- .ok("INTERVAL '1:1' MINUTE(11) TO SECOND");
- expr("INTERVAL '1:1' MINUTE TO SECOND(10)")
- .ok("INTERVAL '1:1' MINUTE TO SECOND(10)");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0:0' MINUTE(0) TO SECOND")
- .ok("INTERVAL '0:0' MINUTE(0) TO SECOND");
- expr("INTERVAL '0:0' MINUTE TO SECOND(0)")
- .ok("INTERVAL '0:0' MINUTE TO SECOND(0)");
- }
-
- /**
- * Runs tests for INTERVAL... SECOND that should pass parser but fail
- * validator. A substantially identical set of tests exists in
- * SqlValidatorTest, and any changes here should be synchronized there.
- * Similarly, any changes to tests here should be echoed appropriately to
- * each of the other 12 subTestIntervalXXXFailsValidation() tests.
- */
- public void subTestIntervalSecondFailsValidation() {
- // Qualifier - field mismatches
- expr("INTERVAL ':' SECOND")
- .ok("INTERVAL ':' SECOND");
- expr("INTERVAL '.' SECOND")
- .ok("INTERVAL '.' SECOND");
- expr("INTERVAL '1-2' SECOND")
- .ok("INTERVAL '1-2' SECOND");
- expr("INTERVAL '1.x' SECOND")
- .ok("INTERVAL '1.x' SECOND");
- expr("INTERVAL 'x.1' SECOND")
- .ok("INTERVAL 'x.1' SECOND");
- expr("INTERVAL '1 2' SECOND")
- .ok("INTERVAL '1 2' SECOND");
- expr("INTERVAL '1:2' SECOND")
- .ok("INTERVAL '1:2' SECOND");
- expr("INTERVAL '1-2' SECOND(2)")
- .ok("INTERVAL '1-2' SECOND(2)");
- expr("INTERVAL 'bogus text' SECOND")
- .ok("INTERVAL 'bogus text' SECOND");
-
- // negative field values
- expr("INTERVAL '--1' SECOND")
- .ok("INTERVAL '--1' SECOND");
- expr("INTERVAL '1.-1' SECOND")
- .ok("INTERVAL '1.-1' SECOND");
-
- // Field value out of range
- // (default, explicit default, alt, neg alt, max, neg max)
- expr("INTERVAL '100' SECOND")
- .ok("INTERVAL '100' SECOND");
- expr("INTERVAL '100' SECOND(2)")
- .ok("INTERVAL '100' SECOND(2)");
- expr("INTERVAL '1000' SECOND(3)")
- .ok("INTERVAL '1000' SECOND(3)");
- expr("INTERVAL '-1000' SECOND(3)")
- .ok("INTERVAL '-1000' SECOND(3)");
- expr("INTERVAL '2147483648' SECOND(10)")
- .ok("INTERVAL '2147483648' SECOND(10)");
- expr("INTERVAL '-2147483648' SECOND(10)")
- .ok("INTERVAL '-2147483648' SECOND(10)");
- expr("INTERVAL '1.0000001' SECOND")
- .ok("INTERVAL '1.0000001' SECOND");
- expr("INTERVAL '1.0000001' SECOND(2)")
- .ok("INTERVAL '1.0000001' SECOND(2)");
- expr("INTERVAL '1.0001' SECOND(2, 3)")
- .ok("INTERVAL '1.0001' SECOND(2, 3)");
- expr("INTERVAL '1.000000001' SECOND(2, 9)")
- .ok("INTERVAL '1.000000001' SECOND(2, 9)");
-
- // precision > maximum
- expr("INTERVAL '1' SECOND(11)")
- .ok("INTERVAL '1' SECOND(11)");
- expr("INTERVAL '1.1' SECOND(1, 10)")
- .ok("INTERVAL '1.1' SECOND(1, 10)");
-
- // precision < minimum allowed)
- // note: parser will catch negative values, here we
- // just need to check for 0
- expr("INTERVAL '0' SECOND(0)")
- .ok("INTERVAL '0' SECOND(0)");
- expr("INTERVAL '0' SECOND(1, 0)")
- .ok("INTERVAL '0' SECOND(1, 0)");
- }
-
/**
* Runs tests for each of the thirteen different main types of INTERVAL
* qualifiers (YEAR, YEAR TO MONTH, etc.) Tests in this section fall into
@@ -7495,33 +5908,37 @@ public class SqlParserTest {
* any changes here should be synchronized there.
*/
@Test void testIntervalLiterals() {
- subTestIntervalYearPositive();
- subTestIntervalYearToMonthPositive();
- subTestIntervalMonthPositive();
- subTestIntervalDayPositive();
- subTestIntervalDayToHourPositive();
- subTestIntervalDayToMinutePositive();
- subTestIntervalDayToSecondPositive();
- subTestIntervalHourPositive();
- subTestIntervalHourToMinutePositive();
- subTestIntervalHourToSecondPositive();
- subTestIntervalMinutePositive();
- subTestIntervalMinuteToSecondPositive();
- subTestIntervalSecondPositive();
-
- subTestIntervalYearFailsValidation();
- subTestIntervalYearToMonthFailsValidation();
- subTestIntervalMonthFailsValidation();
- subTestIntervalDayFailsValidation();
- subTestIntervalDayToHourFailsValidation();
- subTestIntervalDayToMinuteFailsValidation();
- subTestIntervalDayToSecondFailsValidation();
- subTestIntervalHourFailsValidation();
- subTestIntervalHourToMinuteFailsValidation();
- subTestIntervalHourToSecondFailsValidation();
- subTestIntervalMinuteFailsValidation();
- subTestIntervalMinuteToSecondFailsValidation();
- subTestIntervalSecondFailsValidation();
+ final SqlParserFixture f = fixture();
+ final IntervalTest.Fixture intervalFixture = new IntervalTest.Fixture() {
+ @Override public IntervalTest.Fixture2 expr(String sql) {
+ final SqlParserFixture f2 = f.sql(sql).expression(true);
+ return getFixture2(f2, f2.sap.sql);
+ }
+
+ @Override public IntervalTest.Fixture2 wholeExpr(String sql) {
+ return expr(sql);
+ }
+
+ private IntervalTest.Fixture2 getFixture2(SqlParserFixture f2,
+ String expectedSql) {
+ return new IntervalTest.Fixture2() {
+ @Override public void fails(String message) {
+ f2.compare(expectedSql);
+ }
+
+ @Override public void columnType(String expectedType) {
+ f2.compare(expectedSql);
+ }
+
+ @Override public IntervalTest.Fixture2 assertParse(
+ String expectedSql) {
+ return getFixture2(f2, expectedSql);
+ }
+ };
+ }
+ };
+
+ new IntervalTest(intervalFixture).testAll();
}
@Test void testUnparseableIntervalQualifiers() {
diff --git a/testkit/src/main/java/org/apache/calcite/test/IntervalTest.java b/testkit/src/main/java/org/apache/calcite/test/IntervalTest.java
new file mode 100644
index 0000000000..1f6d5ed30d
--- /dev/null
+++ b/testkit/src/main/java/org/apache/calcite/test/IntervalTest.java
@@ -0,0 +1,1834 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to you under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+package org.apache.calcite.test;
+
+/** Test cases for intervals.
+ *
+ * <p>Called, with varying implementations of {@link Fixture},
+ * from both parser and validator test.
+ */
+public class IntervalTest {
+ private final Fixture f;
+
+ public IntervalTest(Fixture fixture) {
+ this.f = fixture;
+ }
+
+ /** Runs all tests. */
+ public void testAll() {
+ // Tests that should pass both parser and validator
+ subTestIntervalYearPositive();
+ subTestIntervalYearToMonthPositive();
+ subTestIntervalMonthPositive();
+ subTestIntervalDayPositive();
+ subTestIntervalDayToHourPositive();
+ subTestIntervalDayToMinutePositive();
+ subTestIntervalDayToSecondPositive();
+ subTestIntervalHourPositive();
+ subTestIntervalHourToMinutePositive();
+ subTestIntervalHourToSecondPositive();
+ subTestIntervalMinutePositive();
+ subTestIntervalMinuteToSecondPositive();
+ subTestIntervalSecondPositive();
+
+ // Tests that should pass parser but fail validator
+ subTestIntervalYearNegative();
+ subTestIntervalYearToMonthNegative();
+ subTestIntervalMonthNegative();
+ subTestIntervalDayNegative();
+ subTestIntervalDayToHourNegative();
+ subTestIntervalDayToMinuteNegative();
+ subTestIntervalDayToSecondNegative();
+ subTestIntervalHourNegative();
+ subTestIntervalHourToMinuteNegative();
+ subTestIntervalHourToSecondNegative();
+ subTestIntervalMinuteNegative();
+ subTestIntervalMinuteToSecondNegative();
+ subTestIntervalSecondNegative();
+
+ subTestMisc();
+ }
+
+ /**
+ * Runs tests for INTERVAL... YEAR that should pass both parser and
+ * validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXPositive() tests.
+ */
+ public void subTestIntervalYearPositive() {
+ // default precision
+ f.expr("INTERVAL '1' YEAR")
+ .columnType("INTERVAL YEAR NOT NULL");
+ f.expr("INTERVAL '99' YEAR")
+ .columnType("INTERVAL YEAR NOT NULL");
+
+ // explicit precision equal to default
+ f.expr("INTERVAL '1' YEAR(2)")
+ .columnType("INTERVAL YEAR(2) NOT NULL");
+ f.expr("INTERVAL '99' YEAR(2)")
+ .columnType("INTERVAL YEAR(2) NOT NULL");
+
+ // max precision
+ f.expr("INTERVAL '2147483647' YEAR(10)")
+ .columnType("INTERVAL YEAR(10) NOT NULL");
+
+ // min precision
+ f.expr("INTERVAL '0' YEAR(1)")
+ .columnType("INTERVAL YEAR(1) NOT NULL");
+
+ // alternate precision
+ f.expr("INTERVAL '1234' YEAR(4)")
+ .columnType("INTERVAL YEAR(4) NOT NULL");
+
+ // sign
+ f.expr("INTERVAL '+1' YEAR")
+ .columnType("INTERVAL YEAR NOT NULL");
+ f.expr("INTERVAL '-1' YEAR")
+ .columnType("INTERVAL YEAR NOT NULL");
+ f.expr("INTERVAL +'1' YEAR")
+ .assertParse("INTERVAL '1' YEAR")
+ .columnType("INTERVAL YEAR NOT NULL");
+ f.expr("INTERVAL +'+1' YEAR")
+ .assertParse("INTERVAL '+1' YEAR")
+ .columnType("INTERVAL YEAR NOT NULL");
+ f.expr("INTERVAL +'-1' YEAR")
+ .assertParse("INTERVAL '-1' YEAR")
+ .columnType("INTERVAL YEAR NOT NULL");
+ f.expr("INTERVAL -'1' YEAR")
+ .columnType("INTERVAL YEAR NOT NULL");
+ f.expr("INTERVAL -'+1' YEAR")
+ .columnType("INTERVAL YEAR NOT NULL");
+ f.expr("INTERVAL -'-1' YEAR")
+ .columnType("INTERVAL YEAR NOT NULL");
+ }
+
+ /**
+ * Runs tests for INTERVAL... YEAR TO MONTH that should pass both parser and
+ * validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXPositive() tests.
+ */
+ public void subTestIntervalYearToMonthPositive() {
+ // default precision
+ f.expr("INTERVAL '1-2' YEAR TO MONTH")
+ .columnType("INTERVAL YEAR TO MONTH NOT NULL");
+ f.expr("INTERVAL '99-11' YEAR TO MONTH")
+ .columnType("INTERVAL YEAR TO MONTH NOT NULL");
+ f.expr("INTERVAL '99-0' YEAR TO MONTH")
+ .columnType("INTERVAL YEAR TO MONTH NOT NULL");
+
+ // explicit precision equal to default
+ f.expr("INTERVAL '1-2' YEAR(2) TO MONTH")
+ .columnType("INTERVAL YEAR(2) TO MONTH NOT NULL");
+ f.expr("INTERVAL '99-11' YEAR(2) TO MONTH")
+ .columnType("INTERVAL YEAR(2) TO MONTH NOT NULL");
+ f.expr("INTERVAL '99-0' YEAR(2) TO MONTH")
+ .columnType("INTERVAL YEAR(2) TO MONTH NOT NULL");
+
+ // max precision
+ f.expr("INTERVAL '2147483647-11' YEAR(10) TO MONTH")
+ .columnType("INTERVAL YEAR(10) TO MONTH NOT NULL");
+
+ // min precision
+ f.expr("INTERVAL '0-0' YEAR(1) TO MONTH")
+ .columnType("INTERVAL YEAR(1) TO MONTH NOT NULL");
+
+ // alternate precision
+ f.expr("INTERVAL '2006-2' YEAR(4) TO MONTH")
+ .columnType("INTERVAL YEAR(4) TO MONTH NOT NULL");
+
+ // sign
+ f.expr("INTERVAL '-1-2' YEAR TO MONTH")
+ .columnType("INTERVAL YEAR TO MONTH NOT NULL");
+ f.expr("INTERVAL '+1-2' YEAR TO MONTH")
+ .columnType("INTERVAL YEAR TO MONTH NOT NULL");
+ f.expr("INTERVAL +'1-2' YEAR TO MONTH")
+ .assertParse("INTERVAL '1-2' YEAR TO MONTH")
+ .columnType("INTERVAL YEAR TO MONTH NOT NULL");
+ f.expr("INTERVAL +'-1-2' YEAR TO MONTH")
+ .assertParse("INTERVAL '-1-2' YEAR TO MONTH")
+ .columnType("INTERVAL YEAR TO MONTH NOT NULL");
+ f.expr("INTERVAL +'+1-2' YEAR TO MONTH")
+ .assertParse("INTERVAL '+1-2' YEAR TO MONTH")
+ .columnType("INTERVAL YEAR TO MONTH NOT NULL");
+ f.expr("INTERVAL -'1-2' YEAR TO MONTH")
+ .columnType("INTERVAL YEAR TO MONTH NOT NULL");
+ f.expr("INTERVAL -'-1-2' YEAR TO MONTH")
+ .columnType("INTERVAL YEAR TO MONTH NOT NULL");
+ f.expr("INTERVAL -'+1-2' YEAR TO MONTH")
+ .columnType("INTERVAL YEAR TO MONTH NOT NULL");
+ }
+
+ /**
+ * Runs tests for INTERVAL... MONTH that should pass both parser and
+ * validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXPositive() tests.
+ */
+ public void subTestIntervalMonthPositive() {
+ // default precision
+ f.expr("INTERVAL '1' MONTH")
+ .columnType("INTERVAL MONTH NOT NULL");
+ f.expr("INTERVAL '99' MONTH")
+ .columnType("INTERVAL MONTH NOT NULL");
+
+ // explicit precision equal to default
+ f.expr("INTERVAL '1' MONTH(2)")
+ .columnType("INTERVAL MONTH(2) NOT NULL");
+ f.expr("INTERVAL '99' MONTH(2)")
+ .columnType("INTERVAL MONTH(2) NOT NULL");
+
+ // max precision
+ f.expr("INTERVAL '2147483647' MONTH(10)")
+ .columnType("INTERVAL MONTH(10) NOT NULL");
+
+ // min precision
+ f.expr("INTERVAL '0' MONTH(1)")
+ .columnType("INTERVAL MONTH(1) NOT NULL");
+
+ // alternate precision
+ f.expr("INTERVAL '1234' MONTH(4)")
+ .columnType("INTERVAL MONTH(4) NOT NULL");
+
+ // sign
+ f.expr("INTERVAL '+1' MONTH")
+ .columnType("INTERVAL MONTH NOT NULL");
+ f.expr("INTERVAL '-1' MONTH")
+ .columnType("INTERVAL MONTH NOT NULL");
+ f.expr("INTERVAL +'1' MONTH")
+ .assertParse("INTERVAL '1' MONTH")
+ .columnType("INTERVAL MONTH NOT NULL");
+ f.expr("INTERVAL +'+1' MONTH")
+ .assertParse("INTERVAL '+1' MONTH")
+ .columnType("INTERVAL MONTH NOT NULL");
+ f.expr("INTERVAL +'-1' MONTH")
+ .assertParse("INTERVAL '-1' MONTH")
+ .columnType("INTERVAL MONTH NOT NULL");
+ f.expr("INTERVAL -'1' MONTH")
+ .columnType("INTERVAL MONTH NOT NULL");
+ f.expr("INTERVAL -'+1' MONTH")
+ .columnType("INTERVAL MONTH NOT NULL");
+ f.expr("INTERVAL -'-1' MONTH")
+ .columnType("INTERVAL MONTH NOT NULL");
+ }
+
+ /**
+ * Runs tests for INTERVAL... DAY that should pass both parser and
+ * validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXPositive() tests.
+ */
+ public void subTestIntervalDayPositive() {
+ // default precision
+ f.expr("INTERVAL '1' DAY")
+ .columnType("INTERVAL DAY NOT NULL");
+ f.expr("INTERVAL '99' DAY")
+ .columnType("INTERVAL DAY NOT NULL");
+
+ // explicit precision equal to default
+ f.expr("INTERVAL '1' DAY(2)")
+ .columnType("INTERVAL DAY(2) NOT NULL");
+ f.expr("INTERVAL '99' DAY(2)")
+ .columnType("INTERVAL DAY(2) NOT NULL");
+
+ // max precision
+ f.expr("INTERVAL '2147483647' DAY(10)")
+ .columnType("INTERVAL DAY(10) NOT NULL");
+
+ // min precision
+ f.expr("INTERVAL '0' DAY(1)")
+ .columnType("INTERVAL DAY(1) NOT NULL");
+
+ // alternate precision
+ f.expr("INTERVAL '1234' DAY(4)")
+ .columnType("INTERVAL DAY(4) NOT NULL");
+
+ // sign
+ f.expr("INTERVAL '+1' DAY")
+ .columnType("INTERVAL DAY NOT NULL");
+ f.expr("INTERVAL '-1' DAY")
+ .columnType("INTERVAL DAY NOT NULL");
+ f.expr("INTERVAL +'1' DAY")
+ .assertParse("INTERVAL '1' DAY")
+ .columnType("INTERVAL DAY NOT NULL");
+ f.expr("INTERVAL +'+1' DAY")
+ .assertParse("INTERVAL '+1' DAY")
+ .columnType("INTERVAL DAY NOT NULL");
+ f.expr("INTERVAL +'-1' DAY")
+ .assertParse("INTERVAL '-1' DAY")
+ .columnType("INTERVAL DAY NOT NULL");
+ f.expr("INTERVAL -'1' DAY")
+ .columnType("INTERVAL DAY NOT NULL");
+ f.expr("INTERVAL -'+1' DAY")
+ .columnType("INTERVAL DAY NOT NULL");
+ f.expr("INTERVAL -'-1' DAY")
+ .columnType("INTERVAL DAY NOT NULL");
+ }
+
+ public void subTestIntervalDayToHourPositive() {
+ // default precision
+ f.expr("INTERVAL '1 2' DAY TO HOUR")
+ .columnType("INTERVAL DAY TO HOUR NOT NULL");
+ f.expr("INTERVAL '99 23' DAY TO HOUR")
+ .columnType("INTERVAL DAY TO HOUR NOT NULL");
+ f.expr("INTERVAL '99 0' DAY TO HOUR")
+ .columnType("INTERVAL DAY TO HOUR NOT NULL");
+
+ // explicit precision equal to default
+ f.expr("INTERVAL '1 2' DAY(2) TO HOUR")
+ .columnType("INTERVAL DAY(2) TO HOUR NOT NULL");
+ f.expr("INTERVAL '99 23' DAY(2) TO HOUR")
+ .columnType("INTERVAL DAY(2) TO HOUR NOT NULL");
+ f.expr("INTERVAL '99 0' DAY(2) TO HOUR")
+ .columnType("INTERVAL DAY(2) TO HOUR NOT NULL");
+
+ // max precision
+ f.expr("INTERVAL '2147483647 23' DAY(10) TO HOUR")
+ .columnType("INTERVAL DAY(10) TO HOUR NOT NULL");
+
+ // min precision
+ f.expr("INTERVAL '0 0' DAY(1) TO HOUR")
+ .columnType("INTERVAL DAY(1) TO HOUR NOT NULL");
+
+ // alternate precision
+ f.expr("INTERVAL '2345 2' DAY(4) TO HOUR")
+ .columnType("INTERVAL DAY(4) TO HOUR NOT NULL");
+
+ // sign
+ f.expr("INTERVAL '-1 2' DAY TO HOUR")
+ .columnType("INTERVAL DAY TO HOUR NOT NULL");
+ f.expr("INTERVAL '+1 2' DAY TO HOUR")
+ .columnType("INTERVAL DAY TO HOUR NOT NULL");
+ f.expr("INTERVAL +'1 2' DAY TO HOUR")
+ .assertParse("INTERVAL '1 2' DAY TO HOUR")
+ .columnType("INTERVAL DAY TO HOUR NOT NULL");
+ f.expr("INTERVAL +'-1 2' DAY TO HOUR")
+ .assertParse("INTERVAL '-1 2' DAY TO HOUR")
+ .columnType("INTERVAL DAY TO HOUR NOT NULL");
+ f.expr("INTERVAL +'+1 2' DAY TO HOUR")
+ .assertParse("INTERVAL '+1 2' DAY TO HOUR")
+ .columnType("INTERVAL DAY TO HOUR NOT NULL");
+ f.expr("INTERVAL -'1 2' DAY TO HOUR")
+ .columnType("INTERVAL DAY TO HOUR NOT NULL");
+ f.expr("INTERVAL -'-1 2' DAY TO HOUR")
+ .columnType("INTERVAL DAY TO HOUR NOT NULL");
+ f.expr("INTERVAL -'+1 2' DAY TO HOUR")
+ .columnType("INTERVAL DAY TO HOUR NOT NULL");
+ }
+
+ /**
+ * Runs tests for INTERVAL... DAY TO MINUTE that should pass both parser and
+ * validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXPositive() tests.
+ */
+ public void subTestIntervalDayToMinutePositive() {
+ // default precision
+ f.expr("INTERVAL '1 2:3' DAY TO MINUTE")
+ .columnType("INTERVAL DAY TO MINUTE NOT NULL");
+ f.expr("INTERVAL '99 23:59' DAY TO MINUTE")
+ .columnType("INTERVAL DAY TO MINUTE NOT NULL");
+ f.expr("INTERVAL '99 0:0' DAY TO MINUTE")
+ .columnType("INTERVAL DAY TO MINUTE NOT NULL");
+
+ // explicit precision equal to default
+ f.expr("INTERVAL '1 2:3' DAY(2) TO MINUTE")
+ .columnType("INTERVAL DAY(2) TO MINUTE NOT NULL");
+ f.expr("INTERVAL '99 23:59' DAY(2) TO MINUTE")
+ .columnType("INTERVAL DAY(2) TO MINUTE NOT NULL");
+ f.expr("INTERVAL '99 0:0' DAY(2) TO MINUTE")
+ .columnType("INTERVAL DAY(2) TO MINUTE NOT NULL");
+
+ // max precision
+ f.expr("INTERVAL '2147483647 23:59' DAY(10) TO MINUTE")
+ .columnType("INTERVAL DAY(10) TO MINUTE NOT NULL");
+
+ // min precision
+ f.expr("INTERVAL '0 0:0' DAY(1) TO MINUTE")
+ .columnType("INTERVAL DAY(1) TO MINUTE NOT NULL");
+
+ // alternate precision
+ f.expr("INTERVAL '2345 6:7' DAY(4) TO MINUTE")
+ .columnType("INTERVAL DAY(4) TO MINUTE NOT NULL");
+
+ // sign
+ f.expr("INTERVAL '-1 2:3' DAY TO MINUTE")
+ .columnType("INTERVAL DAY TO MINUTE NOT NULL");
+ f.expr("INTERVAL '+1 2:3' DAY TO MINUTE")
+ .assertParse("INTERVAL '+1 2:3' DAY TO MINUTE")
+ .columnType("INTERVAL DAY TO MINUTE NOT NULL");
+ f.expr("INTERVAL +'1 2:3' DAY TO MINUTE")
+ .assertParse("INTERVAL '1 2:3' DAY TO MINUTE")
+ .columnType("INTERVAL DAY TO MINUTE NOT NULL");
+ f.expr("INTERVAL +'-1 2:3' DAY TO MINUTE")
+ .assertParse("INTERVAL '-1 2:3' DAY TO MINUTE")
+ .columnType("INTERVAL DAY TO MINUTE NOT NULL");
+ f.expr("INTERVAL +'+1 2:3' DAY TO MINUTE")
+ .assertParse("INTERVAL '+1 2:3' DAY TO MINUTE")
+ .columnType("INTERVAL DAY TO MINUTE NOT NULL");
+ f.expr("INTERVAL -'1 2:3' DAY TO MINUTE")
+ .columnType("INTERVAL DAY TO MINUTE NOT NULL");
+ f.expr("INTERVAL -'-1 2:3' DAY TO MINUTE")
+ .columnType("INTERVAL DAY TO MINUTE NOT NULL");
+ f.expr("INTERVAL -'+1 2:3' DAY TO MINUTE")
+ .columnType("INTERVAL DAY TO MINUTE NOT NULL");
+ }
+
+ /**
+ * Runs tests for INTERVAL... DAY TO SECOND that should pass both parser and
+ * validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXPositive() tests.
+ */
+ public void subTestIntervalDayToSecondPositive() {
+ // default precision
+ f.expr("INTERVAL '1 2:3:4' DAY TO SECOND")
+ .columnType("INTERVAL DAY TO SECOND NOT NULL");
+ f.expr("INTERVAL '99 23:59:59' DAY TO SECOND")
+ .columnType("INTERVAL DAY TO SECOND NOT NULL");
+ f.expr("INTERVAL '99 0:0:0' DAY TO SECOND")
+ .columnType("INTERVAL DAY TO SECOND NOT NULL");
+ f.expr("INTERVAL '99 23:59:59.999999' DAY TO SECOND")
+ .columnType("INTERVAL DAY TO SECOND NOT NULL");
+ f.expr("INTERVAL '99 0:0:0.0' DAY TO SECOND")
+ .columnType("INTERVAL DAY TO SECOND NOT NULL");
+
+ // explicit precision equal to default
+ f.expr("INTERVAL '1 2:3:4' DAY(2) TO SECOND")
+ .columnType("INTERVAL DAY(2) TO SECOND NOT NULL");
+ f.expr("INTERVAL '99 23:59:59' DAY(2) TO SECOND")
+ .columnType("INTERVAL DAY(2) TO SECOND NOT NULL");
+ f.expr("INTERVAL '99 0:0:0' DAY(2) TO SECOND")
+ .columnType("INTERVAL DAY(2) TO SECOND NOT NULL");
+ f.expr("INTERVAL '99 23:59:59.999999' DAY TO SECOND(6)")
+ .columnType("INTERVAL DAY TO SECOND(6) NOT NULL");
+ f.expr("INTERVAL '99 0:0:0.0' DAY TO SECOND(6)")
+ .columnType("INTERVAL DAY TO SECOND(6) NOT NULL");
+
+ // max precision
+ f.expr("INTERVAL '2147483647 23:59:59' DAY(10) TO SECOND")
+ .columnType("INTERVAL DAY(10) TO SECOND NOT NULL");
+ f.expr("INTERVAL '2147483647 23:59:59.999999999' DAY(10) TO SECOND(9)")
+ .columnType("INTERVAL DAY(10) TO SECOND(9) NOT NULL");
+
+ // min precision
+ f.expr("INTERVAL '0 0:0:0' DAY(1) TO SECOND")
+ .columnType("INTERVAL DAY(1) TO SECOND NOT NULL");
+ f.expr("INTERVAL '0 0:0:0.0' DAY(1) TO SECOND(1)")
+ .columnType("INTERVAL DAY(1) TO SECOND(1) NOT NULL");
+
+ // alternate precision
+ f.expr("INTERVAL '2345 6:7:8' DAY(4) TO SECOND")
+ .columnType("INTERVAL DAY(4) TO SECOND NOT NULL");
+ f.expr("INTERVAL '2345 6:7:8.9012' DAY(4) TO SECOND(4)")
+ .columnType("INTERVAL DAY(4) TO SECOND(4) NOT NULL");
+
+ // sign
+ f.expr("INTERVAL '-1 2:3:4' DAY TO SECOND")
+ .columnType("INTERVAL DAY TO SECOND NOT NULL");
+ f.expr("INTERVAL '+1 2:3:4' DAY TO SECOND")
+ .columnType("INTERVAL DAY TO SECOND NOT NULL");
+ f.expr("INTERVAL +'1 2:3:4' DAY TO SECOND")
+ .assertParse("INTERVAL '1 2:3:4' DAY TO SECOND")
+ .columnType("INTERVAL DAY TO SECOND NOT NULL");
+ f.expr("INTERVAL +'-1 2:3:4' DAY TO SECOND")
+ .assertParse("INTERVAL '-1 2:3:4' DAY TO SECOND")
+ .columnType("INTERVAL DAY TO SECOND NOT NULL");
+ f.expr("INTERVAL +'+1 2:3:4' DAY TO SECOND")
+ .assertParse("INTERVAL '+1 2:3:4' DAY TO SECOND")
+ .columnType("INTERVAL DAY TO SECOND NOT NULL");
+ f.expr("INTERVAL -'1 2:3:4' DAY TO SECOND")
+ .columnType("INTERVAL DAY TO SECOND NOT NULL");
+ f.expr("INTERVAL -'-1 2:3:4' DAY TO SECOND")
+ .columnType("INTERVAL DAY TO SECOND NOT NULL");
+ f.expr("INTERVAL -'+1 2:3:4' DAY TO SECOND")
+ .columnType("INTERVAL DAY TO SECOND NOT NULL");
+ }
+
+ /**
+ * Runs tests for INTERVAL... HOUR that should pass both parser and
+ * validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXPositive() tests.
+ */
+ public void subTestIntervalHourPositive() {
+ // default precision
+ f.expr("INTERVAL '1' HOUR")
+ .columnType("INTERVAL HOUR NOT NULL");
+ f.expr("INTERVAL '99' HOUR")
+ .columnType("INTERVAL HOUR NOT NULL");
+
+ // explicit precision equal to default
+ f.expr("INTERVAL '1' HOUR(2)")
+ .columnType("INTERVAL HOUR(2) NOT NULL");
+ f.expr("INTERVAL '99' HOUR(2)")
+ .columnType("INTERVAL HOUR(2) NOT NULL");
+
+ // max precision
+ f.expr("INTERVAL '2147483647' HOUR(10)")
+ .columnType("INTERVAL HOUR(10) NOT NULL");
+
+ // min precision
+ f.expr("INTERVAL '0' HOUR(1)")
+ .columnType("INTERVAL HOUR(1) NOT NULL");
+
+ // alternate precision
+ f.expr("INTERVAL '1234' HOUR(4)")
+ .columnType("INTERVAL HOUR(4) NOT NULL");
+
+ // sign
+ f.expr("INTERVAL '+1' HOUR")
+ .columnType("INTERVAL HOUR NOT NULL");
+ f.expr("INTERVAL '-1' HOUR")
+ .columnType("INTERVAL HOUR NOT NULL");
+ f.expr("INTERVAL +'1' HOUR")
+ .assertParse("INTERVAL '1' HOUR")
+ .columnType("INTERVAL HOUR NOT NULL");
+ f.expr("INTERVAL +'+1' HOUR")
+ .assertParse("INTERVAL '+1' HOUR")
+ .columnType("INTERVAL HOUR NOT NULL");
+ f.expr("INTERVAL +'-1' HOUR")
+ .assertParse("INTERVAL '-1' HOUR")
+ .columnType("INTERVAL HOUR NOT NULL");
+ f.expr("INTERVAL -'1' HOUR")
+ .columnType("INTERVAL HOUR NOT NULL");
+ f.expr("INTERVAL -'+1' HOUR")
+ .columnType("INTERVAL HOUR NOT NULL");
+ f.expr("INTERVAL -'-1' HOUR")
+ .columnType("INTERVAL HOUR NOT NULL");
+ }
+
+ /**
+ * Runs tests for INTERVAL... HOUR TO MINUTE that should pass both parser
+ * and validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXPositive() tests.
+ */
+ public void subTestIntervalHourToMinutePositive() {
+ // default precision
+ f.expr("INTERVAL '2:3' HOUR TO MINUTE")
+ .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
+ f.expr("INTERVAL '23:59' HOUR TO MINUTE")
+ .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
+ f.expr("INTERVAL '99:0' HOUR TO MINUTE")
+ .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
+
+ // explicit precision equal to default
+ f.expr("INTERVAL '2:3' HOUR(2) TO MINUTE")
+ .columnType("INTERVAL HOUR(2) TO MINUTE NOT NULL");
+ f.expr("INTERVAL '23:59' HOUR(2) TO MINUTE")
+ .columnType("INTERVAL HOUR(2) TO MINUTE NOT NULL");
+ f.expr("INTERVAL '99:0' HOUR(2) TO MINUTE")
+ .columnType("INTERVAL HOUR(2) TO MINUTE NOT NULL");
+
+ // max precision
+ f.expr("INTERVAL '2147483647:59' HOUR(10) TO MINUTE")
+ .columnType("INTERVAL HOUR(10) TO MINUTE NOT NULL");
+
+ // min precision
+ f.expr("INTERVAL '0:0' HOUR(1) TO MINUTE")
+ .columnType("INTERVAL HOUR(1) TO MINUTE NOT NULL");
+
+ // alternate precision
+ f.expr("INTERVAL '2345:7' HOUR(4) TO MINUTE")
+ .columnType("INTERVAL HOUR(4) TO MINUTE NOT NULL");
+
+ // sign
+ f.expr("INTERVAL '-1:3' HOUR TO MINUTE")
+ .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
+ f.expr("INTERVAL '+1:3' HOUR TO MINUTE")
+ .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
+ f.expr("INTERVAL +'2:3' HOUR TO MINUTE")
+ .assertParse("INTERVAL '2:3' HOUR TO MINUTE")
+ .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
+ f.expr("INTERVAL +'-2:3' HOUR TO MINUTE")
+ .assertParse("INTERVAL '-2:3' HOUR TO MINUTE")
+ .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
+ f.expr("INTERVAL +'+2:3' HOUR TO MINUTE")
+ .assertParse("INTERVAL '+2:3' HOUR TO MINUTE")
+ .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
+ f.expr("INTERVAL -'2:3' HOUR TO MINUTE")
+ .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
+ f.expr("INTERVAL -'-2:3' HOUR TO MINUTE")
+ .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
+ f.expr("INTERVAL -'+2:3' HOUR TO MINUTE")
+ .columnType("INTERVAL HOUR TO MINUTE NOT NULL");
+ }
+
+ /**
+ * Runs tests for INTERVAL... HOUR TO SECOND that should pass both parser
+ * and validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXPositive() tests.
+ */
+ public void subTestIntervalHourToSecondPositive() {
+ // default precision
+ f.expr("INTERVAL '2:3:4' HOUR TO SECOND")
+ .columnType("INTERVAL HOUR TO SECOND NOT NULL");
+ f.expr("INTERVAL '23:59:59' HOUR TO SECOND")
+ .columnType("INTERVAL HOUR TO SECOND NOT NULL");
+ f.expr("INTERVAL '99:0:0' HOUR TO SECOND")
+ .columnType("INTERVAL HOUR TO SECOND NOT NULL");
+ f.expr("INTERVAL '23:59:59.999999' HOUR TO SECOND")
+ .columnType("INTERVAL HOUR TO SECOND NOT NULL");
+ f.expr("INTERVAL '99:0:0.0' HOUR TO SECOND")
+ .columnType("INTERVAL HOUR TO SECOND NOT NULL");
+
+ // explicit precision equal to default
+ f.expr("INTERVAL '2:3:4' HOUR(2) TO SECOND")
+ .columnType("INTERVAL HOUR(2) TO SECOND NOT NULL");
+ f.expr("INTERVAL '99:59:59' HOUR(2) TO SECOND")
+ .columnType("INTERVAL HOUR(2) TO SECOND NOT NULL");
+ f.expr("INTERVAL '99:0:0' HOUR(2) TO SECOND")
+ .columnType("INTERVAL HOUR(2) TO SECOND NOT NULL");
+ f.expr("INTERVAL '99:59:59.999999' HOUR TO SECOND(6)")
+ .columnType("INTERVAL HOUR TO SECOND(6) NOT NULL");
+ f.expr("INTERVAL '99:0:0.0' HOUR TO SECOND(6)")
+ .columnType("INTERVAL HOUR TO SECOND(6) NOT NULL");
+
+ // max precision
+ f.expr("INTERVAL '2147483647:59:59' HOUR(10) TO SECOND")
+ .columnType("INTERVAL HOUR(10) TO SECOND NOT NULL");
+ f.expr("INTERVAL '2147483647:59:59.999999999' HOUR(10) TO SECOND(9)")
+ .columnType("INTERVAL HOUR(10) TO SECOND(9) NOT NULL");
+
+ // min precision
+ f.expr("INTERVAL '0:0:0' HOUR(1) TO SECOND")
+ .columnType("INTERVAL HOUR(1) TO SECOND NOT NULL");
+ f.expr("INTERVAL '0:0:0.0' HOUR(1) TO SECOND(1)")
+ .columnType("INTERVAL HOUR(1) TO SECOND(1) NOT NULL");
+
+ // alternate precision
+ f.expr("INTERVAL '2345:7:8' HOUR(4) TO SECOND")
+ .columnType("INTERVAL HOUR(4) TO SECOND NOT NULL");
+ f.expr("INTERVAL '2345:7:8.9012' HOUR(4) TO SECOND(4)")
+ .columnType("INTERVAL HOUR(4) TO SECOND(4) NOT NULL");
+
+ // sign
+ f.expr("INTERVAL '-2:3:4' HOUR TO SECOND")
+ .columnType("INTERVAL HOUR TO SECOND NOT NULL");
+ f.expr("INTERVAL '+2:3:4' HOUR TO SECOND")
+ .columnType("INTERVAL HOUR TO SECOND NOT NULL");
+ f.expr("INTERVAL +'2:3:4' HOUR TO SECOND")
+ .assertParse("INTERVAL '2:3:4' HOUR TO SECOND")
+ .columnType("INTERVAL HOUR TO SECOND NOT NULL");
+ f.expr("INTERVAL +'-2:3:4' HOUR TO SECOND")
+ .assertParse("INTERVAL '-2:3:4' HOUR TO SECOND")
+ .columnType("INTERVAL HOUR TO SECOND NOT NULL");
+ f.expr("INTERVAL +'+2:3:4' HOUR TO SECOND")
+ .assertParse("INTERVAL '+2:3:4' HOUR TO SECOND")
+ .columnType("INTERVAL HOUR TO SECOND NOT NULL");
+ f.expr("INTERVAL -'2:3:4' HOUR TO SECOND")
+ .columnType("INTERVAL HOUR TO SECOND NOT NULL");
+ f.expr("INTERVAL -'-2:3:4' HOUR TO SECOND")
+ .columnType("INTERVAL HOUR TO SECOND NOT NULL");
+ f.expr("INTERVAL -'+2:3:4' HOUR TO SECOND")
+ .columnType("INTERVAL HOUR TO SECOND NOT NULL");
+ }
+
+ /**
+ * Runs tests for INTERVAL... MINUTE that should pass both parser and
+ * validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXPositive() tests.
+ */
+ public void subTestIntervalMinutePositive() {
+ // default precision
+ f.expr("INTERVAL '1' MINUTE")
+ .columnType("INTERVAL MINUTE NOT NULL");
+ f.expr("INTERVAL '99' MINUTE")
+ .columnType("INTERVAL MINUTE NOT NULL");
+
+ // explicit precision equal to default
+ f.expr("INTERVAL '1' MINUTE(2)")
+ .columnType("INTERVAL MINUTE(2) NOT NULL");
+ f.expr("INTERVAL '99' MINUTE(2)")
+ .columnType("INTERVAL MINUTE(2) NOT NULL");
+
+ // max precision
+ f.expr("INTERVAL '2147483647' MINUTE(10)")
+ .columnType("INTERVAL MINUTE(10) NOT NULL");
+
+ // min precision
+ f.expr("INTERVAL '0' MINUTE(1)")
+ .columnType("INTERVAL MINUTE(1) NOT NULL");
+
+ // alternate precision
+ f.expr("INTERVAL '1234' MINUTE(4)")
+ .columnType("INTERVAL MINUTE(4) NOT NULL");
+
+ // sign
+ f.expr("INTERVAL '+1' MINUTE")
+ .columnType("INTERVAL MINUTE NOT NULL");
+ f.expr("INTERVAL '-1' MINUTE")
+ .columnType("INTERVAL MINUTE NOT NULL");
+ f.expr("INTERVAL +'1' MINUTE")
+ .assertParse("INTERVAL '1' MINUTE")
+ .columnType("INTERVAL MINUTE NOT NULL");
+ f.expr("INTERVAL +'+1' MINUTE")
+ .assertParse("INTERVAL '+1' MINUTE")
+ .columnType("INTERVAL MINUTE NOT NULL");
+ f.expr("INTERVAL +'-1' MINUTE")
+ .assertParse("INTERVAL '-1' MINUTE")
+ .columnType("INTERVAL MINUTE NOT NULL");
+ f.expr("INTERVAL -'1' MINUTE")
+ .columnType("INTERVAL MINUTE NOT NULL");
+ f.expr("INTERVAL -'+1' MINUTE")
+ .columnType("INTERVAL MINUTE NOT NULL");
+ f.expr("INTERVAL -'-1' MINUTE")
+ .columnType("INTERVAL MINUTE NOT NULL");
+ }
+
+ /**
+ * Runs tests for INTERVAL... MINUTE TO SECOND that should pass both parser
+ * and validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXPositive() tests.
+ */
+ public void subTestIntervalMinuteToSecondPositive() {
+ // default precision
+ f.expr("INTERVAL '2:4' MINUTE TO SECOND")
+ .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
+ f.expr("INTERVAL '59:59' MINUTE TO SECOND")
+ .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
+ f.expr("INTERVAL '99:0' MINUTE TO SECOND")
+ .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
+ f.expr("INTERVAL '59:59.999999' MINUTE TO SECOND")
+ .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
+ f.expr("INTERVAL '99:0.0' MINUTE TO SECOND")
+ .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
+
+ // explicit precision equal to default
+ f.expr("INTERVAL '2:4' MINUTE(2) TO SECOND")
+ .columnType("INTERVAL MINUTE(2) TO SECOND NOT NULL");
+ f.expr("INTERVAL '99:59' MINUTE(2) TO SECOND")
+ .columnType("INTERVAL MINUTE(2) TO SECOND NOT NULL");
+ f.expr("INTERVAL '99:0' MINUTE(2) TO SECOND")
+ .columnType("INTERVAL MINUTE(2) TO SECOND NOT NULL");
+ f.expr("INTERVAL '99:59.999999' MINUTE TO SECOND(6)")
+ .columnType("INTERVAL MINUTE TO SECOND(6) NOT NULL");
+ f.expr("INTERVAL '99:0.0' MINUTE TO SECOND(6)")
+ .columnType("INTERVAL MINUTE TO SECOND(6) NOT NULL");
+
+ // max precision
+ f.expr("INTERVAL '2147483647:59' MINUTE(10) TO SECOND")
+ .columnType("INTERVAL MINUTE(10) TO SECOND NOT NULL");
+ f.expr("INTERVAL '2147483647:59.999999999' MINUTE(10) TO SECOND(9)")
+ .columnType("INTERVAL MINUTE(10) TO SECOND(9) NOT NULL");
+
+ // min precision
+ f.expr("INTERVAL '0:0' MINUTE(1) TO SECOND")
+ .columnType("INTERVAL MINUTE(1) TO SECOND NOT NULL");
+ f.expr("INTERVAL '0:0.0' MINUTE(1) TO SECOND(1)")
+ .columnType("INTERVAL MINUTE(1) TO SECOND(1) NOT NULL");
+
+ // alternate precision
+ f.expr("INTERVAL '2345:8' MINUTE(4) TO SECOND")
+ .columnType("INTERVAL MINUTE(4) TO SECOND NOT NULL");
+ f.expr("INTERVAL '2345:7.8901' MINUTE(4) TO SECOND(4)")
+ .columnType("INTERVAL MINUTE(4) TO SECOND(4) NOT NULL");
+
+ // sign
+ f.expr("INTERVAL '-3:4' MINUTE TO SECOND")
+ .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
+ f.expr("INTERVAL '+3:4' MINUTE TO SECOND")
+ .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
+ f.expr("INTERVAL +'3:4' MINUTE TO SECOND")
+ .assertParse("INTERVAL '3:4' MINUTE TO SECOND")
+ .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
+ f.expr("INTERVAL +'-3:4' MINUTE TO SECOND")
+ .assertParse("INTERVAL '-3:4' MINUTE TO SECOND")
+ .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
+ f.expr("INTERVAL +'+3:4' MINUTE TO SECOND")
+ .assertParse("INTERVAL '+3:4' MINUTE TO SECOND")
+ .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
+ f.expr("INTERVAL -'3:4' MINUTE TO SECOND")
+ .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
+ f.expr("INTERVAL -'-3:4' MINUTE TO SECOND")
+ .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
+ f.expr("INTERVAL -'+3:4' MINUTE TO SECOND")
+ .columnType("INTERVAL MINUTE TO SECOND NOT NULL");
+ }
+
+ /**
+ * Runs tests for INTERVAL... SECOND that should pass both parser and
+ * validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXPositive() tests.
+ */
+ public void subTestIntervalSecondPositive() {
+ // default precision
+ f.expr("INTERVAL '1' SECOND")
+ .columnType("INTERVAL SECOND NOT NULL");
+ f.expr("INTERVAL '99' SECOND")
+ .columnType("INTERVAL SECOND NOT NULL");
+
+ // explicit precision equal to default
+ f.expr("INTERVAL '1' SECOND(2)")
+ .columnType("INTERVAL SECOND(2) NOT NULL");
+ f.expr("INTERVAL '99' SECOND(2)")
+ .columnType("INTERVAL SECOND(2) NOT NULL");
+ f.expr("INTERVAL '1' SECOND(2, 6)")
+ .columnType("INTERVAL SECOND(2, 6) NOT NULL");
+ f.expr("INTERVAL '99' SECOND(2, 6)")
+ .columnType("INTERVAL SECOND(2, 6) NOT NULL");
+
+ // max precision
+ f.expr("INTERVAL '2147483647' SECOND(10)")
+ .columnType("INTERVAL SECOND(10) NOT NULL");
+ f.expr("INTERVAL '2147483647.999999999' SECOND(10, 9)")
+ .columnType("INTERVAL SECOND(10, 9) NOT NULL");
+
+ // min precision
+ f.expr("INTERVAL '0' SECOND(1)")
+ .columnType("INTERVAL SECOND(1) NOT NULL");
+ f.expr("INTERVAL '0.0' SECOND(1, 1)")
+ .columnType("INTERVAL SECOND(1, 1) NOT NULL");
+
+ // alternate precision
+ f.expr("INTERVAL '1234' SECOND(4)")
+ .columnType("INTERVAL SECOND(4) NOT NULL");
+ f.expr("INTERVAL '1234.56789' SECOND(4, 5)")
+ .columnType("INTERVAL SECOND(4, 5) NOT NULL");
+
+ // sign
+ f.expr("INTERVAL '+1' SECOND")
+ .columnType("INTERVAL SECOND NOT NULL");
+ f.expr("INTERVAL '-1' SECOND")
+ .columnType("INTERVAL SECOND NOT NULL");
+ f.expr("INTERVAL +'1' SECOND")
+ .assertParse("INTERVAL '1' SECOND")
+ .columnType("INTERVAL SECOND NOT NULL");
+ f.expr("INTERVAL +'+1' SECOND")
+ .assertParse("INTERVAL '+1' SECOND")
+ .columnType("INTERVAL SECOND NOT NULL");
+ f.expr("INTERVAL +'-1' SECOND")
+ .assertParse("INTERVAL '-1' SECOND")
+ .columnType("INTERVAL SECOND NOT NULL");
+ f.expr("INTERVAL -'1' SECOND")
+ .columnType("INTERVAL SECOND NOT NULL");
+ f.expr("INTERVAL -'+1' SECOND")
+ .columnType("INTERVAL SECOND NOT NULL");
+ f.expr("INTERVAL -'-1' SECOND")
+ .columnType("INTERVAL SECOND NOT NULL");
+ }
+
+ /**
+ * Runs tests for INTERVAL... YEAR that should pass parser but fail
+ * validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXNegative() tests.
+ */
+ public void subTestIntervalYearNegative() {
+ // Qualifier - field mismatches
+ f.wholeExpr("INTERVAL '-' YEAR")
+ .fails("Illegal interval literal format '-' for INTERVAL YEAR.*");
+ f.wholeExpr("INTERVAL '1-2' YEAR")
+ .fails("Illegal interval literal format '1-2' for INTERVAL YEAR.*");
+ f.wholeExpr("INTERVAL '1.2' YEAR")
+ .fails("Illegal interval literal format '1.2' for INTERVAL YEAR.*");
+ f.wholeExpr("INTERVAL '1 2' YEAR")
+ .fails("Illegal interval literal format '1 2' for INTERVAL YEAR.*");
+ f.wholeExpr("INTERVAL '1-2' YEAR(2)")
+ .fails("Illegal interval literal format '1-2' for INTERVAL YEAR\\(2\\)");
+ f.wholeExpr("INTERVAL 'bogus text' YEAR")
+ .fails("Illegal interval literal format 'bogus text' for INTERVAL YEAR.*");
+
+ // negative field values
+ f.wholeExpr("INTERVAL '--1' YEAR")
+ .fails("Illegal interval literal format '--1' for INTERVAL YEAR.*");
+
+ // Field value out of range
+ // (default, explicit default, alt, neg alt, max, neg max)
+ f.wholeExpr("INTERVAL '100' YEAR")
+ .fails("Interval field value 100 exceeds precision of YEAR\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '100' YEAR(2)")
+ .fails("Interval field value 100 exceeds precision of YEAR\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '1000' YEAR(3)")
+ .fails("Interval field value 1,000 exceeds precision of YEAR\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '-1000' YEAR(3)")
+ .fails("Interval field value -1,000 exceeds precision of YEAR\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '2147483648' YEAR(10)")
+ .fails("Interval field value 2,147,483,648 exceeds precision of "
+ + "YEAR\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '-2147483648' YEAR(10)")
+ .fails("Interval field value -2,147,483,648 exceeds precision of "
+ + "YEAR\\(10\\) field");
+
+ // precision > maximum
+ f.expr("INTERVAL '1' ^YEAR(11)^")
+ .fails("Interval leading field precision '11' out of range for "
+ + "INTERVAL YEAR\\(11\\)");
+
+ // precision < minimum allowed)
+ // note: parser will catch negative values, here we
+ // just need to check for 0
+ f.expr("INTERVAL '0' ^YEAR(0)^")
+ .fails("Interval leading field precision '0' out of range for "
+ + "INTERVAL YEAR\\(0\\)");
+ }
+
+ /**
+ * Runs tests for INTERVAL... YEAR TO MONTH that should pass parser but fail
+ * validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXNegative() tests.
+ */
+ public void subTestIntervalYearToMonthNegative() {
+ // Qualifier - field mismatches
+ f.wholeExpr("INTERVAL '-' YEAR TO MONTH")
+ .fails("Illegal interval literal format '-' for INTERVAL YEAR TO MONTH");
+ f.wholeExpr("INTERVAL '1' YEAR TO MONTH")
+ .fails("Illegal interval literal format '1' for INTERVAL YEAR TO MONTH");
+ f.wholeExpr("INTERVAL '1:2' YEAR TO MONTH")
+ .fails("Illegal interval literal format '1:2' for INTERVAL YEAR TO MONTH");
+ f.wholeExpr("INTERVAL '1.2' YEAR TO MONTH")
+ .fails("Illegal interval literal format '1.2' for INTERVAL YEAR TO MONTH");
+ f.wholeExpr("INTERVAL '1 2' YEAR TO MONTH")
+ .fails("Illegal interval literal format '1 2' for INTERVAL YEAR TO MONTH");
+ f.wholeExpr("INTERVAL '1:2' YEAR(2) TO MONTH")
+ .fails("Illegal interval literal format '1:2' for "
+ + "INTERVAL YEAR\\(2\\) TO MONTH");
+ f.wholeExpr("INTERVAL 'bogus text' YEAR TO MONTH")
+ .fails("Illegal interval literal format 'bogus text' for "
+ + "INTERVAL YEAR TO MONTH");
+
+ // negative field values
+ f.wholeExpr("INTERVAL '--1-2' YEAR TO MONTH")
+ .fails("Illegal interval literal format '--1-2' for "
+ + "INTERVAL YEAR TO MONTH");
+ f.wholeExpr("INTERVAL '1--2' YEAR TO MONTH")
+ .fails("Illegal interval literal format '1--2' for "
+ + "INTERVAL YEAR TO MONTH");
+
+ // Field value out of range
+ // (default, explicit default, alt, neg alt, max, neg max)
+ // plus >max value for mid/end fields
+ f.wholeExpr("INTERVAL '100-0' YEAR TO MONTH")
+ .fails("Interval field value 100 exceeds precision of YEAR\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '100-0' YEAR(2) TO MONTH")
+ .fails("Interval field value 100 exceeds precision of YEAR\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '1000-0' YEAR(3) TO MONTH")
+ .fails("Interval field value 1,000 exceeds precision of YEAR\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '-1000-0' YEAR(3) TO MONTH")
+ .fails("Interval field value -1,000 exceeds precision of YEAR\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '2147483648-0' YEAR(10) TO MONTH")
+ .fails("Interval field value 2,147,483,648 exceeds precision of YEAR\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '-2147483648-0' YEAR(10) TO MONTH")
+ .fails("Interval field value -2,147,483,648 exceeds precision of YEAR\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '1-12' YEAR TO MONTH")
+ .fails("Illegal interval literal format '1-12' for INTERVAL YEAR TO MONTH.*");
+
+ // precision > maximum
+ f.expr("INTERVAL '1-1' ^YEAR(11) TO MONTH^")
+ .fails("Interval leading field precision '11' out of range for "
+ + "INTERVAL YEAR\\(11\\) TO MONTH");
+
+ // precision < minimum allowed)
+ // note: parser will catch negative values, here we
+ // just need to check for 0
+ f.expr("INTERVAL '0-0' ^YEAR(0) TO MONTH^")
+ .fails("Interval leading field precision '0' out of range for "
+ + "INTERVAL YEAR\\(0\\) TO MONTH");
+ }
+
+ /**
+ * Runs tests for INTERVAL... MONTH that should pass parser but fail
+ * validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXNegative() tests.
+ */
+ public void subTestIntervalMonthNegative() {
+ // Qualifier - field mismatches
+ f.wholeExpr("INTERVAL '-' MONTH")
+ .fails("Illegal interval literal format '-' for INTERVAL MONTH.*");
+ f.wholeExpr("INTERVAL '1-2' MONTH")
+ .fails("Illegal interval literal format '1-2' for INTERVAL MONTH.*");
+ f.wholeExpr("INTERVAL '1.2' MONTH")
+ .fails("Illegal interval literal format '1.2' for INTERVAL MONTH.*");
+ f.wholeExpr("INTERVAL '1 2' MONTH")
+ .fails("Illegal interval literal format '1 2' for INTERVAL MONTH.*");
+ f.wholeExpr("INTERVAL '1-2' MONTH(2)")
+ .fails("Illegal interval literal format '1-2' for INTERVAL MONTH\\(2\\)");
+ f.wholeExpr("INTERVAL 'bogus text' MONTH")
+ .fails("Illegal interval literal format 'bogus text' for INTERVAL MONTH.*");
+
+ // negative field values
+ f.wholeExpr("INTERVAL '--1' MONTH")
+ .fails("Illegal interval literal format '--1' for INTERVAL MONTH.*");
+
+ // Field value out of range
+ // (default, explicit default, alt, neg alt, max, neg max)
+ f.wholeExpr("INTERVAL '100' MONTH")
+ .fails("Interval field value 100 exceeds precision of MONTH\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '100' MONTH(2)")
+ .fails("Interval field value 100 exceeds precision of MONTH\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '1000' MONTH(3)")
+ .fails("Interval field value 1,000 exceeds precision of MONTH\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '-1000' MONTH(3)")
+ .fails("Interval field value -1,000 exceeds precision of MONTH\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '2147483648' MONTH(10)")
+ .fails("Interval field value 2,147,483,648 exceeds precision of MONTH\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '-2147483648' MONTH(10)")
+ .fails("Interval field value -2,147,483,648 exceeds precision of MONTH\\(10\\) field.*");
+
+ // precision > maximum
+ f.expr("INTERVAL '1' ^MONTH(11)^")
+ .fails("Interval leading field precision '11' out of range for "
+ + "INTERVAL MONTH\\(11\\)");
+
+ // precision < minimum allowed)
+ // note: parser will catch negative values, here we
+ // just need to check for 0
+ f.expr("INTERVAL '0' ^MONTH(0)^")
+ .fails("Interval leading field precision '0' out of range for "
+ + "INTERVAL MONTH\\(0\\)");
+ }
+
+ /**
+ * Runs tests for INTERVAL... DAY that should pass parser but fail
+ * validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXNegative() tests.
+ */
+ public void subTestIntervalDayNegative() {
+ // Qualifier - field mismatches
+ f.wholeExpr("INTERVAL '-' DAY")
+ .fails("Illegal interval literal format '-' for INTERVAL DAY.*");
+ f.wholeExpr("INTERVAL '1-2' DAY")
+ .fails("Illegal interval literal format '1-2' for INTERVAL DAY.*");
+ f.wholeExpr("INTERVAL '1.2' DAY")
+ .fails("Illegal interval literal format '1.2' for INTERVAL DAY.*");
+ f.wholeExpr("INTERVAL '1 2' DAY")
+ .fails("Illegal interval literal format '1 2' for INTERVAL DAY.*");
+ f.wholeExpr("INTERVAL '1:2' DAY")
+ .fails("Illegal interval literal format '1:2' for INTERVAL DAY.*");
+ f.wholeExpr("INTERVAL '1-2' DAY(2)")
+ .fails("Illegal interval literal format '1-2' for INTERVAL DAY\\(2\\)");
+ f.wholeExpr("INTERVAL 'bogus text' DAY")
+ .fails("Illegal interval literal format 'bogus text' for INTERVAL DAY.*");
+
+ // negative field values
+ f.wholeExpr("INTERVAL '--1' DAY")
+ .fails("Illegal interval literal format '--1' for INTERVAL DAY.*");
+
+ // Field value out of range
+ // (default, explicit default, alt, neg alt, max, neg max)
+ f.wholeExpr("INTERVAL '100' DAY")
+ .fails("Interval field value 100 exceeds precision of DAY\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '100' DAY(2)")
+ .fails("Interval field value 100 exceeds precision of DAY\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '1000' DAY(3)")
+ .fails("Interval field value 1,000 exceeds precision of DAY\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '-1000' DAY(3)")
+ .fails("Interval field value -1,000 exceeds precision of DAY\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '2147483648' DAY(10)")
+ .fails("Interval field value 2,147,483,648 exceeds precision of "
+ + "DAY\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '-2147483648' DAY(10)")
+ .fails("Interval field value -2,147,483,648 exceeds precision of "
+ + "DAY\\(10\\) field.*");
+
+ // precision > maximum
+ f.expr("INTERVAL '1' ^DAY(11)^")
+ .fails("Interval leading field precision '11' out of range for "
+ + "INTERVAL DAY\\(11\\)");
+
+ // precision < minimum allowed)
+ // note: parser will catch negative values, here we
+ // just need to check for 0
+ f.expr("INTERVAL '0' ^DAY(0)^")
+ .fails("Interval leading field precision '0' out of range for "
+ + "INTERVAL DAY\\(0\\)");
+ }
+
+ /**
+ * Runs tests for INTERVAL... DAY TO HOUR that should pass parser but fail
+ * validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXNegative() tests.
+ */
+ public void subTestIntervalDayToHourNegative() {
+ // Qualifier - field mismatches
+ f.wholeExpr("INTERVAL '-' DAY TO HOUR")
+ .fails("Illegal interval literal format '-' for INTERVAL DAY TO HOUR");
+ f.wholeExpr("INTERVAL '1' DAY TO HOUR")
+ .fails("Illegal interval literal format '1' for INTERVAL DAY TO HOUR");
+ f.wholeExpr("INTERVAL '1:2' DAY TO HOUR")
+ .fails("Illegal interval literal format '1:2' for INTERVAL DAY TO HOUR");
+ f.wholeExpr("INTERVAL '1.2' DAY TO HOUR")
+ .fails("Illegal interval literal format '1.2' for INTERVAL DAY TO HOUR");
+ f.wholeExpr("INTERVAL '1 x' DAY TO HOUR")
+ .fails("Illegal interval literal format '1 x' for INTERVAL DAY TO HOUR");
+ f.wholeExpr("INTERVAL ' ' DAY TO HOUR")
+ .fails("Illegal interval literal format ' ' for INTERVAL DAY TO HOUR");
+ f.wholeExpr("INTERVAL '1:2' DAY(2) TO HOUR")
+ .fails("Illegal interval literal format '1:2' for "
+ + "INTERVAL DAY\\(2\\) TO HOUR");
+ f.wholeExpr("INTERVAL 'bogus text' DAY TO HOUR")
+ .fails("Illegal interval literal format 'bogus text' for "
+ + "INTERVAL DAY TO HOUR");
+
+ // negative field values
+ f.wholeExpr("INTERVAL '--1 1' DAY TO HOUR")
+ .fails("Illegal interval literal format '--1 1' for INTERVAL DAY TO HOUR");
+ f.wholeExpr("INTERVAL '1 -1' DAY TO HOUR")
+ .fails("Illegal interval literal format '1 -1' for INTERVAL DAY TO HOUR");
+
+ // Field value out of range
+ // (default, explicit default, alt, neg alt, max, neg max)
+ // plus >max value for mid/end fields
+ f.wholeExpr("INTERVAL '100 0' DAY TO HOUR")
+ .fails("Interval field value 100 exceeds precision of DAY\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '100 0' DAY(2) TO HOUR")
+ .fails("Interval field value 100 exceeds precision of DAY\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '1000 0' DAY(3) TO HOUR")
+ .fails("Interval field value 1,000 exceeds precision of DAY\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '-1000 0' DAY(3) TO HOUR")
+ .fails("Interval field value -1,000 exceeds precision of DAY\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '2147483648 0' DAY(10) TO HOUR")
+ .fails("Interval field value 2,147,483,648 exceeds precision of DAY\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '-2147483648 0' DAY(10) TO HOUR")
+ .fails("Interval field value -2,147,483,648 exceeds precision of "
+ + "DAY\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '1 24' DAY TO HOUR")
+ .fails("Illegal interval literal format '1 24' for INTERVAL DAY TO HOUR.*");
+
+ // precision > maximum
+ f.expr("INTERVAL '1 1' ^DAY(11) TO HOUR^")
+ .fails("Interval leading field precision '11' out of range for "
+ + "INTERVAL DAY\\(11\\) TO HOUR");
+
+ // precision < minimum allowed)
+ // note: parser will catch negative values, here we
+ // just need to check for 0
+ f.expr("INTERVAL '0 0' ^DAY(0) TO HOUR^")
+ .fails("Interval leading field precision '0' out of range for INTERVAL DAY\\(0\\) TO HOUR");
+ }
+
+ /**
+ * Runs tests for INTERVAL... DAY TO MINUTE that should pass parser but fail
+ * validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXNegative() tests.
+ */
+ public void subTestIntervalDayToMinuteNegative() {
+ // Qualifier - field mismatches
+ f.wholeExpr("INTERVAL ' :' DAY TO MINUTE")
+ .fails("Illegal interval literal format ' :' for INTERVAL DAY TO MINUTE");
+ f.wholeExpr("INTERVAL '1' DAY TO MINUTE")
+ .fails("Illegal interval literal format '1' for INTERVAL DAY TO MINUTE");
+ f.wholeExpr("INTERVAL '1 2' DAY TO MINUTE")
+ .fails("Illegal interval literal format '1 2' for INTERVAL DAY TO MINUTE");
+ f.wholeExpr("INTERVAL '1:2' DAY TO MINUTE")
+ .fails("Illegal interval literal format '1:2' for INTERVAL DAY TO MINUTE");
+ f.wholeExpr("INTERVAL '1.2' DAY TO MINUTE")
+ .fails("Illegal interval literal format '1.2' for INTERVAL DAY TO MINUTE");
+ f.wholeExpr("INTERVAL 'x 1:1' DAY TO MINUTE")
+ .fails("Illegal interval literal format 'x 1:1' for INTERVAL DAY TO MINUTE");
+ f.wholeExpr("INTERVAL '1 x:1' DAY TO MINUTE")
+ .fails("Illegal interval literal format '1 x:1' for INTERVAL DAY TO MINUTE");
+ f.wholeExpr("INTERVAL '1 1:x' DAY TO MINUTE")
+ .fails("Illegal interval literal format '1 1:x' for INTERVAL DAY TO MINUTE");
+ f.wholeExpr("INTERVAL '1 1:2:3' DAY TO MINUTE")
+ .fails("Illegal interval literal format '1 1:2:3' for INTERVAL DAY TO MINUTE");
+ f.wholeExpr("INTERVAL '1 1:1:1.2' DAY TO MINUTE")
+ .fails("Illegal interval literal format '1 1:1:1.2' for INTERVAL DAY TO MINUTE");
+ f.wholeExpr("INTERVAL '1 1:2:3' DAY(2) TO MINUTE")
+ .fails("Illegal interval literal format '1 1:2:3' for "
+ + "INTERVAL DAY\\(2\\) TO MINUTE");
+ f.wholeExpr("INTERVAL '1 1' DAY(2) TO MINUTE")
+ .fails("Illegal interval literal format '1 1' for "
+ + "INTERVAL DAY\\(2\\) TO MINUTE");
+ f.wholeExpr("INTERVAL 'bogus text' DAY TO MINUTE")
+ .fails("Illegal interval literal format 'bogus text' for "
+ + "INTERVAL DAY TO MINUTE");
+
+ // negative field values
+ f.wholeExpr("INTERVAL '--1 1:1' DAY TO MINUTE")
+ .fails("Illegal interval literal format '--1 1:1' for INTERVAL DAY TO MINUTE");
+ f.wholeExpr("INTERVAL '1 -1:1' DAY TO MINUTE")
+ .fails("Illegal interval literal format '1 -1:1' for INTERVAL DAY TO MINUTE");
+ f.wholeExpr("INTERVAL '1 1:-1' DAY TO MINUTE")
+ .fails("Illegal interval literal format '1 1:-1' for INTERVAL DAY TO MINUTE");
+
+ // Field value out of range
+ // (default, explicit default, alt, neg alt, max, neg max)
+ // plus >max value for mid/end fields
+ f.wholeExpr("INTERVAL '100 0:0' DAY TO MINUTE")
+ .fails("Interval field value 100 exceeds precision of DAY\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '100 0:0' DAY(2) TO MINUTE")
+ .fails("Interval field value 100 exceeds precision of DAY\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '1000 0:0' DAY(3) TO MINUTE")
+ .fails("Interval field value 1,000 exceeds precision of DAY\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '-1000 0:0' DAY(3) TO MINUTE")
+ .fails("Interval field value -1,000 exceeds precision of DAY\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '2147483648 0:0' DAY(10) TO MINUTE")
+ .fails("Interval field value 2,147,483,648 exceeds precision of "
+ + "DAY\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '-2147483648 0:0' DAY(10) TO MINUTE")
+ .fails("Interval field value -2,147,483,648 exceeds precision of "
+ + "DAY\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '1 24:1' DAY TO MINUTE")
+ .fails("Illegal interval literal format '1 24:1' for "
+ + "INTERVAL DAY TO MINUTE.*");
+ f.wholeExpr("INTERVAL '1 1:60' DAY TO MINUTE")
+ .fails("Illegal interval literal format '1 1:60' for INTERVAL DAY TO MINUTE.*");
+
+ // precision > maximum
+ f.expr("INTERVAL '1 1:1' ^DAY(11) TO MINUTE^")
+ .fails("Interval leading field precision '11' out of range for "
+ + "INTERVAL DAY\\(11\\) TO MINUTE");
+
+ // precision < minimum allowed)
+ // note: parser will catch negative values, here we
+ // just need to check for 0
+ f.expr("INTERVAL '0 0' ^DAY(0) TO MINUTE^")
+ .fails("Interval leading field precision '0' out of range for "
+ + "INTERVAL DAY\\(0\\) TO MINUTE");
+ }
+
+ /**
+ * Runs tests for INTERVAL... DAY TO SECOND that should pass parser but fail
+ * validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXNegative() tests.
+ */
+ public void subTestIntervalDayToSecondNegative() {
+ // Qualifier - field mismatches
+ f.wholeExpr("INTERVAL ' ::' DAY TO SECOND")
+ .fails("Illegal interval literal format ' ::' for INTERVAL DAY TO SECOND");
+ f.wholeExpr("INTERVAL ' ::.' DAY TO SECOND")
+ .fails("Illegal interval literal format ' ::\\.' for INTERVAL DAY TO SECOND");
+ f.wholeExpr("INTERVAL '1' DAY TO SECOND")
+ .fails("Illegal interval literal format '1' for INTERVAL DAY TO SECOND");
+ f.wholeExpr("INTERVAL '1 2' DAY TO SECOND")
+ .fails("Illegal interval literal format '1 2' for INTERVAL DAY TO SECOND");
+ f.wholeExpr("INTERVAL '1:2' DAY TO SECOND")
+ .fails("Illegal interval literal format '1:2' for "
+ + "INTERVAL DAY TO SECOND");
+ f.wholeExpr("INTERVAL '1.2' DAY TO SECOND")
+ .fails("Illegal interval literal format '1\\.2' for "
+ + "INTERVAL DAY TO SECOND");
+ f.wholeExpr("INTERVAL '1 1:2' DAY TO SECOND")
+ .fails("Illegal interval literal format '1 1:2' for "
+ + "INTERVAL DAY TO SECOND");
+ f.wholeExpr("INTERVAL '1 1:2:x' DAY TO SECOND")
+ .fails("Illegal interval literal format '1 1:2:x' for "
+ + "INTERVAL DAY TO SECOND");
+ f.wholeExpr("INTERVAL '1:2:3' DAY TO SECOND")
+ .fails("Illegal interval literal format '1:2:3' for "
+ + "INTERVAL DAY TO SECOND");
+ f.wholeExpr("INTERVAL '1:1:1.2' DAY TO SECOND")
+ .fails("Illegal interval literal format '1:1:1\\.2' for "
+ + "INTERVAL DAY TO SECOND");
+ f.wholeExpr("INTERVAL '1 1:2' DAY(2) TO SECOND")
+ .fails("Illegal interval literal format '1 1:2' for "
+ + "INTERVAL DAY\\(2\\) TO SECOND");
+ f.wholeExpr("INTERVAL '1 1' DAY(2) TO SECOND")
+ .fails("Illegal interval literal format '1 1' for "
+ + "INTERVAL DAY\\(2\\) TO SECOND");
+ f.wholeExpr("INTERVAL 'bogus text' DAY TO SECOND")
+ .fails("Illegal interval literal format 'bogus text' for "
+ + "INTERVAL DAY TO SECOND");
+ f.wholeExpr("INTERVAL '2345 6:7:8901' DAY TO SECOND(4)")
+ .fails("Illegal interval literal format '2345 6:7:8901' for "
+ + "INTERVAL DAY TO SECOND\\(4\\)");
+
+ // negative field values
+ f.wholeExpr("INTERVAL '--1 1:1:1' DAY TO SECOND")
+ .fails("Illegal interval literal format '--1 1:1:1' for "
+ + "INTERVAL DAY TO SECOND");
+ f.wholeExpr("INTERVAL '1 -1:1:1' DAY TO SECOND")
+ .fails("Illegal interval literal format '1 -1:1:1' for "
+ + "INTERVAL DAY TO SECOND");
+ f.wholeExpr("INTERVAL '1 1:-1:1' DAY TO SECOND")
+ .fails("Illegal interval literal format '1 1:-1:1' for "
+ + "INTERVAL DAY TO SECOND");
+ f.wholeExpr("INTERVAL '1 1:1:-1' DAY TO SECOND")
+ .fails("Illegal interval literal format '1 1:1:-1' for "
+ + "INTERVAL DAY TO SECOND");
+ f.wholeExpr("INTERVAL '1 1:1:1.-1' DAY TO SECOND")
+ .fails("Illegal interval literal format '1 1:1:1.-1' for "
+ + "INTERVAL DAY TO SECOND");
+
+ // Field value out of range
+ // (default, explicit default, alt, neg alt, max, neg max)
+ // plus >max value for mid/end fields
+ f.wholeExpr("INTERVAL '100 0' DAY TO SECOND")
+ .fails("Illegal interval literal format '100 0' for "
+ + "INTERVAL DAY TO SECOND.*");
+ f.wholeExpr("INTERVAL '100 0' DAY(2) TO SECOND")
+ .fails("Illegal interval literal format '100 0' for "
+ + "INTERVAL DAY\\(2\\) TO SECOND.*");
+ f.wholeExpr("INTERVAL '1000 0' DAY(3) TO SECOND")
+ .fails("Illegal interval literal format '1000 0' for "
+ + "INTERVAL DAY\\(3\\) TO SECOND.*");
+ f.wholeExpr("INTERVAL '-1000 0' DAY(3) TO SECOND")
+ .fails("Illegal interval literal format '-1000 0' for "
+ + "INTERVAL DAY\\(3\\) TO SECOND.*");
+ f.wholeExpr("INTERVAL '2147483648 1:1:0' DAY(10) TO SECOND")
+ .fails("Interval field value 2,147,483,648 exceeds precision of "
+ + "DAY\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '-2147483648 1:1:0' DAY(10) TO SECOND")
+ .fails("Interval field value -2,147,483,648 exceeds precision of "
+ + "DAY\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '2147483648 0' DAY(10) TO SECOND")
+ .fails("Illegal interval literal format '2147483648 0' for "
+ + "INTERVAL DAY\\(10\\) TO SECOND.*");
+ f.wholeExpr("INTERVAL '-2147483648 0' DAY(10) TO SECOND")
+ .fails("Illegal interval literal format '-2147483648 0' for "
+ + "INTERVAL DAY\\(10\\) TO SECOND.*");
+ f.wholeExpr("INTERVAL '1 24:1:1' DAY TO SECOND")
+ .fails("Illegal interval literal format '1 24:1:1' for "
+ + "INTERVAL DAY TO SECOND.*");
+ f.wholeExpr("INTERVAL '1 1:60:1' DAY TO SECOND")
+ .fails("Illegal interval literal format '1 1:60:1' for "
+ + "INTERVAL DAY TO SECOND.*");
+ f.wholeExpr("INTERVAL '1 1:1:60' DAY TO SECOND")
+ .fails("Illegal interval literal format '1 1:1:60' for "
+ + "INTERVAL DAY TO SECOND.*");
+ f.wholeExpr("INTERVAL '1 1:1:1.0000001' DAY TO SECOND")
+ .fails("Illegal interval literal format '1 1:1:1\\.0000001' for "
+ + "INTERVAL DAY TO SECOND.*");
+ f.wholeExpr("INTERVAL '1 1:1:1.0001' DAY TO SECOND(3)")
+ .fails("Illegal interval literal format '1 1:1:1\\.0001' for "
+ + "INTERVAL DAY TO SECOND\\(3\\).*");
+
+ // precision > maximum
+ f.expr("INTERVAL '1 1' ^DAY(11) TO SECOND^")
+ .fails("Interval leading field precision '11' out of range for "
+ + "INTERVAL DAY\\(11\\) TO SECOND");
+ f.expr("INTERVAL '1 1' ^DAY TO SECOND(10)^")
+ .fails("Interval fractional second precision '10' out of range for "
+ + "INTERVAL DAY TO SECOND\\(10\\)");
+
+ // precision < minimum allowed)
+ // note: parser will catch negative values, here we
+ // just need to check for 0
+ f.expr("INTERVAL '0 0:0:0' ^DAY(0) TO SECOND^")
+ .fails("Interval leading field precision '0' out of range for "
+ + "INTERVAL DAY\\(0\\) TO SECOND");
+ f.expr("INTERVAL '0 0:0:0' ^DAY TO SECOND(0)^")
+ .fails("Interval fractional second precision '0' out of range for "
+ + "INTERVAL DAY TO SECOND\\(0\\)");
+ }
+
+ /**
+ * Runs tests for INTERVAL... HOUR that should pass parser but fail
+ * validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXNegative() tests.
+ */
+ public void subTestIntervalHourNegative() {
+ // Qualifier - field mismatches
+ f.wholeExpr("INTERVAL '-' HOUR")
+ .fails("Illegal interval literal format '-' for INTERVAL HOUR.*");
+ f.wholeExpr("INTERVAL '1-2' HOUR")
+ .fails("Illegal interval literal format '1-2' for INTERVAL HOUR.*");
+ f.wholeExpr("INTERVAL '1.2' HOUR")
+ .fails("Illegal interval literal format '1.2' for INTERVAL HOUR.*");
+ f.wholeExpr("INTERVAL '1 2' HOUR")
+ .fails("Illegal interval literal format '1 2' for INTERVAL HOUR.*");
+ f.wholeExpr("INTERVAL '1:2' HOUR")
+ .fails("Illegal interval literal format '1:2' for INTERVAL HOUR.*");
+ f.wholeExpr("INTERVAL '1-2' HOUR(2)")
+ .fails("Illegal interval literal format '1-2' for INTERVAL HOUR\\(2\\)");
+ f.wholeExpr("INTERVAL 'bogus text' HOUR")
+ .fails("Illegal interval literal format 'bogus text' for "
+ + "INTERVAL HOUR.*");
+
+ // negative field values
+ f.wholeExpr("INTERVAL '--1' HOUR")
+ .fails("Illegal interval literal format '--1' for INTERVAL HOUR.*");
+
+ // Field value out of range
+ // (default, explicit default, alt, neg alt, max, neg max)
+ f.wholeExpr("INTERVAL '100' HOUR")
+ .fails("Interval field value 100 exceeds precision of "
+ + "HOUR\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '100' HOUR(2)")
+ .fails("Interval field value 100 exceeds precision of "
+ + "HOUR\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '1000' HOUR(3)")
+ .fails("Interval field value 1,000 exceeds precision of "
+ + "HOUR\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '-1000' HOUR(3)")
+ .fails("Interval field value -1,000 exceeds precision of "
+ + "HOUR\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '2147483648' HOUR(10)")
+ .fails("Interval field value 2,147,483,648 exceeds precision of "
+ + "HOUR\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '-2147483648' HOUR(10)")
+ .fails("Interval field value -2,147,483,648 exceeds precision of "
+ + "HOUR\\(10\\) field.*");
+
+ // precision > maximum
+ f.expr("INTERVAL '1' ^HOUR(11)^")
+ .fails("Interval leading field precision '11' out of range for "
+ + "INTERVAL HOUR\\(11\\)");
+
+ // precision < minimum allowed)
+ // note: parser will catch negative values, here we
+ // just need to check for 0
+ f.expr("INTERVAL '0' ^HOUR(0)^")
+ .fails("Interval leading field precision '0' out of range for "
+ + "INTERVAL HOUR\\(0\\)");
+ }
+
+ /**
+ * Runs tests for INTERVAL... HOUR TO MINUTE that should pass parser but
+ * fail validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXNegative() tests.
+ */
+ public void subTestIntervalHourToMinuteNegative() {
+ // Qualifier - field mismatches
+ f.wholeExpr("INTERVAL ':' HOUR TO MINUTE")
+ .fails("Illegal interval literal format ':' for INTERVAL HOUR TO MINUTE");
+ f.wholeExpr("INTERVAL '1' HOUR TO MINUTE")
+ .fails("Illegal interval literal format '1' for INTERVAL HOUR TO MINUTE");
+ f.wholeExpr("INTERVAL '1:x' HOUR TO MINUTE")
+ .fails("Illegal interval literal format '1:x' for INTERVAL HOUR TO MINUTE");
+ f.wholeExpr("INTERVAL '1.2' HOUR TO MINUTE")
+ .fails("Illegal interval literal format '1.2' for INTERVAL HOUR TO MINUTE");
+ f.wholeExpr("INTERVAL '1 2' HOUR TO MINUTE")
+ .fails("Illegal interval literal format '1 2' for INTERVAL HOUR TO MINUTE");
+ f.wholeExpr("INTERVAL '1:2:3' HOUR TO MINUTE")
+ .fails("Illegal interval literal format '1:2:3' for INTERVAL HOUR TO MINUTE");
+ f.wholeExpr("INTERVAL '1 2' HOUR(2) TO MINUTE")
+ .fails("Illegal interval literal format '1 2' for "
+ + "INTERVAL HOUR\\(2\\) TO MINUTE");
+ f.wholeExpr("INTERVAL 'bogus text' HOUR TO MINUTE")
+ .fails("Illegal interval literal format 'bogus text' for "
+ + "INTERVAL HOUR TO MINUTE");
+
+ // negative field values
+ f.wholeExpr("INTERVAL '--1:1' HOUR TO MINUTE")
+ .fails("Illegal interval literal format '--1:1' for INTERVAL HOUR TO MINUTE");
+ f.wholeExpr("INTERVAL '1:-1' HOUR TO MINUTE")
+ .fails("Illegal interval literal format '1:-1' for INTERVAL HOUR TO MINUTE");
+
+ // Field value out of range
+ // (default, explicit default, alt, neg alt, max, neg max)
+ // plus >max value for mid/end fields
+ f.wholeExpr("INTERVAL '100:0' HOUR TO MINUTE")
+ .fails("Interval field value 100 exceeds precision of HOUR\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '100:0' HOUR(2) TO MINUTE")
+ .fails("Interval field value 100 exceeds precision of HOUR\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '1000:0' HOUR(3) TO MINUTE")
+ .fails("Interval field value 1,000 exceeds precision of HOUR\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '-1000:0' HOUR(3) TO MINUTE")
+ .fails("Interval field value -1,000 exceeds precision of HOUR\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '2147483648:0' HOUR(10) TO MINUTE")
+ .fails("Interval field value 2,147,483,648 exceeds precision of HOUR\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '-2147483648:0' HOUR(10) TO MINUTE")
+ .fails("Interval field value -2,147,483,648 exceeds precision of HOUR\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '1:60' HOUR TO MINUTE")
+ .fails("Illegal interval literal format '1:60' for INTERVAL HOUR TO MINUTE.*");
+
+ // precision > maximum
+ f.expr("INTERVAL '1:1' ^HOUR(11) TO MINUTE^")
+ .fails("Interval leading field precision '11' out of range for "
+ + "INTERVAL HOUR\\(11\\) TO MINUTE");
+
+ // precision < minimum allowed)
+ // note: parser will catch negative values, here we
+ // just need to check for 0
+ f.expr("INTERVAL '0:0' ^HOUR(0) TO MINUTE^")
+ .fails("Interval leading field precision '0' out of range for "
+ + "INTERVAL HOUR\\(0\\) TO MINUTE");
+ }
+
+ /**
+ * Runs tests for INTERVAL... HOUR TO SECOND that should pass parser but
+ * fail validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXNegative() tests.
+ */
+ public void subTestIntervalHourToSecondNegative() {
+ // Qualifier - field mismatches
+ f.wholeExpr("INTERVAL '::' HOUR TO SECOND")
+ .fails("Illegal interval literal format '::' for INTERVAL HOUR TO SECOND");
+ f.wholeExpr("INTERVAL '::.' HOUR TO SECOND")
+ .fails("Illegal interval literal format '::\\.' for INTERVAL HOUR TO SECOND");
+ f.wholeExpr("INTERVAL '1' HOUR TO SECOND")
+ .fails("Illegal interval literal format '1' for INTERVAL HOUR TO SECOND");
+ f.wholeExpr("INTERVAL '1 2' HOUR TO SECOND")
+ .fails("Illegal interval literal format '1 2' for INTERVAL HOUR TO SECOND");
+ f.wholeExpr("INTERVAL '1:2' HOUR TO SECOND")
+ .fails("Illegal interval literal format '1:2' for INTERVAL HOUR TO SECOND");
+ f.wholeExpr("INTERVAL '1.2' HOUR TO SECOND")
+ .fails("Illegal interval literal format '1\\.2' for INTERVAL HOUR TO SECOND");
+ f.wholeExpr("INTERVAL '1 1:2' HOUR TO SECOND")
+ .fails("Illegal interval literal format '1 1:2' for INTERVAL HOUR TO SECOND");
+ f.wholeExpr("INTERVAL '1:2:x' HOUR TO SECOND")
+ .fails("Illegal interval literal format '1:2:x' for INTERVAL HOUR TO SECOND");
+ f.wholeExpr("INTERVAL '1:x:3' HOUR TO SECOND")
+ .fails("Illegal interval literal format '1:x:3' for INTERVAL HOUR TO SECOND");
+ f.wholeExpr("INTERVAL '1:1:1.x' HOUR TO SECOND")
+ .fails("Illegal interval literal format '1:1:1\\.x' for INTERVAL HOUR TO SECOND");
+ f.wholeExpr("INTERVAL '1 1:2' HOUR(2) TO SECOND")
+ .fails("Illegal interval literal format '1 1:2' for INTERVAL HOUR\\(2\\) TO SECOND");
+ f.wholeExpr("INTERVAL '1 1' HOUR(2) TO SECOND")
+ .fails("Illegal interval literal format '1 1' for INTERVAL HOUR\\(2\\) TO SECOND");
+ f.wholeExpr("INTERVAL 'bogus text' HOUR TO SECOND")
+ .fails("Illegal interval literal format 'bogus text' for INTERVAL HOUR TO SECOND");
+ f.wholeExpr("INTERVAL '6:7:8901' HOUR TO SECOND(4)")
+ .fails("Illegal interval literal format '6:7:8901' for INTERVAL HOUR TO SECOND\\(4\\)");
+
+ // negative field values
+ f.wholeExpr("INTERVAL '--1:1:1' HOUR TO SECOND")
+ .fails("Illegal interval literal format '--1:1:1' for INTERVAL HOUR TO SECOND");
+ f.wholeExpr("INTERVAL '1:-1:1' HOUR TO SECOND")
+ .fails("Illegal interval literal format '1:-1:1' for INTERVAL HOUR TO SECOND");
+ f.wholeExpr("INTERVAL '1:1:-1' HOUR TO SECOND")
+ .fails("Illegal interval literal format '1:1:-1' for INTERVAL HOUR TO SECOND");
+ f.wholeExpr("INTERVAL '1:1:1.-1' HOUR TO SECOND")
+ .fails("Illegal interval literal format '1:1:1\\.-1' for INTERVAL HOUR TO SECOND");
+
+ // Field value out of range
+ // (default, explicit default, alt, neg alt, max, neg max)
+ // plus >max value for mid/end fields
+ f.wholeExpr("INTERVAL '100:0:0' HOUR TO SECOND")
+ .fails("Interval field value 100 exceeds precision of "
+ + "HOUR\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '100:0:0' HOUR(2) TO SECOND")
+ .fails("Interval field value 100 exceeds precision of "
+ + "HOUR\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '1000:0:0' HOUR(3) TO SECOND")
+ .fails("Interval field value 1,000 exceeds precision of "
+ + "HOUR\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '-1000:0:0' HOUR(3) TO SECOND")
+ .fails("Interval field value -1,000 exceeds precision of "
+ + "HOUR\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '2147483648:0:0' HOUR(10) TO SECOND")
+ .fails("Interval field value 2,147,483,648 exceeds precision of "
+ + "HOUR\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '-2147483648:0:0' HOUR(10) TO SECOND")
+ .fails("Interval field value -2,147,483,648 exceeds precision of "
+ + "HOUR\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '1:60:1' HOUR TO SECOND")
+ .fails("Illegal interval literal format '1:60:1' for "
+ + "INTERVAL HOUR TO SECOND.*");
+ f.wholeExpr("INTERVAL '1:1:60' HOUR TO SECOND")
+ .fails("Illegal interval literal format '1:1:60' for "
+ + "INTERVAL HOUR TO SECOND.*");
+ f.wholeExpr("INTERVAL '1:1:1.0000001' HOUR TO SECOND")
+ .fails("Illegal interval literal format '1:1:1\\.0000001' for "
+ + "INTERVAL HOUR TO SECOND.*");
+ f.wholeExpr("INTERVAL '1:1:1.0001' HOUR TO SECOND(3)")
+ .fails("Illegal interval literal format '1:1:1\\.0001' for "
+ + "INTERVAL HOUR TO SECOND\\(3\\).*");
+
+ // precision > maximum
+ f.expr("INTERVAL '1:1:1' ^HOUR(11) TO SECOND^")
+ .fails("Interval leading field precision '11' out of range for "
+ + "INTERVAL HOUR\\(11\\) TO SECOND");
+ f.expr("INTERVAL '1:1:1' ^HOUR TO SECOND(10)^")
+ .fails("Interval fractional second precision '10' out of range for "
+ + "INTERVAL HOUR TO SECOND\\(10\\)");
+
+ // precision < minimum allowed)
+ // note: parser will catch negative values, here we
+ // just need to check for 0
+ f.expr("INTERVAL '0:0:0' ^HOUR(0) TO SECOND^")
+ .fails("Interval leading field precision '0' out of range for "
+ + "INTERVAL HOUR\\(0\\) TO SECOND");
+ f.expr("INTERVAL '0:0:0' ^HOUR TO SECOND(0)^")
+ .fails("Interval fractional second precision '0' out of range for "
+ + "INTERVAL HOUR TO SECOND\\(0\\)");
+ }
+
+ /**
+ * Runs tests for INTERVAL... MINUTE that should pass parser but fail
+ * validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXNegative() tests.
+ */
+ public void subTestIntervalMinuteNegative() {
+ // Qualifier - field mismatches
+ f.wholeExpr("INTERVAL '-' MINUTE")
+ .fails("Illegal interval literal format '-' for INTERVAL MINUTE.*");
+ f.wholeExpr("INTERVAL '1-2' MINUTE")
+ .fails("Illegal interval literal format '1-2' for INTERVAL MINUTE.*");
+ f.wholeExpr("INTERVAL '1.2' MINUTE")
+ .fails("Illegal interval literal format '1.2' for INTERVAL MINUTE.*");
+ f.wholeExpr("INTERVAL '1 2' MINUTE")
+ .fails("Illegal interval literal format '1 2' for INTERVAL MINUTE.*");
+ f.wholeExpr("INTERVAL '1:2' MINUTE")
+ .fails("Illegal interval literal format '1:2' for INTERVAL MINUTE.*");
+ f.wholeExpr("INTERVAL '1-2' MINUTE(2)")
+ .fails("Illegal interval literal format '1-2' for INTERVAL MINUTE\\(2\\)");
+ f.wholeExpr("INTERVAL 'bogus text' MINUTE")
+ .fails("Illegal interval literal format 'bogus text' for INTERVAL MINUTE.*");
+
+ // negative field values
+ f.wholeExpr("INTERVAL '--1' MINUTE")
+ .fails("Illegal interval literal format '--1' for INTERVAL MINUTE.*");
+
+ // Field value out of range
+ // (default, explicit default, alt, neg alt, max, neg max)
+ f.wholeExpr("INTERVAL '100' MINUTE")
+ .fails("Interval field value 100 exceeds precision of MINUTE\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '100' MINUTE(2)")
+ .fails("Interval field value 100 exceeds precision of MINUTE\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '1000' MINUTE(3)")
+ .fails("Interval field value 1,000 exceeds precision of MINUTE\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '-1000' MINUTE(3)")
+ .fails("Interval field value -1,000 exceeds precision of MINUTE\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '2147483648' MINUTE(10)")
+ .fails("Interval field value 2,147,483,648 exceeds precision of MINUTE\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '-2147483648' MINUTE(10)")
+ .fails("Interval field value -2,147,483,648 exceeds precision of MINUTE\\(10\\) field.*");
+
+ // precision > maximum
+ f.expr("INTERVAL '1' ^MINUTE(11)^")
+ .fails("Interval leading field precision '11' out of range for "
+ + "INTERVAL MINUTE\\(11\\)");
+
+ // precision < minimum allowed)
+ // note: parser will catch negative values, here we
+ // just need to check for 0
+ f.expr("INTERVAL '0' ^MINUTE(0)^")
+ .fails("Interval leading field precision '0' out of range for "
+ + "INTERVAL MINUTE\\(0\\)");
+ }
+
+ /**
+ * Runs tests for INTERVAL... MINUTE TO SECOND that should pass parser but
+ * fail validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXNegative() tests.
+ */
+ public void subTestIntervalMinuteToSecondNegative() {
+ // Qualifier - field mismatches
+ f.wholeExpr("INTERVAL ':' MINUTE TO SECOND")
+ .fails("Illegal interval literal format ':' for INTERVAL MINUTE TO SECOND");
+ f.wholeExpr("INTERVAL ':.' MINUTE TO SECOND")
+ .fails("Illegal interval literal format ':\\.' for INTERVAL MINUTE TO SECOND");
+ f.wholeExpr("INTERVAL '1' MINUTE TO SECOND")
+ .fails("Illegal interval literal format '1' for INTERVAL MINUTE TO SECOND");
+ f.wholeExpr("INTERVAL '1 2' MINUTE TO SECOND")
+ .fails("Illegal interval literal format '1 2' for INTERVAL MINUTE TO SECOND");
+ f.wholeExpr("INTERVAL '1.2' MINUTE TO SECOND")
+ .fails("Illegal interval literal format '1\\.2' for INTERVAL MINUTE TO SECOND");
+ f.wholeExpr("INTERVAL '1 1:2' MINUTE TO SECOND")
+ .fails("Illegal interval literal format '1 1:2' for INTERVAL MINUTE TO SECOND");
+ f.wholeExpr("INTERVAL '1:x' MINUTE TO SECOND")
+ .fails("Illegal interval literal format '1:x' for INTERVAL MINUTE TO SECOND");
+ f.wholeExpr("INTERVAL 'x:3' MINUTE TO SECOND")
+ .fails("Illegal interval literal format 'x:3' for INTERVAL MINUTE TO SECOND");
+ f.wholeExpr("INTERVAL '1:1.x' MINUTE TO SECOND")
+ .fails("Illegal interval literal format '1:1\\.x' for INTERVAL MINUTE TO SECOND");
+ f.wholeExpr("INTERVAL '1 1:2' MINUTE(2) TO SECOND")
+ .fails("Illegal interval literal format '1 1:2' for INTERVAL MINUTE\\(2\\) TO SECOND");
+ f.wholeExpr("INTERVAL '1 1' MINUTE(2) TO SECOND")
+ .fails("Illegal interval literal format '1 1' for INTERVAL MINUTE\\(2\\) TO SECOND");
+ f.wholeExpr("INTERVAL 'bogus text' MINUTE TO SECOND")
+ .fails("Illegal interval literal format 'bogus text' for INTERVAL MINUTE TO SECOND");
+ f.wholeExpr("INTERVAL '7:8901' MINUTE TO SECOND(4)")
+ .fails("Illegal interval literal format '7:8901' for INTERVAL MINUTE TO SECOND\\(4\\)");
+
+ // negative field values
+ f.wholeExpr("INTERVAL '--1:1' MINUTE TO SECOND")
+ .fails("Illegal interval literal format '--1:1' for INTERVAL MINUTE TO SECOND");
+ f.wholeExpr("INTERVAL '1:-1' MINUTE TO SECOND")
+ .fails("Illegal interval literal format '1:-1' for INTERVAL MINUTE TO SECOND");
+ f.wholeExpr("INTERVAL '1:1.-1' MINUTE TO SECOND")
+ .fails("Illegal interval literal format '1:1.-1' for INTERVAL MINUTE TO SECOND");
+
+ // Field value out of range
+ // (default, explicit default, alt, neg alt, max, neg max)
+ // plus >max value for mid/end fields
+ f.wholeExpr("INTERVAL '100:0' MINUTE TO SECOND")
+ .fails("Interval field value 100 exceeds precision of MINUTE\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '100:0' MINUTE(2) TO SECOND")
+ .fails("Interval field value 100 exceeds precision of MINUTE\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '1000:0' MINUTE(3) TO SECOND")
+ .fails("Interval field value 1,000 exceeds precision of MINUTE\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '-1000:0' MINUTE(3) TO SECOND")
+ .fails("Interval field value -1,000 exceeds precision of MINUTE\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '2147483648:0' MINUTE(10) TO SECOND")
+ .fails("Interval field value 2,147,483,648 exceeds precision of MINUTE\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '-2147483648:0' MINUTE(10) TO SECOND")
+ .fails("Interval field value -2,147,483,648 exceeds precision of MINUTE\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '1:60' MINUTE TO SECOND")
+ .fails("Illegal interval literal format '1:60' for"
+ + " INTERVAL MINUTE TO SECOND.*");
+ f.wholeExpr("INTERVAL '1:1.0000001' MINUTE TO SECOND")
+ .fails("Illegal interval literal format '1:1\\.0000001' for"
+ + " INTERVAL MINUTE TO SECOND.*");
+ f.wholeExpr("INTERVAL '1:1:1.0001' MINUTE TO SECOND(3)")
+ .fails("Illegal interval literal format '1:1:1\\.0001' for"
+ + " INTERVAL MINUTE TO SECOND\\(3\\).*");
+
+ // precision > maximum
+ f.expr("INTERVAL '1:1' ^MINUTE(11) TO SECOND^")
+ .fails("Interval leading field precision '11' out of range for"
+ + " INTERVAL MINUTE\\(11\\) TO SECOND");
+ f.expr("INTERVAL '1:1' ^MINUTE TO SECOND(10)^")
+ .fails("Interval fractional second precision '10' out of range for"
+ + " INTERVAL MINUTE TO SECOND\\(10\\)");
+
+ // precision < minimum allowed)
+ // note: parser will catch negative values, here we
+ // just need to check for 0
+ f.expr("INTERVAL '0:0' ^MINUTE(0) TO SECOND^")
+ .fails("Interval leading field precision '0' out of range for"
+ + " INTERVAL MINUTE\\(0\\) TO SECOND");
+ f.expr("INTERVAL '0:0' ^MINUTE TO SECOND(0)^")
+ .fails("Interval fractional second precision '0' out of range for"
+ + " INTERVAL MINUTE TO SECOND\\(0\\)");
+ }
+
+ /**
+ * Runs tests for INTERVAL... SECOND that should pass parser but fail
+ * validator. A substantially identical set of tests exists in
+ * SqlParserTest, and any changes here should be synchronized there.
+ * Similarly, any changes to tests here should be echoed appropriately to
+ * each of the other 12 subTestIntervalXXXNegative() tests.
+ */
+ public void subTestIntervalSecondNegative() {
+ // Qualifier - field mismatches
+ f.wholeExpr("INTERVAL ':' SECOND")
+ .fails("Illegal interval literal format ':' for INTERVAL SECOND.*");
+ f.wholeExpr("INTERVAL '.' SECOND")
+ .fails("Illegal interval literal format '\\.' for INTERVAL SECOND.*");
+ f.wholeExpr("INTERVAL '1-2' SECOND")
+ .fails("Illegal interval literal format '1-2' for INTERVAL SECOND.*");
+ f.wholeExpr("INTERVAL '1.x' SECOND")
+ .fails("Illegal interval literal format '1\\.x' for INTERVAL SECOND.*");
+ f.wholeExpr("INTERVAL 'x.1' SECOND")
+ .fails("Illegal interval literal format 'x\\.1' for INTERVAL SECOND.*");
+ f.wholeExpr("INTERVAL '1 2' SECOND")
+ .fails("Illegal interval literal format '1 2' for INTERVAL SECOND.*");
+ f.wholeExpr("INTERVAL '1:2' SECOND")
+ .fails("Illegal interval literal format '1:2' for INTERVAL SECOND.*");
+ f.wholeExpr("INTERVAL '1-2' SECOND(2)")
+ .fails("Illegal interval literal format '1-2' for INTERVAL SECOND\\(2\\)");
+ f.wholeExpr("INTERVAL 'bogus text' SECOND")
+ .fails("Illegal interval literal format 'bogus text' for INTERVAL SECOND.*");
+
+ // negative field values
+ f.wholeExpr("INTERVAL '--1' SECOND")
+ .fails("Illegal interval literal format '--1' for INTERVAL SECOND.*");
+ f.wholeExpr("INTERVAL '1.-1' SECOND")
+ .fails("Illegal interval literal format '1.-1' for INTERVAL SECOND.*");
+
+ // Field value out of range
+ // (default, explicit default, alt, neg alt, max, neg max)
+ f.wholeExpr("INTERVAL '100' SECOND")
+ .fails("Interval field value 100 exceeds precision of SECOND\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '100' SECOND(2)")
+ .fails("Interval field value 100 exceeds precision of SECOND\\(2\\) field.*");
+ f.wholeExpr("INTERVAL '1000' SECOND(3)")
+ .fails("Interval field value 1,000 exceeds precision of SECOND\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '-1000' SECOND(3)")
+ .fails("Interval field value -1,000 exceeds precision of SECOND\\(3\\) field.*");
+ f.wholeExpr("INTERVAL '2147483648' SECOND(10)")
+ .fails("Interval field value 2,147,483,648 exceeds precision of SECOND\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '-2147483648' SECOND(10)")
+ .fails("Interval field value -2,147,483,648 exceeds precision of SECOND\\(10\\) field.*");
+ f.wholeExpr("INTERVAL '1.0000001' SECOND")
+ .fails("Illegal interval literal format '1\\.0000001' for INTERVAL SECOND.*");
+ f.wholeExpr("INTERVAL '1.0000001' SECOND(2)")
+ .fails("Illegal interval literal format '1\\.0000001' for INTERVAL SECOND\\(2\\).*");
+ f.wholeExpr("INTERVAL '1.0001' SECOND(2, 3)")
+ .fails("Illegal interval literal format '1\\.0001' for INTERVAL SECOND\\(2, 3\\).*");
+ f.wholeExpr("INTERVAL '1.0000000001' SECOND(2, 9)")
+ .fails("Illegal interval literal format '1\\.0000000001' for"
+ + " INTERVAL SECOND\\(2, 9\\).*");
+
+ // precision > maximum
+ f.expr("INTERVAL '1' ^SECOND(11)^")
+ .fails("Interval leading field precision '11' out of range for"
+ + " INTERVAL SECOND\\(11\\)");
+ f.expr("INTERVAL '1.1' ^SECOND(1, 10)^")
+ .fails("Interval fractional second precision '10' out of range for"
+ + " INTERVAL SECOND\\(1, 10\\)");
+
+ // precision < minimum allowed)
+ // note: parser will catch negative values, here we
+ // just need to check for 0
+ f.expr("INTERVAL '0' ^SECOND(0)^")
+ .fails("Interval leading field precision '0' out of range for"
+ + " INTERVAL SECOND\\(0\\)");
+ f.expr("INTERVAL '0' ^SECOND(1, 0)^")
+ .fails("Interval fractional second precision '0' out of range for"
+ + " INTERVAL SECOND\\(1, 0\\)");
+ }
+
+ public void subTestMisc() {
+ // Miscellaneous
+ // fractional value is not OK, even if it is 0
+ f.wholeExpr("INTERVAL '1.0' HOUR")
+ .fails("Illegal interval literal format '1.0' for INTERVAL HOUR");
+ // only seconds are allowed to have a fractional part
+ f.expr("INTERVAL '1.0' SECOND")
+ .columnType("INTERVAL SECOND NOT NULL");
+ // leading zeros do not cause precision to be exceeded
+ f.expr("INTERVAL '0999' MONTH(3)")
+ .columnType("INTERVAL MONTH(3) NOT NULL");
+ }
+
+ /** Fluent interface for binding an expression to create a fixture that can
+ * be used to validate, check AST, or check type. */
+ public interface Fixture {
+ Fixture2 expr(String s);
+ Fixture2 wholeExpr(String s);
+ }
+
+ /** Fluent interface to validate an expression. */
+ public interface Fixture2 {
+ /** Checks that the expression is valid in the parser
+ * but invalid (with the given error message) in the validator. */
+ void fails(String expected);
+
+ /** Checks that the expression is valid in the parser and validator
+ * and has the given column type. */
+ void columnType(String expectedType);
+
+ /** Checks that the expression parses successfully and produces the given
+ * SQL when unparsed. */
+ Fixture2 assertParse(String expectedAst);
+ }
+}