Hi, any suggestions how this is accomplished? If this is a bug, let me know and I will be happy to create an issue.
Thanks. On Tuesday, August 19, 2014 11:27:05 AM UTC-4, Jon Fields wrote: > > I just tried that: > > insert into index:books set key = ["Donald Knuth", "The Art of > Computer Programming", 1968], rid = #12:0 > Error: > com.orientechnologies.orient.core.exception.OCommandExecutionException: > Error on execution of command: sql.insert into index:books set key = > ["Donald Knuth", "The Art of Computer Programming", 1968], rid = #12:0 > Error: java.lang.ClassCastException: java.util.ArrayList cannot be > cast to java.lang.Comparable > > BTW I have tried this with both a UNIQUE and DICTIONARY index. > > Thanks! > Jon > > On Tuesday, August 19, 2014 11:08:37 AM UTC-4, Lvc@ wrote: >> >> Have you tried: >> >> insert into index:books set key = ["Donald Knuth", "The Art of Computer >> Programming", 1968], values = #12:0 >> >> >> Lvc@ >> >> >> On 19 August 2014 16:23, Jon Fields <[email protected]> wrote: >> >>> BTW, this is version 1.7.7 using console.sh. >>> >>> >>> On Tuesday, August 19, 2014 10:20:27 AM UTC-4, Jon Fields wrote: >>>> >>>> According to the documentation, this is possible: >>>> >>>> select from index:books where key = ["Donald Knuth", "The Art of >>>> Computer Programming", 1968] >>>> >>>> >>>> However, I cannot figure out how to insert such a value >>>> >>>> insert into index:books (key, rid) values (["Donald Knuth", "The Art of >>>> Computer Programming", 1968], #12:0) >>>> >>>> >>>> Error: >>>> com.orientechnologies.orient.core.exception.OCommandExecutionException: >>>> Error on execution of command: sql.insert into index:Test1 (key,rid) >>>> values (["a","b","c"], #12:0) >>>> >>>> Error: java.lang.ClassCastException: java.util.ArrayList cannot be cast >>>> to java.lang.Comparable >>>> >>>> >>>> What is the correct syntax in SQL for doing this? >>>> >>>> Thanks! >>>> >>>> -- >>> >>> --- >>> 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. >>> >> >> -- --- 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.
