[Mondrian] Forcing "expr direction NULLS LAST" in order by without rebuild?

Jesús Barrasa jbarrasa at outlook.com
Mon Apr 7 07:28:38 EDT 2014


Hi,
I would like to force the use of ANSI syntax ("expr direction NULLS LAST") in the ORDER BY of the SQL generated by Mondrian because my database does not support the default ORDER BY syntax (with a CASE expression in it). 
I see that there is actually an alternative implementation "generateOrderByNullsAnsi" for the generation of the ORDER BY in the JdbcDialectImpl class that produces the desired output. 
Is there an alternative to writing an implementation of the Dialect interface and rebuilding the source? 

Cheers,

J. Barrasa
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20140407/a6b21751/attachment.html 


More information about the Mondrian mailing list