You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Jørgen Løland (JIRA)" <ji...@apache.org> on 2007/05/04 15:34:15 UTC
[jira] Created: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
---------------------------------------------------------------------------------------------
Key: DERBY-2610
URL: https://issues.apache.org/jira/browse/DERBY-2610
Project: Derby
Issue Type: Bug
Components: JDBC
Affects Versions: 10.2.2.0, 10.3.0.0
Reporter: Jørgen Løland
Priority: Trivial
Fix For: 10.3.0.0
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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12495881 ]
Jørgen Løland commented on DERBY-2610:
--------------------------------------
Thanks for committing the patch, Kristian
> Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-2610
> URL: https://issues.apache.org/jira/browse/DERBY-2610
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.2.0, 10.3.0.0
> Reporter: Jørgen Løland
> Assigned To: Jørgen Løland
> Priority: Trivial
> Fix For: 10.3.0.0
>
> Attachments: DERBY-2610-1.diff, DERBY-2610-1.stat
>
>
> 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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jørgen Løland reassigned DERBY-2610:
------------------------------------
Assignee: Jørgen Løland
> Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-2610
> URL: https://issues.apache.org/jira/browse/DERBY-2610
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.2.0, 10.3.0.0
> Reporter: Jørgen Løland
> Assigned To: Jørgen Løland
> Priority: Trivial
> Fix For: 10.3.0.0
>
>
> 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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12496026 ]
Kathey Marsden commented on DERBY-2610:
---------------------------------------
Should this be marked as existing application impact, in case users were counting on the pattern matching extension?
> Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-2610
> URL: https://issues.apache.org/jira/browse/DERBY-2610
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.2.0, 10.3.0.0
> Reporter: Jørgen Løland
> Assigned To: Jørgen Løland
> Priority: Trivial
> Fix For: 10.3.0.0
>
> Attachments: DERBY-2610-1.diff, DERBY-2610-1.stat
>
>
> 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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Posted by "Kristian Waagan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12495551 ]
Kristian Waagan commented on DERBY-2610:
----------------------------------------
I ran derbyall/suites.All with DERBY-1484 (modified according to Knut Anders comment) and this issue. No failures seen (Sun JVM 1.5).
Is it expected that these fixes make it into 10.2 as well?
> Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-2610
> URL: https://issues.apache.org/jira/browse/DERBY-2610
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.2.0, 10.3.0.0
> Reporter: Jørgen Løland
> Assigned To: Jørgen Løland
> Priority: Trivial
> Fix For: 10.3.0.0
>
> Attachments: DERBY-2610-1.diff, DERBY-2610-1.stat
>
>
> 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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jørgen Løland updated DERBY-2610:
---------------------------------
Derby Info: [Existing Application Impact]
Thanks for the comment, Kathey.
This issue is related to 1484. After seeing your comment, I edited the release note of 1484 to better reflect both issues, and marked 1484 and this issue with existing application impact.
> Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-2610
> URL: https://issues.apache.org/jira/browse/DERBY-2610
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.2.0, 10.3.0.0
> Reporter: Jørgen Løland
> Assigned To: Jørgen Løland
> Priority: Trivial
> Fix For: 10.3.0.0
>
> Attachments: DERBY-2610-1.diff, DERBY-2610-1.stat
>
>
> 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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Reopened: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jørgen Løland reopened DERBY-2610:
----------------------------------
> Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-2610
> URL: https://issues.apache.org/jira/browse/DERBY-2610
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.2.0, 10.3.0.0
> Reporter: Jørgen Løland
> Assigned To: Jørgen Løland
> Priority: Trivial
> Fix For: 10.3.0.0
>
> Attachments: DERBY-2610-1.diff, DERBY-2610-1.stat
>
>
> 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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jørgen Løland updated DERBY-2610:
---------------------------------
Attachment: releaseNote.html
changed release note according to comment in DERBY-2758
> Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-2610
> URL: https://issues.apache.org/jira/browse/DERBY-2610
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.2.0, 10.3.0.0
> Reporter: Jørgen Løland
> Assignee: Jørgen Løland
> Priority: Trivial
> Fix For: 10.3.0.0
>
> Attachments: DERBY-2610-1.diff, DERBY-2610-1.stat, releaseNote.html, releaseNote.html
>
>
> 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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Reopened: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jørgen Løland reopened DERBY-2610:
----------------------------------
need to change the release note
> Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-2610
> URL: https://issues.apache.org/jira/browse/DERBY-2610
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.2.0, 10.3.0.0
> Reporter: Jørgen Løland
> Assignee: Jørgen Løland
> Priority: Trivial
> Fix For: 10.3.0.0
>
> Attachments: DERBY-2610-1.diff, DERBY-2610-1.stat, releaseNote.html
>
>
> 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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Posted by "A B (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12501370 ]
A B commented on DERBY-2610:
----------------------------
Linked to DERBY-2758 since that appears to be a "regression" related to this issue.
> Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-2610
> URL: https://issues.apache.org/jira/browse/DERBY-2610
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.2.0, 10.3.0.0
> Reporter: Jørgen Løland
> Assignee: Jørgen Løland
> Priority: Trivial
> Fix For: 10.3.0.0
>
> Attachments: DERBY-2610-1.diff, DERBY-2610-1.stat, releaseNote.html
>
>
> 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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Myrna van Lunteren updated DERBY-2610:
--------------------------------------
Attachment: releaseNote.html
Attaching a release note to aid automatic release note generation.
> Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-2610
> URL: https://issues.apache.org/jira/browse/DERBY-2610
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.2.0, 10.3.0.0
> Reporter: Jørgen Løland
> Assigned To: Jørgen Løland
> Priority: Trivial
> Fix For: 10.3.0.0
>
> Attachments: DERBY-2610-1.diff, DERBY-2610-1.stat, releaseNote.html
>
>
> 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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Reopened: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Myrna van Lunteren reopened DERBY-2610:
---------------------------------------
> Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-2610
> URL: https://issues.apache.org/jira/browse/DERBY-2610
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.2.0, 10.3.0.0
> Reporter: Jørgen Løland
> Assigned To: Jørgen Løland
> Priority: Trivial
> Fix For: 10.3.0.0
>
> Attachments: DERBY-2610-1.diff, DERBY-2610-1.stat
>
>
> 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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jørgen Løland closed DERBY-2610.
--------------------------------
Resolution: Fixed
> Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-2610
> URL: https://issues.apache.org/jira/browse/DERBY-2610
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.2.0, 10.3.0.0
> Reporter: Jørgen Løland
> Assigned To: Jørgen Løland
> Priority: Trivial
> Fix For: 10.3.0.0
>
> Attachments: DERBY-2610-1.diff, DERBY-2610-1.stat
>
>
> 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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jørgen Løland updated DERBY-2610:
---------------------------------
Derby Info: [Patch Available]
Tests for patch (1): derbyall fails bootLock (as usual; very likely not related), suite.all fails the same 9 tests as tinderbox for revision 536720 (encryption)
> Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-2610
> URL: https://issues.apache.org/jira/browse/DERBY-2610
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.2.0, 10.3.0.0
> Reporter: Jørgen Løland
> Assigned To: Jørgen Løland
> Priority: Trivial
> Fix For: 10.3.0.0
>
> Attachments: DERBY-2610-1.diff, DERBY-2610-1.stat
>
>
> 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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Myrna van Lunteren closed DERBY-2610.
-------------------------------------
Resolution: Fixed
> Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-2610
> URL: https://issues.apache.org/jira/browse/DERBY-2610
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.2.0, 10.3.0.0
> Reporter: Jørgen Løland
> Assigned To: Jørgen Løland
> Priority: Trivial
> Fix For: 10.3.0.0
>
> Attachments: DERBY-2610-1.diff, DERBY-2610-1.stat, releaseNote.html
>
>
> 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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12495558 ]
Jørgen Løland commented on DERBY-2610:
--------------------------------------
Thanks for reviewing these patches, Kristian.
I don't think it is necessary to commit this to 10.2, especially since they require a release note.
> Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-2610
> URL: https://issues.apache.org/jira/browse/DERBY-2610
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.2.0, 10.3.0.0
> Reporter: Jørgen Løland
> Assigned To: Jørgen Løland
> Priority: Trivial
> Fix For: 10.3.0.0
>
> Attachments: DERBY-2610-1.diff, DERBY-2610-1.stat
>
>
> 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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jørgen Løland updated DERBY-2610:
---------------------------------
Attachment: DERBY-2610-1.diff
DERBY-2610-1.stat
Patch (1) removes table-patterns from the queries used by the seven methods. Note that there is one exception to this: the foreign table name of getCrossReference is still a pattern because this query is used by getExportedKeys with a wildcard. Removal of this pattern requires a new query for getExportedKeys
> Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-2610
> URL: https://issues.apache.org/jira/browse/DERBY-2610
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.2.0, 10.3.0.0
> Reporter: Jørgen Løland
> Assigned To: Jørgen Løland
> Priority: Trivial
> Fix For: 10.3.0.0
>
> Attachments: DERBY-2610-1.diff, DERBY-2610-1.stat
>
>
> 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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jørgen Løland closed DERBY-2610.
--------------------------------
> Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-2610
> URL: https://issues.apache.org/jira/browse/DERBY-2610
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.2.0, 10.3.0.0
> Reporter: Jørgen Løland
> Assigned To: Jørgen Løland
> Priority: Trivial
> Fix For: 10.3.0.0
>
> Attachments: DERBY-2610-1.diff, DERBY-2610-1.stat
>
>
> 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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Posted by "Kristian Waagan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kristian Waagan resolved DERBY-2610.
------------------------------------
Resolution: Fixed
Derby Info: (was: [Patch Available])
Committed 'DERBY-2610-1.diff' to trunk with revision 538072.
Thanks for the patch!
> Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-2610
> URL: https://issues.apache.org/jira/browse/DERBY-2610
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.2.0, 10.3.0.0
> Reporter: Jørgen Løland
> Assigned To: Jørgen Løland
> Priority: Trivial
> Fix For: 10.3.0.0
>
> Attachments: DERBY-2610-1.diff, DERBY-2610-1.stat
>
>
> 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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-2610) Queries in metadata.properties allow
tablepattern for JDBC methods that do not allow patterns
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jørgen Løland closed DERBY-2610.
--------------------------------
Resolution: Fixed
Derby Info: [Existing Application Impact, Release Note Needed] (was: [Existing Application Impact])
> Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-2610
> URL: https://issues.apache.org/jira/browse/DERBY-2610
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.2.0, 10.3.0.0
> Reporter: Jørgen Løland
> Assignee: Jørgen Løland
> Priority: Trivial
> Fix For: 10.3.0.0
>
> Attachments: DERBY-2610-1.diff, DERBY-2610-1.stat, releaseNote.html, releaseNote.html
>
>
> 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=?".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.