Fix test cases with 0.9.2 update

[Dtenwolde]

Updating to 0.9.2 caused some tests which passed previously to fail.

• create_property_graph 954f99f

Query unexpectedly failed! (/Users/dljtw/git/duckpgq/test/sql/create_pg/create_property_graph.test:65)!
================================================================================
-CREATE PROPERTY GRAPH pg2
VERTEX TABLES (
    Student as Student_alias PROPERTIES ( id as id_alias, name ) LABEL Person
    )
EDGE TABLES (
    know    SOURCE KEY ( src ) REFERENCES Student_alias ( id )
            DESTINATION KEY ( dst ) REFERENCES Student ( id )
            PROPERTIES ( createDate ) LABEL Knows
    );
================================================================================
Binder Error: Referenced vertex table Student_alias does not exist.

• explain_duckpgq

Query unexpectedly failed! (/Users/dljtw/git/duckpgq/test/sql/explain_duckpgq.test:10)!
================================================================================
-EXPLAIN FROM GRAPH_TABLE (snb
    MATCH (a:Person WHERE a.id = 17592186044461)-[k:knows]-(b:Person)<-[au:hasAuthor]-(m:message WHERE m.creationDate < '2010-10-16')
    COLUMNS (a.id, a.firstName, a.lastName, m.id as messageId, coalesce(m.imageFile, m.content), m.creationDate)
    ) tmp
    ORDER BY creationDate DESC, Messageid ASC
    LIMIT 20;
================================================================================
Binder Error: Unknown DuckPGQ query encountered

• complex_matching Implement more complex join patterns #62

Query unexpectedly failed (/Users/dljtw/git/duckpgq/test/sql/path-finding/complex_matching.test:52)
================================================================================
-FROM GRAPH_TABLE (snb
    MATCH o = ANY SHORTEST (p:Person)-[w:knows]-> {1,3}(p2:Person)-[i:hasInterest]->(t:Tag)
    COLUMNS (p.id as p_id, p2.id as p2_id, t.id)
    ) tmp
    limit 10;
================================================================================
Actual result:
Binder Error: Referenced table "t" not found!
Candidate tables: "o"

• shortest path

Wrong result in query! (/Users/dljtw/git/duckpgq/test/sql/path-finding/shortest_path.test:57)!
================================================================================
-FROM GRAPH_TABLE (pg
    MATCH
    p = ANY SHORTEST (a:Person)-[k:knows]->{1,3}(b:Person)
    COLUMNS (path_length(p), p, a.name as name, b.name as b_name)
    ) study;
================================================================================
Mismatch on row 1, column 1
2 <> 1

• snb

Wrong result in query! (/Users/dljtw/git/duckpgq/test/sql/snb/snb.test:158)!
================================================================================
-FROM GRAPH_TABLE (snb
    MATCH (replyAuthor:person)<-[au2:hasAuthor]-(c:message where c.ParentMessageId is not null)-[r:replyOf]->(m:message where m.id = 618475290624)-[au:hasAuthor]->(messageAuthor:person),
    (replyAuthor:person)-[k:knows]-(messageAuthor:person)
    COLUMNS (c.id,c.content,c.creationDate, replyAuthor.id, replyAuthor.firstName, replyAuthor.lastName)
    ) tmp;
================================================================================
Mismatch on row 1, column 1
962072674305 <> 962072674306

• basic_match

Wrong result in query! (/Users/dljtw/git/duckpgq/test/sql/pattern-matching/basic_match.test:160)!
================================================================================
-SELECT study.a_name, count(study.b_name)
FROM GRAPH_TABLE (pg
    MATCH
    (a:Person)-[k:Knows]->(b:Person)
    COLUMNS (a.name as a_name, b.name as b_name)
    ) study
    GROUP BY study.a_name
    ORDER BY count(study.b_name) DESC;
================================================================================
Mismatch on row 3, column 1
Gabor <> Peter

- [ ] duckpgq

Query unexpectedly failed (/Users/dljtw/git/duckpgq/test/sql/duckpgq.test:20)
================================================================================
SELECT duckpgq_openssl_version('Michael');
================================================================================
Actual result:
Binder Error: Registered state not found

[Dtenwolde]

Skipping the test in duckpgq.test, opened separate issue: #59

[Dtenwolde]

complex_matching is not necessarily a bug related to the 0.9.2 upgrade, so made a new issue for that and closing this one.