History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: FRG-187
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Muralidhar Ravuri
Reporter: Angel Chang
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Farrago

FarragoAutoVmOperatorTest.testOverlapsOperator fails

Created: 19/Aug/06 07:14 PM   Updated: 19/Aug/06 07:14 PM
Component/s: Test
Affects Version/s: None
Fix Version/s: None


 Description  « Hide
The overlaps operator is not working - please fix so SqlOperatorTests.testOverlapsOperator (this test didn't use to do anything since overlaps was not registered explictly as being supported by the fennel or java calc) runs under FarragoAutoVmOperatorTest.

There are different errors with the overlaps operators, two of them which are:
0: jdbc:sqlstream:engine:> values ((time '12:00:00', time '12:00:00') overlaps (time '12:00:00', interval '1' hour));
Error: org.codehaus.janino.util.TunnelException: org.codehaus.janino.util.TunnelException: File /home/hersker/monkey/dt/farrago/classes/net/sf/farrago/dynamic/stmt22232/ExecutableStmt.java, Line 90, Column 119: "long" has no field "value" (state=,code=0)

java.lang.RuntimeException: net.sf.farrago.jdbc.FarragoJdbcUtil$FarragoSqlException: java.lang.AssertionError: Value IntervalYearMonth of class class org.eigenbase.sql.type.SqlTypeName unexpected here
at org.eigenbase.util14.Enum14$BasicValue.unexpected(Enum14.java:488)
at org.eigenbase.sql2rel.SqlNodeToRexConverterImpl.convertLiteral(SqlNodeToRexConverterImpl.java:158)
at org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:2589)
at org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:2209)
at org.eigenbase.sql.SqlLiteral.accept(SqlLiteral.java:367)
at org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.convertExpression(SqlToRelConverter.java:2540)
at org.eigenbase.sql2rel.StandardConvertletTable.convertExpressionList(StandardConvertletTable.java:601)
at org.eigenbase.sql2rel.StandardConvertletTable.convertCall(StandardConvertletTable.java:590)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at org.eigenbase.sql2rel.ReflectiveConvertletTable$1.convertCall(ReflectiveConvertletTable.java:104)
at org.eigenbase.sql2rel.SqlNodeToRexConverterImpl.convertCall(SqlNodeToRexConverterImpl.java:66)
at org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:2604)
at org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:2209)
at org.eigenbase.sql.SqlCall.accept(SqlCall.java:176)
at org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.convertExpression(SqlToRelConverter.java:2540)
at org.eigenbase.sql2rel.StandardConvertletTable.convertExpressionList(StandardConvertletTable.java:601)
at org.eigenbase.sql2rel.StandardConvertletTable.convertCall(StandardConvertletTable.java:590)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at org.eigenbase.sql2rel.ReflectiveConvertletTable$1.convertCall(ReflectiveConvertletTable.java:104)
at org.eigenbase.sql2rel.SqlNodeToRexConverterImpl.convertCall(SqlNodeToRexConverterImpl.java:66)
at org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:2604)
at org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:2209)
at org.eigenbase.sql.SqlCall.accept(SqlCall.java:176)
at org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.convertExpression(SqlToRelConverter.java:2540)
at org.eigenbase.sql2rel.StandardConvertletTable.convertExpressionList(StandardConvertletTable.java:601)
at org.eigenbase.sql2rel.StandardConvertletTable.convertCall(StandardConvertletTable.java:590)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at org.eigenbase.sql2rel.ReflectiveConvertletTable$1.convertCall(ReflectiveConvertletTable.java:104)
at org.eigenbase.sql2rel.SqlNodeToRexConverterImpl.convertCall(SqlNodeToRexConverterImpl.java:66)
at org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:2604)
at org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:2209)
at org.eigenbase.sql.SqlCall.accept(SqlCall.java:176)
at org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.convertExpression(SqlToRelConverter.java:2540)
at org.eigenbase.sql2rel.StandardConvertletTable.convertCall(StandardConvertletTable.java:588)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at org.eigenbase.sql2rel.ReflectiveConvertletTable$1.convertCall(ReflectiveConvertletTable.java:104)
at org.eigenbase.sql2rel.SqlNodeToRexConverterImpl.convertCall(SqlNodeToRexConverterImpl.java:66)
at org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:2604)
at org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:2209)
at org.eigenbase.sql.SqlCall.accept(SqlCall.java:176)
at org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.convertExpression(SqlToRelConverter.java:2540)
at org.eigenbase.sql2rel.SqlToRelConverter.convertValues(SqlToRelConverter.java:2075)
at org.eigenbase.sql2rel.SqlToRelConverter.convertFrom(SqlToRelConverter.java:1037)
at org.eigenbase.sql2rel.SqlToRelConverter.convertFrom(SqlToRelConverter.java:960)
at org.eigenbase.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:289)
at org.eigenbase.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:266)
at org.eigenbase.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:1440)
at org.eigenbase.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:214)
at org.eigenbase.oj.stmt.OJPreparingStmt.prepareSql(OJPreparingStmt.java:257)
at net.sf.farrago.query.FarragoPreparingStmt.prepare(FarragoPreparingStmt.java:270)
at net.sf.farrago.db.FarragoDatabase$2.initializeEntry(FarragoDatabase.java:824)
at net.sf.farrago.util.FarragoObjectCache.pin(FarragoObjectCache.java:153)
at net.sf.farrago.db.FarragoDatabase.prepareStmtImpl(FarragoDatabase.java:836)
at net.sf.farrago.db.FarragoDatabase.prepareStmt(FarragoDatabase.java:707)
at net.sf.farrago.db.FarragoDbSession.prepareImpl(FarragoDbSession.java:935)
at net.sf.farrago.db.FarragoDbSession.prepare(FarragoDbSession.java:862)
at net.sf.farrago.db.FarragoDbStmtContext.prepare(FarragoDbStmtContext.java:105)
at net.sf.farrago.jdbc.engine.FarragoJdbcEngineStatement.executeQuery(FarragoJdbcEngineStatement.java:167)
at net.sf.farrago.test.FarragoSqlOperatorsSuite$FarragoSqlTester.check(FarragoSqlOperatorsSuite.java:253)
at net.sf.farrago.test.FarragoSqlOperatorsSuite$FarragoSqlTester.check(FarragoSqlOperatorsSuite.java:180)
at org.eigenbase.sql.test.AbstractSqlTester.checkBoolean(AbstractSqlTester.java:189)
at org.eigenbase.sql.test.SqlOperatorTests.testOverlapsOperator(SqlOperatorTests.java:1379)


 All   Comments   Change History      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.