Re: [Neo4j] Cannot drop index with nested property (dot) in Neo4j using bolt

[Davide D'Alto]

Thanks Michael,
that's the right solution:
https://stackoverflow.com/questions/50453953/drop-index-with-on-nested-property-with-a-dot-in-neo4j?noredirect=1#comment87924847_50453953

By the way, related to this, I have another issue.
When I get all the constraints in the schema calling `CALL
db.constraints()` I'm surprised that it returns only a column
description with queries like this:

CONSTRAINT ON ( per#son:Per#Son ) ASSERT per#son.nickname IS UNIQUE

Note that that's not an error, I've actually created a label `Per#son`
(I added a special char in it).
The problem here is that the query returned by `db.constraints()` does
not escape special chars and therefore if I want to drop the
constraint I cannot simply add the DROP at the beginning.
I think the same happens for db.indexes() but because there are
additional columns I can create the right query myself.

I think the description field should keep track of part of the query
requiring escaping.
Am I missing something here?

Thanks



On Tue, May 22, 2018 at 9:39 AM, 'Michael Hunger' via Neo4j
 wrote:
> As that is not a valid identifier anymore you have to quote it with
> backticks, like `id.id` same goes for labels and rel-types.
>
> Michael
>
> On Mon, May 21, 2018 at 6:26 PM, Davide D'Alto 
> wrote:
>>
>> Hi,
>> I was surprised to see the following error:
>>
>>
>> Neo.ClientError.Statement.SyntaxError: Invalid input '.': expected an
>> identifier character, whitespace, ',' or ')' (line 1, column 38 (offset:
>> 37)) "DROP INDEX ON :SingleBoardComputer(id.id)"
>>
>> How is it that I can create the index but I cannot drop it? Is there a
>> special syntax?
>>
>> Thanks,
>> Davide
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Neo4j" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to neo4j+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "Neo4j" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/neo4j/vPSZXNqmmOc/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Neo4j] Cannot drop index with nested property (dot) in Neo4j using bolt

['Michael Hunger' via Neo4j]

As that is not a valid identifier anymore you have to quote it with
backticks, like `id.id` same goes for labels and rel-types.

Michael

On Mon, May 21, 2018 at 6:26 PM, Davide D'Alto 
wrote:

> Hi,
> I was surprised to see the following error:
>
>
> Neo.ClientError.Statement.SyntaxError: Invalid input '.': expected an
> identifier character, whitespace, ',' or ')' (line 1, column 38 (offset:
> 37)) "DROP INDEX ON :SingleBoardComputer(id.id)"
>
> How is it that I can create the index but I cannot drop it? Is there a
> special syntax?
>
> Thanks,
> Davide
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.