[teiid-issues] [JBoss JIRA] (TEIID-3933) Accumulo translator: problem comparing number literals

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13172391#comment-13172391 ] 

RH Bugzilla Integration commented on TEIID-3933:
------------------------------------------------

Van Halbert <vhalbert at redhat.com> changed the Status of [bug 1301665|https://bugzilla.redhat.com/show_bug.cgi?id=1301665] from MODIFIED to ON_QA

> Accumulo translator: problem comparing number literals
> ------------------------------------------------------
>
>                 Key: TEIID-3933
>                 URL: https://issues.jboss.org/browse/TEIID-3933
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.12.3
>            Reporter: Jan Stastny
>            Assignee: Ramesh Reddy
>             Fix For: 9.0, 8.12.5
>
>
> When accessing Accumulo instance using accumulo translator with table DDL defined in the model's metadata, there are problems filtering the output in from clause.
> For example, when there is a comparison between a column of type long with literal value 3, an exception, whose cause is below, is thrown on accumulo's side:
> {code:sql}
> SELECT * FROM accumulo.SmallA WHERE LongNum>3
> {code}
> {code:plain}
> Caused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.Long
>           at java.lang.Long.compareTo(Long.java:50)
>           at org.teiid.query.sql.symbol.Constant$2.compare(Constant.java:99)
>           at org.teiid.query.eval.Evaluator.compare(Evaluator.java:645)
>           at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:373)
>           at org.teiid.query.eval.Evaluator.internalEvaluateTVL(Evaluator.java:237)
>           at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:226)
>           at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:220)
>           at org.teiid.translator.accumulo.EvaluatorIterator.acceptRow(EvaluatorIterator.java:229)
>           at org.teiid.translator.accumulo.EvaluatorIterator.filter(EvaluatorIterator.java:184)
>           at org.teiid.translator.accumulo.EvaluatorIterator.prepKeys(EvaluatorIterator.java:180)
>           at org.teiid.translator.accumulo.EvaluatorIterator.seek(EvaluatorIterator.java:159)
>           at org.apache.accumulo.core.iterators.WrappingIterator.seek(WrappingIterator.java:101)
>           at org.apache.accumulo.core.iterators.user.VersioningIterator.seek(VersioningIterator.java:81)
>           at org.apache.accumulo.core.iterators.system.SourceSwitchingIterator.readNext(SourceSwitchingIterator.java:116)
>           at org.apache.accumulo.core.iterators.system.SourceSwitchingIterator.seek(SourceSwitchingIterator.java:168)
>           at org.apache.accumulo.server.tabletserver.Tablet.nextBatch(Tablet.java:1737)
>           at org.apache.accumulo.server.tabletserver.Tablet.access$3200(Tablet.java:152)
>           at org.apache.accumulo.server.tabletserver.Tablet$Scanner.read(Tablet.java:1879)
>           at org.apache.accumulo.server.tabletserver.TabletServer$ThriftClientHandler$NextBatchTask.run(TabletServer.java:945)
>           at org.apache.accumulo.trace.instrument.TraceRunnable.run(TraceRunnable.java:47)
> {code}
> but when I provide a value higher, than can be saved in integer, thus the type of the literal is inferred as long, the query runs as expected.
> {code:sql}
> SELECT * FROM accumulo.SmallA WHERE LongNum>30000000000000000000
> {code}
> Similar problems I had with
> ||Column type||Literal||Inferred type||Rootcause message||
> |long|3|Integer|java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.Long|
> |biginteger|3|Integer|java.lang.ClassCastException: java.lang.Integer cannot be cast to java.math.BigInteger|
> |double|3.0|BigDecimal|java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.Double|
> |float|3.0|BigDecimal|java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.Float|
> rest of the cause's stacktrace look the same.
> In Squirrel I get:
> {code:plain}
> TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 node-one: Error on server 127.0.0.1:9997
> {code}



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)