[DERBY-5537] Casting to a shorter string type does not warn about truncation

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 10.8.2.2
• Component/s: SQL
• Labels: derby_triage10_9
• Urgency: Normal
• Issue & fix info: Release Note Needed, Repro attached
• Bug behavior facts: Deviation from standard
• Assignee: Unassigned
• Reporter: Knut Anders Hatlen
• Created: 14/Dec/11 10:30
• Updated: 24/Jul/12 17:28
• Resolved: 11/May/12 13:58

Description

SQL:2003, part 2, 6.12 <cast specification> specifies that a truncation warning should be raised when casting from one (character or binary) string data type to another. Derby does truncate, but it doesn't raise a warning:

ij> values cast('abc' as char(2));
1
–
ab

1 row selected
ij> values cast(x'cafebabe' as char(2) for bit data);
1

---

cafe

1 row selected

We should generate a warning in order to be compliant.

Issue Links

• duplicates: DERBY-129 Derby should throw a truncation error or warning when CASTing a parameter/constant to char or char for bit datatypes and the data is too large for the datatype.
• is related to: DERBY-5525 Precision for UPPER function is wrong if the returned value is longer than the literal argument
• relates to: DERBY-5749 Implicit cast of variable length values, e.g. as arguments to stored methods and generated columns values, silently truncate if too long