commit 3c4fd64d1f92172e28143eea81c8f6edb3d173cf Author: Ashutosh Bapat Date: Mon Nov 24 10:22:23 2025 +0530 Quote keyword "order" in property graph examples The example, as is, gives a syntax error. But quoting the keyword "order" fixes the syntax error. Peter, who wrote the example, may decide to change the example to avoid this subtelity altogether. Hence didn't merge it with the first commit. Author: Ashutosh Bapat Reported-by: Junwang Zhou diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index cdee8eaa39b..a05458a1a4a 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -5810,7 +5810,7 @@ CREATE PROPERTY GRAPH myshop VERTEX TABLES ( products LABEL product, customers LABEL customer, - orders LABEL order + orders LABEL "order" ) EDGE TABLES ( order_items SOURCE orders DESTINATION products LABEL contains, @@ -5822,12 +5822,17 @@ CREATE PROPERTY GRAPH myshop With this definition, we can write a query like this: -SELECT customer_name FROM GRAPH_TABLE (myshop MATCH (c:customer)-[:has]->(o:order WHERE o.ordered_when = current_date) COLUMNS (c.name AS customer_name)); +SELECT customer_name FROM GRAPH_TABLE (myshop MATCH (c:customer)-[:has]->(o:"order" WHERE o.ordered_when = current_date) COLUMNS (c.name AS customer_name)); With the new labels and using the colon instead of IS, which are equivalent, the MATCH clause is now more compact and intuitive. + + Please notice that label order is quoted. If we run above + statements without adding quotes around order, we will get + a syntax error since order is a keyword. + Another use is to apply the same label to multiple element tables. For