Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
4.3.0
-
None
-
None
Description
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;