{"issue":{"milestone":null,"title":"[LDB-104] join on 2 foreign tables in oracle gives error (and does not use hash join) ","created_at":"2011-12-30T02:22:32Z","user":{"login":"dynamobi-build","id":1123017,"url":"https://api.github.com/users/dynamobi-build","avatar_url":"https://secure.gravatar.com/avatar/cb215b3d786be20761071a562a56af64?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"cb215b3d786be20761071a562a56af64"},"updated_at":"2011-12-30T02:22:32Z","state":"open","labels":[{"name":"LDB","url":"https://api.github.com/repos/dynamobi/dynamobi/labels/LDB","color":"e2b9bd"},{"name":"LHX","url":"https://api.github.com/repos/dynamobi/dynamobi/labels/LHX","color":"5deccd"}],"id":2685406,"closed_at":null,"html_url":"https://github.com/dynamobi/dynamobi/issues/217","pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"body":"<b><i>[reporter=\"schoi\", created=\"Fri, 2 Jun 2006 15:30:54 -0500 (GMT-05:00)\"]</i></b>\nrepro steps:<br/>\n-------------------<br/>\ncreate server orcl_server2<br/>\n foreign data wrapper orcl_jdbc<br/>\n options(<br/>\n     url 'jdbc:oracle:thin:@akela.lucidera.com:1521:XE',<br/>\n     user_name 'lucidwh',<br/>\n     password 'lucidwh',<br/>\n     driver_class 'oracle.jdbc.driver.OracleDriver'<br/>\n );<br/>\n<br/>\nselect * from orcl_server2.\"HR\".\"EMPLOYEES\" as e, orcl_server2.\"HR\".\"DEPARTMENTS\" as d where d.\"DEPARTMENT_ID\" = e.\"DEPARTMENT_ID\";<br/>\n<br/>\n=> output:<br/>\nError: Invalid operation for forward only resultset : first (state=,code=17075)<br/>\njava.sql.SQLException: Invalid operation for forward only resultset : first<br/>\n        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)<br/>\n        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:190)<br/>\n        at oracle.jdbc.driver.BaseResultSet.first(BaseResultSet.java:85)<br/>\n        at org.eigenbase.runtime.ResultSetTupleIter.restart(ResultSetTupleIter.java:73)<br/>\n        at net.sf.farrago.runtime.FarragoTransformImpl.restart(FarragoTransformImpl.java:117)<br/>\n        at net.sf.farrago.fennel.FennelStorage.tupleStreamFetch(Native Method)<br/>\n        at net.sf.farrago.fennel.FennelStreamGraph.fetch(FennelStreamGraph.java:175)<br/>\n        at net.sf.farrago.runtime.FennelTupleIter.populateBuffer(FennelTupleIter.java:110)<br/>\n        at net.sf.farrago.runtime.FennelAbstractTupleIter.fetchNext(FennelAbstractTupleIter.java:99)<br/>\n        at net.sf.farrago.dynamic.stmt13849.ExecutableStmt$2.fetchNext(Unknown Source)<br/>\n        at org.eigenbase.runtime.TupleIterResultSet.next(TupleIterResultSet.java:90)<br/>\n        at net.sf.farrago.runtime.FarragoTupleIterResultSet.next(FarragoTupleIterResultSet.java:97)<br/>\n        at sqlline.SqlLine$BufferedRows.<init>(Unknown Source)<br/>\n<br/>\n<br/>\nexplain plan for select * from orcl_server2.\"HR\".\"EMPLOYEES\" as e, orcl_server2.\"HR\".\"DEPARTMENTS\" as d where d.\"DEPARTMENT_ID\" = e.\"DEPARTMENT_ID\";<br/>\n<br/>\n+-------------------------------------------------------------------------------------------------------------+<br/>\n|     column0 |<br/>\n+-------------------------------------------------------------------------------------------------------------+<br/>\n| IterCalcRel(expr#0..14=[{inputs}], expr#15=[Reinterpret($t11)], expr#16=[Reinterpret($t10)], expr#17=[=($t1 |<br/>\n|   FennelToIteratorConverter |<br/>\n|     FennelCartesianProductRel(leftouterjoin=[false])|<br/>\n|       IteratorToFennelConverter     |<br/>\n| ResultSetToFarragoIteratorConverter |<br/>\n|   MedJdbcQueryRel(foreignSql=[SELECT *      |<br/>\n| FROM \"HR\".\"EMPLOYEES\"])     |<br/>\n|       IteratorToFennelConverter     |<br/>\n| ResultSetToFarragoIteratorConverter |<br/>\n|   MedJdbcQueryRel(foreignSql=[SELECT *      |<br/>\n| FROM \"HR\".\"DEPARTMENTS\"])   |<br/>\n+-------------------------------------------------------------------------------------------------------------+<br/>\n<br/>\n","number":217,"url":"https://api.github.com/repos/dynamobi/dynamobi/issues/217","comments":0,"assignee":null},"action":"opened"}