Aakash Pradeep created PHOENIX-1937:
---------------------------------------
Summary: String concatenation operator should be only supported to
Varchar and Char
Key: PHOENIX-1937
URL: https://issues.apache.org/jira/browse/PHOENIX-1937
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.4.0
Reporter: Aakash Pradeep
Assignee: Aakash Pradeep
Priority: Minor
String concatenation should be supported only for Varchar and Char type,
currently it is supported for all the type. Here is some of the examples :
select now()||now() from <Table_Name>;
+------------------------+
| '2015-04-292015-04-29' |
+------------------------+
| 2015-04-292015-04-29 |
| 2015-04-292015-04-29 |
select 1.2||1.2 from <Table_Name>;
+----------+
| '1.21.2' |
+----------+
| 1.21.2 |
| 1.21.2 |
select 1||1 from <Table_Name>;
+------+
| '11' |
+------+
| 11 |
| 11 |
select 1||ARRAY[1] from <Table_Name>;
+--------------------------------------------------------------------------------+
|
'1org.apache.phoenix.schema.types.PhoenixArray$PrimitiveIntPhoenixArray@d29ba' |
+--------------------------------------------------------------------------------+
| 1org.apache.phoenix.schema.types.PhoenixArray$PrimitiveIntPhoenixArray@d29ba
|
select ARRAY['a']||ARRAY[1] from <Table_Name>;
+---------------------------------------------------------------------------------------------------------------------------------+
|
'org.apache.phoenix.schema.types.PhoenixArray@d2b42org.apache.phoenix.schema.types.PhoenixArray$PrimitiveIntPhoenixArray@d29ba'
|
+---------------------------------------------------------------------------------------------------------------------------------+
|
org.apache.phoenix.schema.types.PhoenixArray@d2b42org.apache.phoenix.schema.types.PhoenixArray$PrimitiveIntPhoenixArray@d29ba
|
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
