dynamobi/dynamobi — Issue #685: [FRG-187] FarragoAutoVmOperatorTest.testOverlapsOperator fails
Author: dynamobi-build
Created: 2011-12-30 03:43:16+00:00
State: open
Labels: FRG, Test

[reporter="angel", created="Sat, 19 Aug 2006 19:14:50 -0500 (GMT-05:00)"]
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)