Andrey, I am up against a deadline today (using my case-folding work-around for now) and time zone differences are working against us.I will get back to you with the results of this test tomorrow or over the weekend.
Thanks for your patience! -- John On Thursday, September 1, 2016 at 5:41:42 AM UTC-4, Andrey Lomakin wrote: > > Hi John, > > Strange issue. > Could you do following: > > 1. Get the source code of a database. > 2. Set breakpoint on ORecordDuplicatedException and check values of new > and existing records when exception is going to be thrown > > WDYT ? > > > On Wed, Aug 31, 2016 at 6:39 PM John J. Szucs <[email protected] > <javascript:>> wrote: > >> 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]> >>> 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]. >>> >>> >>>> 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] <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.
