Property graph names are not case insensitive

[Dtenwolde]

What happens?

The property graph names are not consistently case insensitive in the current implementation.
Note in the following examples there is socialNetwork and SocialNetwork (Capitalization of the S)

SELECT count(id)
   FROM
     GRAPH_TABLE (socialNetwork
       MATCH p = ANY SHORTEST (p1:person WHERE p1.name='Bob')
   -[f:follows]-> *(p2:person)
           -[l:livesIn]->(c:city WHERE c.name='Utrecht')
       COLUMNS (p2.id));

Results in:

Binder Error: Property graph socialNetwork does not exist

But then running the following create property graph query:

CREATE PROPERTY GRAPH SocialNetwork
      VERTEX TABLES (
        person,
        city
      )
      EDGE TABLES (
        follows    SOURCE KEY (p1id) REFERENCES person (id)
                      DESTINATION KEY (p2id) REFERENCES person (id),
        livesin    SOURCE KEY (personid) REFERENCES person (id)
                    DESTINATION KEY (cityid) REFERENCES city (id)
    );

Results in:

Invalid Error: Property graph table with name SocialNetwork already exists

To Reproduce

CREATE TABLE city (
  id bigint PRIMARY KEY,
  name varchar
);


CREATE TABLE person (
  id bigint PRIMARY KEY,
  name varchar
);
CREATE TABLE livesIn (
  personid bigint,
  cityid bigint
);

CREATE TABLE follows (
  p1id bigint,
  p2id bigint
);

CREATE PROPERTY GRAPH SocialNetwork
  VERTEX TABLES (
	person, 
	city
  )
  EDGE TABLES (
	follows	SOURCE KEY (p1id) REFERENCES person (id)
			  	DESTINATION KEY (p2id) REFERENCES person (id),
	livesin	SOURCE KEY (personid) REFERENCES person (id)
				DESTINATION KEY (cityid) REFERENCES city (id)
);

SELECT count(id)
FROM
  GRAPH_TABLE (socialNetwork 
    MATCH p = ANY SHORTEST (p1:person WHERE p1.name='Bob') 
-[f:follows]-> *(p2:person)
        -[l:livesIn]->(c:city WHERE c.name='Utrecht')
    COLUMNS (p2.id));

Results in:

Binder Error: Property graph socialNetwork does not exist

OS:

macOs 13 - Apple M1 Pro

DuckDB Version:

v1.1.3

DuckDB Client:

CLI

Full Name:

Daniel ten Wolde

Affiliation:

CWI

How did you load the extension?

Community extension version

Did you include all relevant data sets for reproducing the issue?

Yes

Did you include all code required to reproduce the issue?

• Yes, I have

Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?

• Yes, I have

[Dtenwolde]

Fixed in #188