N1QL does not escape forward-slash

SQL++
1

Hello,
We use Couchbase to store RDF documents in JSON-LD format, expanded to prevent context duplication in stored documents. The problem is that N1QL returns incorrect results when quering fields containing forward-slash. Say, I have a doc in bucket “rdf”, which looks like following:
{
“@id” : “http://wonderland#whiterabbit”,
“http://wonderland#Color” : “White”
}

If I try to query docs by

SELECT * FROM `rdf` WHERE `@id`=“http://wonderland#whiterabbit”,

I get this doc without any problems, but if I execute a query

SELECT * FROM `rdf` WHERE `http://wonderland#Color\` IS NOT MISSING,

I get an empty result set like
{
“requestID”: “6cfa3436-59c6-4f32-acec-8a9243246160”,
“signature”: {
“": "”
},
“results”: [
],
“status”: “success”,
“metrics”: {
“elapsedTime”: “14.01ms”,
“executionTime”: “14.01ms”,
“resultCount”: 0,
“resultSize”: 0
}
}.

Through some experiments with cbq shell I determined that similar situations take place only when there is one or more forward-slashes in JSON property names.
I am using CB Server 4.0.0-4051 Community Edition (build-4051).
So, my question is: is there something I did wrong all about it, or it’s just a N1QL character escaping bug?

2

We will look into this. Meanwhile, can you try escaping the forward-slash as follows, and let us know if that helps:

3

SELECT * FROM rdf WHERE `http://wonderland#Color` IS NOT MISSING;

This query also returns an empty result.

SELECT `http://wonderland#Color\` FROM rdf;

as well as

SELECT `http://wonderland#Color` FROM rdf;

gives the following:

{
“requestID”: “50bc024e-d563-476c-ad84-622bed3c1f34”,
“signature”: {
“http://wonderland#Color”: “json”
},
“results”: [
{},
{},
{},
{},
{}
],
“status”: “success”,
“metrics”: {
“elapsedTime”: “12.0093ms”,
“executionTime”: “12.0093ms”,
“resultCount”: 5,
“resultSize”: 10
}
}

4

Ok. We will take a look. There will be a 4.1.0 developer preview soon.

Thanks,
Gerald

5

Thank you for your answer. I’ll wait. )