0.2sec org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest > testNestedSchemaNestedColumns() java.lang.AssertionError: Expected: is "SELECT \"a\", \"e\", \"n1\".\"n11\".\"b\", \"n2\".\"d\"\nFROM \"myDb\".\"myTable\"" but: was "SELECT \"a\", \"e\", \"n1\".\"n11\".\"b\", \"n2\".\"d\"\r\nFROM \"myDb\".\"myTable\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest.testNestedSchemaNestedColumns(RelToSqlConverterStructsTest.java:87)

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest > testNestedSchemaSelectStar() java.lang.AssertionError: Expected: is "SELECT \"a\", ROW(ROW(\"n1\".\"n11\".\"b\"), ROW(\"n1\".\"n12\".\"c\")) AS \"n1\", ROW(\"n2\".\"d\") AS \"n2\", \"xs\", \"e\"\nFROM \"myDb\".\"myTable\"" but: was "SELECT \"a\", ROW(ROW(\"n1\".\"n11\".\"b\"), ROW(\"n1\".\"n12\".\"c\")) AS \"n1\", ROW(\"n2\".\"d\") AS \"n2\", \"xs\", \"e\"\r\nFROM \"myDb\".\"myTable\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest.testNestedSchemaSelectStar(RelToSqlConverterStructsTest.java:66)

0.1sec org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest > testNestedSchemaRootColumns() java.lang.AssertionError: Expected: is "SELECT \"a\", \"e\"\nFROM \"myDb\".\"myTable\"" but: was "SELECT \"a\", \"e\"\r\nFROM \"myDb\".\"myTable\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest.testNestedSchemaRootColumns(RelToSqlConverterStructsTest.java:74)

4.6sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testLateralCorrelate() java.lang.AssertionError: Expected: is "SELECT *\nFROM \"foodmart\".\"product\" AS \"$cor0\",\nLATERAL (SELECT *\nFROM TABLE(RAMP(\"$cor0\".\"product_id\"))) AS \"t\"" but: was "SELECT *\r\nFROM \"foodmart\".\"product\" AS \"$cor0\",\r\nLATERAL (SELECT *\r\nFROM TABLE(RAMP(\"$cor0\".\"product_id\"))) AS \"t\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testLateralCorrelate(RelToSqlConverterTest.java:7476)

0.3sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testCommaCrossJoin() java.lang.AssertionError: Expected: is "SELECT \"t\".\"nation_name\", \"t\".\"cnt1\" - \"t0\".\"cnt2\" AS \"f1\"\nFROM (SELECT \"nation_name\", COUNT(*) AS \"cnt1\"\nFROM \"tpch\".\"customer\"\nGROUP BY \"nation_name\") AS \"t\"\nCROSS JOIN (SELECT COUNT(*) AS \"cnt2\"\nFROM \"tpch\".\"lineitem\") AS \"t0\"\nLEFT JOIN \"tpch\".\"part\" ON \"t\".\"nation_name\" = \"part\".\"p_brand\"" but: was "SELECT \"t\".\"nation_name\", \"t\".\"cnt1\" - \"t0\".\"cnt2\" AS \"f1\"\r\nFROM (SELECT \"nation_name\", COUNT(*) AS \"cnt1\"\r\nFROM \"tpch\".\"customer\"\r\nGROUP BY \"nation_name\") AS \"t\"\r\nCROSS JOIN (SELECT COUNT(*) AS \"cnt2\"\r\nFROM \"tpch\".\"lineitem\") AS \"t0\"\r\nLEFT JOIN \"tpch\".\"part\" ON \"t\".\"nation_name\" = \"part\".\"p_brand\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testCommaCrossJoin(RelToSqlConverterTest.java:7757)

0.1sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testBigQueryParseDatetimeFunctions() java.lang.AssertionError: Expected: is "SELECT PARSE_TIME('%I:%M:%S', '07:30:00')\nFROM \"foodmart\".\"product\"" but: was "SELECT PARSE_TIME('%I:%M:%S', '07:30:00')\r\nFROM \"foodmart\".\"product\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testBigQueryParseDatetimeFunctions(RelToSqlConverterTest.java:2616)

0.2sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testHiveSubstringWithLength() java.lang.AssertionError: Expected: is "SELECT SUBSTRING('ABC', 2, 3)\nFROM `foodmart`.`reserve_employee`" but: was "SELECT SUBSTRING('ABC', 2, 3)\r\nFROM `foodmart`.`reserve_employee`" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testHiveSubstringWithLength(RelToSqlConverterTest.java:3450)

0.3sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testOrderByExpressionNotInTheProjectionThatRefersToUnderlyingFieldWithSameAlias() java.lang.AssertionError: Expected: is "SELECT \"EMPNO\"\nFROM (SELECT UPPER(\"ENAME\") AS \"EMPNO\", \"EMPNO\" + 1 AS \"$f1\"\nFROM \"scott\".\"EMP\"\nORDER BY 2) AS \"t0\"" but: was "SELECT \"EMPNO\"\r\nFROM (SELECT UPPER(\"ENAME\") AS \"EMPNO\", \"EMPNO\" + 1 AS \"$f1\"\r\nFROM \"scott\".\"EMP\"\r\nORDER BY 2) AS \"t0\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testOrderByExpressionNotInTheProjectionThatRefersToUnderlyingFieldWithSameAlias(RelToSqlConverterTest.java:1305)

0.2sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSum0BecomesCoalesce() java.lang.AssertionError: Expected: is "SELECT COALESCE(SUM(`MGR`), 0) AS `s`\nFROM `scott`.`EMP`" but: was "SELECT COALESCE(SUM(`MGR`), 0) AS `s`\r\nFROM `scott`.`EMP`" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testSum0BecomesCoalesce(RelToSqlConverterTest.java:1485)

0.4sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSelectQueryWithGroup() java.lang.AssertionError: Expected: is "SELECT COUNT(*), SUM(\"employee_id\")\nFROM \"foodmart\".\"reserve_employee\"\nWHERE \"hire_date\" > '2015-01-01' AND (\"position_title\" = 'SDE' OR \"position_title\" = 'SDM')\nGROUP BY \"store_id\", \"position_title\"" but: was "SELECT COUNT(*), SUM(\"employee_id\")\r\nFROM \"foodmart\".\"reserve_employee\"\r\nWHERE \"hire_date\" > '2015-01-01' AND (\"position_title\" = 'SDE' OR \"position_title\" = 'SDM')\r\nGROUP BY \"store_id\", \"position_title\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testSelectQueryWithGroup(RelToSqlConverterTest.java:4187)

0.2sec org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest > testNestedSchemaNestedColumns() java.lang.AssertionError: Expected: is "SELECT \"a\", \"e\", \"n1\".\"n11\".\"b\", \"n2\".\"d\"\nFROM \"myDb\".\"myTable\"" but: was "SELECT \"a\", \"e\", \"n1\".\"n11\".\"b\", \"n2\".\"d\"\r\nFROM \"myDb\".\"myTable\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest.testNestedSchemaNestedColumns(RelToSqlConverterStructsTest.java:87)

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest > testNestedSchemaSelectStar() java.lang.AssertionError: Expected: is "SELECT \"a\", ROW(ROW(\"n1\".\"n11\".\"b\"), ROW(\"n1\".\"n12\".\"c\")) AS \"n1\", ROW(\"n2\".\"d\") AS \"n2\", \"xs\", \"e\"\nFROM \"myDb\".\"myTable\"" but: was "SELECT \"a\", ROW(ROW(\"n1\".\"n11\".\"b\"), ROW(\"n1\".\"n12\".\"c\")) AS \"n1\", ROW(\"n2\".\"d\") AS \"n2\", \"xs\", \"e\"\r\nFROM \"myDb\".\"myTable\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest.testNestedSchemaSelectStar(RelToSqlConverterStructsTest.java:66)

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest > testNestedSchemaRootColumns() java.lang.AssertionError: Expected: is "SELECT \"a\", \"e\"\nFROM \"myDb\".\"myTable\"" but: was "SELECT \"a\", \"e\"\r\nFROM \"myDb\".\"myTable\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest.testNestedSchemaRootColumns(RelToSqlConverterStructsTest.java:74)

