SQL-2003 regexp rules are certainly hard to understand, and I am not sure how many vendors are supporting it fully. There should be many Java programs that query a DB using regexp patterns; however I was not able to find an open source translator between SQL regexp and Java version.<br>
<br>As for LucidDB, the plugin is a good idea- saves the headache of LucidDB having to translate SQL regexp back to the Java one!<br><br>Rushan<br><br><div class="gmail_quote">On Fri, Apr 17, 2009 at 2:01 PM, John V. Sichi <span dir="ltr"><<a href="mailto:jsichi@gmail.com">jsichi@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">Rushan wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Note that the only dimension filter considered at this point is In/Not In. There are other candidates such as Matches/Not Matches filter. I punted on this one because DBs have different levels of SQL regexp support. Some are buggy such as LucidDB.<br>
</blockquote>
<br></div>
For MATCHES, another way to do it would be to allow vendors to plug something in via the dialect, since I doubt very many DBMS products are ever going to implement the bizarre SQL:2003 mishmash convention of regular expressions and LIKE patterns ('%' for '.*', '_' for '.').<br>
<br>
So, for example, we could require the DBMS to be capable of processing a regular expression directly (instead of a SQL:2003 pattern). In the case of LucidDB, that can be done with a UDF wrapping java.util.regex as described here:<br>
<br>
<a href="http://pub.eigenbase.org/wiki/LucidDbUdfJavaHowto" target="_blank">http://pub.eigenbase.org/wiki/LucidDbUdfJavaHowto</a><br>
<br>
Other DB's may have native regex-processing capabilities. A sticking point might be that there are a number of different conventions for regex patterns across languages/libraries.<br>
<br>
JVS<br>
<br>
_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
</blockquote></div><br>