Re: Questions about numeric type conversion

2024-06-09 Thread Cancai Cai
Hi Julian, Thank you for your answer Best regards, Cancai Cai Julian Hyde 于2024年6月10日周一 05:38写道: > I believe that there are many overlapping problems, many of which are that > each DBMS has its own semantics. > > In order to emulate a particular DBMS, we need to understand its > semantics, do

Re: Questions about numeric type conversion

2024-06-09 Thread Julian Hyde
I believe that there are many overlapping problems, many of which are that each DBMS has its own semantics. In order to emulate a particular DBMS, we need to understand its semantics, document that semantics by writing tests, and then follow that semantics (if Calcite is in a mode that should f

Questions about numeric type conversion

2024-06-09 Thread Cancai Cai
Hello calcite community, I would like to ask a question. Actually, I am not sure whether it is appropriate to ask this question in the calcite community. It is mainly about the database's handling of numeric types. [10:53:45]TiDB root:test> explain select id = 8145308033243873280 from test; +-