chucheng92 commented on PR #3324: URL: https://github.com/apache/calcite/pull/3324#issuecomment-1678492298
> So to clarify: you can have an array with multiple types, but only if they are NUMERIC/CHARACTER? What if you have another combination like [1, Date '2008-12-25', 'a']? @tanclary thanks for reviewing. I understand your point. however, array function use `SameOperandTypeChecker`, it will cause exception firstly and can not enter arrayReturnTypeInference when use `[1, Date '2008-12-25', 'a']`.(varchar is a special case, it will pass SameOperandTypeChecker in SqlTypeUtil.isComparable). So, can returnTypeInference rely on OperandTypeChecker? if yes, then here we do not need other types check. and if no, we need other types check here. from your professional perspective, WDYT? -- 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]
