Bug in multiple result sets
Closed this issue · 2 comments
I found that when multiple result sets is returned, the description is not updated after calling the nextset
method. For example, I run the following SQL which returns 2 result sets. Table A
has 2 columns a
and d
. After calling the nextset
method, the description
is not updated (to show only 1 column a
). For small data sets, I often convert it to a pandas DataFrame for presentation purpose. Without the correct description information, I could do the conversion.
select * from A; select a from A
This is a bug in the UdaExec cursor wrapper. The underlying tdodbc cursor does update the description when nextset
is called. Will put out a new patch with the fix in the next day or two.
That's correct. I found that that teradata.tdodbc
works well and have been using it. Thank you very much for fixing the issue!