Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-25230

JSON_TABLE: CREATE VIEW with 2nd level NESTED PATH ends up with invalid frm, Assertion `m_status == DA_ERROR || m_status == DA_OK || m_status == DA_OK_BULK' failed

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • N/A
    • 10.6.0
    • JSON, Views
    • None

    Description

      CREATE VIEW v AS SELECT * FROM JSON_TABLE('{}', '$' COLUMNS(NESTED PATH '$' COLUMNS(NESTED PATH '$.*' COLUMNS(o FOR ORDINALITY)))) AS jt;
      SELECT * FROM v;
      

      bb-10.6-mdev17399-hf 49603a0191

      'SELECT * FROM v' failed: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) `jt`' at line 1
      

      frm

      TYPE=VIEW
      query=select `jt`.`o` AS `o` from JSON_TABLE(\'{}\', \'$\' COLUMNS ()) `jt`
      md5=f253a6b293f2eaad473af1906b3c1f1a
      updatable=1
      algorithm=0
      definer_user=root
      definer_host=localhost
      suid=2
      with_check_option=0
      timestamp=2021-03-23 15:15:37
      create-version=2
      source=SELECT * FROM JSON_TABLE(\'{}\', \'$\' COLUMNS(NESTED PATH \'$\' COLUMNS(NESTED PATH \'$.*\' COLUMNS(o FOR ORDINALITY)))) AS jt
      client_cs_name=latin1
      connection_cl_name=latin1_swedish_ci
      view_body_utf8=select `jt`.`o` AS `o` from JSON_TABLE(\'{}\', \'$\' COLUMNS ()) `jt`
      mariadb-version=100600
      

      Attachments

        Issue Links

          Activity

            People

              holyfoot Alexey Botchkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.