Fix test cases with 0.9.2 update

[Dtenwolde]

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

• [x] create_property_graph https://github.com/cwida/duckpgq-extension/commit/954f99fc1216fa3ad77f5491e1cce270bed8a72a

  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.

• [x] 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 https://github.com/cwida/duckpgq-extension/issues/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"

• [x] 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

• [x] 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

• [x] 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.