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

Parameter 'signed' metadata is always returned as false

    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

            People

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

              Dates

              • Created:
                Updated:
                Resolved: