| Bug #45793 | macce charset causes error with IBMDB2I | ||
|---|---|---|---|
| Submitted: | 26 Jun 2009 19:06 | Modified: | 14 Jul 2009 15:01 |
| Reporter: | Tim Clark | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: DB2SE for IBM i | Severity: | S3 (Non-critical) |
| Version: | 5.1.35 | OS: | IBM i |
| Assigned to: | Tim Clark | CPU Architecture: | Any |
[2 Jul 2009 8:04]
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/77731 2991 V Narayanan 2009-07-02 Bug#45793 macce charset causes error with IBMDB2I Creating an IBMDB2I table with the macce character set is successful, but any attempt to insert data into the table was failing. This was happening because the character set name "macce" is not a valid iconv descriptor for IBM i PASE. This patch adds an override to convertTextDesc to use the equivalent valid iconv descriptor "IBM-1282" instead. @ mysql-test/suite/ibmdb2i/r/ibmdb2i_bug_45793.result Bug#45793 macce charset causes error with IBMDB2I Result file for the test case. @ mysql-test/suite/ibmdb2i/t/ibmdb2i_bug_45793.test Bug#45793 macce charset causes error with IBMDB2I Add a testcase for the macce charater set. @ storage/ibmdb2i/db2i_charsetSupport.cc Bug#45793 macce charset causes error with IBMDB2I The character set name "macce" is not a valid iconv descriptor for IBM i PASE. Add an override to convertTextDesc to use the equivalent valid iconv descriptor "IBM-1282" instead.
[8 Jul 2009 13:30]
Bugs System
Pushed into 5.1.37 (revid:joro@sun.com-20090708131116-kyz8iotbum8w9yic) (version source revid:v.narayanan@sun.com-20090702080423-txjk66lpf3efhojg) (merge vers: 5.1.37) (pib:11)
[9 Jul 2009 7:36]
Bugs System
Pushed into 5.1.37 (revid:joro@sun.com-20090708131116-kyz8iotbum8w9yic) (version source revid:v.narayanan@sun.com-20090702080423-txjk66lpf3efhojg) (merge vers: 5.1.37) (pib:11)
[10 Jul 2009 11:21]
Bugs System
Pushed into 5.4.4-alpha (revid:anozdrin@bk-internal.mysql.com-20090710111017-bnh2cau84ug1hvei) (version source revid:v.narayanan@sun.com-20090702082353-wotgos42zkykg9zo) (merge vers: 5.4.4-alpha) (pib:11)
[14 Jul 2009 15:01]
MC Brown
A note has been added to the 5.1.37 and 5.4.4 changelogs: Inserting data into a table using the macce character set with the IBMDB2I storage engine would fail.
[12 Aug 2009 22:13]
Paul DuBois
Noted in 5.4.2 changelog because next 5.4 version will be 5.4.2 and not 5.4.4.
[14 Aug 2009 23:03]
Paul DuBois
Ignore previous comment about 5.4.2.
[26 Aug 2009 13:46]
Bugs System
Pushed into 5.1.37-ndb-7.0.8 (revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)
[26 Aug 2009 13:46]
Bugs System
Pushed into 5.1.37-ndb-6.3.27 (revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (version source revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (merge vers: 5.1.37-ndb-6.3.27) (pib:11)
[26 Aug 2009 13:48]
Bugs System
Pushed into 5.1.37-ndb-6.2.19 (revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (version source revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (merge vers: 5.1.37-ndb-6.2.19) (pib:11)
[27 Aug 2009 16:33]
Bugs System
Pushed into 5.1.35-ndb-7.1.0 (revid:magnus.blaudd@sun.com-20090827163030-6o3kk6r2oua159hr) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)
[7 Oct 2009 18:27]
Paul DuBois
The 5.4 fix has been pushed to 5.4.2.
Description: Creating an IBMDB2I table with the macce character set is successful, but any attempt to insert data into the table will fail. How to repeat: > create table t1 (c char(10)) charset macce engine=ibmdb2i; > insert into t1 values ("test"); Got error 2501 'Error on _ILECALL for API 'QlgCvtTextDescToDesc' (error = -11)' from IBMDB2I Suggested fix: Fix the error or document the charset as unsupported.