search

Cascading / lingual

Stand-alone ANSI SQL for Cascading on Apache Hadoop
http://www.cascading.org/lingual/
48 stars 17 forks source link

Self left join problems in Optiq #4

Closed rdelbru closed 11 years ago

rdelbru commented 11 years ago

Here is a set of unit tests showing different issues from Optiq when self left joins are used. The first unit test, testSelfLeftJoin1, returns a class cast exception. The second unit test, testSelfLeftJoin2, returns a StackOverflowError. The third unit test, testSelfLeftJoin3, returns an array IndexOutOfBoundException.

rdelbru commented 11 years ago

I have checked again this unit test with the latest snapshot of wip-1.0, and I now get a NPE:

java.lang.NullPointerException
    at org.eigenbase.sql.validate.SqlValidatorUtil.checkCharsetAndCollateConsistentIfCharType(SqlValidatorUtil.java:147)
    at org.eigenbase.sql.type.SqlTypeUtil.addCharsetAndCollation(SqlTypeUtil.java:1178)
    at org.eigenbase.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:4324)
    at org.eigenbase.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:4225)
    at org.eigenbase.sql.SqlIdentifier.accept(SqlIdentifier.java:266)
    at org.eigenbase.sql.validate.SqlValidatorImpl.deriveTypeImpl(SqlValidatorImpl.java:1503)
    at org.eigenbase.sql.validate.SqlValidatorImpl.deriveType(SqlValidatorImpl.java:1485)
    at org.eigenbase.sql.type.SqlTypeStrategies$17.inferOperandTypes(SqlTypeStrategies.java:1270)
cwensel commented 11 years ago

These should be resolved in the latest wip. we merged the above tests and they currently pass.