When copying and pasting queries be careful about auto-formatting. Many editors want to replace an n-dash '-' with an m-dash '–' . Some (or possibly most) SQL shells interpret these differently. Often, only the first is synonymous with subtraction.
It took an embarrassing amount of time today for me to catch that one. I hope someone is spared a few minutes by my wasted time.
No comments:
Post a Comment