babelfish_extensions icon indicating copy to clipboard operation
babelfish_extensions copied to clipboard

[Bug]: TDS Column MetaData is different and looks incorrect

Open dcowan-e-courier opened this issue 1 year ago • 1 comments

What happened?

I have noticed ADO.net rowsets do not behave correctly when trying to do batch operations. Also inspecting rowset xml differs between mssql and babelfish. Key columns are not identified as key columns. I believe this is due to the TDS metadata for columns.

For a query like

select RateGroupID,Description from RateGroup with (readuncommitted) order by Description

I get TDS data like so image

For babelfish 3.4 I get this result

image

Notice many flags are missing. Also notice the Identity Flag is always true even for non identity columns. Also Updateable is false for babelfish

ADO.net connections seem to rely heavily on the column metadata and its correctness.

Version

BABEL_3_X_DEV (Default)

Extension

None

Which flavor of Linux are you using when you see the bug?

Ubuntu (Default)

Relevant log output

No response

Code of Conduct

  • [X] I agree to follow this project's Code of Conduct.

dcowan-e-courier avatar Feb 28 '24 21:02 dcowan-e-courier