Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1186

Parameter 'signed' metadata is always returned as false

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    Description

      Prepare a statement with parameters
      ie.

      request: {
          "request":"prepare",
          "connectionId":"1646a1b9-334e-4a21-ade8-47c3d0c8e5a3",
          "sql":"SELECT * FROM employees where emp_id =?",
          "maxRowCount":-1
          }

      response

      {
      "response":"prepare",
      "statement":{
          "connectionId":"1646a1b9-334e-4a21-ade8-47c3d0c8e5a3",
          "id":972365839,
          "signature":{
              "columns":[
                  {"ordinal":0,"autoIncrement":false,"caseSensitive":false,"searchable":true,"currency":false,"nullable":0,"signed":true,"displaySize":40,"label":"EMP_ID","columnName":"EMP_ID","schemaName":"","precision":0,"scale":0,"tableName":"EMPLOYEES","catalogName":"","type":{"type":"scalar","id":4,"name":"INTEGER","rep":"PRIMITIVE_INT"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.Integer"},
                  {"ordinal":1,"autoIncrement":false,"caseSensitive":false,"searchable":true,"currency":false,"nullable":1,"signed":false,"displaySize":40,"label":"LAST_NAME","columnName":"LAST_NAME","schemaName":"","precision":0,"scale":0,"tableName":"EMPLOYEES","catalogName":"","type":{"type":"scalar","id":12,"name":"VARCHAR","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"},
                  {"ordinal":2,"autoIncrement":false,"caseSensitive":false,"searchable":true,"currency":false,"nullable":1,"signed":false,"displaySize":40,"label":"FIRST_NAME","columnName":"FIRST_NAME","schemaName":"","precision":0,"scale":0,"tableName":"EMPLOYEES","catalogName":"","type":{"type":"scalar","id":12,"name":"VARCHAR","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"}],
              "sql":"SELECT * FROM employees where emp_id=?",
              "parameters":[
                  {"signed":false,"precision":0,"scale":0,"parameterType":4,"typeName":"INTEGER","className":"java.lang.Integer","name":"?1"}
              ],
              "cursorFactory":{"style":"LIST","clazz":null,"fieldNames":null}}
          }
      }

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            elserj Josh Elser
            kliew Kevin Liew
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment