SPARQL Regex using the modifier "i" crashes using AWS Redshift as data source

26 views
Skip to first unread message

Ste fan

unread,
Aug 15, 2023, 9:36:24 AM8/15/23
to ontop4obda
Hello :)

I recently opened a bug ticket: https://github.com/ontop/ontop/issues/738
But maybe I'm doing things super wrong.
The issue is since I'm using the "i" modifier in my regex command e.g.
"FILTER (regex(str(?value), "1234", "i"))"
I'm getting the Error:
"ERROR in i.u.i.o.a.c.impl.QuestStatement - com.amazon.redshift.util.RedshiftException: ERROR: Invalid preceding regular expression prior to repetition operator. The error occurred while parsing the regular expression: '(?>>>HERE>>>i)1234'."
It works fine without the "i" flag.
Does anyone has an idea how I could avoid the error without changing the SPARQL query?

Regards Stefan

Benjamin Cogrel

unread,
Aug 22, 2023, 3:30:25 PM8/22/23
to Ste fan, ontop4obda
Hi Stefan,

Thanks for reporting the issue. It should be fixed now: https://github.com/ontop/ontop/pull/745 .

Best,
Benjamin

--
Please follow our guidelines on how to report a bug https://ontop-vkg.org/community/contributing/bug-report
---
You received this message because you are subscribed to the Google Groups "ontop4obda" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ontop4obda+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ontop4obda/988e5de4-0226-43b8-b7e9-0e6585fdc2ccn%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages