Node names are case-insensitive but the move operation is not. about phpcr-odm HOT 9 CLOSED

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?

from phpcr-odm.

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

from phpcr-odm.

@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.

from phpcr-odm.

Will put this on my todo

from phpcr-odm.

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?

from phpcr-odm.

@dantleech where you able to investigate on this?

from phpcr-odm.

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.

from phpcr-odm.

On the otherhand this is not an ODM issue ..

from phpcr-odm.

created jackalope/jackalope-doctrine-dbal#179

from phpcr-odm.