When qualifying a synonym with its name in the select list, Derby throws
SQLSTATE 42X04.
----------------------------------------------------------------------------------------
Key: DERBY-1784
URL: http://issues.apache.org/jira/browse/DERBY-1784
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.1.3.1, 10.3.0.0
Environment: Any environment
Reporter: Yip Ng
When qualifying a synonym with its name in the select list, Derby throws
SQLSTATE 42X04 but if there is no qualification of the column, then the select
statement executes successfully.
ij version 10.3
ij> connect 'jdbc:derby:wombat;create=true' user 'user1' as user1;
WARNING 01J01: Database 'wombat' not created, connection made to existing
database instead.
ij> create schema test1;
0 rows inserted/updated/deleted
ij> create schema test2;
0 rows inserted/updated/deleted
ij> create table test1.t1 ( id bigint not null );
0 rows inserted/updated/deleted
ij> create synonym test2.t1 for test1.t1;
0 rows inserted/updated/deleted
ij> set schema test1;
0 rows inserted/updated/deleted
ij> select t1.id from t1;
ID
--------------------
0 rows selected
ij> set schema test2;
0 rows inserted/updated/deleted
ij> select t1.id from t1;
ERROR 42X04: Column 'T1.ID' is either not in any table in the FROM list or
appears within a join specification and is outside the scope of the join
specification or appears in a HAVING clause and is not in the GROUP BY list. If
this is a CREATE or ALTER TABLE statement then 'T1.ID' is not a column in the
target table
ij> select id from t1;
ID
--------------------
0 rows selected
------------------ Java Information ------------------
Java Version: 1.4.2_12
Java Vendor: Sun Microsystems Inc.
Java home: C:\Program Files\Java\j2re1.4.2_12
Java classpath: classes;.
OS name: Windows XP
OS architecture: x86
OS version: 5.1
Java user name: Yip
Java user home: C:\Documents and Settings\Yip
Java user dir: C:\work3\derby\trunk
java.specification.name: Java Platform API Specification
java.specification.version: 1.4
--------- Derby Information --------
JRE - JDBC: J2SE 1.4.2 - JDBC 3.0
[C:\work3\derby\trunk\classes] 10.3.0.0 alpha - (438358)
------------------------------------------------------
----------------- Locale Information -----------------
Current Locale : [English/United States [en_US]]
Found support for locale: [de_DE]
version: 10.3.0.0 alpha - (438358)
Found support for locale: [es]
version: 10.3.0.0 alpha - (438358)
Found support for locale: [fr]
version: 10.3.0.0 alpha - (438358)
Found support for locale: [it]
version: 10.3.0.0 alpha - (438358)
Found support for locale: [ja_JP]
version: 10.3.0.0 alpha - (438358)
Found support for locale: [ko_KR]
version: 10.3.0.0 alpha - (438358)
Found support for locale: [pt_BR]
version: 10.3.0.0 alpha - (438358)
Found support for locale: [zh_CN]
version: 10.3.0.0 alpha - (438358)
Found support for locale: [zh_TW]
version: 10.3.0.0 alpha - (438358)
------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
