Phasheng opened a new issue, #2201:
URL: https://github.com/apache/age/issues/2201
**Describe the bug**
I observed an unexpected behavior in Apache AGE when using empty strings
('') as arguments in string functions such as toLower. According to the
documentation, toLower(NULL) returns NULL, which is expected. However, when
passing an empty string '' as the argument inside the function, the result is
unexpectedly NULL. In contrast, when directly checking if '' IS NULL, it
correctly returns false.
**How are you accessing AGE (Command line, driver, etc.)?**
- Command line
**What is the command that caused the error?**
```pgsql
SELECT * FROM cypher('test_graph', $$
RETURN toLower('') IS NULL AS ref0
$$) AS (ref0 agtype);
-- Result: true
SELECT * FROM cypher('test_graph', $$
RETURN '' IS NULL AS ref0
$$) AS (ref0 agtype);
-- Result: false
```
**Expected behavior**
The two queries executed above should both return false.
**Environment (please complete the following information):**
- Version: latest in docker hub
--
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]
