Andrey, I just created: https://github.com/orientechnologies/orientdb/issues/2741
Thank you, Jon On Friday, August 29, 2014 8:15:30 AM UTC-4, Andrey Lomakin wrote: > > Jon, > Did you open issue about it ? > If you did not, could you open it and send link to me ? > > > On Sat, Aug 23, 2014 at 3:33 AM, Jon Fields <[email protected] > <javascript:>> wrote: > >> 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] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Best regards, > Andrey Lomakin. > > Orient Technologies > the Company behind OrientDB > > -- --- 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.