0.1sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testLateralCorrelate() java.lang.AssertionError: Expected: is "SELECT *\nFROM \"foodmart\".\"product\" AS \"$cor0\",\nLATERAL (SELECT *\nFROM TABLE(RAMP(\"$cor0\".\"product_id\"))) AS \"t\"" but: was "SELECT *\r\nFROM \"foodmart\".\"product\" AS \"$cor0\",\r\nLATERAL (SELECT *\r\nFROM TABLE(RAMP(\"$cor0\".\"product_id\"))) AS \"t\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testLateralCorrelate(RelToSqlConverterTest.java:7476)

0.2sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testHavingAliasSameAsColumnIgnoringCase() java.lang.AssertionError: Expected: is "SELECT product_id + 1, GROSS_WEIGHT\nFROM (SELECT product_id, SUM(gross_weight) AS GROSS_WEIGHT\nFROM foodmart.product\nGROUP BY product_id\nHAVING GROSS_WEIGHT < 2.000E2) AS t1" but: was "SELECT product_id + 1, GROSS_WEIGHT\r\nFROM (SELECT product_id, SUM(gross_weight) AS GROSS_WEIGHT\r\nFROM foodmart.product\r\nGROUP BY product_id\r\nHAVING GROSS_WEIGHT < 2.000E2) AS t1" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.checkHavingAliasSameAsColumn(RelToSqlConverterTest.java:2305) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testHavingAliasSameAsColumnIgnoringCase(RelToSqlConverterTest.java:2261)

0.3sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testCommaCrossJoin() java.lang.AssertionError: Expected: is "SELECT \"t\".\"nation_name\", \"t\".\"cnt1\" - \"t0\".\"cnt2\" AS \"f1\"\nFROM (SELECT \"nation_name\", COUNT(*) AS \"cnt1\"\nFROM \"tpch\".\"customer\"\nGROUP BY \"nation_name\") AS \"t\"\nCROSS JOIN (SELECT COUNT(*) AS \"cnt2\"\nFROM \"tpch\".\"lineitem\") AS \"t0\"\nLEFT JOIN \"tpch\".\"part\" ON \"t\".\"nation_name\" = \"part\".\"p_brand\"" but: was "SELECT \"t\".\"nation_name\", \"t\".\"cnt1\" - \"t0\".\"cnt2\" AS \"f1\"\r\nFROM (SELECT \"nation_name\", COUNT(*) AS \"cnt1\"\r\nFROM \"tpch\".\"customer\"\r\nGROUP BY \"nation_name\") AS \"t\"\r\nCROSS JOIN (SELECT COUNT(*) AS \"cnt2\"\r\nFROM \"tpch\".\"lineitem\") AS \"t0\"\r\nLEFT JOIN \"tpch\".\"part\" ON \"t\".\"nation_name\" = \"part\".\"p_brand\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testCommaCrossJoin(RelToSqlConverterTest.java:7757)

