[
https://issues.apache.org/jira/browse/PHOENIX-2422?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-2422:
----------------------------------
Issue Type: Improvement (was: Bug)
Summary: Differentiate between null and empty string (was: Null
upserted instead of empty string)
> Differentiate between null and empty string
> -------------------------------------------
>
> Key: PHOENIX-2422
> URL: https://issues.apache.org/jira/browse/PHOENIX-2422
> Project: Phoenix
> Issue Type: Improvement
> 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
> Labels: char, null, phoenix, string
>
> 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)
