search

kuzudb / kuzu

Embeddable property graph database management system built for query speed and scalability. Implements Cypher.
https://kuzudb.com/
MIT License
1.43k stars 98 forks source link

Full support of SET operations #2649

Open ray6080 opened 10 months ago

ray6080 commented 10 months ago

We miss the support of INTERSECT and EXCEPT for SET operations defined in SQL. The detailed semantic can be found here (https://www.postgresql.org/docs/current/queries-union.html).

@andyfengHKU we need to double check equivalent semantics/syntaxes in Cypher world too. I saw this in NebulaGraph, and I can check more later.

semihsalihoglu-uw commented 10 months ago

Had a conversation with @andyfengHKU and he thinks we need these two new clauses. So we need to extend openCypher for this.