qazxcdswe123 commented on issue #15291:
URL: https://github.com/apache/datafusion/issues/15291#issuecomment-2735134447
@alamb On head commit.
```csv
col_int32,col_int64,col_uint32,col_utf8
1,1,0,a
2,2,1,b
3,3,2,c
4,4,3,d
5,5,4,e
6,6,5,f
7,7,6,g
8,8,7,h
9,9,8,i
10,10,9,j
```
```
> PREPARE req(BIGINT) AS
WITH aggregations_group AS (
SELECT
count(col_utf8) FILTER (WHERE $1 - 1 <= col_int64) as
foo,
count(col_utf8) FILTER (WHERE $1 - 2 <= col_int64 AND
col_uint32 >= 0) as bar,
count(col_utf8) FILTER (WHERE $1 - 2 <= col_int64 AND
col_uint32 >= 0 AND col_uint32 >= 0) as baz
FROM test
)
SELECT * FROM aggregations_group;
0 row(s) fetched.
Elapsed 0.010 seconds.
> EXECUTE req(42);
+-----+-----+-----+
| foo | bar | baz |
+-----+-----+-----+
| 0 | 0 | 0 |
+-----+-----+-----+
1 row(s) fetched.
Elapsed 0.016 seconds.
> EXECUTE req(1);
+-----+-----+-----+
| foo | bar | baz |
+-----+-----+-----+
| 10 | 10 | 10 |
+-----+-----+-----+
1 row(s) fetched.
Elapsed 0.025 seconds.
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
