[FRG-188] FarragoAutoVmOperatorTest tests for aggregate functions fails

[dynamobi-build]

[reporter="angel", created="Sat, 19 Aug 2006 20:12:13 -0500 (GMT-05:00)"] Please fix so the following tests in SqlOperatorTests runs under FarragoAutoVmOperatorTest.

• testWindow
  
• testCountFunc
  
• testSumFunc
  
• testAvgFunc
  
• testLastValueFunc
  
• testFirstValueFunc
  
  these tests didn't use to do anything since these operators were not registered explictly as being supported by the fennel or java calc.
  
  These tests gives the following errors (the first one looks similar to http://jirahost.eigenbase.org:8081/browse/FRG-170
  
  java.lang.RuntimeException: net.sf.farrago.jdbc.FarragoJdbcUtil$FarragoSqlException: Optimizer failed to find a valid physical implementation for relational expression rel#11473:WindowedAggregateRel.NONE(child=HepRelVertex#11487,expr#0..1={inputs},expr#2=SUM($t1) OVER (ORDER BY $t0 ROWS BETWEEN CURRENT ROW AND CURRENT ROW),EXPR$0=$t2); see trace for partially optimized plan
  at net.sf.farrago.resource.FarragoResource$_Def0.ex(FarragoResource.java:1497)
  at net.sf.farrago.query.FarragoPreparingStmt.optimize(FarragoPreparingStmt.java:706)
  at org.eigenbase.oj.stmt.OJPreparingStmt.prepareSql(OJPreparingStmt.java:299)
  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.SqlOperatorTests.testWindow(SqlOperatorTests.java:2347)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
  at junit.extensions.TestSetup$1.protect(TestSetup.java:23)
  at junit.extensions.TestSetup.run(TestSetup.java:27)
  at com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
  Caused by: net.sf.farrago.jdbc.FarragoJdbcUtil$FarragoSqlException: Optimizer failed to find a valid physical implementation for relational expression rel#11473:WindowedAggregateRel.NONE(child=HepRelVertex#11487,expr#0..1={inputs},expr#2=SUM($t1) OVER (ORDER BY $t0 ROWS BETWEEN CURRENT ROW AND CURRENT ROW),EXPR$0=$t2); see trace for partially optimized plan
  ... 42 more
  
  
  java.lang.RuntimeException: net.sf.farrago.jdbc.FarragoJdbcUtil$FarragoSqlException: java.lang.AssertionError: Internal error: cannot implement COUNT()
  at org.eigenbase.util.Util.newInternal(Util.java:785)
  at com.disruptivetech.farrago.rel.CalcRelSplitter.chooseLevels(CalcRelSplitter.java:322)
  at com.disruptivetech.farrago.rel.CalcRelSplitter.execute(CalcRelSplitter.java:123)
  at com.disruptivetech.farrago.rel.FarragoAutoCalcRule.onMatch(FarragoAutoCalcRule.java:212)
  at org.eigenbase.relopt.AbstractRelOptPlanner.fireRule(AbstractRelOptPlanner.java:247)
  at org.eigenbase.relopt.hep.HepPlanner.applyRule(HepPlanner.java:439)
  at org.eigenbase.relopt.hep.HepPlanner.applyRules(HepPlanner.java:340)
  at org.eigenbase.relopt.hep.HepPlanner.executeInstruction(HepPlanner.java:210)
  at org.eigenbase.relopt.hep.HepInstruction$RuleInstance.execute(HepInstruction.java:136)
  at org.eigenbase.relopt.hep.HepPlanner.executeProgram(HepPlanner.java:158)
  at org.eigenbase.relopt.hep.HepPlanner.findBestExp(HepPlanner.java:144)
  at org.eigenbase.oj.stmt.OJPreparingStmt.optimize(OJPreparingStmt.java:334)
  at net.sf.farrago.query.FarragoPreparingStmt.optimize(FarragoPreparingStmt.java:679)
  at org.eigenbase.oj.stmt.OJPreparingStmt.prepareSql(OJPreparingStmt.java:299)
  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.checkType(FarragoSqlOperatorsSuite.java:331)
  at net.sf.farrago.test.FarragoSqlOperatorsSuite$FarragoSqlTester.checkType(FarragoSqlOperatorsSuite.java:156)
  at org.eigenbase.sql.test.SqlOperatorTests.testCountFunc(SqlOperatorTests.java:2475)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
  at junit.extensions.TestSetup$1.protect(TestSetup.java:23)
  at junit.extensions.TestSetup.run(TestSetup.java:27)
  at com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
  Caused by: net.sf.farrago.jdbc.FarragoJdbcUtil$FarragoSqlException: java.lang.AssertionError: Internal error: cannot implement COUNT()
  ... 53 more
  
  
  java.lang.RuntimeException: net.sf.farrago.jdbc.FarragoJdbcUtil$FarragoSqlException: java.lang.AssertionError: Internal error: cannot implement SUM($t1)
  at org.eigenbase.util.Util.newInternal(Util.java:785)
  at com.disruptivetech.farrago.rel.CalcRelSplitter.chooseLevels(CalcRelSplitter.java:322)
  at com.disruptivetech.farrago.rel.CalcRelSplitter.execute(CalcRelSplitter.java:123)
  at com.disruptivetech.farrago.rel.FarragoAutoCalcRule.onMatch(FarragoAutoCalcRule.java:212)
  at org.eigenbase.relopt.AbstractRelOptPlanner.fireRule(AbstractRelOptPlanner.java:247)
  at org.eigenbase.relopt.hep.HepPlanner.applyRule(HepPlanner.java:439)
  at org.eigenbase.relopt.hep.HepPlanner.applyRules(HepPlanner.java:340)
  at org.eigenbase.relopt.hep.HepPlanner.executeInstruction(HepPlanner.java:210)
  at org.eigenbase.relopt.hep.HepInstruction$RuleInstance.execute(HepInstruction.java:136)
  at org.eigenbase.relopt.hep.HepPlanner.executeProgram(HepPlanner.java:158)
  at org.eigenbase.relopt.hep.HepPlanner.findBestExp(HepPlanner.java:144)
  at org.eigenbase.oj.stmt.OJPreparingStmt.optimize(OJPreparingStmt.java:334)
  at net.sf.farrago.query.FarragoPreparingStmt.optimize(FarragoPreparingStmt.java:679)
  at org.eigenbase.oj.stmt.OJPreparingStmt.prepareSql(OJPreparingStmt.java:299)
  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.checkType(FarragoSqlOperatorsSuite.java:331)
  at net.sf.farrago.test.FarragoSqlOperatorsSuite$FarragoSqlTester.checkType(FarragoSqlOperatorsSuite.java:156)
  at org.eigenbase.sql.test.SqlOperatorTests.testSumFunc(SqlOperatorTests.java:2533)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
  at junit.extensions.TestSetup$1.protect(TestSetup.java:23)
  at junit.extensions.TestSetup.run(TestSetup.java:27)
  at com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
  Caused by: net.sf.farrago.jdbc.FarragoJdbcUtil$FarragoSqlException: java.lang.AssertionError: Internal error: cannot implement SUM($t1)
  ... 53 more
  
  
  java.lang.RuntimeException: net.sf.farrago.jdbc.FarragoJdbcUtil$FarragoSqlException: java.lang.AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes:
  validated type:
  RecordType(INTEGER EXPR$0) NOT NULL
  converted type:
  RecordType(BIGINT EXPR$0) NOT NULL
  rel:
  ProjectRel(EXPR$0=[$0])
    ProjectRel(EXPR$0=[CASE(=(COUNT(CAST(null):INTEGER), 0), CAST(null):INTEGER, /(SUM(CAST(null):INTEGER), COUNT(CAST(null):INTEGER)))])
      OneRowRel
  
  at org.eigenbase.util.Util.newInternal(Util.java:785)
  at org.eigenbase.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:233)
  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.checkType(FarragoSqlOperatorsSuite.java:331)
  at net.sf.farrago.test.FarragoSqlOperatorsSuite$FarragoSqlTester.checkType(FarragoSqlOperatorsSuite.java:156)
  at org.eigenbase.sql.test.SqlOperatorTests.testAvgFunc(SqlOperatorTests.java:2572)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
  at junit.extensions.TestSetup$1.protect(TestSetup.java:23)
  at junit.extensions.TestSetup.run(TestSetup.java:27)
  at com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
  Caused by: net.sf.farrago.jdbc.FarragoJdbcUtil$FarragoSqlException: java.lang.AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes:
  validated type:
  RecordType(INTEGER EXPR$0) NOT NULL
  converted type:
  RecordType(BIGINT EXPR$0) NOT NULL
  rel:
  ProjectRel(EXPR$0=[$0])
    ProjectRel(EXPR$0=[CASE(=(COUNT(CAST(null):INTEGER), 0), CAST(null):INTEGER, /(SUM(CAST(null):INTEGER), COUNT(CAST(null):INTEGER)))])
      OneRowRel
  
  ... 42 more
  
  
  java.lang.RuntimeException: net.sf.farrago.jdbc.FarragoJdbcUtil$FarragoSqlException: java.lang.AssertionError: Internal error: cannot implement LAST_VALUE($t1)
  at org.eigenbase.util.Util.newInternal(Util.java:785)
  at com.disruptivetech.farrago.rel.CalcRelSplitter.chooseLevels(CalcRelSplitter.java:322)
  at com.disruptivetech.farrago.rel.CalcRelSplitter.execute(CalcRelSplitter.java:123)
  at com.disruptivetech.farrago.rel.FarragoAutoCalcRule.onMatch(FarragoAutoCalcRule.java:212)
  at org.eigenbase.relopt.AbstractRelOptPlanner.fireRule(AbstractRelOptPlanner.java:247)
  at org.eigenbase.relopt.hep.HepPlanner.applyRule(HepPlanner.java:439)
  at org.eigenbase.relopt.hep.HepPlanner.applyRules(HepPlanner.java:340)
  at org.eigenbase.relopt.hep.HepPlanner.executeInstruction(HepPlanner.java:210)
  at org.eigenbase.relopt.hep.HepInstruction$RuleInstance.execute(HepInstruction.java:136)
  at org.eigenbase.relopt.hep.HepPlanner.executeProgram(HepPlanner.java:158)
  at org.eigenbase.relopt.hep.HepPlanner.findBestExp(HepPlanner.java:144)
  at org.eigenbase.oj.stmt.OJPreparingStmt.optimize(OJPreparingStmt.java:334)
  at net.sf.farrago.query.FarragoPreparingStmt.optimize(FarragoPreparingStmt.java:679)
  at org.eigenbase.oj.stmt.OJPreparingStmt.prepareSql(OJPreparingStmt.java:299)
  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.checkScalarExact(AbstractSqlTester.java:150)
  at org.eigenbase.sql.test.SqlOperatorTests.testLastValueFunc(SqlOperatorTests.java:2595)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
  at junit.extensions.TestSetup$1.protect(TestSetup.java:23)
  at junit.extensions.TestSetup.run(TestSetup.java:27)
  at com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
  Caused by: net.sf.farrago.jdbc.FarragoJdbcUtil$FarragoSqlException: java.lang.AssertionError: Internal error: cannot implement LAST_VALUE($t1)
  ... 54 more
  
  
  Process finished with exit code -1
  
  java.lang.RuntimeException: net.sf.farrago.jdbc.FarragoJdbcUtil$FarragoSqlException: java.lang.AssertionError: Internal error: cannot implement FIRST_VALUE($t1)
  at org.eigenbase.util.Util.newInternal(Util.java:785)
  at com.disruptivetech.farrago.rel.CalcRelSplitter.chooseLevels(CalcRelSplitter.java:322)
  at com.disruptivetech.farrago.rel.CalcRelSplitter.execute(CalcRelSplitter.java:123)
  at com.disruptivetech.farrago.rel.FarragoAutoCalcRule.onMatch(FarragoAutoCalcRule.java:212)
  at org.eigenbase.relopt.AbstractRelOptPlanner.fireRule(AbstractRelOptPlanner.java:247)
  at org.eigenbase.relopt.hep.HepPlanner.applyRule(HepPlanner.java:439)
  at org.eigenbase.relopt.hep.HepPlanner.applyRules(HepPlanner.java:340)
  at org.eigenbase.relopt.hep.HepPlanner.executeInstruction(HepPlanner.java:210)
  at org.eigenbase.relopt.hep.HepInstruction$RuleInstance.execute(HepInstruction.java:136)
  at org.eigenbase.relopt.hep.HepPlanner.executeProgram(HepPlanner.java:158)
  at org.eigenbase.relopt.hep.HepPlanner.findBestExp(HepPlanner.java:144)
  at org.eigenbase.oj.stmt.OJPreparingStmt.optimize(OJPreparingStmt.java:334)
  at net.sf.farrago.query.FarragoPreparingStmt.optimize(FarragoPreparingStmt.java:679)
  at org.eigenbase.oj.stmt.OJPreparingStmt.prepareSql(OJPreparingStmt.java:299)
  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.checkScalarExact(AbstractSqlTester.java:150)
  at org.eigenbase.sql.test.SqlOperatorTests.testFirstValueFunc(SqlOperatorTests.java:2608)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
  at junit.extensions.TestSetup$1.protect(TestSetup.java:23)
  at junit.extensions.TestSetup.run(TestSetup.java:27)
  at com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
  Caused by: net.sf.farrago.jdbc.FarragoJdbcUtil$FarragoSqlException: java.lang.AssertionError: Internal error: cannot implement FIRST_VALUE($t1)
  ... 54 more
  
  

[dynamobi-build]

[author="jvs", created="Mon, 21 Aug 2006 00:16:35 -0500 (GMT-05:00)"] See my question on FRG-170 regarding state of SQL/OLAP in vanilla Farrago.

The failure due to "Conversion to relational algebra failed to preserve datatypes" is a separate problem; see FRG-181.