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