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

LOWER() function causes SQL error when providing UUID in filter #33

Open
baronadam0 opened this issue Sep 17, 2024 · 0 comments
Open

LOWER() function causes SQL error when providing UUID in filter #33

baronadam0 opened this issue Sep 17, 2024 · 0 comments

Comments

@baronadam0
Copy link

For the following example filter customer_id eq '55cd8332-a5be-458d-a27c-7387c768b3cd' SQL error ERROR: function lower(uuid) does not exist (SQLSTATE 42883) is raised.

I'm wondering if the LOWER() function is even required for eq and ne operands, as it probably should check for the exact value provided by the API user. I'm not sure if this would fix the issue, but it is possible.

where.WriteString(fmt.Sprintf("LOWER(%s) %s LOWER(%s)", property, filterOperations[operand], value))

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

1 participant