ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mikhail Kostyuckovich (Jira)" <j...@apache.org>
Subject [jira] [Updated] (IGNITE-12976) Invalid SQL syntax for NULLS LAST / NULLS FIRST in IgniteQueryGenerator
Date Fri, 01 May 2020 15:11:00 GMT

     [ 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)

Mime
View raw message