0.1sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testBigQueryParseDatetimeFunctions() java.lang.AssertionError: Expected: is "SELECT PARSE_TIME('%I:%M:%S', '07:30:00')\nFROM \"foodmart\".\"product\"" but: was "SELECT PARSE_TIME('%I:%M:%S', '07:30:00')\r\nFROM \"foodmart\".\"product\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testBigQueryParseDatetimeFunctions(RelToSqlConverterTest.java:2616)

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testHiveSubstringWithLength() java.lang.AssertionError: Expected: is "SELECT SUBSTRING('ABC', 2, 3)\nFROM `foodmart`.`reserve_employee`" but: was "SELECT SUBSTRING('ABC', 2, 3)\r\nFROM `foodmart`.`reserve_employee`" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testHiveSubstringWithLength(RelToSqlConverterTest.java:3450)

0.5sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSimpleJoin() java.lang.AssertionError: Expected: is "SELECT \"sales_fact_1997\".\"product_id\" AS \"product_id\", \"sales_fact_1997\".\"time_id\" AS \"time_id\", \"sales_fact_1997\".\"customer_id\" AS \"customer_id\", \"sales_fact_1997\".\"promotion_id\" AS \"promotion_id\", \"sales_fact_1997\".\"store_id\" AS \"store_id\", \"sales_fact_1997\".\"store_sales\" AS \"store_sales\", \"sales_fact_1997\".\"store_cost\" AS \"store_cost\", \"sales_fact_1997\".\"unit_sales\" AS \"unit_sales\", \"customer\".\"customer_id\" AS \"customer_id0\", \"customer\".\"account_num\" AS \"account_num\", \"customer\".\"lname\" AS \"lname\", \"customer\".\"fname\" AS \"fname\", \"customer\".\"mi\" AS \"mi\", \"customer\".\"address1\" AS \"address1\", \"customer\".\"address2\" AS \"address2\", \"customer\".\"address3\" AS \"address3\", \"customer\".\"address4\" AS \"address4\", \"customer\".\"city\" AS \"city\", \"customer\".\"state_province\" AS \"state_province\", \"customer\".\"postal_code\" AS \"postal_code\", \"customer\".\"country\" AS \"country\", \"customer\".\"customer_region_id\" AS \"customer_region_id\", \"customer\".\"phone1\" AS \"phone1\", \"customer\".\"phone2\" AS \"phone2\", \"customer\".\"birthdate\" AS \"birthdate\", \"customer\".\"marital_status\" AS \"marital_status\", \"customer\".\"yearly_income\" AS \"yearly_income\", \"customer\".\"gender\" AS \"gender\", \"customer\".\"total_children\" AS \"total_children\", \"customer\".\"num_children_at_home\" AS \"num_children_at_home\", \"customer\".\"education\" AS \"education\", \"customer\".\"date_accnt_opened\" AS \"date_accnt_opened\", \"customer\".\"member_card\" AS \"member_card\", \"customer\".\"occupation\" AS \"occupation\", \"customer\".\"houseowner\" AS \"houseowner\", \"customer\".\"num_cars_owned\" AS \"num_cars_owned\", \"customer\".\"fullname\" AS \"fullname\", \"product\".\"product_class_id\" AS \"product_class_id\", \"product\".\"product_id\" AS \"product_id0\", \"product\".\"brand_name\" AS \"brand_name\", \"product\".\"product_name\" AS \"product_name\", \"product\".\"SKU\" AS \"SKU\", \"product\".\"SRP\" AS \"SRP\", \"product\".\"gross_weight\" AS \"gross_weight\", \"product\".\"net_weight\" AS \"net_weight\", \"product\".\"recyclable_package\" AS \"recyclable_package\", \"product\".\"low_fat\" AS \"low_fat\", \"product\".\"units_per_case\" AS \"units_per_case\", \"product\".\"cases_per_pallet\" AS \"cases_per_pallet\", \"product\".\"shelf_width\" AS \"shelf_width\", \"product\".\"shelf_height\" AS \"shelf_height\", \"product\".\"shelf_depth\" AS \"shelf_depth\", \"product_class\".\"product_class_id\" AS \"product_class_id0\", \"product_class\".\"product_subcategory\" AS \"product_subcategory\", \"product_class\".\"product_category\" AS \"product_category\", \"product_class\".\"product_department\" AS \"product_department\", \"product_class\".\"product_family\" AS \"product_family\"\nFROM \"foodmart\".\"sales_fact_1997\"\nINNER JOIN \"foodmart\".\"customer\" ON \"sales_fact_1997\".\"customer_id\" = \"customer\".\"customer_id\"\nINNER JOIN \"foodmart\".\"product\" ON \"sales_fact_1997\".\"product_id\" = \"product\".\"product_id\"\nINNER JOIN \"foodmart\".\"product_class\" ON \"product\".\"product_class_id\" = \"product_class\".\"product_class_id\"\nWHERE \"customer\".\"city\" = 'San Francisco' AND \"product_class\".\"product_department\" = 'Snacks'" but: was "SELECT \"sales_fact_1997\".\"product_id\" AS \"product_id\", \"sales_fact_1997\".\"time_id\" AS \"time_id\", \"sales_fact_1997\".\"customer_id\" AS \"customer_id\", \"sales_fact_1997\".\"promotion_id\" AS \"promotion_id\", \"sales_fact_1997\".\"store_id\" AS \"store_id\", \"sales_fact_1997\".\"store_sales\" AS \"store_sales\", \"sales_fact_1997\".\"store_cost\" AS \"store_cost\", \"sales_fact_1997\".\"unit_sales\" AS \"unit_sales\", \"customer\".\"customer_id\" AS \"customer_id0\", \"customer\".\"account_num\" AS \"account_num\", \"customer\".\"lname\" AS \"lname\", \"customer\".\"fname\" AS \"fname\", \"customer\".\"mi\" AS \"mi\",

