[DERBY-5749] Implicit cast of variable length values, e.g. as arguments to stored methods and generated columns values, silently truncate if too long

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.3.1.4, 10.3.2.1, 10.3.3.0, 10.4.1.3, 10.4.2.0, 10.5.1.1, 10.5.2.0, 10.5.3.0, 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2, 10.8.2.2
• Fix Version/s: 10.9.1.0
• Component/s: JDBC, SQL
• Labels: derby_backport_reject_10_8
• Issue & fix info: Release Note Needed
• Bug behavior facts: Data corruption, Deviation from standard
• Assignee: Dag H. Wanvik
• Reporter: Dag H. Wanvik
• Created: 08/May/12 19:25
• Updated: 27/Jun/13 23:06
• Resolved: 27/Jun/13 23:06

Description

Cf the attached repro SilentVarcharArgTruncation.
It seem implicit casts are inserted here, cf discussion on derby-dev thread starting here: http://mail-archives.apache.org/mod_mbox/db-derby-dev/201205.mbox/%3Cx67gwm7hir.fsf%40oracle.com%3E

Issue Links

• is related to: DERBY-5537 Casting to a shorter string type does not warn about truncation