zhong.zhu created KYLIN-5738:
--------------------------------
Summary: Query support using '+' to concatenate strings
Key: KYLIN-5738
URL: https://issues.apache.org/jira/browse/KYLIN-5738
Project: Kylin
Issue Type: Bug
Affects Versions: 5.0-beta
Reporter: zhong.zhu
Assignee: zhong.zhu
Fix For: 5.0.0
Many queries of the client's mobile reports are SQL queries with + concatenated
strings. The client does not agree with the SQL transformation of the front-end
reports and hopes that KYLIN 4.X is forward compatible with this function.
For example:
Both the company and first_deptname fields are of type varchar(4096)
Case one:
SELECT company + '-' + first_deptname FROM Table name
_KYLIN 4 Query Result with Exception:_
_Conversion to relational algebra failed to preserve datatypes:_
_validated type:_
_RecordType(CHAR(1) CHARACTER SET "UTF-16LE" COLLATE "UTF-16LE$en_US$primary"
NOT NULL EXPR$0) NOT NULL_
_converted type:_
_RecordType(CHAR(3) CHARACTER SET "UTF-16LE" COLLATE "UTF-16LE$en_US$primary"
NOT NULL EXPR$0) NOT NULL_
_rel:_
_LogicalSort(fetch=[500])_
_LogicalProject(EXPR$0=[||(||('A', '_'), 'B')])
KapTableScan(table=[[APP, A02_HR_ORGANIZATION_TALENT_CHAIN]], ctx=[], fields=
In KYLIN 3.x, the query result is right: company-deptname
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
