Re: [Hsqldb-developers] Order by which supports database defaults for nulls last

[Fred T. <fr...@us...>]

Hi Jean-Noel,

Thanks for sharing the patch. The default NULLS LAST is a useful
enhancements.

The correct place to implement this feature is in the ParserDQL, which I
have done and committed to SVN /base/trunk. The SQL setting for DB2
compatibility mode has also been added, to be used for future syntax
compatibility features.

Default null ordering is controlled with a new setting, SET DATABASE SQL
NULLS FIRST { TRUE | FALSE } and the connection property
sql.nulls_first.

You can modify ParserDQL further to use NULLS LAST by default for the
three dialects.

Fred Toussi

On Friday, December 02, 2011 8:49 AM, "Jean-Noël Rouvignac"
<jnrouvignac@InformationMosaic.com> wrote:
> 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: 'hsq...@li...' 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
> ______________________________________________________________________
> ----------------------------------------------------------------------
> --------
> 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 hsq...@li...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
>
> Email had 1 attachment:
> + orderBySupportsDatabaseDefaultsForNullsLast v2.patch 17k (application/octet-
>   stream)