[jira] [Created] (TINKERPOP-2721) Order by handling null values as filter

["Pavel (Jira)" <ji...@apache.org>]

Pavel created TINKERPOP-2721:
--------------------------------

             Summary: 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


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)