[jira] [Commented] (NIFI-1241) PutSQL does not support Boolean, Numeric, or Decimal data types

[Bryan Bende (JIRA)]

    [ 
https://issues.apache.org/jira/browse/NIFI-1241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15036825#comment-15036825
 ] 

Bryan Bende commented on NIFI-1241:
-----------------------------------

Testing latest patch... I have this table:
{code}
CREATE TABLE TEST(
   ID VARCHAR PRIMARY KEY     NOT NULL,
   BOOL_TEST           BOOLEAN    NOT NULL,
   NUMERIC_TEST            NUMERIC     NOT NULL,
   DECIMAL_TEST        DECIMAL NOT NULL
);
{code}

I send in a FlowFile with values:
{code}
 ${UUID()}, true, 12345, 1.01  
{code}

and I select from the table and get:
{code}
d71387e0-f443-4193-aaa4-a37e5f533124 | t         |        12345 |            1
{code}

With the previous patch that "1" was "1.01" in the database.

> PutSQL does not support Boolean, Numeric, or Decimal data types
> ---------------------------------------------------------------
>
>                 Key: NIFI-1241
>                 URL: https://issues.apache.org/jira/browse/NIFI-1241
>             Project: Apache NiFi
>          Issue Type: Bug
>          Components: Extensions
>            Reporter: Mark Payne
>            Assignee: Mark Payne
>             Fix For: 0.4.0
>
>         Attachments: 
> 0001-NIFI-1241-Incorporate-Boolean-Numeric-and-Decimal-da.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)