Prussian1870 opened a new issue, #1077:
URL: https://github.com/apache/arrow-adbc/issues/1077
When a cursor is created that has some of the target table's columns, the
commit fails. It succeeds when the cursor matches the target table exactly.
This is an issue if the target table has a default insert date or a primary key
that is filled by default:
conn=adbc_sqlite.connect("C:/projects/adbc.db")
tbl_1=pyarrow.Table.from_pydict({'numbers': [1, 2], 'letters': ['a', 'b']})
db_cursor=conn.cursor()
db_cursor.execute("drop table if exists adbc_bug")
db_cursor.adbc_ingest("adbc_bug", tbl_1, "create")
db_cursor.connection.commit()`
tbl_2=pyarrow.Table.from_pydict({'numbers': [3, 4]})
db_cursor.adbc_ingest("adbc_bug", tbl_2, "append")
db_cursor.connection.commit()
db_cursor.close()
Error:
File "C:\py_310\lib\site-packages\adbc_driver_manager\dbapi.py", line 789,
in adbc_ingest
return self._stmt.execute_update()
File "adbc_driver_manager\\_lib.pyx", line 1068, in
adbc_driver_manager._lib.AdbcStatement.execute_update
File "adbc_driver_manager\\_lib.pyx", line 399, in
adbc_driver_manager._lib.check_error
adbc_driver_manager.InternalError: INTERNAL: [SQLite] Failed to prepare
statement: table adbc_bug has 2 columns but 1 values were supplied (executed
'INSERT INTO adbc_bug VALUES (?)')
Thanks
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
