[
https://issues.apache.org/jira/browse/TINKERPOP-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel closed TINKERPOP-2721.
----------------------------
Resolution: Not A Problem
> Order by handling null values as filter
> ---------------------------------------
>
> Key: TINKERPOP-2721
> URL: https://issues.apache.org/jira/browse/TINKERPOP-2721
> Project: TinkerPop
> Issue Type: Bug
> Components: process
> Affects Versions: 3.6.0
> Reporter: Pavel
> Priority: Major
>
> Snippet
> {code}
> public static void main(String[] args) throws Exception {
> final TinkerGraph g = TinkerGraph.open();
> g.traversal()
> .addV("V")
> .property("name", "n1")
> .addV("V")
> .property("name", "v2")
> .property("date", Instant.now())
> .iterate();
>
> System.out.println(g.traversal().V().order().by(__.id()).valueMap("name").toList());
>
> System.out.println(g.traversal().V().order().by("date").valueMap("name").toList());
> System.out.println(g.traversal().V()
> .project("name", "date")
> .by("name").by("date")
> .order().by("date").toList());
> System.out.println(g.traversal().V().group().by("date").toList());
> g.close();
> }
> {code}
> 3.5.3-SNAPSHOT
> {code}
> [{id=0, label=V, name=n1}, {id=2, label=V, date=2022-03-16T12:53:19.038763Z,
> name=v2}]
> [{id=0, label=V, name=n1}, {id=2, label=V, date=2022-03-16T12:53:19.038763Z,
> name=v2}]
> [{name=n1, date=null}, {name=v2, date=2022-03-16T12:53:19.038763Z}]
> [{null=[v[0]], 2022-03-16T12:53:19.038763Z=[v[2]]}]
> {code}
> 3.6.0-SNAPSHOT
> {code}
> [{id=0, label=V, name=n1}, {id=2, label=V, date=2022-03-16T12:54:25.005772Z,
> name=v2}]
> [{id=2, label=V, date=2022-03-16T12:54:25.005772Z, name=v2}]
> [{name=n1}, {name=v2, date=2022-03-16T12:54:25.005772Z}]
> [{2022-03-16T12:54:25.005772Z=[v[2]]}]
> {code}
> But SQL does not filter out of null value during order by clause
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
