You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@metamodel.apache.org by "Kasper Sørensen (Jira)" <ji...@apache.org> on 2021/05/12 14:10:00 UTC
[jira] [Updated] (METAMODEL-1237) Add support for CASE expressions
in SELECT clause
[ https://issues.apache.org/jira/browse/METAMODEL-1237?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kasper Sørensen updated METAMODEL-1237:
---------------------------------------
Description:
Query parser support parse inline CASE statements like
{code}
SELECT MAX(CASE coursename WHEN 'network' THEN score END) AS 'network' FROM course
{code}
More syntax examples here: https://www.w3schools.com/sql/sql_case.asp
was:
Query parser support parse inline CASE statements like
{code}
SELECT MAX(CASE coursename WHEN 'network' THEN score END) AS 'network' FROM course
{code}
> Add support for CASE expressions in SELECT clause
> -------------------------------------------------
>
> Key: METAMODEL-1237
> URL: https://issues.apache.org/jira/browse/METAMODEL-1237
> Project: Apache MetaModel
> Issue Type: Improvement
> Reporter: wangxiaoshan
> Priority: Major
>
> Query parser support parse inline CASE statements like
> {code}
> SELECT MAX(CASE coursename WHEN 'network' THEN score END) AS 'network' FROM course
> {code}
> More syntax examples here: https://www.w3schools.com/sql/sql_case.asp
--
This message was sent by Atlassian Jira
(v8.3.4#803005)