This is an issue with sets originally created from a SqlTable, which initializes SqlSet with tableName and columnList. When calling Select(), the original columnList is ignored. Calling Select() again works fine since the set is now based on a definingQuery.
It is probable safe to ignore the original columnList if equal to *, otherwise a subquery should be created. This bug has been there forever, but only recently caused an issue with a database that used an invisible column. The column was listed in the columnList, but a Select<MyDto>("*") made the column invisible again.
This is an issue with sets originally created from a SqlTable, which initializes SqlSet with tableName and columnList. When calling Select(), the original columnList is ignored. Calling Select() again works fine since the set is now based on a definingQuery.
It is probable safe to ignore the original columnList if equal to
*, otherwise a subquery should be created. This bug has been there forever, but only recently caused an issue with a database that used an invisible column. The column was listed in the columnList, but aSelect<MyDto>("*")made the column invisible again.