[TRAFODION-2684] getString from tinyint unsiged(255) column, throw exception: Numerica out of range

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.1-incubating
• Component/s: client-jdbc-t4
• Environment: centos:6.7,
• Assignee: Unassigned
• Reporter: luoyunpeng
• Created: 12/Jul/17 02:21
• Updated: 18/Jul/17 18:11

Description

when i was using getString method on tinyint unsigned(255) column, throwed exception:
Numerica out of range .

test code as following:
####
public void testGetString() throws SQLException {
String tableName = "testGetString";

try

{ Statement stmt = conn.createStatement(); stmt.executeUpdate("cqd traf_tinyint_return_values 'ON'"); stmt.executeUpdate("cqd traf_tinyint_input_params 'ON'"); stmt.executeUpdate("create table " + tableName + " (id int not null,age tinyint unsigned,primary key(id))"); stmt.executeUpdate("insert into " + tableName + " values(1,255)"); ResultSet rs = stmt.executeQuery("select * from " + tableName); rs.next(); System.out.println(rs.getString(2)); }

finally

{ dropTable(tableName); }

}
####

Issue Links

• links to: GitHub Pull Request #1181