|
|
|
Sponsor |
Re: [jira] Commented: (DERBY-18) Exposed name matching has bugs when the co: msg#00395apache.db.derby.devel
Dan, I did the patch for this. From your comments I looked at the getSchemaDescriptor() in QueryTreeNode. The schema name was getting stored there but not stored in the TableName in the corresponding node. Since *null* schema implies current schema I just called bind() in TableName.java whereever the schema was null. By calling this proper schema names get stored. I had to do these changes in some of the file where the method getMatchingColumn() is called so that TableName comparisions happen on objects that have the correct data. When put this patch and ran the tests I had some failures which were becasue the error messages were different. This is because in the earlier file, if the error message had "S1.T1" now it has "APP.S1.T1" hence the failures. I am attaching the patch and the test run results. thanks Shreyas Daniel John Debrunner wrote: -----BEGIN PGP SIGNED MESSAGE-----Index: java/engine/org/apache/derby/impl/sql/compile/FromList.java =================================================================== --- java/engine/org/apache/derby/impl/sql/compile/FromList.java (revision 148848) +++ java/engine/org/apache/derby/impl/sql/compile/FromList.java (working copy) @@ -138,6 +138,7 @@ */ TableName leftTable = null; TableName rightTable = null; + if (! (fromTable instanceof TableOperatorNode)) { /* Check for duplicate table name in FROM list */ @@ -146,12 +147,18 @@ { leftTable = fromTable.getTableName(); + if(leftTable.getSchemaName() == null) + leftTable.bind(this.getDataDictionary()); + if(((FromTable) elementAt(index)) instanceof TableOperatorNode) { continue; } - else { + else { rightTable = ((FromTable) elementAt(index)).getTableName(); + + if(rightTable.getSchemaName() == null) + rightTable.bind(this.getDataDictionary()); } if(leftTable.equals(rightTable)) { @@ -291,6 +298,7 @@ { fromTable = (FromTable) elementAt(index); setElementAt(fromTable.bindNonVTITables(dataDictionary, fromListParam), index); + } for (int index = 0; index < size; index++) { @@ -499,9 +507,9 @@ int size = size(); for (int index = 0; index < size; index++) { - fromTable = (FromTable) elementAt(index); + fromTable = (FromTable) elementAt(index); - /* We can stop if we've found a matching column or table name + /* We can stop if we've found a matching column or table name * at the previous nesting level. */ currentLevel = fromTable.getLevel(); Index: java/engine/org/apache/derby/impl/sql/compile/FromVTI.java =================================================================== --- java/engine/org/apache/derby/impl/sql/compile/FromVTI.java (revision 148848) +++ java/engine/org/apache/derby/impl/sql/compile/FromVTI.java (working copy) @@ -988,6 +988,13 @@ columnsTableName = columnReference.getTableNameNode(); + if(columnsTableName != null) + if(columnsTableName.getSchemaName() == null) + columnsTableName.bind(this.getDataDictionary()); + + if(exposedName != null) + if(exposedName.getSchemaName() == null) + exposedName.bind(this.getDataDictionary()); /* ** If the column did not specify a name, or the specified name ** matches the table we're looking at, see whether the column Index: java/engine/org/apache/derby/impl/sql/compile/FromBaseTable.java =================================================================== --- java/engine/org/apache/derby/impl/sql/compile/FromBaseTable.java (revision 148848) +++ java/engine/org/apache/derby/impl/sql/compile/FromBaseTable.java (working copy) @@ -2125,6 +2125,7 @@ { TableDescriptor tableDescriptor = bindTableDescriptor(); + /* if (tableDescriptor.getTableType() == TableDescriptor.VTI_TYPE) { ResultSetNode vtiNode = getNodeFactory().mapTableAsVTI(getContextManager(), tableDescriptor); return vtiNode.bindNonVTITables(dataDictionary, fromListParam); @@ -2445,6 +2446,10 @@ columnsTableName = columnReference.getTableNameNode(); + if(columnsTableName != null) { + if(columnsTableName.getSchemaName() == null) + columnsTableName.bind(this.getDataDictionary()); + } /* ** If there is a correlation name, use that instead of the ** table name. @@ -2457,7 +2462,9 @@ { exposedTableName = tableName; } - + + if(exposedTableName.getSchemaName() == null) + exposedTableName.bind(this.getDataDictionary()); /* ** If the column did not specify a name, or the specified name ** matches the table we're looking at, see whether the column @@ -2465,6 +2472,7 @@ */ if (columnsTableName == null || columnsTableName.equals(exposedTableName)) { + resultColumn = resultColumns.getResultColumn(columnReference.getColumnName()); /* Did we find a match? */ if (resultColumn != null) @@ -2480,8 +2488,7 @@ tableDescriptor.setReferencedColumnMap(referencedColumnMap); } } - } - + } return resultColumn; } Index: java/engine/org/apache/derby/impl/sql/compile/CurrentOfNode.java =================================================================== --- java/engine/org/apache/derby/impl/sql/compile/CurrentOfNode.java (revision 148848) +++ java/engine/org/apache/derby/impl/sql/compile/CurrentOfNode.java (working copy) @@ -305,6 +305,10 @@ columnsTableName = columnReference.getTableNameNode(); + if(columnsTableName != null) + if(columnsTableName.getSchemaName() == null) + columnsTableName.bind(this.getDataDictionary()); + if (SanityManager.DEBUG) { SanityManager.ASSERT(preStmt!=null, "must have prepared statement"); @@ -324,6 +328,11 @@ SanityManager.ASSERT(baseTableName!=null,"no name on target table"); } + if(baseTableName != null) + if(baseTableName.getSchemaName() == null) + baseTableName.bind(this.getDataDictionary()); + + /* * If the column did not specify a name, or the specified name * matches the table we're looking at, see whether the column Generating report for RunSuite derbylang java null null true ------------------ Java Information ------------------ Java Version: 1.4.2 Java Vendor: Sun Microsystems Inc. Java home: /java/j2sdk1.4.2/jre Java classpath: /drivers/derby/trunk/classes:/drivers/derby/trunk/tools/java/jakarta-oro-2.0.8.jar OS name: SunOS OS architecture: sparc OS version: 5.9 Java user name: sk149173 Java user home: /home/sk149173 Java user dir: /drivers/derby/trunk --------- Derby Information -------- [/drivers/derby/trunk/classes] 10.1.0.0 alpha - (1) ------------------------------------------------------ ----------------- Locale Information ----------------- Current Locale : [English/ [en]] Found support for locale: [de_DE] version: 10.1.0.0 alpha - (1) Found support for locale: [es] version: 10.1.0.0 alpha - (1) Found support for locale: [fr] version: 10.1.0.0 alpha - (1) Found support for locale: [it] version: 10.1.0.0 alpha - (1) Found support for locale: [ja_JP] version: 10.1.0.0 alpha - (1) Found support for locale: [ko_KR] version: 10.1.0.0 alpha - (1) Found support for locale: [pt_BR] version: 10.1.0.0 alpha - (1) Found support for locale: [zh_CN] version: 10.1.0.0 alpha - (1) Found support for locale: [zh_TW] version: 10.1.0.0 alpha - (1) ------------------------------------------------------ Test environment information: COMMAND LINE STYLE: jdk13 TEST CANONS: master ------------------------------------------------------ ------------------------------------------------------ Summary results: Test Run Started: 2005-01-27 17:40:58.0 Test Run Duration: 01:13:29 136 Tests Run 94% Pass (127 tests passed) 6% Fail (9 tests failed) 0 Suites skipped ------------------------------------------------------ Failed tests in: derbylang_fail.txt ------------------------------------------------------ Passed tests in: derbylang_pass.txt ------------------------------------------------------ System properties in: derbylang_prop.txt ------------------------------------------------------ ------------------------------------------------------ Failure Details: ********* Diff file derbylang/derbylang/LOB.diff *** Start: LOB jdk1.4.2 derbylang:derbylang 2005-01-27 17:43:17 *** 69 del < ERROR 42X04: Column 'B.NCLOB' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'B.NCLOB' is not a column in the target table. 69a69 > ERROR 42X04: Column 'APP.B.NCLOB' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.B.NCLOB' is not > a column in the target table. 120 del < ERROR 42X04: Column 'B.NCLOB' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'B.NCLOB' is not a column in the target table. 120a120 > ERROR 42X04: Column 'APP.B.NCLOB' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.B.NCLOB' is not > a column in the target table. 127 del < ERROR 42X04: Column 'B.NCLOB' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'B.NCLOB' is not a column in the target table. 127a127 > ERROR 42X04: Column 'APP.B.NCLOB' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.B.NCLOB' is not > a column in the target table. Test Failed. *** End: LOB jdk1.4.2 derbylang:derbylang 2005-01-27 17:43:46 *** ********* Diff file derbylang/derbylang/groupBy.diff *** Start: groupBy jdk1.4.2 derbylang:derbylang 2005-01-27 18:09:45 *** 40 del < ERROR 42X04: Column 'B.O' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'B.O' is not a column in the target table. 40a40 > ERROR 42X04: Column 'APP.B.O' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.B.O' is not a > column in the target table. 565 del < ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least 1 aggregate then all entries must be valid aggregate expressions. 565a565 > ERROR 42Y35: Column reference 'APP.T1.C1' is invalid. When the SELECT list > contains at least 1 aggregate then all entries must be valid aggregate > expressions. 571 del < ERROR 42Y35: Column reference 'T1_OUTER.C1' is invalid. When the SELECT list contains at least 1 aggregate then all entries must be valid aggregate expressions. 571a571 > ERROR 42Y35: Column reference 'APP.T1_OUTER.C1' is invalid. When the SELECT > list contains at least 1 aggregate then all entries must be valid aggregate > expressions. 591 del < ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least 1 aggregate then all entries must be valid aggregate expressions. 591a591 > ERROR 42Y35: Column reference 'APP.T1.C1' is invalid. When the SELECT list > contains at least 1 aggregate then all entries must be valid aggregate > expressions. 600 del < ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least 1 aggregate then all entries must be valid aggregate expressions. 600a600 > ERROR 42Y35: Column reference 'APP.T1.C1' is invalid. When the SELECT list > contains at least 1 aggregate then all entries must be valid aggregate > expressions. 606 del < ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least 1 aggregate then all entries must be valid aggregate expressions. 606a606 > ERROR 42Y35: Column reference 'APP.T1.C1' is invalid. When the SELECT list > contains at least 1 aggregate then all entries must be valid aggregate > expressions. Test Failed. *** End: groupBy jdk1.4.2 derbylang:derbylang 2005-01-27 18:10:05 *** ********* Diff file derbylang/derbylang/innerjoin.diff *** Start: innerjoin jdk1.4.2 derbylang:derbylang 2005-01-27 18:12:49 *** 36 del < ERROR 42X03: Column name 'T1.C1' is in more than one table in the FROM list. 36a36 > ERROR 42X03: Column name 'APP.T1.C1' is in more than one table in the FROM > list. 39 del < ERROR 42X03: Column name 'T1.C1' is in more than one table in the FROM list. 39a39 > ERROR 42X03: Column name 'APP.T1.C1' is in more than one table in the FROM > list. 41 del < ERROR 42X03: Column name 'T1.C1' is in more than one table in the FROM list. 41a41 > ERROR 42X03: Column name 'APP.T1.C1' is in more than one table in the FROM > list. 48 del < ERROR 42X04: Column 'A.C1' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'A.C1' is not a column in the target table. 48a48 > ERROR 42X04: Column 'APP.A.C1' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.A.C1' is not a > column in the target table. Test Failed. *** End: innerjoin jdk1.4.2 derbylang:derbylang 2005-01-27 18:13:06 *** ********* Diff file derbylang/derbylang/joins.diff *** Start: joins jdk1.4.2 derbylang:derbylang 2005-01-27 18:14:39 *** 32 del < ERROR 42X09: The table or alias name 'T1' is used more than once in the FROM list. 32a32 > ERROR 42X09: The table or alias name 'APP.T1' is used more than once in the > FROM list. Test Failed. *** End: joins jdk1.4.2 derbylang:derbylang 2005-01-27 18:15:04 *** ********* Diff file derbylang/derbylang/orderby.diff *** Start: orderby jdk1.4.2 derbylang:derbylang 2005-01-27 18:23:13 *** 353 del < ERROR 42X04: Column 'OBT.I' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'OBT.I' is not a column in the target table. 353a353 > ERROR 42X04: Column 'APP.OBT.I' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.OBT.I' is not a > column in the target table. 356 del < ERROR 42X04: Column 'OBT.NOTEXISTS' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'OBT.NOTEXISTS' is not a column in the target table. 356a356 > ERROR 42X04: Column 'APP.OBT.NOTEXISTS' is not in any table in the FROM list > or it appears within a join specification and is outside the scope of the > join specification or it appears in a HAVING clause and is not in the GROUP > BY list. If this is a CREATE or ALTER TABLE statement then > 'APP.OBT.NOTEXISTS' is not a column in the target table. 463,464d462 < ERROR 42X10: 'SYS.T1' is not an exposed table name in the scope in which it appears. < ij> select c1 from app.t1 order by sys.t1.c1; 465a464,465 > ij> select c1 from app.t1 order by sys.t1.c1; > ERROR 42X04: Column 'SYS.T1.C1' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'SYS.T1.C1' is not a > column in the target table. 472 del < ERROR 42X04: Column 'T1.A' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'T1.A' is not a column in the target table. 472a472 > ERROR 42X04: Column 'APP.T1.A' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.T1.A' is not a > column in the target table. 475 del < ERROR 42X04: Column 'T3.C1' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'T3.C1' is not a column in the target table. 475a475 > ERROR 42X04: Column 'APP.T3.C1' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.T3.C1' is not a > column in the target table. 872 del < ERROR 42X04: Column 'T.D' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'T.D' is not a column in the target table. 872a872 > ERROR 42X04: Column 'APP.T.D' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.T.D' is not a > column in the target table. 874 del < ERROR 42X04: Column 'S.D' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'S.D' is not a column in the target table. 874a874 > ERROR 42X04: Column 'APP.S.D' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.S.D' is not a > column in the target table. 886 del < ERROR 42X04: Column 'T.D' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'T.D' is not a column in the target table. 886a886 > ERROR 42X04: Column 'APP.T.D' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.T.D' is not a > column in the target table. 888 del < ERROR 42X04: Column 'S.D' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'S.D' is not a column in the target table. 888a888 > ERROR 42X04: Column 'APP.S.D' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.S.D' is not a > column in the target table. 894 del < ERROR 42X04: Column 'T.D' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'T.D' is not a column in the target table. 894a894 > ERROR 42X04: Column 'APP.T.D' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.T.D' is not a > column in the target table. 896 del < ERROR 42X04: Column 'S.D' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'S.D' is not a column in the target table. 896a896 > ERROR 42X04: Column 'APP.S.D' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.S.D' is not a > column in the target table. Test Failed. *** End: orderby jdk1.4.2 derbylang:derbylang 2005-01-27 18:23:35 *** ********* Diff file derbylang/derbylang/outerjoin.diff *** Start: outerjoin jdk1.4.2 derbylang:derbylang 2005-01-27 18:23:56 *** 1878 del < ERROR 42X03: Column name 'TTAB1.A' is in more than one table in the FROM list. 1878a1878 > ERROR 42X03: Column name 'APP.TTAB1.A' is in more than one table in the FROM > list. Test Failed. *** End: outerjoin jdk1.4.2 derbylang:derbylang 2005-01-27 18:24:33 *** ********* Diff file derbylang/derbylang/refActions1.diff *** Start: refActions1 jdk1.4.2 derbylang:derbylang 2005-01-27 18:30:21 *** 2944 del < ERROR 42X04: Column 'E.NAME' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'E.NAME' is not a column in the target table. 2944a2944 > ERROR 42X04: Column 'DB2TEST.E.NAME' is not in any table in the FROM list or > it appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'DB2TEST.E.NAME' is > not a column in the target table. 3112 del < ERROR 42X04: Column 'E.NAME' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'E.NAME' is not a column in the target table. 3112a3112 > ERROR 42X04: Column 'DB2TEST.E.NAME' is not in any table in the FROM list or > it appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'DB2TEST.E.NAME' is > not a column in the target table. 3281 del < ERROR 42X04: Column 'E.NAME' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'E.NAME' is not a column in the target table. 3281a3281 > ERROR 42X04: Column 'DB2TEST.E.NAME' is not in any table in the FROM list or > it appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'DB2TEST.E.NAME' is > not a column in the target table. 7578 del < ERROR 42X04: Column 'E5.NAME' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'E5.NAME' is not a column in the target table. 7578a7578 > ERROR 42X04: Column 'DB2TEST.E5.NAME' is not in any table in the FROM list or > it appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'DB2TEST.E5.NAME' is > not a column in the target table. 7746 del < ERROR 42X04: Column 'E.NAME' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'E.NAME' is not a column in the target table. 7746a7746 > ERROR 42X04: Column 'DB2TEST.E.NAME' is not in any table in the FROM list or > it appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'DB2TEST.E.NAME' is > not a column in the target table. 7914 del < ERROR 42X04: Column 'E.NAME' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'E.NAME' is not a column in the target table. 7914a7914 > ERROR 42X04: Column 'DB2TEST.E.NAME' is not in any table in the FROM list or > it appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'DB2TEST.E.NAME' is > not a column in the target table. Test Failed. *** End: refActions1 jdk1.4.2 derbylang:derbylang 2005-01-27 18:33:36 *** ********* Diff file derbylang/derbylang/schemas.diff *** Start: schemas jdk1.4.2 derbylang:derbylang 2005-01-27 18:39:20 *** 732 del < ERROR 42X04: Column 'SS.I' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'SS.I' is not a column in the target table. 732a732 > ERROR 42X04: Column 'APP.SS.I' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.SS.I' is not a > column in the target table. 736 del < ERROR 42X04: Column 'S.I' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'S.I' is not a column in the target table. 736a736 > ERROR 42X04: Column 'APP.S.I' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.S.I' is not a > column in the target table. Test Failed. *** End: schemas jdk1.4.2 derbylang:derbylang 2005-01-27 18:39:47 *** ********* Diff file derbylang/derbylang/subquery.diff *** Start: subquery jdk1.4.2 derbylang:derbylang 2005-01-27 18:43:41 *** 525 del < ERROR 42X04: Column 'SS.I' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'SS.I' is not a column in the target table. 525a525 > ERROR 42X04: Column 'APP.SS.I' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.SS.I' is not a > column in the target table. 529 del < ERROR 42X04: Column 'S.I' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'S.I' is not a column in the target table. 529a529 > ERROR 42X04: Column 'APP.S.I' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.S.I' is not a > column in the target table. 534 del < ERROR 42X04: Column 'TT.II' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'TT.II' is not a column in the target table. 534a534 > ERROR 42X04: Column 'APP.TT.II' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.TT.II' is not a > column in the target table. 539 del < ERROR 42X04: Column 'S.I' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'S.I' is not a column in the target table. 539a539 > ERROR 42X04: Column 'APP.S.I' is not in any table in the FROM list or it > appears within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'APP.S.I' is not a > column in the target table. Test Failed. *** End: subquery jdk1.4.2 derbylang:derbylang 2005-01-27 18:44:05 *** ------------------------------------------------------
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Re: Derby home page now blank??, Shreyas Kaushik |
|---|---|
| Next by Date: | Re: Derby home page now blank??, Jean T. Anderson |
| Previous by Thread: | Re: [jira] Commented: (DERBY-18) Exposed name matching has bugs when the column name is qualified with a schema name., Daniel John Debrunner |
| Next by Thread: | Re: [jira] Commented: (DERBY-18) Exposed name matching has bugs when the column name is qualified with a schema name., Daniel John Debrunner |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |
Home | sitemap
| advertise | OSDir is
an inevitable website. 
|
