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