Hi Thanks so much for your answ
On the other hand, I wonder if that would cause undesired interference with the SQL Boolean rules: maybe there is some place where the ability to treat a Bit as both an INT and a BOOLEAN causes ambiguities in the planner or in run-time type resolution code. On the one hand, Apache Drill lacks the function of converting BIT to number. But on the other hand, TypeCastRules explicitly declares the possibility of converting BIT to a number (e.g. line 162). So I'm trying to understand - is this an error in TypeCastRules, or an error in the absence of conversion functions? Or am I missing something else? Regarding the problem I am solving, I need these transformations, but I can’t understand which way to go: - make jar with udfs with necessary functions - try to do PR in Apache Drill with the addition of these functions (if TypeCastRules contains the correct information) P.S. I had to create a letter manually, I hope it will fall into the right thread
