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

[Bug] abscissa type not supported, from sqlancer test #317

Open
1 of 2 tasks
congxuebin opened this issue Nov 29, 2023 · 2 comments
Open
1 of 2 tasks

[Bug] abscissa type not supported, from sqlancer test #317

congxuebin opened this issue Nov 29, 2023 · 2 comments
Labels
type: Bug Something isn't working

Comments

@congxuebin
Copy link
Collaborator

congxuebin commented Nov 29, 2023

Cloudberry Database version

No response

What happened

Request to confirm if it is as designed?
BTW, "abscissa type" is vague, if the statement not valid, I believe customer does not know how to fix it according to "abscissa type" error.

UPDATE t0 SET c0 = DEFAULT WHERE (pg_catalog.float8div('2.2946442861439234E-33'::float8, pg_catalog.interval_interval_div(('15:01:06'::time) -(pg_catalog.linear_interpolate(('true') ||('false'), pg_catalog.cash_words(CAST(1.4549639 AS money)), ('209820 day 11 hour 25 min 41 sec'::interval) +('09:05'::time), ('false') ||('true'), ('483158 day 5 hour 20 min 21 sec'::interval) +('00:56:56'::time))), '909172 day 16 hour 39 min 49 sec'::interval))) <(pg_catalog.float8(((-8521399760881100626::numeric) %(1011845922400518285::numeric)) /(pg_catalog.trunc((-5182015971170804306::numeric) ^(4186530105024981936::numeric), 465134229))));

ERROR: abscissa type not supported

What you think should happen instead

No response

How to reproduce

CREATE TABLE t0(c0 date );

UPDATE t0 SET c0 = DEFAULT WHERE (pg_catalog.float8div('2.2946442861439234E-33'::float8, pg_catalog.interval_interval_div(('15:01:06'::time) -(pg_catalog.linear_interpolate(('true') ||('false'), pg_catalog.cash_words(CAST(1.4549639 AS money)), ('209820 day 11 hour 25 min 41 sec'::interval) +('09:05'::time), ('false') ||('true'), ('483158 day 5 hour 20 min 21 sec'::interval) +('00:56:56'::time))), '909172 day 16 hour 39 min 49 sec'::interval))) <(pg_catalog.float8(((-8521399760881100626::numeric) %(1011845922400518285::numeric)) /(pg_catalog.trunc((-5182015971170804306::numeric) ^(4186530105024981936::numeric), 465134229))));

Operating System

centos7

Anything else

No response

Are you willing to submit PR?

  • Yes, I am willing to submit a PR!

Code of Conduct

@congxuebin congxuebin added the type: Bug Something isn't working label Nov 29, 2023
@congxuebin congxuebin changed the title [Bug] abscissa type not supported, from sqlancer Test [Bug] abscissa type not supported, from sqlancer test Nov 29, 2023
@congxuebin
Copy link
Collaborator Author

congxuebin commented Nov 29, 2023

@gfphoenix78 Hi Hao, this is the issue we talked before. I get a simple recreate today. I 'd like to use this issue for tracking this.

@congxuebin
Copy link
Collaborator Author

UPDATE t0 SET c0 = DEFAULT WHERE
(pg_catalog.float8div
('2.2946442861439234E-33'::float8, pg_catalog.interval_interval_div(
(pg_catalog.linear_interpolate(('true'), pg_catalog.cash_words(CAST(1.4549639 AS money)),
('09:05'::time), ('true'),
('00:56:56'::time))), '909172 day 16 hour 39 min 49 sec'::interval)))
<0;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type: Bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant