[#MDEV-9371] select insert('a',2,1,'b') doesn't return expected 'a'

[MDEV-9371] select insert('a',2,1,'b') doesn't return expected 'a' Created: 2016-01-06 Updated: 2016-02-10 Resolved: 2016-02-10
Status:	Closed
Project:	MariaDB Server
Component/s:	OTHER
Affects Version/s:	5.3.13, 5.5, 10.0, 10.1
Fix Version/s:	5.5.48

Type:

Bug

Priority:

Major

Reporter:

Dylan Su

Assignee:

Alexander Barkov

Resolution:

Fixed

Votes:

Labels:

upstream-fixed

Sprint:

5.5.48-0

Description

Output:

mysql> select insert('a',2,1,'b');

+---------------------+

| insert('a',2,1,'b') |

+---------------------+

| ab                  |

+---------------------+

1 row in set (0.00 sec)

mysql> select version();

+-----------------+

| version()       |

+-----------------+

| 10.1.10-MariaDB |

+-----------------+

1 row in set (0.00 sec)

Recreate:

select insert('a',2,1,'b');

Problem:
========
'a' is expected.

Comments

Comment by Elena Stepanova [ 2016-01-11 ]

Thanks for the report and the test case.
Also reproducible with MySQL 5.5, apparently fixed in 5.6

Generated at Thu Feb 08 07:34:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.