Oops, I forgot to use the new Database.sqlSyntaxDb2 field in SortAndSlice.java This is now included in this new patch.
Thanks, Jean-Noel -----Original Message----- From: Jean-Noël Rouvignac Sent: 02 December 2011 08:40 To: 'hsqldb-developers@lists.sourceforge.net' Subject: Order by which supports database defaults for nulls last Hello, Here is a patch changing the default sorting for nulls when using the order by clause. The patch was generated from hsqldb-2.2.6.zip available on Sourceforge. According to https://hibernate.onjira.com/browse/HHH-465 : In different DBs, the sorting of nulls relative to other values is handled differently. PostgreSQL - Nulls are considered HIGHER than non-nulls. DB2 - Higher MSSQL - Lower MySQL - Lower Oracle - Higher This patch is making sure that when using the Oracle or PostgreSQL, we are using the same ordering for nulls. I also added a Boolean for sqlSyntaxDb2 since I had the information available. I leave it to someone interested to expand on it. Please let me know if this patch is ok with you. Thanks, Jean-Noël Rouvignac ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________
orderBySupportsDatabaseDefaultsForNullsLast v2.patch
Description: orderBySupportsDatabaseDefaultsForNullsLast v2.patch
------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d
_______________________________________________ hsqldb-developers mailing list hsqldb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
