Support sql_mode TIME_TRUNCATE_FRACTIONAL #29406
Labels
type/feature-request
Categorizes issue or PR as related to a new feature.
Comments
Thearas
added
the
type/feature-request
|
Currently, TiDB behaves as if Consider the following testcase: CREATE TABLE t1 (a INT, b TIME(6));
INSERT INTO t1 (b) VALUES ('-10:10:59.500000');
INSERT INTO t1 (b) VALUES ('-10:10:59.500000');
UPDATE t1 SET a=b;
SELECT * FROM t1;
..
tidb> SELECT * FROM t1;
+---------+------------------+
| a | b |
+---------+------------------+
| -101059 | -10:10:59.500000 |
| -101059 | -10:10:59.500000 |
+---------+------------------+
2 rows in set (0.00 sec)
mysql [localhost:5735] {msandbox} (test) > SELECT * FROM t1;
+---------+------------------+
| a | b |
+---------+------------------+
| -101100 | -10:10:59.500000 |
| -101100 | -10:10:59.500000 |
+---------+------------------+
2 rows in set (0.00 sec) |
This was referenced Oct 3, 2024
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Feature Request
Is your feature request related to a problem? Please describe:
No.
Describe the feature you'd like:
Same as mysql
TIME_TRUNCATE_FRACTIONAL. I don't want to rounddatetime, truncation is better in my scene.Describe alternatives you've considered:
No.
Teachability, Documentation, Adoption, Migration Strategy:
See MySQL Doc: https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html#sqlmode_time_truncate_fractional
The text was updated successfully, but these errors were encountered: