[
https://issues.apache.org/jira/browse/IGNITE-26065?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vladimir Steshin reassigned IGNITE-26065:
-----------------------------------------
Assignee: Vladimir Steshin
> Calcite. "field names not distinct" with '-ea' JVM option
> ---------------------------------------------------------
>
> Key: IGNITE-26065
> URL: https://issues.apache.org/jira/browse/IGNITE-26065
> Project: Ignite
> Issue Type: Bug
> Affects Versions: 2.17
> Reporter: Vladimir Steshin
> Assignee: Vladimir Steshin
> Priority: Major
> Labels: calcite, ignite-2, ise
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> Adoption of IGNITE-25896 .
>
> *Reproducer:*
> {code:java}
> @Test
> public void test0() {
> assumeTrue(sqlTxMode == SqlTransactionMode.NONE);
> String sql = "CREATE TABLE CITY(ID INT PRIMARY KEY, NAME VARCHAR(255));\n"
> + "CREATE TABLE STREET(ID INT PRIMARY KEY, CITY_ID INT, NAME
> VARCHAR(255));\n"
> + "INSERT INTO CITY(ID, NAME) VALUES(1, 'New York');\n"
> + "INSERT INTO STREET(ID, CITY_ID, NAME) VALUES(1, 1, 'Broadway');\n"
> + "INSERT INTO STREET(ID, CITY_ID, NAME) VALUES(2, 1, 'Wall
> Street');\n";
> sql(sql);
> sql("SELECT CITY_ID, NAME, NAME FROM STREET ORDER BY ID");
> sql("SELECT CITY.NAME, STREET.NAME FROM STREET JOIN CITY ON
> STREET.CITY_ID = CITY.ID ORDER BY STREET.ID");
> } {code}
> *Error:*
> {code:java}
> java.lang.AssertionError: field names not distinct: RecordType(INTEGER
> CITY_ID, VARCHAR NAME, VARCHAR NAME) at
> org.apache.calcite.util.Litmus.lambda$static$0(Litmus.java:31)
> ~[calcite-core-1.40.0.jar:1.40.0] at
> org.apache.calcite.rel.core.Project.isValid(Project.java:267)
> ~[calcite-core-1.40.0.jar:1.40.0] at
> org.apache.calcite.rel.core.Project.<init>(Project.java:106)
> ~[calcite-core-1.40.0.jar:1.40.0] at
> org.apache.calcite.rel.core.Project.<init>(Project.java:117)
> ~[calcite-core-1.40.0.jar:1.40.0] at
> org.apache.ignite.internal.processors.query.calcite.rel.IgniteProject.<init>(IgniteProject.java:74)
> ~[classes/:?] at
> org.apache.ignite.internal.processors.query.calcite.prepare.PlannerHelper.optimize(PlannerHelper.java:161)
> ~[classes/:?] at
> org.apache.ignite.internal.processors.query.calcite.prepare.PrepareServiceImpl.prepareQuery(PrepareServiceImpl.java:168)
> ~[classes/:?] at
> org.apache.ignite.internal.processors.query.calcite.prepare.PrepareServiceImpl.prepareSingle(PrepareServiceImpl.java:94)
> ~[classes/:?] {code}
> *Note:*
> When _-ea_ JVM option is set.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
