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

Error querying unbounded numrange #233

Closed
eliseuvideira opened this issue Mar 9, 2020 · 2 comments
Closed

Error querying unbounded numrange #233

eliseuvideira opened this issue Mar 9, 2020 · 2 comments

Comments

@eliseuvideira
Copy link

Hi, my name is Eliseu.
I'm getting an error on azuredatastudio when I run any query on postgresql using unbounded numrange type.
Examples:
SELECT numrange(1, NULL);

SELECT numrange(NULL, 1);

SELECT numrange(NULL, NULL);

SELECT '(,1]'::numrange;

SELECT '[1,)'::numrange;

CREATE TABLE test (
field1 numrange
);
INSERT INTO test (field1) VALUES (numrange(1, NULL))
SELECT * FROM test;

all these querys throw the same error:
Unhandled exception while executing query: int() argument must be a string, a bytes-like object or a number, not 'NoneType'

I tested and they all work on psql, postbird, dbeaver.

I'm using the version 0.2.4 of the extension and version 1.15.1 of azure data studio.

The postgres I'm using is the official docker image (https://hub.docker.com/_/postgres)

This error repeated in 3 different machines (two running linux, one with windows) I've seem so far.

Let me know if more information is needed

error-azuredatastudio

@swjain23 swjain23 transferred this issue from microsoft/azuredatastudio-postgresql Mar 10, 2020
@swjain23
Copy link
Contributor

Hi Eliseu,

This issue has been fixed by this PR: #231. It will be part of our next deployment and should be fixed.

@eliseuvideira
Copy link
Author

Excellent
Thanks for answering.
Keep up the good work!

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

No branches or pull requests

2 participants