Node names are case-insensitive but the move operation is not.

[dantleech]

When renaming a node in the Sonata Admin from "main" to "Main" I get:

 ItemExistsException: Cannot move '/cms/pages/main' to '/cms/pages/Main' because destination node already exists

I guess this is a PHCR-ODM issue.

[dbu]

unless you accidentally already have both, this would have to be in odm, phpcr itself should be case sensitive. unless one of the sql backends does the path uniqueness in the db and is doing that case insensitiv, which would be a bug afaik.

can you maybe start by adding a test to phpcr-api-tests so that we know whether there is an issue on that layer?

[dbu]

are you sure that this is not because you had duplicated documents? i would assume the paths to be case sensitive always.

[dbu]

@dantleech are you able to reproduce this? could it be a mysql only issue? i think mysql is by default case insensitive. jackrabbit and postgres should be case sensitive. maybe we should tell mysql to use a case sensitive collation in our schema, to behave like the rest.

[dantleech]

Will put this on my todo

[dbu]

uh oh, setting mysql to a case sensitive collation in general would be a dangerous thing, as it would make everything case sensitive. if it is a mysql issue, then it belongs into jackalope-doctrine-dbal and we need something like http://stackoverflow.com/questions/3396253/altering-mysql-table-column-to-be-case-sensitive ALTER TABLE UserAccounts CHANGE Password Password varchar(50) NOT NULL COLLATE utf8_bin; - is utf8_bin commonly available or will that pose new installation problems?

[dbu]

@dantleech where you able to investigate on this?

[dantleech]

Yeah it is a doctrine-dbal only issue:

PHPCR > session:node:move cms Cms
PHPCR > ls
+-------------+-----------------+--------+
| Node / Prop | Type            | Value  |
+-------------+-----------------+--------+
| /           | nt:unstructured |        |
|  -fooo      | STRING          | barrrr |
|  Cms/       | nt:unstructured |        |
+-------------+-----------------+--------+

2 node(s)
PHPCR > session:save
Cannot move '/cms' to '/Cms' because destination node already exists.

With jackrabbit it works fine.

[dantleech]

On the otherhand this is not an ODM issue ..

[dbu]

created jackalope/jackalope-doctrine-dbal#179