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

Taeyun Kim updated PHOENIX-1933:
--------------------------------
    Description: 
The following test fails:

{code:title=Test.java|borderStyle=solid}
    @Test
    public void testPhoenix5() throws Exception
    {
        try (Connection con = DriverManager.getConnection(
            "jdbc:phoenix:cluster02,cluster03,cluster04:2181:/hbase-unsecure"))
        {
            Statement stmt = con.createStatement();
            stmt.executeUpdate("drop table if exists test_tinyint");
            stmt.executeUpdate(
                "create table test_tinyint (i tinyint not null primary key)");
            stmt.executeUpdate("upsert into test_tinyint values (-1)");
            con.commit();
        }
    }
{code}

When value (-1) is replaced with (-2), it works.


  was:
The following test fails:

    @Test
    public void testPhoenix5() throws Exception
    {
        try (Connection con = DriverManager.getConnection(
            "jdbc:phoenix:cluster02,cluster03,cluster04:2181:/hbase-unsecure"))
        {
            Statement stmt = con.createStatement();
            stmt.executeUpdate("drop table if exists test_tinyint");
            stmt.executeUpdate(
                "create table test_tinyint (i tinyint not null primary key)");
            stmt.executeUpdate("upsert into test_tinyint values (-1)");
            con.commit();
        }
    }

When value (-1) is replaced with (-2), it works.



> Cannot upsert -1 into a tinyint column
> --------------------------------------
>
>                 Key: PHOENIX-1933
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1933
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.3.0
>         Environment: Windows
>            Reporter: Taeyun Kim
>
> The following test fails:
> {code:title=Test.java|borderStyle=solid}
>     @Test
>     public void testPhoenix5() throws Exception
>     {
>         try (Connection con = DriverManager.getConnection(
>             
> "jdbc:phoenix:cluster02,cluster03,cluster04:2181:/hbase-unsecure"))
>         {
>             Statement stmt = con.createStatement();
>             stmt.executeUpdate("drop table if exists test_tinyint");
>             stmt.executeUpdate(
>                 "create table test_tinyint (i tinyint not null primary key)");
>             stmt.executeUpdate("upsert into test_tinyint values (-1)");
>             con.commit();
>         }
>     }
> {code}
> When value (-1) is replaced with (-2), it works.



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

Reply via email to