You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Roman Shtykh (JIRA)" <ji...@apache.org> on 2018/09/04 10:26:00 UTC

[jira] [Commented] (IGNITE-9453) REST: UUID column type displayed like byte array

    [ https://issues.apache.org/jira/browse/IGNITE-9453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16602870#comment-16602870 ] 

Roman Shtykh commented on IGNITE-9453:
--------------------------------------

Looks like it's not only about REST.

{{H2Utils.meta()}} calls {{ResultSetMetaData#getColumnClassName}} which returns a Java type.
 I think for SQL we have rather call \{{ResultSetMetaData#getColumnTypeName }}

[~vozerov] what do you think?

> REST: UUID column type displayed like byte array
> ------------------------------------------------
>
>                 Key: IGNITE-9453
>                 URL: https://issues.apache.org/jira/browse/IGNITE-9453
>             Project: Ignite
>          Issue Type: Bug
>          Components: rest
>    Affects Versions: 2.5
>            Reporter: Stepan Pilschikov
>            Assignee: Roman Shtykh
>            Priority: Major
>
> Case:
> - Create table with uuid
> {code:sql}
> CREATE TABLE test(id int primary key, field varchar2(50), uuid UUID)
> {code}
> - Execute `select * from test` query with rest
> {code:bash}
> curl "http://localhost:8080/ignite?cmd=qryfldexe&pageSize=10&cacheName=SQL_PUBLIC_TEST&qry=select%20%2A%20from%20test%3B"
> {code}
> Actual:
> {code:json}
> {
>     "successStatus": 0,
>     "sessionToken": null,
>     "error": null,
>     "response": {
>         "items": [],
>         "last": true,
>         "fieldsMetadata": [
>             {
>                 "schemaName": "PUBLIC",
>                 "typeName": "TEST",
>                 "fieldName": "ID",
>                 "fieldTypeName": "java.lang.Integer"
>             },
>             {
>                 "schemaName": "PUBLIC",
>                 "typeName": "TEST",
>                 "fieldName": "FIELD",
>                 "fieldTypeName": "java.lang.String"
>             },
>             {
>                 "schemaName": "PUBLIC",
>                 "typeName": "TEST",
>                 "fieldName": "UUID",
>                 "fieldTypeName": "[B"
>             }
>         ],
>         "queryId": 0
>     }
> }
> {code}
> Expected:
> uuid was displayed somehow but not "[B"



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)