tity index.
> -Original Message-
> From: Tars Joris [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 29, 2008 4:02 AM
> To: Derby Discussion; [EMAIL PROTECTED]
> Subject: RE: Incorrect ORDER BY caused by index?
>
> Hi Michael,
>
> Thanks for your reply. See my responses in
Hi Michael,
Thanks for your reply. See my responses inline.
> Lets look at your select statement:
>
> SELECT table1.id, m0.value, m1.value
> FROM table1, table2 m0, table2 m1
> WHERE table1.id=m0.id
> ANDm0.name='PageSequenceId'
> ANDtable1.id=m1.id
> ANDm1.name='PostComponentId'
>
ensdag 29 oktober 2008 0:52
> To: Derby Discussion
> Subject: Re: Incorrect ORDER BY caused by index?
>
> Tars Joris wrote:
> > this looks like a bug. I use Derby version 10.4.2.0.
> >
> >
> I agree. A couple other notes. It seems to also exist with 10.2 and
> 10.1.
Sorry to top post, it's a bit quicker and I'm going to pull things from your
post to show you something. I'm also reformatting your code to make it
easier to read...
Lets take a look at your tables...
CREATE TABLE table1 (id BIGINT NOT NULL,
PRIMARY KEY(id));
CREATE INDEX
Tars Joris wrote:
this looks like a bug. I use Derby version 10.4.2.0.
I agree. A couple other notes. It seems to also exist with 10.2 and
10.1. Also I noticed if I recreate the index I see the right result.
Please file an issue in Jira. Thanks for the report.
Kathey