Remove LIKE tweak from metadata.properties

• Key: DERBY-2145
• Type: Improvement
• Status: Resolved
• Resolution: Fixed
• Priority: Trivial
• Assignee: Bernt M. Johnsen
• Reporter: Bernt M. Johnsen
• Component/s: SQL
• Fix Version/s: 10.4.1.3

Description

The tweak in the second last line in metadata.properties:
      AND (V."COLUMN_NAME" LIKE ? OR V."COLUMN_NAME" = ?) \
may be changed to
      AND V."COLUMN_NAME" LIKE ? \
when DERBY-1231 is fixed

Comments

[Bernt M. Johnsen]

A fix for this issue should not be back-ported to the 10.2 branch. Se Kunt's komment in DERBY-1231

[Andrew McIntyre]

Unsetting Fix Version on unassigned issues.

[Thomas Nielsen]

Attached Bernts proposed diff for this issue now that DERBY-1231 is fixed.
suites.All pass.

[Bernt M. Johnsen]

Committed revision 551124.

[Ole Solberg]

Checkin 551124 appears to have caused testGetFunctionColumnsStartingWithDUMMY(org.apache.derbyTesting.functionTests.tests.jdbc4.TestDbMetaData)java.sql.SQLException: The parameter position '4' is out of range. The number of parameters for this prepared statement is '3'.

See DERBY-2880.

[Bernt M. Johnsen]

This slipped thorugh because the test suite was not run in JDK 1.6. I have a patch ready, just waiting for the test suite.

[Bernt M. Johnsen]

Attached a patch which fixes the bug Ole found.

[Bernt M. Johnsen]

So... the correct diff.

[Bernt M. Johnsen]

with Grant license....

[Bernt M. Johnsen]

The correct diff with grant license. The sad thing is that when I start doing these mistakes, it's broadcast all over the world (at least all over the community) and archived for the future. Anyway, suites.All runs without errors on JDK 1.6. Will commit.

[Bernt M. Johnsen]

Committed revision 551878.

[Bernt M. Johnsen]

Patch to remove the no more needed PreparedStatement in EmbedDatabaseMetaData.getFunctionColumns()

[Bernt M. Johnsen]

Committed revision 551882.