SELECT FROM (<MATCH query...>) not working?

[hrstoyanov]

OrientDB Version: 3.0.5-SNAPSHOT

Java Version: 1.8

OS: any

I have a MATCH query that works as expected:

match 
{class: Account, as: a}.outE(WorksFor){where: ('admin' in ROLES)}.inV(Staffer){where: (email='[email protected]')},
{as:a}.outE(WorksFor){where:('admin' in ROLES)} 
return a, count(*) as totalAdmins group by a;

+----+-----+-----------+
|#   |a    |totalAdmins|
+----+-----+-----------+
|0   |#65:0|2          |
|1   |#66:0|1          |
+----+-----+-----------+

However any attempt to wrap it with SELECT :

select from (<the_above_query>) where totalAdmins=1;
select a from (<the_above_query>) where totalAdmins=1;

fails with syntax error???

Error: com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error parsing query:
select from (match {class:Account, as: a}
          ^
Encountered " <FROM> "from "" at line 1, column 8.
Was expecting one of:
    <DISTINCT> ...
    <DISTINCT> ...
    <DISTINCT> ...
    <DISTINCT> ...
    <DISTINCT> ...
    <DISTINCT> ...
    <DISTINCT> ...
    <DISTINCT> ...
    <DISTINCT> ...

[hrstoyanov]

This appear to be issue with the console only. Studio works as expected!

[luigidellaquila]

Hi @hrstoyanov

I just pushed a fix for this

Thanks

Luigi

[hrstoyanov]

@luigidellaquila seems fixed, thanks