# db-derby-dev mailing list archives

##### Site index · List index
Message view
Top
From "A B (JIRA)" <j...@apache.org>
Subject [jira] Issue Comment Edited: (DERBY-3303) ArrayIndexOutOfBoundsException at MergeSort.compare
Date Thu, 14 Feb 2008 01:43:08 GMT
```
[ https://issues.apache.org/jira/browse/DERBY-3303?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12568780#action_12568780
]

army edited comment on DERBY-3303 at 2/13/08 5:42 PM:
-----------------------------------------------------

A simpler way to reproduce the problem on trunk:

create table t1 (i int, j int, k int);
insert into t1 values (1, 1, 2), (1, 3, 3), (2, 3, 1), (2, 2, 4);

-- Works.
select sum(k) as s from t1 group by i order by 1;

-- Works.
select sum(k) as s from t1 group by i order by s;

-- Fails (ArrayIndexOutOfBounds / ASSERT); should fail with ERROR 42X77...
select sum(k) as s from t1 group by i order by 2;

-- Fails (ArrayIndexOutOfBounds / ASSERT)
select sum(k) as s from t1 group by i order by abs(1);

-- Fails (ArrayIndexOutOfBounds / ASSERT)
select sum(k) as s from t1 group by i order by sum(k);

Confirmed that all of these run without error before DERBY-681 changes were committed.

was (Author: army):
A simpler way to reproduce the problem on trunk:

create table t1 (i int, j int, k int);
insert into t1 values (1, 1, 2), (1, 3, 3), (2, 3, 1), (2, 2, 4);

-- Works.
select sum(k) as s from t1 group by i order by 1;

-- Works.
select sum(k) as s from t1 group by i order by s;

-- Fails (ArrayIndexOutOfBounds / ASSERT); should fail with ERROR 42X77...
select sum(k) as s from t1 group by i order by 2;

-- Fails (ArrayIndexOutOfBounds / ASSERT)
select sum(k) as s from t1 group by i order by abs(1);

-- Fails (ArrayIndexOutOfBounds / ASSERT)
select sum(k) as s from t1 group by i order by sum(k);

> ArrayIndexOutOfBoundsException at MergeSort.compare
> ---------------------------------------------------
>
>                 Key: DERBY-3303
>                 URL: https://issues.apache.org/jira/browse/DERBY-3303
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.3.2.1
>         Environment: ------------------ Java Information ------------------
> Java Version:    1.6.0_03
> Java Vendor:     Sun Microsystems Inc.
> Java home:       D:\Programs\Java\jre1.6.0_03
> Java classpath:  derbytools.jar
> OS name:         Windows XP
> OS architecture: x86
> OS version:      5.1
> Java user name:  Donatas
> Java user home:  C:\Documents and Settings\Donatas
> Java user dir:   d:\java\derby-10.3.2.1\lib
> java.specification.name: Java Platform API Specification
> java.specification.version: 1.6
> --------- Derby Information --------
> JRE - JDBC: Java SE 6 - JDBC 4.0
> [D:\java\derby-10.3.2.1\lib\derbytools.jar] 10.3.2.1 - (599110)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
>            Reporter: Donatas Ciuksys
>            Priority: Blocker
>         Attachments: db.zip, ddl.sql
>
>
> Derby throws ArrayIndexOutOfBoundsException  when I try to execute SQL query shown below.
> This is a regression, since Derby 10.2.2.0 executes this query without problems.
> Attached are DDL statements to create DB tables, and database itself (with data).
= 0), (DATABASE = InventorizacijaDB), (DRDAID = NF000001.G46A-666250070078662256{1}), Failed
Statement is: select MAX(preke0_.BARKODAS) as col_0_0_, MAX(preke0_.PAVADINIMAS) as col_1_0_,
MAX(preke0_.KIEKIS) as col_2_0_, SUM(irasas1_.FAKTINIS_KIEKIS) as col_3_0_ from PREKE preke0_,
IRASAS irasas1_, IRASU_BLOKAS irasubloka2_ where irasas1_.IRASU_BLOKAS=irasubloka2_.ID and
preke0_.UNIKALUS_KODAS=irasas1_.UNIKALUS_KODAS and irasubloka2_.INVENTORIZACIJA=? group by
irasas1_.UNIKALUS_KODAS order by abs(SUM(irasas1_.FAKTINIS_KIEKIS)-MAX(preke0_.KIEKIS)) DESC
with 1 parameters begin parameter #1: 1 :end parameter
> java.lang.ArrayIndexOutOfBoundsException: 5
> 	at org.apache.derby.impl.store.access.sort.MergeSort.compare(Unknown Source)
> 	at org.apache.derby.impl.store.access.sort.SortBuffer.insert(Unknown Source)
> 	at org.apache.derby.impl.store.access.sort.MergeInserter.insert(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.SortResultSet.openCore(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)
> 	at org.apache.derby.impl.drda.DRDAStatement.execute(Unknown Source)