[MDEV-5402] Make "constant_string_expr+interval" look inside the constant to detect a correct data type - Jira

Alexander Barkov created issue - 2013-12-06 18:34

Alexander Barkov made changes - 2013-12-06 18:34

Field	Original Value	New Value
Summary	Make "constant_string_expr+interval" functions look inside the constant to detect a correct data type	Make "constant_string_expr+interval" look inside the constant to detect a correct data type

Alexander Barkov made changes - 2013-12-06 18:34

Description

Notice the difference between the two expressions:

{code}
mysql> select '10:10:10'+interval 1 minute, time('10:10:10')+interval 1 minute;+------------------------------+------------------------------------+
| '10:10:10'+interval 1 minute | time('10:10:10')+interval 1 minute |
+------------------------------+------------------------------------+
| 2010-10-10 00:01:00 | 10:11:10 |
+------------------------------+------------------------------------+
1 row in set (0.00 sec)
{code}

The first expression should return '10:11:10',
similar to the second one.

Let's do it only in 10.x.

Notice the difference between the two expressions:

{code}
mysql> select '10:10:10'+interval 1 minute, time('10:10:10')+interval 1 minute;
+------------------------------+------------------------------------+
| '10:10:10'+interval 1 minute | time('10:10:10')+interval 1 minute |
+------------------------------+------------------------------------+
| 2010-10-10 00:01:00 | 10:11:10 |
+------------------------------+------------------------------------+
1 row in set (0.00 sec)
{code}

The first expression should return '10:11:10',
similar to the second one.

Let's do it only in 10.x.

Alexander Barkov made changes - 2013-12-06 18:37

Description

Notice the difference between the two expressions:

{code}
mysql> select '10:10:10'+interval 1 minute, time('10:10:10')+interval 1 minute;
+------------------------------+------------------------------------+
| '10:10:10'+interval 1 minute | time('10:10:10')+interval 1 minute |
+------------------------------+------------------------------------+
| 2010-10-10 00:01:00 | 10:11:10 |
+------------------------------+------------------------------------+
1 row in set (0.00 sec)
{code}

The first expression should return '10:11:10',
similar to the second one.

Let's do it only in 10.x.

Notice the difference between the two expressions:

{code}
mysql> select '10:10:10'+interval 1 minute, time('10:10:10')+interval 1 minute;
+------------------------------+------------------------------------+
| '10:10:10'+interval 1 minute | time('10:10:10')+interval 1 minute |
+------------------------------+------------------------------------+
| 2010-10-10 00:01:00 | 10:11:10 |
+------------------------------+------------------------------------+
1 row in set (0.00 sec)
{code}

The first expression should return '10:11:10',
similar to the second one.

Let's do it only in 10.x.

Note, another temporal hybrid function ADDTIME() seems to work correctly:
{code}
mysql> select addtime('10:10:10',1), addtime('2001-01-01 10:10:10',1);
+-----------------------+----------------------------------+
| addtime('10:10:10',1) | addtime('2001-01-01 10:10:10',1) |
+-----------------------+----------------------------------+
| 10:10:11 | 2001-01-01 10:10:11 |
+-----------------------+----------------------------------+
1 row in set (0.00 sec)
{code}

Sergei Golubchik made changes - 2013-12-06 18:49

Fix Version/s

10.0.8 [ 14200 ]

Sergei Golubchik made changes - 2014-02-10 16:13

Fix Version/s		10.0.9 [ 14400 ]
Fix Version/s	10.0.8 [ 14200 ]

Sergei Golubchik made changes - 2014-03-09 22:02

Fix Version/s		10.0.10 [ 14500 ]
Fix Version/s	10.0.9 [ 14400 ]

Sergei Golubchik made changes - 2014-03-31 14:23

Fix Version/s		10.0.11 [ 15200 ]
Fix Version/s	10.0.10 [ 14500 ]

Sergei Golubchik made changes - 2014-05-10 23:12

Fix Version/s		10.0.12 [ 15201 ]
Fix Version/s	10.0.11 [ 15200 ]

Sergei Golubchik made changes - 2014-06-13 15:06

Workflow

defaullt [ 30635 ]

MariaDB v2 [ 44674 ]

Sergei Golubchik made changes - 2014-06-16 13:27

Fix Version/s		10.0.13 [ 16000 ]
Fix Version/s	10.0.12 [ 15201 ]

Rasmus Johansson (Inactive) made changes - 2015-05-18 17:51

Workflow

MariaDB v2 [ 44674 ]

MariaDB v3 [ 63696 ]

Alexander Barkov made changes - 2017-04-17 05:05

Link

This issue blocks ~~MDEV-4912~~ [ ~~MDEV-4912~~ ]

Alexander Barkov made changes - 2017-04-17 05:06

Labels

datatype

Alexander Barkov made changes - 2019-11-15 13:06

Component/s

Data types [ 13906 ]

Alexander Barkov made changes - 2019-11-15 13:06

Component/s

Temporal Types [ 11000 ]

Julien Fritsch made changes - 2019-11-18 11:41

Epic Link

MDEV-21071 [ 80504 ]

Julien Fritsch made changes - 2019-11-18 12:00

Link

This issue blocks ~~MDEV-4912~~ [ ~~MDEV-4912~~ ]

Sergei Golubchik made changes - 2021-12-06 21:32

Workflow

MariaDB v3 [ 63696 ]

MariaDB v4 [ 139565 ]

Sergei Golubchik made changes - 2022-09-08 09:54

Fix Version/s

10.0 [ 16000 ]

Sergei Golubchik made changes - 2022-10-31 13:26

Fix Version/s		10.7 [ 24805 ]
Fix Version/s		10.8 [ 26121 ]
Fix Version/s		10.9 [ 26905 ]
Fix Version/s		10.10 [ 27530 ]

Julien Fritsch made changes - 2023-03-03 17:36

Fix Version/s

10.7 [ 24805 ]

Julien Fritsch made changes - 2023-04-27 14:52

Fix Version/s

10.8 [ 26121 ]

Julien Fritsch made changes - 2023-11-28 10:51

Fix Version/s

10.11 [ 27614 ]

Julien Fritsch made changes - 2023-11-28 10:54

Fix Version/s	10.9 [ 26905 ]
Fix Version/s	10.10 [ 27530 ]

MariaDB Server

Make "constant_string_expr+interval" look inside the constant to detect a correct data type

Details

Description

Attachments

Activity

People

Dates

Git Integration