[jira] [Created] (PHOENIX-2422) Null upserted instead of empty string

[Kevin Liew (JIRA)]

Kevin Liew created PHOENIX-2422:
-----------------------------------

             Summary: Null upserted instead of empty string
                 Key: PHOENIX-2422
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2422
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.5.2
         Environment: Sending Avatica requests to Phoenix 4.5.2 using Telerik 
Fiddler or any REST test tool
            Reporter: Kevin Liew


Create a table with a character column (use the JDBC driver or bulk import tool)
{noformat}
DROP TABLE IF EXISTS SEN.Char_Table;
CREATE TABLE IF NOT EXISTS SEN.Char_Table(
        KeyColumn VARCHAR(255) PRIMARY KEY,
        Column1 CHAR(100));
{noformat}

Upsert an empty string using Avatica wire protocol
{noformat}
request: {
  "request": "prepareAndExecute",
  "connectionId": "bed590dc-04d0-f1c2-16cd-a20107271BA9",
  "sql": "UPSERT INTO SEN.CHAR_TABLE(KeyColumn, Column1) 
VALUES('ConversionTestKey', '')",
  "maxRowCount": -1
}
{noformat}

Query the inserted data
{noformat}
request: {
  "request": "prepareAndExecute",
  "connectionId": "bed590dc-04d0-f1c2-16cd-a20107271BA9",
  "sql": "SELECT RTRIM(Column1) FROM SEN.CHAR_TABLE WHERE RTRIM(KeyColumn) = 
'ConversionTestKey'",
  "maxRowCount": -1
}
{noformat}

Actual result:
{noformat}
{
  "response": "Service$ExecuteResponse",
  "results": [
    {
      "response": "resultSet",
      "connectionId": "bed590dc-04d0-f1c2-16cd-a20107271BA9",
      "statementId": 371048010,
      "ownStatement": true,
      "signature": {
        "columns": [
          {
            "ordinal": 0,
            "autoIncrement": false,
            "caseSensitive": false,
            "searchable": true,
            "currency": false,
            "nullable": 1,
            "signed": false,
            "displaySize": 255,
            "label": "RTRIM(COLUMN1)",
            "columnName": "RTRIM(COLUMN1)",
            "schemaName": "",
            "precision": 255,
            "scale": 0,
            "tableName": "SEN.CHAR_TABLE",
            "catalogName": "",
            "type": {
              "type": "scalar",
              "id": 12,
              "name": "VARCHAR",
              "rep": "STRING"
            },
            "readOnly": true,
            "writable": false,
            "definitelyWritable": false,
            "columnClassName": "java.lang.String"
          }
        ],
        "sql": null,
        "parameters": [
          
        ],
        "cursorFactory": {
          "style": "LIST",
          "clazz": null,
          "fieldNames": null
        }
      },
      "firstFrame": {
        "offset": 0,
        "done": true,
        "rows": [
          [
            null
          ]
        ]
      },
      "updateCount": -1
    }
  ]
}
{noformat}

Expected result: results.firstFrame.rows\[0\] should contain an empty string, 
not 'null'



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