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
• Status: Verified
• Category: MySQL Server: Charsets
• Severity: S3 (Non-critical)
• Version: 6.0
• OS: Linux
• CPU Architecture: Any

[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.