You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Ivan Daschinsky (Jira)" <ji...@apache.org> on 2021/04/09 08:06:00 UTC

[jira] [Commented] (IGNITE-11593) python thin client: insert and select VARBINARY data type through SQL

    [ https://issues.apache.org/jira/browse/IGNITE-11593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17317761#comment-17317761 ] 

Ivan Daschinsky commented on IGNITE-11593:
------------------------------------------

On  recent version all works ok
{code: python}
from pyignite import Client
import pyignite
print(pyignite.__version__)
client = Client()
client.connect('127.0.0.1', 10800)
client.sql('DROP TABLE test IF EXISTS')
client.sql('CREATE TABLE test(id int primary key, varbin VARBINARY)')
client.sql('INSERT INTO test(id, varbin) VALUES (?, ?)', query_args=(1, bytearray('Test message', 'UTF-8')))
result = client.sql('SELECT * FROM test')
field_data = list(*result)
print(field_data)
.......
0.4.0-dev
[1, bytearray(b'Test message')]
{code}


> python thin client: insert and select VARBINARY data type through SQL
> ---------------------------------------------------------------------
>
>                 Key: IGNITE-11593
>                 URL: https://issues.apache.org/jira/browse/IGNITE-11593
>             Project: Ignite
>          Issue Type: Bug
>          Components: thin client
>    Affects Versions: 2.7
>            Reporter: Stepan Pilschikov
>            Assignee: Dmitry Melnichuk
>            Priority: Major
>              Labels: python
>
> varbin data type select is getting not parsed array of integer values
> Example:
> https://gist.github.com/pilshchikov/b98ce5514209ef7009099b9c188398a6



--
This message was sent by Atlassian Jira
(v8.3.4#803005)