julianhyde commented on PR #3947: URL: https://github.com/apache/calcite/pull/3947#issuecomment-2518458355
I agree with your remark that variants are difficult to use without TYPEOF. We could also add something like this (apologies for the crappy syntax, hopefully you get the idea): ``` CASE v WHENINSTANCEOF number THEN v + 5 WHENINSTANCEOF varchar THEN length(v) ELSE 0 END ``` I believe Java has something like this and maybe some SQL dialects do too. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
