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

extract_json_value fails with negative value #50

Open
GoogleCodeExporter opened this issue Jun 18, 2015 · 1 comment
Open

extract_json_value fails with negative value #50

GoogleCodeExporter opened this issue Jun 18, 2015 · 1 comment

Comments

@GoogleCodeExporter
Copy link

Which version of common_schema are you using? (specify
revision+distribution)
2.2 523
Which component is failing? (specify the view, function, etc.)
select extract_json_value('{"test":"-2"}','/test'); fails returning NULL
but remove the negative and the function works.
select extract_json_value('{"test":"2"}','/test');

What is the expected output? What do you see instead?
Expect to see 2 instead of NULL

Can you provide with sample data?

(As of version 1.1), please provide output of
SELECT * FROM common_schema.status

Please provide any additional information below.
I do not have the entire common_schema installed as I don't have permission in 
my VPS but I have installed the following functions/procedures
get_json_token
encode_xml
extract_json_value
json_to_xml
trim_wspace
unquote



Original issue reported on code.google.com by [email protected] on 29 Nov 2013 at 2:47

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant