carloea2 opened a new issue, #8156:
URL: https://github.com/apache/texera/issues/8156
### What happened?
Dashboard search removes whitespace after checking whether keywords are
empty. A whitespace-only keyword therefore survives validation and produces an
empty full-text predicate instead of behaving like an empty search.
Before: whitespace-only query -> `pgroonga_condition('')`
After: whitespace-only query -> no full-text condition
On the local main branch, a request without a query returns 200 while the
same request with three spaces returns 500 during the unnecessary full-text
lookup.
### How to reproduce?
1. Run the current main branch locally.
2. Request `GET /api/dashboard/publicSearch?resourceType=workflow` and
observe HTTP 200.
3. Repeat with `query` set to three spaces.
4. Observe the empty PGroonga condition in the generated SQL and HTTP 500
locally.
### Version/Branch
1.3.0-incubating-SNAPSHOT (main)
### Commit Hash
98588bf2ab49aac65ebf002496eb057670e6fc07
### Relevant log output
where (((COALESCE(...) &@~ pgroonga_condition('', fuzzy_max_distance_ratio
=> 0.34))
--
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]
