search

LucidDB / luciddb

DEFUNCT: See README
https://github.com/LucidDB/luciddb
Apache License 2.0
52 stars 24 forks source link

[FRG-187] FarragoAutoVmOperatorTest.testOverlapsOperator fails #685

Open dynamobi-build opened 12 years ago

dynamobi-build commented 12 years ago

[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)