Mailing-List: contact jdo-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: jdo-dev@db.apache.org
Received-SPF: pass (nike.apache.org: local policy)
Message-ID: <4D29EC01.7070305@spree.de>
Date: Sun, 09 Jan 2011 18:10:25 +0100
From: Michael Bouschen <mbo.tech@spree.de>
Organization: akquinet tech@spree GmbH
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; de;
 rv:1.9.2.13) Gecko/20101207 Thunderbird/3.1.7
MIME-Version: 1.0
To: jdo-dev@db.apache.org
Subject: Re: Query test failure with newer derby version (was Re: Minutes:
 JDO TCK Conference Call Friday, Jan 7, 9 am Pacific Time)
References: <4966C3D9.9050408@sun.com> <4BDA63FA.2030902@sonic.net>
 <4BE38D45.5010308@sonic.net> <4BECD0DB.3080709@sonic.net>
 <4C11B5A3.40203@sonic!.net>
 <79f3420acc7d5b2c4cb90280a4ee555d.squirrel@webmail.sonic.net>
 <4CB7CAF0.2020904@sonic.net> <4CCA3F7F.9080501@sonic.net>
 <4CDCA65B.7040303@sonic!.net> <4CF86D72.1010509@sonic!.net>
 <4D26919C.7060100@sonic.net>
 <B16F1158-8488-45A4-AB57-316A57C7D5C9@oracle.com> <4D283D7F.8020000@spree.de>
 <C76587AA-BFFB-4793-885A-8AC1A486EEF2@oracle.com> <4D28ADDB.4040204@spree.de>
In-Reply-To: <4D28ADDB.4040204@spree.de>
Content-Type: multipart/alternative;
 boundary="------------060805060207080007060900"

--------------060805060207080007060900
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Hi,

this is the JDOQL query:
   SELECT FROM org.apache.jdo.tck.pc.mylib.PCPoint EXCLUDE SUBCLASSES
   WHERE (x == 2) == true
and here is the generated SQL:
   SELECT 'org.apache.jdo.tck.pc.mylib.PCPoint' AS 
NUCLEUS_TYPE,A0.ID,A0.X,A0.Y
   FROM APPLICATIONIDENTITY0.PCPOINT A0
   WHERE A0.X = 2 = 1

So the question is: what does SQL define when comparing an integer and a 
boolean?
The expression "A0.X = 2" evaluates to a boolean which is then compared 
to the integer 1.

Regards Michael

> Hi Craig,
>
> [...]
>>>
>>> (2) query test:
>>>
>>> The failing test is in jdoql.conf: class 
>>> org.apache.jdo.tck.query.jdoql.ParenthesesMarkOperatorPrecedence 
>>> method runTestParenthesesMarkOperatorPrecedence08.
>>> The test runs a JDOQL query with PCPoint as candidate class and "(x 
>>> == 2) == true" as filter. It results in an exception thrown by the 
>>> derby SQL compiler:
>>>
>>> java.sql.SQLException: Comparisons between 'BOOLEAN' and 'INTEGER' 
>>> are not supported. Types must be comparable. String types must also 
>>> have matching collation. If collation does not match, a possible 
>>> solution is to cast operands to force them to the default collation 
>>> (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS 
>>> VARCHAR(128)) = 'T1')
>>>
>>> The derby versions 10.6.1.0 and 10.7.1.1 run into this exception. 
>>> But it does NOT happen with derby version 10.4.2.0, which we are 
>>> using in the maven1 environment.
>>
>> Good catch. Would you have time to file a JIRA with Derby?
>
> First I want to take a look at the generated SQL before filing a JIRA. 
> I'll keep you posted.
>
> Regards Michael
>
> [...]
>


-- 
*Michael Bouschen*
*Prokurist*

akquinet tech@spree GmbH
B�lowstr. 66, D-10783 Berlin

Fon:   +49 30 235 520-33
Fax:   +49 30 217 520-12
Email: michael.bouschen@akquinet.de
Url: www.akquinet.de <http://www.akquinet.de>

akquinet tech@spree GmbH, Berlin
Gesch�ftsf�hrung: Martin Weber, Prof. Dr. Christian Roth
Amtsgericht Berlin-Charlottenburg HRB 86780 B
USt.-Id. Nr.: DE 225 964 680

--------------060805060207080007060900--