BTW, I updated to 1.7.8, and experienced the same behavior. On Friday, August 22, 2014 8:24:51 PM UTC-4, Jon Fields wrote: > > 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.
