[DERBY-5236] Client driver silently truncates strings that exceed 32KB

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.8.1.2
• Fix Version/s: 10.8.2.2, 10.9.1.0
• Component/s: Network Client
• Issue & fix info: Repro attached
• Bug behavior facts: Embedded/Client difference, Wrong query result
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 17/May/11 15:54
• Updated: 15/Jan/14 13:36
• Resolved: 12/Sep/11 11:34

Description

Can be seen with this JUnit test case that retrieves a VARCHAR value with 20000 characters. With the client driver, the string is truncated to 10900 characters (32700 bytes when encoded in UTF-8).

public void testLongColumn() throws SQLException

{ PreparedStatement ps = prepareStatement( "values cast(? as varchar(20000))"); char[] chars = new char[20000]; Arrays.fill(chars, '\u4e10'); String str = new String(chars); ps.setString(1, str); JDBC.assertSingleValueResultSet(ps.executeQuery(), str); }

Issue Links

• is related to: DERBY-5220 Output from org.apache.derby.drda.NetworkServerControl runtimeinfo are truncated if the amount of data exceeds some threshold
• is related to: DERBY-6456 Infinite loop in NetworkServerControlImpl when reply >= 32k
• relates to: DERBY-5235 Remove the artificial limit on the length of VARCHAR values, allowing them to be java.lang.Integer.MAX_VALUE long