[
https://issues.apache.org/jira/browse/KYLIN-4988?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rofi Yao updated KYLIN-4988:
----------------------------
Summary: In SQL, '!=' replaced with '<>' (was: In SQL, '!=' replaced with
'')
> In SQL, '!=' replaced with '<>'
> -------------------------------
>
> Key: KYLIN-4988
> URL: https://issues.apache.org/jira/browse/KYLIN-4988
> Project: Kylin
> Issue Type: Bug
> Reporter: Rofi Yao
> Priority: Minor
>
> org.apache.kylin.query.util.DefaultQueryTransformer
> Isn't that too crude？@[~shaofengshi] [~xxyu]
>
> And the result is
> @Test
> public void nonEqualTransform() throws Exception {
> DefaultQueryTransformer transformer = new DefaultQueryTransformer();
> String sql1 = "select a from b where c = '!=' and d = 'sum(1)'";
> String sql2 = transformer.transform(sql1, "", "");
> System.out.println("sql1: " + sql1);
> System.out.println("sql2: " + sql2);
> }
>
> output:
> sql1: select a from b where c = '!=' and d = 'sum(1)'
> sql2: select a from b where c = ' <> ' and d = ' COUNT(1) '
>
> It's not expected result!
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