0.1sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testOrderByExpressionNotInTheProjectionThatRefersToUnderlyingFieldWithSameAlias() java.lang.AssertionError: Expected: is "SELECT \"EMPNO\"\nFROM (SELECT UPPER(\"ENAME\") AS \"EMPNO\", \"EMPNO\" + 1 AS \"$f1\"\nFROM \"scott\".\"EMP\"\nORDER BY 2) AS \"t0\"" but: was "SELECT \"EMPNO\"\r\nFROM (SELECT UPPER(\"ENAME\") AS \"EMPNO\", \"EMPNO\" + 1 AS \"$f1\"\r\nFROM \"scott\".\"EMP\"\r\nORDER BY 2) AS \"t0\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testOrderByExpressionNotInTheProjectionThatRefersToUnderlyingFieldWithSameAlias(RelToSqlConverterTest.java:1305)

0.4sec org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest > testNestedSchemaNestedColumns() java.lang.AssertionError: Expected: is "SELECT \"a\", \"e\", \"n1\".\"n11\".\"b\", \"n2\".\"d\"\nFROM \"myDb\".\"myTable\"" but: was "SELECT \"a\", \"e\", \"n1\".\"n11\".\"b\", \"n2\".\"d\"\r\nFROM \"myDb\".\"myTable\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest.testNestedSchemaNestedColumns(RelToSqlConverterStructsTest.java:87)

0.1sec org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest > testNestedSchemaSelectStar() java.lang.AssertionError: Expected: is "SELECT \"a\", ROW(ROW(\"n1\".\"n11\".\"b\"), ROW(\"n1\".\"n12\".\"c\")) AS \"n1\", ROW(\"n2\".\"d\") AS \"n2\", \"xs\", \"e\"\nFROM \"myDb\".\"myTable\"" but: was "SELECT \"a\", ROW(ROW(\"n1\".\"n11\".\"b\"), ROW(\"n1\".\"n12\".\"c\")) AS \"n1\", ROW(\"n2\".\"d\") AS \"n2\", \"xs\", \"e\"\r\nFROM \"myDb\".\"myTable\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest.testNestedSchemaSelectStar(RelToSqlConverterStructsTest.java:66)

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest > testNestedSchemaRootColumns() java.lang.AssertionError: Expected: is "SELECT \"a\", \"e\"\nFROM \"myDb\".\"myTable\"" but: was "SELECT \"a\", \"e\"\r\nFROM \"myDb\".\"myTable\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest.testNestedSchemaRootColumns(RelToSqlConverterStructsTest.java:74)

