db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Junjie Peng (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3758) Convert "org.apache.derbyTesting.functionTests.tests.lang.precedence.sql" to junit
Date Tue, 29 Jul 2008 09:36:31 GMT

    [ https://issues.apache.org/jira/browse/DERBY-3758?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12617754#action_12617754
] 

Junjie Peng commented on DERBY-3758:
------------------------------------

Hi, Knut. Thanks for your attention!
Yes, there are two of them:
Line 31:
select c11 from t1 where 'acme widgets' like 'acme%' in (1=1);

Line 36:
select c11 from t1 where exists(select * from (values 1) as t) not in (1=2);


They fails on ij, with prompt "Encounter '=' at line *, column *".

I think, from the point of the witer's original intent, the two tests should be 
Line 31:
select c11 from t1 where 'acme widgets' like 'acme%' in ('1=1');

Line 36:
select c11 from t1 where exists(select * from (values 1) as t) not in ('1=2');

the 1=1 & 1=2 should be enbraced by \'. 

How do you think about it?



> Convert "org.apache.derbyTesting.functionTests.tests.lang.precedence.sql" to junit
> ----------------------------------------------------------------------------------
>
>                 Key: DERBY-3758
>                 URL: https://issues.apache.org/jira/browse/DERBY-3758
>             Project: Derby
>          Issue Type: Test
>          Components: Test
>         Environment: windows xp, sp2.
>            Reporter: Junjie Peng
>            Assignee: Junjie Peng
>         Attachments: derby-3758-1-patch.txt, derby-3758-1-stat.txt, derby-3758-patch.txt,
derby-3758-stat.txt
>
>   Original Estimate: 120h
>  Remaining Estimate: 120h
>
> Convert "org.apache.derbyTesting.functionTests.tests.lang.precedence.sql" to junit. It
it a part of 2008 GSOC.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message