Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-963

Cume_dist with Partition by returns error java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 348

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 3.0.3
    • Fix Version/s: 3.0.5
    • Component/s: Other
    • Labels:
      None

      Description

      The SQL below works with Mariadb driver 2.7.3. Using drivers 3.0.3 or 3.0.4, java.lang.ArrayIndexOutOfBoundsException occurs.

      SELECT
      `SNO`,
      `PNO`,
      CUME_DIST()
      OVER(
      PARTITION BY
      `SNO`,
      `PNO`
      ORDER BY
      CASE
      WHEN `QTY` IS NULL THEN 1
      ELSE 0
      END,
      `QTY` ASC
      )
      FROM
      `TSUPPLY`

      java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 348

      The issue seems to be with partition by because the SQL below(no partition by clause) does not fail

      SELECT
      `SNO`,
      `PNO`,
      CUME_DIST()
      OVER(
      ORDER BY
      CASE
      WHEN `QTY` IS NULL THEN 1
      ELSE 0
      END,
      `QTY` ASC
      )
      FROM
      `TSUPPLY`

      Info for table TSUPPLY

      CREATE TABLE IF NOT EXISTS `tsupply` (
      `RNUM` int(11) NOT NULL,
      `SNO` varchar(2) DEFAULT NULL,
      `PNO` varchar(2) DEFAULT NULL,
      `JNO` varchar(2) DEFAULT NULL,
      `QTY` int(11) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

      INSERT INTO `tsupply` (`RNUM`, `SNO`, `PNO`, `JNO`, `QTY`) VALUES
      (0, 'S1', 'P1', 'J1', 200),
      (1, 'S1', 'P1', 'J4', 700),
      (2, 'S2', 'P3', 'J1', 400),
      (3, 'S2', 'P3', 'J2', 200),
      (4, 'S2', 'P3', 'J3', 200),
      (5, 'S2', 'P3', 'J4', 500),
      (6, 'S2', 'P3', 'J5', 600),
      (7, 'S2', 'P3', 'J6', 400),
      (8, 'S2', 'P3', 'J7', 800),
      (9, 'S2', 'P5', 'J2', 100),
      (10, 'S3', 'P3', 'J1', 200),
      (11, 'S3', 'P4', 'J2', 500),
      (12, 'S4', 'P6', 'J3', 300),
      (13, 'S4', 'P6', 'J7', 300),
      (14, 'S5', 'P2', 'J2', 200),
      (15, 'S5', 'P2', 'J4', 100),
      (16, 'S5', 'P5', 'J5', 500),
      (17, 'S5', 'P5', 'J7', 100),
      (18, 'S5', 'P6', 'J2', 200),
      (19, 'S5', 'P1', 'J4', 100),
      (20, 'S5', 'P3', 'J4', 200),
      (21, 'S5', 'P4', 'J4', 800),
      (22, 'S5', 'P5', 'J4', 400),
      (23, 'S5', 'P6', 'J4', 500);

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              diego dupin Diego Dupin
              Reporter:
              Mike.Savoie@ca.ibm.com Mike Savoie
              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.