mithrandyr / SimplySql

PowerShell module for querying various SQL databases
MIT License
197 stars 31 forks source link

v2.0.4 - Fixing issue with incorrect query results when querying only some columns of a primary key table #154

Closed mithrandyr closed 3 months ago

mithrandyr commented 3 months ago

This will fix issue #146

DataTable.Load(dataReader) for MySql and SQLite will incorporate the primary key (if one exists) into the DataTable when loading the dataReader. This will cause issues if you are only selecting a portion of the primary key columns. Code has been changed to not leverage DataTable.Load() as a result. Issue is fixed.