phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maryann Xue (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2105) Changing order of tables in from clause causing "Expected length of at least 8 bytes, but had 1"
Date Tue, 14 Jul 2015 15:33:05 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-2105?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14626486#comment-14626486
] 

Maryann Xue commented on PHOENIX-2105:
--------------------------------------

It was caused by incorrect wrapping of RoundDecimalExpression during compilation of cast node.
It has been fixed by the check-in for PHOENIX-1489:
https://git1-us-west.apache.org/repos/asf?p=phoenix.git;a=commitdiff;h=3f829751dd5158c526e5c5bd3da61dde1c6e4194#patch7

> Changing order of tables in from clause causing "Expected length of at least 8 bytes,
but had 1"
> ------------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-2105
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2105
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.3.0
>            Reporter: Brian Toal
>         Attachments: repro.sql
>
>
> Today I came across the following issue with the query below. The query fails with the
following error. However if you change the order of the inline query and 'profiler.sample
sample' line, the query works fine. I don't think the order should matter.
> Error: ERROR 201 (22000): Illegal data. Expected length of at least 8 bytes, but had
1
> SQLState: 22000
> ErrorCode: 201
> select
> sample.stack_id,
> count(*)
> from 
> (
> select
> distinct s.id
> from
> profiler.frame f,
> profiler.stack s
> where
> f.package = 'foo' and
> f.class = 'Bar' and
> f.method = 'baz()' and
> f.id = s.frame_id
> ) s,
> profiler.sample sample
> where 
> sample.timestamp between 0 and 9999999999999999 and
> sample.stack_id = s.id
> group by
> sample.stack_id;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message