tianyahui-python

mysql> SELECT * FROM numbers WHERE ui=0; ERROR 1105 (HY000): Can't cast column from BIGINT UNSIGNED type to BIGINT type because of one or more values in that column. Reason:...

mysql> prepare s4 from 'delete from t2 where time1=?'; ERROR 1105 (HY000): Column 't2.PADDR' does not exist

https://docs.matrixorigin.io/cn/0.5.1/MatrixOne/Reference/Data-Types/data-types/

> now date type range is date[0001-01-01 to 9999-12-31] Where can I look this up？

As product design, the range of date should be the same as mysql which is between 1000-01-01 and 9999-12-31 ----------------------------------------------------------- @bbbearxyz

@daviszhen only issue owner is can close an issue.

>CREATE TABLE t1 (f1 double); >INSERT INTO t1 SET f1 = -1.0e+30 ; >INSERT INTO t1 SET f1 = +1.0e+30 ; >SELECT f1 AS double_val, CAST(f1 AS SIGNED INT) AS...