[
https://issues.apache.org/jira/browse/PHOENIX-2105?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maryann Xue updated PHOENIX-2105:
---------------------------------
Fix Version/s: 4.4.0
> 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
> Fix For: 4.4.0
>
> 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)
