[MDEV-4653] Wrong result for CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5') - Jira

Alexander Barkov created issue - 2013-06-13 08:59

Alexander Barkov made changes - 2013-06-13 09:00

Field	Original Value	New Value
Assignee		Alexander Barkov [ bar ]

Alexander Barkov made changes - 2013-06-13 09:00

Description

This SQL query returns a wrong result:
<code:sql>
mysql> SELECT CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5'); show warnings;
+----------------------------------------------+
| CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5') |
+----------------------------------------------+
| 0000-00-00 00:00:00 |
+----------------------------------------------+
1 row in set (0.00 sec)
<code>

The expected result is NULL with a warning.

Note: this problem is not repeatable with mysql-5.1, 5.5.

This SQL query returns a wrong result:
{<code:sql}
mysql> SELECT CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5'); show warnings;
+----------------------------------------------+
| CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5') |
+----------------------------------------------+
| 0000-00-00 00:00:00 |
+----------------------------------------------+
1 row in set (0.00 sec)
{code}

The expected result is NULL with a warning.

Note: this problem is not repeatable with mysql-5.1, 5.5.

Alexander Barkov made changes - 2013-06-13 09:01

Description

This SQL query returns a wrong result:
{<code:sql}
mysql> SELECT CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5'); show warnings;
+----------------------------------------------+
| CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5') |
+----------------------------------------------+
| 0000-00-00 00:00:00 |
+----------------------------------------------+
1 row in set (0.00 sec)
{code}

The expected result is NULL with a warning.

Note: this problem is not repeatable with mysql-5.1, 5.5.

This SQL query returns a wrong result:
{code:sql}
mysql> SELECT CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5'); show warnings;
+----------------------------------------------+
| CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5') |
+----------------------------------------------+
| 0000-00-00 00:00:00 |
+----------------------------------------------+
1 row in set (0.00 sec)
{code}

The expected result is NULL with a warning.

Note: this problem is not repeatable with mysql-5.1, 5.5.

Alexander Barkov made changes - 2013-06-13 09:28

Description

This SQL query returns a wrong result:
{code:sql}
mysql> SELECT CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5'); show warnings;
+----------------------------------------------+
| CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5') |
+----------------------------------------------+
| 0000-00-00 00:00:00 |
+----------------------------------------------+
1 row in set (0.00 sec)
{code}

The expected result is NULL with a warning.

Note: this problem is not repeatable with mysql-5.1, 5.5.

This SQL query returns a wrong result:
{code:sql}
mysql> SELECT CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5'); show warnings;
+----------------------------------------------+
| CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5') |
+----------------------------------------------+
| 0000-00-00 00:00:00 |
+----------------------------------------------+
1 row in set (0.00 sec)
{code}

The expected result is NULL with a warning.
The same problem happens in this query:
mysql> SELECT CONVERT_TZ(TIME('2010-01-01 00:00:00'),'+00:00','+7:5');
+---------------------------------------------------------+
| CONVERT_TZ(TIME('2010-01-01 00:00:00'),'+00:00','+7:5') |
+---------------------------------------------------------+
| 0000-00-00 00:00:00 |
+---------------------------------------------------------+
1 row in set (0.00 sec)

Note: this problem is not repeatable with mysql-5.1, 5.5.

Alexander Barkov made changes - 2013-06-13 09:28

Description

This SQL query returns a wrong result:
{code:sql}
mysql> SELECT CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5'); show warnings;
+----------------------------------------------+
| CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5') |
+----------------------------------------------+
| 0000-00-00 00:00:00 |
+----------------------------------------------+
1 row in set (0.00 sec)
{code}

The expected result is NULL with a warning.
The same problem happens in this query:
mysql> SELECT CONVERT_TZ(TIME('2010-01-01 00:00:00'),'+00:00','+7:5');
+---------------------------------------------------------+
| CONVERT_TZ(TIME('2010-01-01 00:00:00'),'+00:00','+7:5') |
+---------------------------------------------------------+
| 0000-00-00 00:00:00 |
+---------------------------------------------------------+
1 row in set (0.00 sec)

Note: this problem is not repeatable with mysql-5.1, 5.5.

This SQL query returns a wrong result:
{code:sql}
mysql> SELECT CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5'); show warnings;
+----------------------------------------------+
| CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5') |
+----------------------------------------------+
| 0000-00-00 00:00:00 |
+----------------------------------------------+
1 row in set (0.00 sec)
{code}

The expected result is NULL with a warning.
The same problem happens in this query:
{code}
mysql> SELECT CONVERT_TZ(TIME('2010-01-01 00:00:00'),'+00:00','+7:5');
+---------------------------------------------------------+
| CONVERT_TZ(TIME('2010-01-01 00:00:00'),'+00:00','+7:5') |
+---------------------------------------------------------+
| 0000-00-00 00:00:00 |
+---------------------------------------------------------+
1 row in set (0.00 sec)
{code}

Note: this problem is not repeatable with mysql-5.1, 5.5.

Sergei Golubchik made changes - 2013-06-13 11:14

Fix Version/s		10.0.4 [ 13101 ]
Fix Version/s		5.5.32 [ 13000 ]
Fix Version/s		5.3.13 [ 12602 ]

Sergei Golubchik made changes - 2013-06-30 10:49

Priority

Major [ 3 ]

Minor [ 4 ]

Sergei Golubchik made changes - 2013-07-18 19:39

Fix Version/s		5.5.33 [ 13300 ]
Fix Version/s	5.5.32 [ 13000 ]

Alexander Barkov made changes - 2013-08-07 13:17

Status

Open [ 1 ]

In Progress [ 3 ]

Alexander Barkov added a comment - 2013-08-08 12:45

Pushed into 5.3.13 and 5.5.32.

Alexander Barkov added a comment - 2013-08-08 12:45 Pushed into 5.3.13 and 5.5.32.

Alexander Barkov made changes - 2013-08-08 12:45

Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

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

Workflow

defaullt [ 27682 ]

MariaDB v2 [ 44310 ]

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

Workflow

MariaDB v2 [ 44310 ]

MariaDB v3 [ 61392 ]

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

Workflow

MariaDB v3 [ 61392 ]

MariaDB v4 [ 146775 ]

MariaDB Server

Wrong result for CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5')

Details

Description

Attachments

Activity

People

Dates

Git Integration