db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4380) SOME not allowed in ON clause
Date Fri, 18 Sep 2009 08:06:57 GMT
SOME not allowed in ON clause
-----------------------------

                 Key: DERBY-4380
                 URL: https://issues.apache.org/jira/browse/DERBY-4380
             Project: Derby
          Issue Type: Bug
          Components: Store
            Reporter: Bernt M. Johnsen


SOME is not allowed in ON-clause:

ij> create table t1 (i integer);
0 rows inserted/updated/deleted
ij> create table t2 (i integer);
0 rows inserted/updated/deleted
ij> create table t3 (i integer);
0 rows inserted/updated/deleted
ij> insert into t1 values (1);
1 row inserted/updated/deleted
ij> insert into t2 values (2);
1 row inserted/updated/deleted
ij> insert into t3 values 2,3,4;
3 rows inserted/updated/deleted
ij> select * from t1 where t1.i = some (select i from t3);
I          
-----------

0 rows selected
ij> select * from t1 inner join t2 on  t1.i = some (select i from t3);
ERROR 42972: An ON clause associated with a JOIN operator is not valid.
ij> 

-- 
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