[CALCITE-4717] Lax mode for JSON paths doesn't automatically unnest arrays

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.27.0
• Component/s: core
• Assignee: Unassigned
• Reporter: Ingo Bürk
• Created: 05/Aug/21 12:21
• Updated: 09/Aug/21 06:20

Description

Given the following test in CalciteSqlOperatorTest:

@Test
public void test() {
  tester.checkBoolean("json_exists('{\"a\": [{\"b\": 1}, {\"b\": 2}]}', 'lax $.a.b')", Boolean.TRUE);
}

Yields:

expected: <[true]> but was: <[false]>

However, according to the specification (ISO/IEC TR 19075-6 (a) 6.3, Table 28, First Row and (b) 5.3.1) this should pass, and be equivalent to strict $.a[*].b (which does indeed pass). This is because in lax mode arrays should be automatically unnested.

Issue Links

• breaks: FLINK-16200 Support JSON_EXISTS
• links to: JsonPath#746