[DERBY-5459] Result set metadata are out of sync on client after underlying table is altered

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 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
• Fix Version/s: 10.8.3.3, 10.9.1.0
• Component/s: JDBC
• Issue & fix info: High Value Fix, Repro attached
• Bug behavior facts: Embedded/Client difference, Wrong query result
• Assignee: Dag H. Wanvik
• Reporter: Dag H. Wanvik
• Created: 13/Oct/11 03:22
• Updated: 13/Aug/13 20:31
• Resolved: 24/Nov/11 23:36

Description

Cf the discussion on DERBY-3823.

The enclosed repro program shows what happens. When I run it with
client/server and embedded respectively we see these two differing
results:

client/server:

$ java -cp .:$CLASSPATH Repo
Done loading data
executing alter
execp.getResultDescription: select * from t1
2. PS#getMetaData: char column length is 8
Reexecuting ps on changed table...
3. RS#getMetadata: char column length is 8
data:1 12345678

dag@T61pOS:~/java/sb/apps/derby3823$ !rm
rm -rf DERBY3823DB

embedded:

dag@T61pOS:~/java/sb/apps/derby3823$ java -cp .:$CLASSPATH Repro 2
execp.getResultDescription: insert into t1 values(?,'aaaaa')
execp.getResultDescription: insert into t1 values(?,'aaaaa')
Done loading data
execp.getResultDescription: select * from t1
execp.getResultDescription: select * from t1
executing alter
2. PS#getMetaData: char column length is 5
Reexecuting ps on changed tableh...
3. RS#getMetadata: char column length is 5
data:1 12345678

As we can see, the metadata results are different after the ALTER
TABLE. The trace from EmbedPreparedData
("execp.getResultDescription:") lines (see repro-patch.diff) show that
after ALTER, the metadata are not refreshed on the server side.

Issue Links

• is related to: DERBY-4373 different results with network server vs. embedded on select from a temporary table with resultset cursor hold over commit
• is related to: DERBY-6289 Derby 10.8 backport issue (summer 2013)
• is related to: DERBY-2402 client ResultSetMetaData for select * after alter table does not return added columns
• is related to: DERBY-3839 Convert "org.apache.derbyTesting.functionTests.tests.store.holdCursorJDBC30.sql" to junit.