[CALCITE-2427] Sub-queries not supported in DML statements

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.14.0, 1.15.0, 1.16.0
• Fix Version/s: 1.20.0
• Component/s: core
• Labels: pull-request-available sub-query
• Assignee: Unassigned
• Reporter: Pressenna
• Created: 24/Jul/18 08:24
• Updated: 05/Aug/19 08:42
• Resolved: 15/Apr/19 06:17

Description

It appears that subqueries are not supported in DML statements.
The yield in a NPE.

Respective testcase is disabled with reference to CALCITE-1527.

@Ignore("CALCITE-1527")
@Test public void testUpdateSubQuery() {
final String sql = "update emp\n"
+ "set empno = (\n"
+ " select min(empno) from emp as e where e.deptno = emp.deptno)";
sql(sql).ok();
}

 

 

Issue Links

• causes: CALCITE-3186 IN expressions in UPDATE statements throws Exceptions
• is related to: CALCITE-1527 Support DML in the JDBC adapter
• links to: GitHub Pull Request #1151