Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
-
None
-
1.0.2-1
Description
LDI into datetime columns, data got saturated. insert works correctly
value used for testing is " 1400-01-01 00:00:00" |
"char data type only is ok |
+--------+--------+--------+--------+--------+--------+---------+----------+-----------+------------+
|
| CCHAR1 | CCHAR2 | CCHAR3 | CCHAR4 | CCHAR5 | CCHAR6 | CCHAR7 | CCHAR8 | CCHAR9 | CCHAR255 |
|
+--------+--------+--------+--------+--------+--------+---------+----------+-----------+------------+
|
| z | zz | zzz | zzzz | zzzzz | zzzzzz | zzzzzzz | zzzzzzzz | zzzzzzzzz | zzzzzzzzzz |
|
+--------+--------+--------+--------+--------+--------+---------+----------+-----------+------------+
|
1 row in set (0.26 sec) |
|
Adding a datetime datatype in front and use a value of ""1400-01-01 00:00:00"" |
Both c1 and cchar255 got saturated
|
|
MariaDB [mytest]> select * from t1;
|
+------+--------+--------+--------+--------+--------+--------+---------+----------+-----------+----------+
|
| c1 | CCHAR1 | CCHAR2 | CCHAR3 | CCHAR4 | CCHAR5 | CCHAR6 | CCHAR7 | CCHAR8 | CCHAR9 | CCHAR255 |
|
+------+--------+--------+--------+--------+--------+--------+---------+----------+-----------+----------+
|
| NULL | z | zz | zzz | zzzz | zzzzz | zzzzzz | zzzzzzz | zzzzzzzz | zzzzzzzzz | zzzzzzz |
|
|
|
adding datetime to the end, then only c1 got saturated
|
+--------+--------+--------+--------+--------+--------+---------+----------+-----------+------------+------+
|
| CCHAR1 | CCHAR2 | CCHAR3 | CCHAR4 | CCHAR5 | CCHAR6 | CCHAR7 | CCHAR8 | CCHAR9 | CCHAR255 | c1 |
|
+--------+--------+--------+--------+--------+--------+---------+----------+-----------+------------+------+
|
| z | zz | zzz | zzzz | zzzzz | zzzzzz | zzzzzzz | zzzzzzzz | zzzzzzzzz | zzzzzzzzzz | NULL |
|
+--------+--------+--------+--------+--------+--------+---------+----------+-----------+------------+------+
|
1 row in set (0.12 sec) |
"