You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@ignite.apache.org by "Mikhail Kostyuckovich (Jira)" <ji...@apache.org> on 2020/05/01 14:34:00 UTC

[jira] [Created] (IGNITE-12976) Invalid SQL syntax for NULLS LAST / NULLS FIRST in IgniteQueryGenerator

Mikhail Kostyuckovich created IGNITE-12976:
----------------------------------------------

             Summary: Invalid SQL syntax for NULLS LAST / NULLS FIRST in IgniteQueryGenerator
                 Key: IGNITE-12976
                 URL: https://issues.apache.org/jira/browse/IGNITE-12976
             Project: Ignite
          Issue Type: Bug
          Components: spring
    Affects Versions: 2.8
            Reporter: Mikhail Kostyuckovich


Ignite Spring Data's {{IgniteQueryGenerator}} (in both {{spring-data}} and {{spring-data-2.0}} modules) generate invalid SQL when null handling other than native is used.

Currently generated query - invalid:

{{SELECT ... ORDER BY ... NULL FIRST ...}}

{{SELECT ... ORDER BY ... NULL LAST ...}}

Expected - valid:

{{SELECT ... ORDER BY ... NULL*S* FIRST ...}}

{{SELECT ... ORDER BY ... NULL*S* LAST ...}}

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)