You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2016/01/23 03:45:39 UTC

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

     [ https://issues.apache.org/jira/browse/PHOENIX-2347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Taylor updated PHOENIX-2347:
----------------------------------
    Fix Version/s: 4.8.0

> 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
>              Labels: avatica, calcite, newbie, phoenix, queryserver
>             Fix For: 4.8.0
>
>
> 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)