You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Kevin Liew (JIRA)" <ji...@apache.org> on 2015/10/23 01:08:27 UTC

[jira] [Created] (PHOENIX-2347) Parameter 'signed' metadata is always returned as false

Kevin Liew created PHOENIX-2347:
-----------------------------------

             Summary: Parameter 'signed' metadata is always returned as false
                 Key: PHOENIX-2347
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2347
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.5.2
            Reporter: Kevin Liew
            Priority: Minor


Prepare a statement with parameters
ie. {noformat}request: {
    "request":"prepare",
    "connectionId":"1646a1b9-334e-4a21-ade8-47c3d0c8e5a3",
    "sql":"SELECT * FROM employees where emp_id =?",
    "maxRowCount":-1
    }{noformat}
response
{noformat}{
"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}}
    }
}{noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)