[BUG]

[makselivanov]

Describe the bug

• Have you validated that this is not currently reported in
  SQL Support and Limitations?

Steps to Reproduce

• Is the JDBC Driver being used in a BI tool?

I am using 1.1.0 version JDBC with SQL language and connect to Janusgraph Server. I use gremlin version 3.5.3(I change code a little bit for it, only some imports) and java 1.8.0 openjdk.

Problem for Janusgraph that id of edge is RelationIdentifier, which is not Comparable. Because of it, you cant write something like g.E().order(__.unfold().id())

Expected behavior

Dont use order(__.unfold().id) by default

Screenshots

Environment

OS: Ubuntu 20.04

Additional Context

I suggest in file GremlinSqlSelectSingle add order to traversal if only driver get ORDER BY in SQL query