CurtHagenlocher commented on issue #4198: URL: https://github.com/apache/arrow-adbc/issues/4198#issuecomment-4207201904
One thing to be aware of for multi-row binding is that you generally need to preallocate enough space to hold the maximum-sized values for a particular column. This becomes problematic when the table has IMAGE or TEXT columns with a very large upper bound on the size. Single-row binding is usually okay, because you can bind a smaller buffer and then fetch that entire value explicitly with `SQLGetData` when there's an overflow. But this doesn't usually work for multi-row binding because most drivers don't let you go back and do `SQLGetData` against a previous row -- you need (IIRC) a local cursor for that. -- 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]
