dongdongyang
dongdongyang
>[SQL STATEMENT]: SELECT floor(ceil(12345678901234567890)); [EXPECT RESULT]: floor(ceil(12345678901234567890)) 12345678901234567890 [ACTUAL RESULT]: floor(ceil(12345678901234567890)) -6101065172474983726 **CURRENT [ACTUAL RESULT]:** floor(ceil(12345678901234567890)) 12345678901234567890 This issue has been fixed.
>[SQL STATEMENT]: select floor(cast(-2 as unsigned)), floor(18446744073709551614), floor(-2); [EXPECT RESULT]: floor(cast(-2 as unsigned)) floor(18446744073709551614) floor(-2) 18446744073709551614 18446744073709551614 -2 [ACTUAL RESULT]: floor(cast(-2 as unsigned unsigned)) floor(18446744073709551614) floor(-2) 18446744073709551614 -2 -2 **CURRENT...
>[SQL STATEMENT]: select floor(9.999999999999999999999); [EXPECT RESULT]: floor(9.999999999999999999999) 9 [ACTUAL RESULT]: floor(9.999999999999999999999) 10.0 will be fixed in 0.6 #3579
the non-numeric value for `LIMIT` should be treated as a SQL syntax error. but it passed into compiler and the compiler tried to cast it into numeric so we got...
> Is there a doc/comment on what the return value true/false means? no unified doc for it now. I add a comment for the return value
add account limit for * `show databases` * `show table` * `show table status` * `show index` * `show columns`