Datastore to_tsquery Numeric Prefixing Does Not Work Well #7916
JVickery-TBS
started this conversation in
Ideas
Replies: 1 comment
-
I'm not seeing that straight in the database:
So what's happening here is that the tsvector is tokenizing to |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
CKAN version
2.9+ (and master branch)
Describe the bug
Datatables view uses prefixed Full Text Search to the Datastore, which builds the
to_tsquery
. This works perfectly fine, but if you are searching with a value that begins with a number, it returns unexpected results.Steps to reproduce
Steps to reproduce the behavior:
example:
01-2019-2020-Q4
2020-Q4
does NOT return this row0-Q4
DOES return this rowIt is pretty strange behavior, I personally could not figure out how this database stuff worked.
Expected behavior
Search results come back consistently
Beta Was this translation helpful? Give feedback.
All reactions