Hello,

I write a new Dialect for die Database Gupta SQLBase. I registry the Database-Functions, with RegisterFunction.

Example:
RegisterFunction("upper", new StandardSQLFunction("@UPPER"));

This Function is working. I see this translation in the "sqlFunctions" object, at the runtime.

Example:
session.Dialect.Funtion["upper"] is "@UPPER".

NHibernate don't translate the HQL-Statement.

Example
SELECT upper(columnXYZ) FROM tableXYZ
the result
SELECT upper(columnXYZ) FROM tableXYZ
it not work. I want the result
SELECT @UPPER(columnXYZ) FROM tableXYZ

I don't find the location how translate the Function in the source code. I have write "RegisterFunction("upper", new StandardSQLFunction("@UPPER")); " in a other Dialect with the self result.

Why don't working the translation?? It this a bug or must I do something before I use the Function "RegisterFunction"??

P.S. sorry, because of my bad English.

With friendly regards
Matthias

I also noticed, that this substitution of function names doesn't work with nhibernate 1.2.1.
You need to register the functions to use them in hql statements (otherwise an exception is thrown). But the function names are not translated.

Hello,

all Dialect Functions (NoArgSQLFunction,...) have the Function "Render". The Function Render translate die SQL-Function. But this Function is never use.

Is this a bug, and working correct in the next version???

Must I do something, to use this Function????

With friendly regards
Matthias

I'm pretty sure it's a bug... or the code is intended to be used in later versions, but prepared in nhibernate 1.2.