As I mentioned before, the result form select should always be an array.
This works accordingly:
INSERT into B set aID = (select id from (select from A where name='Test
1')), text = "tesing me"
INSERT into B set aID = (select id from (select from #29:0)), text =
"tesing me"
{
"result": [
{
"@type": "d",
"@rid": "#34:0",
"@version": 1,
"@class": "b",
"aID": [
1
],
"text": "tesing me"
}
],
"notification": "Query executed in 0.029 sec. Returned 1 record(s)"
}
I don't see a reason for a fix
On Wednesday, January 25, 2017 at 6:49:22 PM UTC+1, Borov wrote:
>
> Hi Luigi,
>
> I've created an issue #7123
> <https://github.com/orientechnologies/orientdb/issues/7123>.
>
> Thanks
>
>
> On Tuesday, January 24, 2017 at 12:34:47 AM UTC-8, Luigi Dell'Aquila wrote:
>>
>> Hi,
>>
>> Yes please, if you could submit a bug (maybe with a simple script to
>> reproduce the problem) it would help a lot
>>
>> Thanks
>>
>> Luigi
>>
>>
>> 2017-01-23 20:57 GMT+01:00 Borov <[email protected]>:
>>
>>> Hi Luigi,
>>>
>>> I just downloaded 2.2.15 to test this fix, but it still fails. Did your
>>> fix made into 2.2.15 or shall I submit a bug?
>>>
>>> Thanks,
>>>
>>>
>>> On Tuesday, January 3, 2017 at 1:23:18 PM UTC-8, Borov wrote:
>>>>
>>>> Thanks for fixing it Luigi.
>>>>
>>>>
>>>> On Monday, January 2, 2017 at 2:19:56 AM UTC-8, Luigi Dell'Aquila wrote:
>>>>>
>>>>> Hi guys,
>>>>>
>>>>> I just pushed a fix on branch 2.2.x
>>>>>
>>>>> Thanks
>>>>>
>>>>> Luigi
>>>>>
>>>>>
>>>>> 2017-01-02 10:19 GMT+01:00 Luigi Dell'Aquila <[email protected]>:
>>>>>
>>>>>> Hi guys,
>>>>>>
>>>>>> You're right, the old executor supported it but the parser does not
>>>>>> correctly parse it. I think I can easily support it, I'm checking it
>>>>>> now.
>>>>>> I'll keep you posted
>>>>>>
>>>>>> Thanks
>>>>>>
>>>>>> Luigi
>>>>>>
>>>>>>
>>>>>> 2016-12-31 17:48 GMT+01:00 hartmut bischoff <[email protected]>:
>>>>>>
>>>>>>>
>>>>>>> select ... where gives an array, thus you simply have to address
>>>>>>> the first item of the resultset
>>>>>>>
>>>>>>> i.e. (untested)
>>>>>>> update #69:0 set meta.ownerId = $a.first let $a= ( select id from
>>>>>>> Account where @rid = #25:1 )
>>>>>>>
>>>>>>> --
>>>>>>>
>>>>>>> ---
>>>>>>> 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.
>>>
>>
>>
--
---
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.
