[IGNITE-12976] Invalid SQL syntax for NULLS LAST / NULLS FIRST in IgniteQueryGenerator

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 2.8
• Component/s: spring
• Assignee: Unassigned
• Reporter: Mikhail Kostyuckovich
• Created: 01/May/20 14:33
• Updated: 11/May/20 20:28

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 ...

 

Issue Links

• links to: GitHub PR #7766