SELECT .... FROM A LEFT SEMI JOIN B ON (A.col1 = B.col2) WHERE ... " If A.col1 is of DOUBLE type, but B.col2 is of BIGINT, will print WARNING: Comparing a bigint and a double may result in a loss of precision. Why can't cast col2 to double automatically?
r7raul1...@163.com
