Andrey, Thanks for responding.
The RID in question changes every time I run this test case. Here are some results with my current run. The way that my environment is set-up, I can't really run the OrientDB console or Studio tool, so I wrote a little "db" command in my app that allows me to execute SQL commands for testing/debugging. You can see this being used below. com.orientechnologies.orient.core.storage.ORecordDuplicatedException: Cannot index record #100:14: found duplicated key 'https://en.wikipedia.org/wiki/fédération_anarchiste' in index 'Identifier.identifier' previously assigned to the record #85:13 ... db "select * from #85:13" 0 results. db "select * from #100:14" 0 results. db "select * from Identifier" Identifier#81:0{identifier:https://en.wikipedia.org/wiki/AccessibleComputing,out_id:[size=1]} v2 Identifier#82:0{identifier:https://en.wikipedia.org/wiki/Computer_accessibility,out_id:[size=1]} v1 Identifier#83:0{identifier:https://en.wikipedia.org/wiki/Anarchism,out_id:[size=1]} v1 Identifier#84:0{identifier:https://en.wikipedia.org/wiki/political_philosophy,out_id:[size=1]} v1 Identifier#85:0{identifier:https://en.wikipedia.org/wiki/AfghanistanHistory,out_id:[size=1]} v1 Identifier#86:0{identifier:https://en.wikipedia.org/wiki/History_of_Afghanistan,out_id:[size=1]} v1 6 results. Note that neither #85:13 nor #100:14 appears to have actually been committed to the database. -- John On Wednesday, August 31, 2016 at 5:43:04 AM UTC-4, Andrey Lomakin wrote: > Hi John, > > Could you send us content of record with rid #109:13 (value of indexed > field will be enough I think) ? > > On Tue, Aug 30, 2016 at 7:02 PM John J. Szucs <[email protected] > <javascript:>> wrote: > >> Thanks for pointing that out. I double-checked the actual code and it is >> using the correct "collate"="ci" Parameter pair for the Java API. >> >> >> On Tuesday, August 30, 2016 at 11:54:21 AM UTC-4, [email protected] >> wrote: >>> >>> Hi, >>> this will not solve the problem but I think the correct command for >>> creating an index with case insensitive is collate >>> >>> CREATE INDEX <name> [ON <class-name> (prop-names [COLLATE <collate>])] >>> <type> [<key-type>] [METADATA Metadata Document} {JSON Index] >>> >>> Example: >>> >>> create index User.name on User (name collate ci) UNIQUE >>> >>> Kind regards, >>> Alessandro >>> >> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "OrientDB" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > -- > Best regards, > Andrey Lomakin, R&D lead. > OrientDB Ltd > > twitter: @Andrey_Lomakin > linkedin: https://ua.linkedin.com/in/andreylomakin > blogger: http://andreylomakin.blogspot.com/ > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
