Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Regression: "Internal error: Only intervals with the same data type are comparable, lhs:Float32, rhs:UInt64." #13186

Closed
alamb opened this issue Oct 30, 2024 · 0 comments · Fixed by #13187
Assignees
Labels
bug Something isn't working regression Something that used to work no longer does

Comments

@alamb
Copy link
Contributor

alamb commented Oct 30, 2024

Describe the bug

There is a bug in calculating filter statistics that results in an internal error

To Reproduce

Reproducer

create table cpu (time timestamp, usage_idle float, usage_user float, cpu int);
insert into cpu values ('1970-01-01 00:00:00', 1.0, 2.0, 3);
copy (select * from cpu) to '/tmp/foo.parquet';

select time, rn
from (
  select time, row_number() OVER (ORDER BY usage_idle, time) as rn
  from '/tmp/foo.parquet'
  where cpu = 3
) where rn > 0;

Results in

ProjectionPushdown
caused by
Internal error: Only intervals with the same data type are comparable, lhs:Float32, rhs:UInt64.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker

Expected behavior

I expect it to produce a row:

+---------------------+----+
| time                | rn |
+---------------------+----+
| 1970-01-01T00:00:00 | 1  |
+---------------------+----+
1 row(s) fetched.

Additional context

We found a bug with some of our internal tests in InfluxDB 3.0

I believe this is a regression introduced by 4659096 / #12281 which added a projection to FilterExec

However, as the projection is not applied to the statistics, the reported output schema and statistics are inconsistent which causes issues upstream.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working regression Something that used to work no longer does
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant