minor, add test case for ||

Project: http://git-wip-us.apache.org/repos/asf/kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/3f9d158a
Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/3f9d158a
Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/3f9d158a

Branch: refs/heads/master
Commit: 3f9d158a13186306b666898ea607768094805559
Parents: 0eeceef
Author: Cheng Wang <[email protected]>
Authored: Thu Jun 22 20:55:19 2017 +0800
Committer: Hongbin Ma <[email protected]>
Committed: Thu Jun 22 20:56:24 2017 +0800

----------------------------------------------------------------------
 kylin-it/src/test/resources/query/sql/query96.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/kylin/blob/3f9d158a/kylin-it/src/test/resources/query/sql/query96.sql
----------------------------------------------------------------------
diff --git a/kylin-it/src/test/resources/query/sql/query96.sql 
b/kylin-it/src/test/resources/query/sql/query96.sql
index 4e80d59..eae99bc 100644
--- a/kylin-it/src/test/resources/query/sql/query96.sql
+++ b/kylin-it/src/test/resources/query/sql/query96.sql
@@ -18,5 +18,5 @@
 
 select upper(lstg_format_name) as lstg_format_name, count(*) as cnt from 
test_kylin_fact
 where lower(lstg_format_name)='abin' and substring(lstg_format_name,1,3) in 
('ABI') and upper(lstg_format_name) > 'AAAA' and
-lower(lstg_format_name) like '%b%' and char_length(lstg_format_name) < 10 and 
char_length(lstg_format_name) > 3 and lstg_format_name||'a'='ABINa'
+lower(lstg_format_name) like '%b%' and char_length(lstg_format_name) < 10 and 
char_length(lstg_format_name) > 3 and 
'abc'||lstg_format_name||'a'||'b'||'c'='abcABINabc'
 group by lstg_format_name
\ No newline at end of file

Reply via email to