[CALCITE-2365] Upgrade Calcite to Avatica 1.12

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.17.0
• Assignee: Julian Hyde
• Reporter: Sergey Nuyanzin
• Created: 15/Jun/18 20:23
• Updated: 20/Jul/18 08:18
• Resolved: 29/Jun/18 18:49

Description

I guess the main reason is CALCITE-2219.
tried to fix it here https://github.com/apache/calcite/compare/master...snuyanzin:CALCITE_AVATICA_12_UPDATE
however there are at least 2 issues which are not fixed but only workarounded

1. org.apache.calcite.test.LatticeTest#testGroupByEmpty3 connection pool factory is used however 3 methods (explainContains, and 2 returnsUnordered ) lead to org.apache.calcite.test.CalciteAssert#assertQuery which closes connections without paying attention if its from pool or not
2. the same test. mats updated in explainplan and execute => that is why finally size is 6.
3. test from core/src/test/resources/sql/misc.iq starts failing as the result of CALCITE-1884

it would be nice to have some advice at least relating to first 2 bullets to fix it in a better way

Issue Links

• is related to: CALCITE-2303 In EXTRACT function, support MICROSECONDS, MILLISECONDS, EPOCH, ISODOW, ISOYEAR and DECADE time units
• is related to: CALCITE-2330 Release Avatica 1.12