jokedst / CsvQuery

Plugin for Notepad++ that treats CSV files as (read only) SQL tables
153 stars 28 forks source link

A column named 'Something' already belongs to this DataTable #12

Closed jokedst closed 6 years ago

jokedst commented 6 years ago

When running a query that results in two columns having the same name (e.g. a self-join with select *) will cause an error popup.

Example data:

12,hej
32,san
99,foo

Run the query SELECT * FROM THIS A JOIN THIS B ON A.Col1 = B.Col1 Results in the error

Error when executing an action: A column named 'Col1' already belongs to this DataTable

Proposed fix: Make sure all columns has unique name when filling up the DataTable with the query results