Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-9453

REST: UUID column type displayed like byte array

    Details

    • Type: Bug
    • Status: In Progress
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.5
    • Fix Version/s: None
    • Component/s: rest
    • Labels:
      None
    • Ignite Flags:
      Docs Required

      Description

      Case:

      • Create table with uuid
        CREATE TABLE test(id int primary key, field varchar2(50), uuid UUID)
        
      • Execute `select * from test` query with rest
        curl "http://localhost:8080/ignite?cmd=qryfldexe&pageSize=10&cacheName=SQL_PUBLIC_TEST&qry=select%20%2A%20from%20test%3B"
        

      Actual:

      {
          "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
          }
      }
      

      Expected:
      uuid was displayed somehow but not "[B"

        Attachments

          Activity

            People

            • Assignee:
              shroman Roman Shtykh
              Reporter:
              spilschikov Stepan Pilschikov
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: