[#DERBY-2610] Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns

Derby

Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns

Created: 04/May/07 01:33 PM Updated: 30/Jun/09 04:12 PM

Return to search

Component/s:

JDBC

Affects Version/s:

10.2.2.0, 10.3.1.4

Fix Version/s:

10.3.1.4

Time Tracking:

Not Specified

File Attachments:

File Name	Date Attached	Attached By	Size
DERBY-2610-1.diff	2007-05-10 11:13 AM	Jørgen Løland	40 kB
DERBY-2610-1.stat	2007-05-10 11:13 AM	Jørgen Løland	0.8 kB
releaseNote.html	2007-06-05 09:31 AM	Jørgen Løland	3 kB
releaseNote.html	2007-05-26 05:37 PM	Myrna van Lunteren	3 kB

Issue Links:

Dependants

This issue depends on:

~~DERBY-1484~~ Client and embedded behave differently when the table name is null in DatabaseMetaData methods

Reference

This issue relates to:

~~DERBY-2758~~ ODBC metadata function "SQLForeignKeys" returns different results in 10.3.

Issue & fix info:	Release Note Needed
Resolution Date:	05/Jun/07 09:33 AM

Description

« Hide

The DatabaseMetaData methods getBestRowIdentifier, getColumnPrivileges, getIndexInfo, getVersionColumns, getPrimaryKeys, getImportedKeys, getExportedKeys do not allow table name patterns. However, the SQL in metadata.properties implement these with "table like ?", thus allowing patterns. The SQL for these methods should be modified to "table=?".

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Jørgen Løland made changes - 07/May/07 09:09 AM

Field	Original Value	New Value
Assignee		Jørgen Løland [ jorgenlo ]

Jørgen Løland made changes - 10/May/07 11:13 AM

Attachment		DERBY-2610-1.stat [ 12357023 ]
Attachment		DERBY-2610-1.diff [ 12357024 ]

Jørgen Løland made changes - 10/May/07 11:28 AM

Derby Info

[Patch Available]

Jørgen Løland made changes - 10/May/07 11:51 AM

Link

This issue depends on ~~DERBY-1484~~ [ ~~DERBY-1484~~ ]

Kristian Waagan made changes - 15/May/07 07:15 AM

Status	Open [ 1 ]	Resolved [ 5 ]
Resolution		Fixed [ 1 ]
Derby Info	[Patch Available]

Jørgen Løland made changes - 15/May/07 07:25 AM

Status

Resolved [ 5 ]

Closed [ 6 ]

Jørgen Løland made changes - 16/May/07 07:21 AM

Status	Closed [ 6 ]	Reopened [ 4 ]
Resolution	Fixed [ 1 ]

Jørgen Løland made changes - 16/May/07 07:22 AM

Derby Info

[Existing Application Impact]

Jørgen Løland made changes - 16/May/07 07:23 AM

Status	Reopened [ 4 ]	Closed [ 6 ]
Resolution		Fixed [ 1 ]

Myrna van Lunteren made changes - 26/May/07 05:37 PM

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Reopened [ 4 ]

Myrna van Lunteren made changes - 26/May/07 05:37 PM

Attachment

releaseNote.html [ 12358310 ]

Myrna van Lunteren made changes - 26/May/07 05:38 PM

Resolution		Fixed [ 1 ]
Status	Reopened [ 4 ]	Closed [ 6 ]

A B made changes - 04/Jun/07 09:13 PM

Link

This issue relates to ~~DERBY-2758~~ [ ~~DERBY-2758~~ ]

Jørgen Løland made changes - 05/Jun/07 09:30 AM

Status	Closed [ 6 ]	Reopened [ 4 ]
Resolution	Fixed [ 1 ]

Jørgen Løland made changes - 05/Jun/07 09:31 AM

Attachment

releaseNote.html [ 12358935 ]

Jørgen Løland made changes - 05/Jun/07 09:33 AM

Status	Reopened [ 4 ]	Closed [ 6 ]
Derby Info	[Existing Application Impact]	[Existing Application Impact, Release Note Needed]
Resolution		Fixed [ 1 ]

Dag H. Wanvik made changes - 30/Jun/09 04:12 PM

Issue & fix info

[Existing Application Impact, Release Note Needed]

[Release Note Needed]