[
https://issues.apache.org/jira/browse/EMPIREDB-472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jan Glaubitz resolved EMPIREDB-472.
-----------------------------------
Resolution: Fixed
fixed in commit 78f6baccba65ce3a680615ca0ea734e2a08612fb
> DBMSHandlerPostgreSQL - Fix convert phrase to text/char
> -------------------------------------------------------
>
> Key: EMPIREDB-472
> URL: https://issues.apache.org/jira/browse/EMPIREDB-472
> Project: Empire-DB
> Issue Type: Bug
> Components: Core
> Affects Versions: empire-db-3.3.0
> Reporter: Jan Glaubitz
> Assignee: Jan Glaubitz
> Priority: Critical
> Fix For: empire-db-3.3.1
>
>
> Currently, Empire-db always uses CAST in the DBMSHandlerPostgreSQL to convert
> Data Types.
> For example
> {code:java}
> => SELECT CAST(161 AS CHAR);
> bpchar
> --------
> 1
> (1 Zeile)
> {code}
> as you can see the result is not what's expected. To correct way to convert
> an integer to varchar is ::text:
> {code:java}
> => SELECT 161::text;
> text
> ------
> 161
> (1 Zeile)
> {code}
> or to_char with a format:
> {code:java}
> => SELECT to_char(161, '999');
> to_char
> ---------
> 161
> (1 Zeile)
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
