Hello:

Can someone clarify this for me?

In "CASE a WHEN b THEN c [ELSE f] END", are the following rules necessary?

1. a and b should have the same TypeInfo, or an exception will be thrown.
2. c and f should have the same TypeInfo, or an exception will be thrown.

Right now, even if c is int, f is smallint, it throws exception.

Please let me know whether such restriction is there by design.

Thank you very much!

Xiu

Reply via email to