mohayu22 commented on PR #895:
URL: https://github.com/apache/age/pull/895#issuecomment-1539059083
@jrgemignani While testing for potential cases to be added in this PR, I
discovered that the code works correctly for all the new cases except for the
function agtype_in. The reason it was failing is that this function only checks
for the types `::integer`, `::float`, and `::numeric`. It does not handle
`::int`, `::pg_float8`, or `::pg_bigint`.
```
SELECT agtype_in('"124"::integer');
agtype_in
-----------
124
(1 row)
SELECT agtype_in('"124"::int');
ERROR: invalid annotation value for scalar
SELECT agtype_in('"124"::pg_bigint');
ERROR: invalid annotation value for scalar
SELECT agtype_in('"12.4"::float');
agtype_in
-----------
12.4
(1 row)
SELECT agtype_in('"12.4"::pg_float8');
ERROR: invalid annotation value for scalar
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
