I was hoping this one would make it to 10.2.1. The patch has been committed to the trunk and I thought it would make your last mega merge. I plan on merging it to 10.1 so would be nice if it does not show up as a regression in 10.2.
Rick Hillegas (JIRA) wrote:
[ http://issues.apache.org/jira/browse/DERBY-1784?page=all ] Rick Hillegas updated DERBY-1784: --------------------------------- Fix Version/s: 10.2.2.0 (was: 10.2.1.0) Moving to 10.2.2.0.When qualifying a column name with its synonym 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.2.1.0, 10.3.0.0, 10.1.3.1 Environment: Any environment Reporter: Yip Ng Assigned To: Yip Ng Fix For: 10.3.0.0, 10.1.4.0, 10.2.2.0 Attachments: derby1784-10.1-diff01.txt, derby1784-10.1-stat01.txt, derby1784-trunk-diff01.txt, derby1784-trunk-diff02.txt, derby1784-trunk-diff03a.txt, derby1784-trunk-diff03b.txt, derby1784-trunk-stat01.txt, derby1784-trunk-stat02.txt, derby1784-trunk-stat03a.txt, derby1784-trunk-stat03b.txt 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) ------------------------------------------------------
