andrenmo opened a new issue, #2068:
URL: https://github.com/apache/arrow-adbc/issues/2068
### What happened?
When querying JSONB data the ADBC driver add an extra "\x01" at the
beginning of each row.
This query:
```SQL
select '{"a": 1}'::jsonb
```
Should return a byte type row with the following data
```python
'{"a": 1}'
```
But instead it returns a byte type row with the following data:
```python
'\x01{"a": 1}'
```
It does not happens if we change the query to JSON:
```SQL
select '{"a": 1}'::json
```
I am not sure if it is a bug or a expected behavior but when querying from
psycopg2 this difference does not occurs.
### Stack Trace
_No response_
### How can we reproduce the bug?
```python
import adbc_driver_postgresql.dbapi
conn_string = 'postgresql://postgres:XXXX@localhost:5432/postgres'
conn = adbc_driver_postgresql.dbapi.connect(conn_string)
cursor = conn.cursor()
query = 'select \'{"a": 1}\'::jsonb'
cursor.execute(query)
cursor.fetchall()
```
### Environment/Setup
macOS
PostgreSQL 15
adbc-driver-postgresql 1.1.0
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscr...@arrow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
