[jira] [Created] (METAMODEL-113) Queries ALIAS and LEFT JOIN

["Francisco Javier Cano (JIRA)" <ji...@apache.org>]

Francisco Javier Cano created METAMODEL-113:
-----------------------------------------------

             Summary: Queries ALIAS and LEFT JOIN
                 Key: METAMODEL-113
                 URL: https://issues.apache.org/jira/browse/METAMODEL-113
             Project: Apache MetaModel
          Issue Type: Bug
    Affects Versions: 4.3.2
            Reporter: Francisco Javier Cano


DataSet:  http://dev.mysql.com/doc/sakila/en/
Does MM support these queries? We get an error:
----
{code}
SELECT l.name as language, COUNT(f.film_id) as films FROM language l LEFT JOIN sakila.film f USING (language_id) GROUP BY l.name
{code}
{code}
org.apache.metamodel.query.parser.QueryParserException: Not capable of parsing FROM token: language l LEFT JOIN sakila.film f USING (language_id). Expected parenthesis to start at first character.
{code}
----
----
{code}
SELECT l.name as name, 2 as dos FROM language l
{code}
{code}
org.apache.metamodel.query.parser.QueryParserException: Not capable of parsing SELECT token: 2
{code}
----

Thanks a lot,



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)