about data type

[hanyisong]

1. Does databend currently have an exponential form of writing? Will it be supported later?

mysql> desc t1;
+-------+--------+------+-------------------------------------------+-------+
| Field | Type   | Null | Default                                   | Extra |
+-------+--------+------+-------------------------------------------+-------+
| c0    | DOUBLE | NO   | cast(1969-12-12 23:25:03 as Timestamp(6)) |       |
+-------+--------+------+-------------------------------------------+-------+
1 row in set (0.02 sec)
Read 0 rows, 0.00 B in 0.008 sec., 0 rows/sec., 0.00 B/sec.

mysql> INSERT INTO t1(c0) VALUES (1541870038), (1.903583017e+9);
ERROR 1105 (HY000): Code: 1005, displayText = sql parser error: Expected ), found: e.
mysql> INSERT INTO t1(c0) VALUES (1e9);
ERROR 1105 (HY000): Code: 1005, displayText = sql parser error: Expected ), found: e9.

2. Can't databend insert using DEFAULT

mysql> desc t1;
+-------+--------+------+-------------------------------------------+-------+
| Field | Type   | Null | Default                                   | Extra |
+-------+--------+------+-------------------------------------------+-------+
| c0    | DOUBLE | NO   | cast(1969-12-12 23:25:03 as Timestamp(6)) |       |
+-------+--------+------+-------------------------------------------+-------+
1 row in set (0.01 sec)
Read 0 rows, 0.00 B in 0.005 sec., 0 rows/sec., 0.00 B/sec.

mysql> INSERT INTO t1(c0) VALUES (DEFAULT);
ERROR 1105 (HY000): Code: 1006, displayText = Unable to get field named "DEFAULT". Valid fields: ["c0"].

[BohuTANG]

Create an issue to track: #6719