[ 
https://issues.apache.org/jira/browse/IGNITE-12976?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mikhail Kostyuckovich updated IGNITE-12976:
-------------------------------------------
    Description: 
Ignite Spring Data's {{IgniteQueryGenerator}} (in all {{spring-data}} / 
{{spring-data-2.0}} / {{spring-data-2.2}} 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 ...}}

 

  was:
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 ...}}

 


> 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
>            Priority: Minor
>
> Ignite Spring Data's {{IgniteQueryGenerator}} (in all {{spring-data}} / 
> {{spring-data-2.0}} / {{spring-data-2.2}} 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)

Reply via email to