usql icon indicating copy to clipboard operation
usql copied to clipboard

Better Error Checking When Creating Views

Open perfectly-panda opened this issue 8 years ago • 1 comments

I have a view that joins a couple external tables for easy access in scripts. Now that I am finally writing a script that uses the view, I keep running into errors with the view script so I am having to go back and correct that code before I can even begin to work with the new script. It would be preferable if these errors were thrown when I was creating the view.

For example, intentionally omitting a comma between column names in my view code compiles and runs, but then throws the appropriate error once I go to run the script that uses that view.

It would be preferable if these errors were checked when first creating the view.

perfectly-panda avatar Apr 18 '17 18:04 perfectly-panda

Hi serri

Thanks for the feedback. Please file a feature request at http://aka.ms/adlfeedback.

We will look at how to improve the error messages during view (and TVF) creation time, although given their late-bound application when being inlined, not all names may be resolvable.

MikeRys avatar Apr 19 '17 19:04 MikeRys