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

Parse error when using JSON_modifier_list with JSON_scalar_modifier #37

Open
PhilippSalvisberg opened this issue Jul 1, 2024 · 1 comment
Assignees
Labels
23.4 bug Something isn't working

Comments

@PhilippSalvisberg
Copy link
Collaborator

PhilippSalvisberg commented Jul 1, 2024

The following use of JSON_modifier_list works:

select cast('[1,2,3]' as json) is json value;
select cast('[1,2,3]' as json) is json object;
select cast('[1,2,3]' as json) is json array;
select cast('[1,2,3]' as json) is json (array, object, value);
select cast('[1,2,3]' as json) is json scalar;

However, when using a JSON_scalar_modifier a syntax error is produced:

select cast('1' as json) is json scalar number;
select cast('2' as json) is json scalar string;
select cast('3' as json) is json scalar binary_double;
select cast('4' as json) is json (scalar binary_double, scalar number, scalar string);
@PhilippSalvisberg PhilippSalvisberg added the bug Something isn't working label Jul 1, 2024
@PhilippSalvisberg
Copy link
Collaborator Author

Functionality worked in 23.3 but was not documented in F47038-0 which was the basis for the implementation. Hence I tag it with 23.4

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

No branches or pull requests

2 participants