5.3sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testLateralCorrelate() java.lang.AssertionError: Expected: is "SELECT *\nFROM \"foodmart\".\"product\" AS \"$cor0\",\nLATERAL (SELECT *\nFROM TABLE(RAMP(\"$cor0\".\"product_id\"))) AS \"t\"" but: was "SELECT *\r\nFROM \"foodmart\".\"product\" AS \"$cor0\",\r\nLATERAL (SELECT *\r\nFROM TABLE(RAMP(\"$cor0\".\"product_id\"))) AS \"t\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testLateralCorrelate(RelToSqlConverterTest.java:7476)

0.5sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testCommaCrossJoin() java.lang.AssertionError: Expected: is "SELECT \"t\".\"nation_name\", \"t\".\"cnt1\" - \"t0\".\"cnt2\" AS \"f1\"\nFROM (SELECT \"nation_name\", COUNT(*) AS \"cnt1\"\nFROM \"tpch\".\"customer\"\nGROUP BY \"nation_name\") AS \"t\"\nCROSS JOIN (SELECT COUNT(*) AS \"cnt2\"\nFROM \"tpch\".\"lineitem\") AS \"t0\"\nLEFT JOIN \"tpch\".\"part\" ON \"t\".\"nation_name\" = \"part\".\"p_brand\"" but: was "SELECT \"t\".\"nation_name\", \"t\".\"cnt1\" - \"t0\".\"cnt2\" AS \"f1\"\r\nFROM (SELECT \"nation_name\", COUNT(*) AS \"cnt1\"\r\nFROM \"tpch\".\"customer\"\r\nGROUP BY \"nation_name\") AS \"t\"\r\nCROSS JOIN (SELECT COUNT(*) AS \"cnt2\"\r\nFROM \"tpch\".\"lineitem\") AS \"t0\"\r\nLEFT JOIN \"tpch\".\"part\" ON \"t\".\"nation_name\" = \"part\".\"p_brand\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testCommaCrossJoin(RelToSqlConverterTest.java:7757)

0.1sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testBigQueryParseDatetimeFunctions() java.lang.AssertionError: Expected: is "SELECT PARSE_TIME('%I:%M:%S', '07:30:00')\nFROM \"foodmart\".\"product\"" but: was "SELECT PARSE_TIME('%I:%M:%S', '07:30:00')\r\nFROM \"foodmart\".\"product\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testBigQueryParseDatetimeFunctions(RelToSqlConverterTest.java:2616)

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testHiveSubstringWithLength() java.lang.AssertionError: Expected: is "SELECT SUBSTRING('ABC', 2, 3)\nFROM `foodmart`.`reserve_employee`" but: was "SELECT SUBSTRING('ABC', 2, 3)\r\nFROM `foodmart`.`reserve_employee`" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testHiveSubstringWithLength(RelToSqlConverterTest.java:3450)

1.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testOrderByExpressionNotInTheProjectionThatRefersToUnderlyingFieldWithSameAlias() java.lang.AssertionError: Expected: is "SELECT \"EMPNO\"\nFROM (SELECT UPPER(\"ENAME\") AS \"EMPNO\", \"EMPNO\" + 1 AS \"$f1\"\nFROM \"scott\".\"EMP\"\nORDER BY 2) AS \"t0\"" but: was "SELECT \"EMPNO\"\r\nFROM (SELECT UPPER(\"ENAME\") AS \"EMPNO\", \"EMPNO\" + 1 AS \"$f1\"\r\nFROM \"scott\".\"EMP\"\r\nORDER BY 2) AS \"t0\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testOrderByExpressionNotInTheProjectionThatRefersToUnderlyingFieldWithSameAlias(RelToSqlConverterTest.java:1305)

0.1sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSum0BecomesCoalesce() java.lang.AssertionError: Expected: is "SELECT COALESCE(SUM(`MGR`), 0) AS `s`\nFROM `scott`.`EMP`" but: was "SELECT COALESCE(SUM(`MGR`), 0) AS `s`\r\nFROM `scott`.`EMP`" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testSum0BecomesCoalesce(RelToSqlConverterTest.java:1485)

0.7sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSelectQueryWithGroup() java.lang.AssertionError: Expected: is "SELECT COUNT(*), SUM(\"employee_id\")\nFROM \"foodmart\".\"reserve_employee\"\nWHERE \"hire_date\" > '2015-01-01' AND (\"position_title\" = 'SDE' OR \"position_title\" = 'SDM')\nGROUP BY \"store_id\", \"position_title\"" but: was "SELECT COUNT(*), SUM(\"employee_id\")\r\nFROM \"foodmart\".\"reserve_employee\"\r\nWHERE \"hire_date\" > '2015-01-01' AND (\"position_title\" = 'SDE' OR \"position_title\" = 'SDM')\r\nGROUP BY \"store_id\", \"position_title\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testSelectQueryWithGroup(RelToSqlConverterTest.java:4187)

Execution failed for task ':core:compileJava': org.gradle.api.internal.tasks.compile.CompilationFailedException: Compilation failed; see the compiler error output for details. at org.gradle.api.internal.tasks.compile.JdkJavaCompiler.execute(JdkJavaCompiler.java:61) at org.gradle.api.internal.tasks.compile.JdkJavaCompiler.execute(JdkJavaCompiler.java:41) at org.gradle.api.internal.tasks.compile.daemon.AbstractIsolatedCompilerWorkerExecutor$CompilerWorkAction.execute(AbstractIsolatedCompilerWorkerExecutor.java:78) at org.gradle.workers.internal.DefaultWorkerServer.execute(DefaultWorkerServer.java:63) at org.gradle.workers.internal.AbstractClassLoaderWorker$1.create(AbstractClassLoaderWorker.java:54) at org.gradle.workers.internal.AbstractClassLoaderWorker$1.create(AbstractClassLoaderWorker.java:48) at org.gradle.internal.classloader.ClassLoaderUtils.executeInClassloader(ClassLoaderUtils.java:100) at org.gradle.workers.internal.AbstractClassLoaderWorker.executeInClassLoader(AbstractClassLoaderWorker.java:48) at org.gradle.workers.internal.FlatClassLoaderWorker.run(FlatClassLoaderWorker.java:32) at org.gradle.workers.internal.FlatClassLoaderWorker.run(FlatClassLoaderWorker.java:22) at org.gradle.workers.internal.WorkerDaemonServer.run(WorkerDaemonServer.java:102) at org.gradle.workers.internal.WorkerDaemonServer.run(WorkerDaemonServer.java:71) at org.gradle.process.internal.worker.request.WorkerAction$1.call(WorkerAction.java:146) at org.gradle.process.internal.worker.child.WorkerLogEventListener.withWorkerLoggingProtocol(WorkerLogEventListener.java:41) at org.gradle.process.internal.worker.request.WorkerAction.lambda$run$0(WorkerAction.java:143) at org.gradle.internal.operations.CurrentBuildOperationRef.with(CurrentBuildOperationRef.java:80) at org.gradle.process.internal.worker.request.WorkerAction.run(WorkerAction.java:135) at org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:36) at org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:24) at org.gradle.internal.remote.internal.hub.MessageHubBackedObjectConnection$DispatchWrapper.dispatch(MessageHubBackedObjectConnection.java:182) at org.gradle.internal.remote.internal.hub.MessageHubBackedObjectConnection$DispatchWrapper.dispatch(MessageHubBackedObjectConnection.java:164) at org.gradle.internal.remote.internal.hub.MessageHub$Handler.run(MessageHub.java:414) at org.gradle.internal.concurrent.ExecutorPolicy$CatchAndRecordFailures.onExecute(ExecutorPolicy.java:64) at org.gradle.internal.concurrent.AbstractManagedExecutor$1.run(AbstractManagedExecutor.java:47) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829)

