Bug #21531 EXPORT_SET() doesn't accept args with coercible character sets

Submitted: 9 Aug 2006 8:38 Modified: 25 Sep 2006 19:42
Reporter: Timothy Smith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Charsets Severity:S3 (Non-critical)
Version:4.1 OS:
Assigned to: Timothy Smith CPU Architecture:Any

[9 Aug 2006 8:38] Timothy Smith
Description:
A typo in Item_func_export_set::fix_length_and_dec() caused the function to require all arguments to have identical collations.

How to repeat:
select export_set(3, _latin1'foo', _utf8'bar', ',', 4);

Suggested fix:
Put MY_COLL_ALLOW_CONV inside the agg_arg_charsets() function, not outside it.

Remove the default value for the flags argument of agg_arg_charsets() while we're at it.

Note: this bug is only in 4.1; 5.0+ don't have it (or have already been fixed).
[9 Aug 2006 8:49] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/10190

ChangeSet@1.2541, 2006-08-09 02:48:34-06:00, tsmith@siva.hindu.god +2 -0
  Bug #21531: EXPORT_SET() doesn't accept args with coercible character sets
  
  - Remove default value for 'flags' argument of agg_arg_charsets()
  - Move MY_COLL_ALLOW_CONV inside the agg_arg_charsets() function, not outside it,
    in Item_func_export_set::fix_length_and_dec()
[24 Aug 2006 0:02] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/10802

ChangeSet@1.2537, 2006-08-23 18:02:31-06:00, tsmith@siva.hindu.god +4 -0
  Bug #21531: EXPORT_SET() doesn't accept args with coercible character sets
  
  - Fix typo in Item_func_export_set::fix_length_and_dec() which caused character set aggregation to fail
  - Remove default argument from last arg of agg_arg_charsets() function, to reduce potential errors
[31 Aug 2006 11:42] Magnus BlÄudd
Pushed to 5.0.25
[25 Sep 2006 19:42] Paul DuBois
Noted in 4.1.22, 5.0.25 changelogs.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.060 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.