You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@metamodel.apache.org by "Francisco Javier Cano (JIRA)" <ji...@apache.org> on 2015/03/02 13:19:04 UTC
[jira] [Commented] (METAMODEL-113) Queries ALIAS and LEFT JOIN
[ https://issues.apache.org/jira/browse/METAMODEL-113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14343105#comment-14343105 ]
Francisco Javier Cano commented on METAMODEL-113:
-------------------------------------------------
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
=>
SELECT l.name as language, COUNT(f.film_id) as films FROM language l LEFT JOIN sakila.film f ON l.language_id=f.language_id GROUP BY l.name;
It wortks perfect, thanks a lot (SQL syntax)
----
Regarding literal (it is not column name with digits) in select statement, I found this:
http://www.firstsql.com/tutor3.htm#exp
I would like to perform queries similar to:
{code}
mysql> SELECT "language", l.name as language, COUNT(f.film_id) as films FROM language l LEFT JOIN sakila.film f ON l.language_id=f.language_id GROUP BY l.name;
+----------+----------+-------+
| language | language | films |
+----------+----------+-------+
| language | English | 1000 |
| language | French | 0 |
| language | German | 0 |
| language | Italian | 0 |
| language | Japanese | 0 |
| language | Mandarin | 0 |
+----------+----------+-------+
{code}
But it looks like an extended release.
Thanks,
> 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)