Named parameter including '.'

SQL++
1

Hi,

I know this works:

cluster.query( “SELECT * FROM default WHERE Type=$type”, named_parameters = {'type":“User”})

Is the following supposed to work?

cluster.query( “SELECT * FROM default WHERE sub.Type=$sub.type”, named_parameters = {“sub.type”:“User”})

From my testing, it seems not working.

The question is:

Can the key of named_parameters include a ‘.’?

Thanks

2

Named parameters are variables and dot represent sub document you can’t have dots. After $ it must be identifier.

Example:

$sub = {"type":  "mydoc"}

SELECT $sub.type;
     result in "mydoc"

Due to above usage you can’t have dot in named parameter.

1 Like