Execution failed for task ':core:compileJava'. > Compilation failed; see the compiler error output for details.

[Task :core:compileJava] [method.invocation.invalid] call to setSchema(java.lang.String) not allowed on the given receiver. setSchema(schema); ^ found : @UnderInitialization(org.apache.calcite.jdbc.CalciteConnectionImpl.class) @nonnull AvaticaConnection

Execution failed for task ':core:compileJava': org.gradle.api.internal.tasks.compile.CompilationFailedException: Compilation failed; see the compiler error output for details. at org.gradle.api.internal.tasks.compile.JdkJavaCompiler.execute(JdkJavaCompiler.java:61) at org.gradle.api.internal.tasks.compile.JdkJavaCompiler.execute(JdkJavaCompiler.java:41) at org.gradle.api.internal.tasks.compile.daemon.AbstractIsolatedCompilerWorkerExecutor$CompilerWorkAction.execute(AbstractIsolatedCompilerWorkerExecutor.java:78) at org.gradle.workers.internal.DefaultWorkerServer.execute(DefaultWorkerServer.java:63) at org.gradle.workers.internal.AbstractClassLoaderWorker$1.create(AbstractClassLoaderWorker.java:54) at org.gradle.workers.internal.AbstractClassLoaderWorker$1.create(AbstractClassLoaderWorker.java:48) at org.gradle.internal.classloader.ClassLoaderUtils.executeInClassloader(ClassLoaderUtils.java:100) at org.gradle.workers.internal.AbstractClassLoaderWorker.executeInClassLoader(AbstractClassLoaderWorker.java:48) at org.gradle.workers.internal.FlatClassLoaderWorker.run(FlatClassLoaderWorker.java:32) at org.gradle.workers.internal.FlatClassLoaderWorker.run(FlatClassLoaderWorker.java:22) at org.gradle.workers.internal.WorkerDaemonServer.run(WorkerDaemonServer.java:102) at org.gradle.workers.internal.WorkerDaemonServer.run(WorkerDaemonServer.java:71) at org.gradle.process.internal.worker.request.WorkerAction$1.call(WorkerAction.java:146) at org.gradle.process.internal.worker.child.WorkerLogEventListener.withWorkerLoggingProtocol(WorkerLogEventListener.java:41) at org.gradle.process.internal.worker.request.WorkerAction.lambda$run$0(WorkerAction.java:143) at org.gradle.internal.operations.CurrentBuildOperationRef.with(CurrentBuildOperationRef.java:80) at org.gradle.process.internal.worker.request.WorkerAction.run(WorkerAction.java:135) at org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:36) at org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:24) at org.gradle.internal.remote.internal.hub.MessageHubBackedObjectConnection$DispatchWrapper.dispatch(MessageHubBackedObjectConnection.java:182) at org.gradle.internal.remote.internal.hub.MessageHubBackedObjectConnection$DispatchWrapper.dispatch(MessageHubBackedObjectConnection.java:164) at org.gradle.internal.remote.internal.hub.MessageHub$Handler.run(MessageHub.java:414) at org.gradle.internal.concurrent.ExecutorPolicy$CatchAndRecordFailures.onExecute(ExecutorPolicy.java:64) at org.gradle.internal.concurrent.AbstractManagedExecutor$1.run(AbstractManagedExecutor.java:47) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829)

Execution failed for task ':core:compileJava'. > Compilation failed; see the compiler error output for details.