Bug #42307 ctype_ujis_ucs2.test fails for falcon, innodb, maria (wrong warnings or errors)
Submitted: 23 Jan 2009 16:21 Modified: 28 Jan 2009 10:04
Reporter: Guilhem Bichot Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Charsets Severity:S3 (Non-critical)
Version:6.0 OS:Linux
Assigned to: CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[23 Jan 2009 16:21] Guilhem Bichot
Description:
I run:
/mtr --mysqld=--default-storage-engine=X --mem ctype_ujis_ucs2

with X=innodb/falcon/maria ; the test fails, and with different outputs:

1) falcon:
mysqltest: At line 76: query 'insert into t1 set ujis=0x20, name='U+0020 SPACE'' failed: 1062: Duplicate entry ' ' for key 'PRIMARY'

2) InnoDB:
warnings of " update t1 set ucs2=ujis, ujis2=ucs2;" differ from warnings expected by the test (differences in row number and string values)

3) Maria:
also differences in warnings (but not like InnoDB)

Bar the expert says "This is not normal. All engines should report the same warnings."

How to repeat:
/mtr --mysqld=--default-storage-engine=X --mem ctype_ujis_ucs2

with X=innodb/falcon/maria
[28 Jan 2009 10:04] Guilhem Bichot
For Falcon it's an error.
For InnoDB and Maria warnings, see the attached file (too long for a post, refused by bugs db)
[28 Jan 2009 10:06] Guilhem Bichot
errors and warnings

Attachment: bug42307.txt (text/plain), 28.53 KiB.