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

CONNECT JSON table type only returns 10 rows

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.0.16
    • N/A
    • Documentation
    • None

    Description

      { "items": [
      { "id": 0, "value": "a" },
      { "id": 1, "value": "b" },
      { "id": 2, "value": "c" },
      { "id": 3, "value": "d" },
      { "id": 5, "value": "e" },
      { "id": 6, "value": "f" },
      { "id": 7, "value": "g" },
      { "id": 8, "value": "h" },
      { "id": 9, "value": "i" },
      { "id": 10, "value": "j" },
      { "id": 11, "value": "k" },
      { "id": 12, "value": "l" },
      { "id": 13, "value": "m" }
      ] }

      mariadb 10.0.16-MariaDB-log (root) [test]> create table json ( id int field_format='items:[x]:id', value char(1) field_format='items:[x]:value' ) engine=connect, table_type=json, file_name='test.json';
      Query OK, 0 rows affected (0.01 sec)
       
      mariadb 10.0.16-MariaDB-log (root) [test]> select * from json;
      +------+-------+
      | id   | value |
      +------+-------+
      |    0 | a     |
      |    1 | b     |
      |    2 | c     |
      |    3 | d     |
      |    5 | e     |
      |    6 | f     |
      |    7 | g     |
      |    8 | h     |
      |    9 | i     |
      |   10 | j     |
      +------+-------+
      10 rows in set (0.00 sec)

      Attachments

        Activity

          People

            bertrandop Olivier Bertrand
            kolbe Kolbe Kegel (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.