[jira] Resolved: (EMPIREDB-40) Postgresql cast problem

["Francis De Brabandere (JIRA)" <em...@incubator.apache.org>]

     [ https://issues.apache.org/jira/browse/EMPIREDB-40?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Francis De Brabandere resolved EMPIREDB-40.
-------------------------------------------

    Resolution: Fixed

fixed in commit: r790710
Should we create issues if the reporters don't create them? It's indeed better for the changelog.

> Postgresql cast problem
> -----------------------
>
>                 Key: EMPIREDB-40
>                 URL: https://issues.apache.org/jira/browse/EMPIREDB-40
>             Project: Empire-DB
>          Issue Type: Bug
>    Affects Versions: empire-db-2.0.5-incubating
>            Reporter: Rainer Döbele
>            Assignee: Francis De Brabandere
>             Fix For: empire-db-2.0.5-incubating
>
>
> Solution submitted by Frank Lupo:
>     public String getConvertPhrase(DataType destType, DataType srcType, Object format)
>     {
>         switch(destType)
>         {
> ->           case BOOL:      return "CAST(? AS BOOL)";
> ->           case INTEGER:   return "CAST(? AS INTEGER)";
>            case DECIMAL:   return "CAST(? AS DECIMAL)";
>            case DOUBLE:    return "CAST(? AS DECIMAL)";
>            case DATE:      return "CAST(? AS DATE)";
> ->           case DATETIME:  return "CAST(? AS TIMESTAMP)";

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.