phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Reopened] (PHOENIX-2422) Differentiate between null and empty string
Date Sun, 22 Nov 2015 05:09:11 GMT

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

James Taylor reopened PHOENIX-2422:
-----------------------------------

> 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)

Mime
View raw message