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

[YSQL] RANGE with offset PRECEDING/FOLLOWING is not supported for column type numeric and offset type double #10692

Open
tedyu opened this issue Nov 24, 2021 · 0 comments
Labels
area/ysql Yugabyte SQL (YSQL) kind/bug This issue is a bug pgcm priority/medium Medium priority issue

Comments

@tedyu
Copy link
Contributor

tedyu commented Nov 24, 2021

Jira Link: DB-1099

Description

This query:

select id, f_numeric, first_value(id) over w, last_value(id) over w
from numerics
window w as (order by f_numeric range between
             1 preceding and 1.1::float8 following);

produces the following error:

ERROR:  RANGE with offset PRECEDING/FOLLOWING is not supported for column type numeric and offset type double precision
LINE 4:              1 preceding and 1.1::float8 following);
                                     ^
@tedyu tedyu added the area/ysql Yugabyte SQL (YSQL) label Nov 24, 2021
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Jun 8, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL) kind/bug This issue is a bug pgcm priority/medium Medium priority issue
Projects
Status: No status
Development

No branches or pull requests

3 participants