[2.1rc3] problem with INSERT INTO ... FROM ( SELECT ... )

[kris mnt]

Hi

I'm getting "Cannot find a command executor for the command request: sql.( SELECT FROM OUser )" trying to copy records to other class with commands below.

CREATE CLASS X

INSERT INTO X FROM ( SELECT FROM OUser ) 

What am I doing wrong ?

Thanks in advance 

Kris

[Enrico Risa]

hi kris

try

INSERT INTO X FROM  SELECT FROM OUser 

--

---
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 orient-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[kris mnt]

It works. 

Thanks a lot.

Best Regards

Kris

[tora...@gmail.com]

The present documentation(GA v2.2.0) is still wrong - it says use sub-query i.e. (select ...)

As already shown (a year ago!) this does not work. 

[Luca Garulli]

Hi,

Which page in the docs?

Best Regards,

Luca Garulli

Founder & CEO

OrientDB

[Tore Austrått]

Hi Luca,

page SQL - INSERT

paragraph Insert from query with this example

insert into GermanyClient from ( select from Client where country = 'Germany' )

Sub-queries works elsewhere...

> You received this message because you are subscribed to a topic in the
> Google Groups "OrientDB" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/orient-database/6VUAhZrqGkw/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to

> orient-databa...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

--
Tore Austrått
phone +47 90657231

[Luca Garulli]

Hi,

Sorry, but the docs seems updated:

http://orientdb.com/docs/last/SQL-Insert.html

Where did you find it?

Best Regards,

Luca Garulli

Founder & CEO

OrientDB

[Tore Austrått]

it seems like I should apologize, the doc was from
http://orientdb.com/docs/2.0/orientdb.wiki/SQL-Insert.html

Sorry.

[Tore Austrått]

Luca,

sorry for the mess. I appreciate the fact that there is a lot to
attend to, but could you please
find time to answer my earlier mail about query(the professor...)

Cheers,

Tore