You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2016/01/24 01:55:39 UTC
[jira] [Resolved] (PHOENIX-1937) String concatenation operator
should be only supported to Varchar and Char
[ https://issues.apache.org/jira/browse/PHOENIX-1937?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Taylor resolved PHOENIX-1937.
-----------------------------------
Resolution: Not A Problem
This is the way it's supposed to work.
> 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)