[TINKERPOP-2721] Order by handling null values as filter

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 3.6.0
• Component/s: process
• Assignee: Unassigned
• Reporter: Pavel
• Created: 16/Mar/22 12:56
• Updated: 17/Mar/22 09:05
• Resolved: 17/Mar/22 09:05

Description

Snippet

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();
    }

3.5.3-SNAPSHOT

[{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]]}]

3.6.0-SNAPSHOT

[{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]]}]

But SQL does not filter out of null value during order by clause