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

["Ingo Bürk (Jira)" <ji...@apache.org>]

Ingo Bürk created CALCITE-4717:
----------------------------------

             Summary: Lax mode for JSON paths doesn't automatically unnest arrays
                 Key: CALCITE-4717
                 URL: https://issues.apache.org/jira/browse/CALCITE-4717
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.27.0
            Reporter: Ingo Bürk


Given the following test in CalciteSqlOperatorTest:
{code:java}
@Test
public void test() {
  tester.checkBoolean("json_exists('{\"a\": [{\"b\": 1}, {\"b\": 2}]}', 'lax $.a.b')", Boolean.TRUE);
}
{code}
Yields:
{code:java}
expected: <[true]> but was: <[false]>{code}
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.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)