Skip to content

Latest commit

 

History

History
229 lines (200 loc) · 5.37 KB

cypher-cypher9-features.adoc

File metadata and controls

229 lines (200 loc) · 5.37 KB

Supported Cypher

This section describes the Cypher9 features supported by Morpheus.

Not all features of Cypher9 are supported by Morpheus. Some will be supported in the future. Others will never be supported.

Notable missing features that will be supported in the future are:

  • shortestPath and allShortestPaths

  • path patterns (p = ()-->())

  • unbounded variable-length patterns

Notable missing feature that will never be supported are:

  • Schema commands

  • Index hints

  • Features that are deprecated in Cypher9 (CREATE UNIQUE, START)

Here follows a comprehensive reference of Cypher9 features and their implementation status.

Types

name status name status

Boolean

[✓]

Date

[✓]

DateTime

[   ]

Duration

[✓]

Float

[✓]

Integer

[✓]

List

[✓]

LocalDateTime

[✓]

LocalTime

[   ]

Map

[✓]

Node

[✓]

Path

[   ]

Point

[   ]

Relationship

[✓]

String

[✓]

Time

[   ]

Clauses

name status name status

CALL …​ YIELD

[   ]

CREATE

[   ]

DELETE

[   ]

DETACH DELETE

[   ]

MANDATORY MATCH

[   ]

MATCH

[✓]

MERGE

[   ]

OPTIONAL MATCH

[✓]

REMOVE

[   ]

RETURN

[✓]

SET

[   ]

UNION

[✓]

UNWIND

[✓]

WITH

[✓]

Sub-clauses

name status name status

LIMIT

[✓]

ON CREATE

[   ]

ON MATCH

[   ]

ORDER BY

[✓]

SKIP

[✓]

WHERE

[✓]

Functions

name status name status name status name status

abs()

[✓]

acos()

[✓]

asin()

[✓]

atan()

[✓]

atan2()

[✓]

ceil()

[✓]

coalesce()

[✓]

cos()

[✓]

cot()

[✓]

degrees()

[✓]

distance()

[   ]

e()

[✓]

endNode()

[✓]

exists()

[✓]

exp()

[✓]

floor()

[✓]

haversin()

[✓]

head()

[✓]

id()

[✓]

in()

[✓]

keys()

[✓]

lTrim()

[✓]

labels()

[✓]

last()

[✓]

left()

[✓]

length()

[✓]

log()

[✓]

log10()

[✓]

nodes()

[   ]

pi()

[✓]

point()

[   ]

properties()

[✓]

rTrim()

[✓]

radians()

[✓]

rand()

[✓]

range()

[✓]

relationships()

[   ]

replace()

[✓]

reverse()

[✓]

right()

[✓]

round()

[✓]

sign()

[✓]

sin()

[✓]

size()

[✓]

split()

[✓]

sqrt()

[✓]

startNode()

[✓]

substring()

[✓]

tail()

[✓]

tan()

[✓]

timestamp()

[✓]

toBoolean()

[✓]

toFloat()

[✓]

toInteger()

[✓]

toLower()

[✓]

toString()

[✓]

Aggregating functions

name status name status

avg()

[✓]

collect()

[✓]

count()

[✓]

max()

[✓]

min()

[✓]

percentileCont()

[✓]

percentileDisc()

[✓]

stdDev()

[✓]

stdDevP()

[✓]

sum()

[✓]

Expressions

name status name status

CASE

[✓]

all

[✓]

allShortestPaths

[   ]

any

[✓]

extract

X

filter

X

list comprehension

[✓]

map projections

[✓]

none

[✓]

parameters

[✓]

pattern comprehensions

[   ]

reduce

[✓]

shortestPath

[   ]

single

[✓]

Operators

name status name status name status

=

[✓]

<>

[✓]

<

[✓]

>

[✓]

<=

[✓]

>=

[✓]

=~

[✓]

+ (arithmetic)

[✓]

+ (list)

[✓]

+ (string)

[✓]

/

[✓]

*

[✓]

.

[✓]

[] (subscript)

[✓]

AND

[✓]

CONTAINS

[✓]

DISTINCT

[✓]

ENDS WITH

[✓]

IS NOT NULL

[✓]

IS NULL

[✓]

NOT

[✓]

OR

[✓]

STARTS WITH

[✓]

XOR

[✓]