phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kevin Liew (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-2424) No error returned when upserting unsupported characters into a varchar column
Date Mon, 16 Nov 2015 21:34:11 GMT
Kevin Liew created PHOENIX-2424:
-----------------------------------

             Summary: No error returned when upserting unsupported characters into a varchar
column
                 Key: PHOENIX-2424
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2424
             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.WChar_Table;
CREATE TABLE IF NOT EXISTS SEN.WChar_Table(
	KeyColumn VARCHAR(255) PRIMARY KEY,
	Column1 CHAR(100));
{noformat}

Upsert an unsupported character using Avatica wire protocol
{noformat}
request: {
  "request": "prepareAndExecute",
  "connectionId": "1ccf2934-7b9b-491b-7d37-17be44bc811E",
  "sql": "UPSERT INTO SEN.WVARCHAR_TABLE(KeyColumn, Column1) VALUES('ConversionTestKey', '喂')",
  "maxRowCount": -1
}
{noformat}

We expect an error (as occurs when attempting to upsert into a CHAR column) but instead the
upsert succeeds. So we query the inserted data and find that incorrect data was inserted at
results.firstFrame.rows\[0\]
{noformat}
{
  "response": "Service$ExecuteResponse",
  "results": [
    {
      "response": "resultSet",
      "connectionId": "1ccf2934-7b9b-491b-7d37-17be44bc811E",
      "statementId": 592785849,
      "ownStatement": true,
      "signature": {
        "columns": [
          {
            "ordinal": 0,
            "autoIncrement": false,
            "caseSensitive": false,
            "searchable": true,
            "currency": false,
            "nullable": 1,
            "signed": false,
            "displaySize": 510,
            "label": "COLUMN1",
            "columnName": "COLUMN1",
            "schemaName": "",
            "precision": 510,
            "scale": 0,
            "tableName": "SEN.WVARCHAR_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": [
          [
            "喂"
          ]
        ]
      },
      "updateCount": -1
    }
  ]
}
{noformat}




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

Mime
View raw message