Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Message-ID: <4A1ABAF2.4040903@amberpoint.com>
Date: Mon, 25 May 2009 08:36:18 -0700
From: Bryan Pendleton <bpendleton@amberpoint.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: Bug in Derby 10.5.1.1 or misuse ?
References: <4A1AB036.2030703@gmail.com>
In-Reply-To: <4A1AB036.2030703@gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

> I can't see what I am doing wrong, but I am not an SQL expert. So, I am 
> doing something wrong or is there a problem with Derby 10.5.1.1?

Looks like a bug in Derby to me, unfortunately. It fails for me on the
current Derby trunk, with this SQL submitted to the ij tool:

drop table types;
drop table methods;
drop table methodParameters;
CREATE TABLE types (
   id INT PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
   name VARCHAR(128) NOT NULL UNIQUE,
   shortName VARCHAR(64) NOT NULL
);
create table methods (id int primary key generated always as identity);
CREATE TABLE methodParameters (
   method INT REFERENCES methods (id),
   position INT,
   parameter INT REFERENCES types (id)
);
prepare p as 'SELECT method, COUNT(method) FROM methodParameters      INNER JOIN types ON parameter = id WHERE name IN (?) GROUP BY 
method HAVING COUNT(method) >= ?';

If you could please file an issue in JIRA, that would be great.
http://db.apache.org/derby/DerbyBugGuidelines.html

I think this issue is quite possibly related to the work we did for
DERBY-2526, so perhaps you could mention that as a possibility in the
problem report.

thanks,

bryan