[jira] [Created] (EMPIREDB-472) DBMSHandlerPostgreSQL - Fix convert phrase to text/char

[Jan Glaubitz (Jira)]

Jan Glaubitz created EMPIREDB-472:
-------------------------------------

             Summary: 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
             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)