[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Can 0.94h no longer handle Outer Join syntax?
- To: "McKoi Database List" <mckoidb@xxxxxxxxx>
- Subject: Can 0.94h no longer handle Outer Join syntax?
- From: "Spencer Roberts at Tellusoft" <sroberts@xxxxxxxxxxxxx>
- Date: Tue, 25 Feb 2003 00:48:03 -0700
- Delivered-To: mailing list mckoidb@mckoi.com
- Importance: Normal
- Mailing-List: contact mckoidb-help@mckoi.com; run by ezmlm
Hi All,
I just upgraded to 0.94h from 0.94g and received this error...
This SQL:
SELECT c.*, count(e.id_contact), cs.name, cs.avg_score
FROM contact c, csr cs
LEFT OUTER JOIN evaluation e
ON c.id_contact = e.id_contact
WHERE cs.id_csr = c.id_csr
AND c.id_csr = 1
Now produces this error:
CAUSE: java.lang.RuntimeException: Unable to find table with variable
reference:
c.id_contact
at
com.mckoi.database.interpret.Planner$QueryTableSetPlanner.findTableSource(Pl
anner.java:1162)
at
com.mckoi.database.interpret.Planner$QueryTableSetPlanner.joinAllPlansWithVa
riables(Planner.java:1253)
at
com.mckoi.database.interpret.Planner$QueryTableSetPlanner.access$600(Planner
.java:1006)
at
com.mckoi.database.interpret.Planner$QueryTableSetPlanner$StandardJoinExpres
sionPlan.addToPlanTree(Planner.java:1718)
at
com.mckoi.database.interpret.Planner$QueryTableSetPlanner.planForExpressionL
ist(Planner.java:2283)
at
com.mckoi.database.interpret.Planner$QueryTableSetPlanner.planForExpression(
Planner.java:2426)
at
com.mckoi.database.interpret.Planner$QueryTableSetPlanner.logicalEvaluate(Pl
anner.java:2448)
at
com.mckoi.database.interpret.Planner$QueryTableSetPlanner.naturallyJoinPlans
(Planner.java:1437)
at
com.mckoi.database.interpret.Planner$QueryTableSetPlanner.planAllOuterJoins(
Planner.java:1478)
at
com.mckoi.database.interpret.Planner$QueryTableSetPlanner.planSearchExpressi
on(Planner.java:2477)
at
com.mckoi.database.interpret.Planner.formQueryPlan(Planner.java:480)
at com.mckoi.database.interpret.Select.prepare(Select.java:123)
at
com.mckoi.database.interpret.SQLQueryExecutor.execute(SQLQueryExecutor.java:
144)
at
com.mckoi.database.jdbcserver.AbstractJDBCDatabaseInterface.execQuery(Abstra
ctJDBCDatabaseInterface.java:321)
at
com.mckoi.database.jdbcserver.JDBCDatabaseInterface.execQuery(JDBCDatabaseIn
terface.java:253)
at
com.mckoi.database.jdbc.MConnection.executeQuery(MConnection.java:348)
at
com.mckoi.database.jdbc.MStatement.executeQuery(MStatement.java:110)
at
com.mckoi.database.jdbc.MPreparedStatement.executeQuery(MPreparedStatement.j
ava:120)
at
com.mckoi.jfccontrols.QueryAgent$QueryThread.run(QueryAgent.java:282)
Any ideas?
TIA,
Spencer