writing to partitionned table is broken

[djouallah]

trying to write to a partitionned table i got this errors, notice, it works fine without partition

InternalException                         Traceback (most recent call last)
Cell In[6], line 1
----> 1 con.sql(F"""    INSERT INTO destination select * from source """)

InternalException: INTERNAL Error: DeltaInsert::Sink expects a single row containing output of the PhysicalCopy that should be its Source


Stack Trace:

/home/trusted-service-user/.duckdb/extensions/8be4461991/linux_amd64/delta.duckdb_extension(+0xddf24b) [0x7f9d032f624b]
/home/trusted-service-user/.duckdb/extensions/8be4461991/linux_amd64/delta.duckdb_extension(+0xddf304) [0x7f9d032f6304]
/home/trusted-service-user/.duckdb/extensions/8be4461991/linux_amd64/delta.duckdb_extension(+0xde1431) [0x7f9d032f8431]
/home/trusted-service-user/.duckdb/extensions/8be4461991/linux_amd64/delta.duckdb_extension(+0x308e9e) [0x7f9d0281fe9e]
/home/trusted-service-user/jupyter-env/python3.11/lib/python3.11/site-packages/_duckdb.cpython-311-x86_64-linux-gnu.so(_ZN6duckdb16PipelineExecutor19ExecutePushInternalERNS_9DataChunkERNS_15ExecutionBudgetEm+0x1fc) [0x7fa34ab2d43c]
/home/trusted-service-user/jupyter-env/python3.11/lib/python3.11/site-packages/_duckdb.cpython-311-x86_64-linux-gnu.so(_ZN6duckdb16PipelineExecutor7ExecuteEm+0x142) [0x7fa34ab2ddf2]
/home/trusted-service-user/jupyter-env/python3.11/lib/python3.11/site-packages/_duckdb.cpython-311-x86_64-linux-gnu.so(_ZN6duckdb12PipelineTask11ExecuteTaskENS_17TaskExecutionModeE+0x152) [0x7fa34ab2e162]
/home/trusted-service-user/jupyter-env/python3.11/lib/python3.11/site-packages/_duckdb.cpython-311-x86_64-linux-gnu.so(_ZN6duckdb12ExecutorTask7ExecuteENS_17TaskExecutionModeE+0xd6) [0x7fa34ab260e6]
/home/trusted-service-user/jupyter-env/python3.11/lib/python3.11/site-packages/_duckdb.cpython-311-x86_64-linux-gnu.so(_ZN6duckdb8Executor11ExecuteTaskEb+0x74) [0x7fa34ab2f4a4]
/home/trusted-service-user/jupyter-env/python3.11/lib/python3.11/site-packages/_duckdb.cpython-311-x86_64-linux-gnu.so(_ZN6duckdb13ClientContext19ExecuteTaskInternalERNS_17ClientContextLockERNS_15BaseQueryResultEb+0x50) [0x7fa34aae7130]
/home/trusted-service-user/jupyter-env/python3.11/lib/python3.11/site-packages/_duckdb.cpython-311-x86_64-linux-gnu.so(_ZN6duckdb18PendingQueryResult11ExecuteTaskEv+0x33) [0x7fa34aae72f3]
/home/trusted-service-user/jupyter-env/python3.11/lib/python3.11/site-packages/_duckdb.cpython-311-x86_64-linux-gnu.so(_ZN6duckdb18DuckDBPyConnection20CompletePendingQueryERNS_18PendingQueryResultE+0x52) [0x7fa349196442]
/home/trusted-service-user/jupyter-env/python3.11/lib/python3.11/site-packages/_duckdb.cpython-311-x86_64-linux-gnu.so(+0xca5e4d) [0x7fa3491a4e4d]
/home/trusted-service-user/jupyter-env/python3.11/lib/python3.11/site-packages/_duckdb.cpython-311-x86_64-linux-gnu.so(+0xcadc73) [0x7fa3491acc73]
/home/trusted-service-user/jupyter-env/python3.11/lib/python3.11/site-packages/_duckdb.cpython-311-x86_64-linux-gnu.so(+0xccca30) [0x7fa3491cba30]
/home/trusted-service-user/jupyter-env/python3.11/lib/python3.11/site-packages/_duckdb.cpython-311-x86_64-linux-gnu.so(+0xc4288a) [0x7fa34914188a]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x1f9196) [0x6533f5a01196]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(_PyObject_MakeTpCall+0x29b) [0x6533f59de6ab]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(_PyEval_EvalFrameDefault+0x70a) [0x6533f59ebd2a]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x29b0ad) [0x6533f5aa30ad]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(PyEval_EvalCode+0x9f) [0x6533f5aa27ef]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x2b1101) [0x6533f5ab9101]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(_PyEval_EvalFrameDefault+0x374b) [0x6533f59eed6b]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x2ae6e8) [0x6533f5ab66e8]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(_PyEval_EvalFrameDefault+0x33c1) [0x6533f59ee9e1]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x2ae6e8) [0x6533f5ab66e8]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(_PyEval_EvalFrameDefault+0x33c1) [0x6533f59ee9e1]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x2ae6e8) [0x6533f5ab66e8]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x2af1a7) [0x6533f5ab71a7]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x211029) [0x6533f5a19029]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(PyObject_Vectorcall+0x2c) [0x6533f59f88cc]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(_PyEval_EvalFrameDefault+0x70a) [0x6533f59ebd2a]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x227a92) [0x6533f5a2fa92]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x227316) [0x6533f5a2f316]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(PyObject_Call+0x134) [0x6533f5a1a964]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(_PyEval_EvalFrameDefault+0x4a29) [0x6533f59f0049]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x2ae6e8) [0x6533f5ab66e8]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(_PyEval_EvalFrameDefault+0x33c1) [0x6533f59ee9e1]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x2ae6e8) [0x6533f5ab66e8]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(_PyEval_EvalFrameDefault+0x33c1) [0x6533f59ee9e1]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x2ae6e8) [0x6533f5ab66e8]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(_PyEval_EvalFrameDefault+0x33c1) [0x6533f59ee9e1]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x2ae6e8) [0x6533f5ab66e8]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(_PyEval_EvalFrameDefault+0x33c1) [0x6533f59ee9e1]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x2ae6e8) [0x6533f5ab66e8]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(_PyEval_EvalFrameDefault+0x33c1) [0x6533f59ee9e1]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x2ae6e8) [0x6533f5ab66e8]
/home/trusted-service-user/jupyter-env/python3.11/lib/python3.11/lib-dynload/_asyncio.cpython-311-x86_64-linux-gnu.so(+0x76a6) [0x7fa3996766a6]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x1f7a3a) [0x6533f59ffa3a]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x191bf9) [0x6533f5999bf9]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x193c79) [0x6533f599bc79]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x1f09df) [0x6533f59f89df]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(_PyEval_EvalFrameDefault+0x8e2c) [0x6533f59f444c]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x29b0ad) [0x6533f5aa30ad]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(PyEval_EvalCode+0x9f) [0x6533f5aa27ef]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x2b1101) [0x6533f5ab9101]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x1f09df) [0x6533f59f89df]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(PyObject_Vectorcall+0x2c) [0x6533f59f88cc]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(_PyEval_EvalFrameDefault+0x70a) [0x6533f59ebd2a]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(_PyFunction_Vectorcall+0x17f) [0x6533f5a10a4f]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x2c3a28) [0x6533f5acba28]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(Py_RunMain+0x142) [0x6533f5acb402]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(Py_BytesMain+0x37) [0x6533f5a92a17]
/usr/lib/libc.so.6(+0x27efb) [0x7fa399b7aefb]
/usr/lib/libc.so.6(__libc_start_main+0x8b) [0x7fa399b7afbb]
/home/trusted-service-user/jupyter-env/python3.11/bin/python(+0x28a8ca) [0x6533f5a928ca]

This error signals an assertion failure within DuckDB. This usually occurs due to unexpected conditions or errors in the program's logic.
For more information, see https://duckdb.org/docs/stable/dev/internal_errors