search

datacamp / sqlwhat

https://sqlwhat.readthedocs.io
GNU Affero General Public License v3.0
3 stars 8 forks source link

Provide option in check_result to make case-insenstive #78

Closed filipsch closed 7 years ago

filipsch commented 7 years ago

Feedback from Graeme, Microsoft contact for the transact-sql course:

Also, I noticed that I get an error based on the column name case not matching the expected answer (e.g. if I were to use the alias CustomerName when it expects Customername) – by default , Transact-SQL is case-insensitive so this should not cause an error. Can you fix that?

I suggest we put an option in check_result() and test_column() to be forgiving for case sensitivity. Pretty urgent.

machow commented 7 years ago

Closing, since in prod. Issue on how to handle to cleanup in case it should be handled differently with postgres here:

85