Ummm... both substring and locate are registered by the base Dialect class.
Still, you can probably import a lot from MsSqlxxxxDialect.
A patch will be welcome (don't forget the tests)
Diego
On Mon, Jun 6, 2011 at 17:58, Rory Plaire <[email protected]> wrote:
> Greetings -
>
> This weekend I needed to write a HQL query which relied on SQL functions to
> search in some text. I found the 'substring' and 'locate' HQL functions and
> then found that SQL CE's dialect didn't work with these because these
> functions are not registered in that dialect. In fact, _no_ functions are
> registered in that dialect.
>
> I created a custom dialect and added all the SQL Server functions which CE
> supports and after doing this, the HQL query worked very well.
>
> Does anyone know if this is just missing functionality, or was there a
> deliberate reason to leave out SQL functions from CE? If it's missing, I
> could just add a JIRA ticket and submit a patch...
>
> -rory
>
