[CALCITE-1186] Parameter 'signed' metadata is always returned as false

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: avatica-1.8.0
• Component/s: avatica
• Labels: avatica calcite newbie phoenix queryserver
• Assignee: Josh Elser
• Reporter: Kevin Liew
• Created: 22/Oct/15 23:08
• Updated: 29/Apr/19 17:14
• Resolved: 04/Apr/16 21:57

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