×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Personally, I treat anything but 00000 and 02000 as abnormal conditions (unless explicitly ignored).
-----Original Message-----
From: John Yeung [mailto:gallium.arsenide@xxxxxxxxx]
Sent: Thursday, February 27, 2020 12:48 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Compatible data types in SQL CASE expressions
On Thu, Feb 27, 2020 at 1:04 PM Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:
I get SQLSTATE 01565.
Ah, fair enough. The "messages and codes" reference says that states starting with 01 are "just" warnings, so that would explain why the operation still succeeds.
I'll accept that it's my responsibility to be aware of possible warnings. I still disagree with the wording in the reference regarding CASE expressions. To me, "must" implies a hard error is coming if you fail to meet the requirement, unless there is an explicit explanation otherwise.
John Y.
midrange.com
