Bug #27723 SQLForeignKeys does not escape _ and % in the table name arguments

• Submitted: 10 Apr 2007 1:15
• Modified: 20 May 2007 8:30
• Reporter: Jim Winstead
• Status: Closed
• Category: Connector/ODBC
• Severity: S3 (Non-critical)
• Version: 3.51.14
• OS: Any
• Assigned to: Jim Winstead

[10 Apr 2007 1:15] Jim Winstead

Description:
The table name arguments to SQLForeignKeys should have any % and _ included escaped
because they are used in a LIKE expression. We need to create a common function for doing
this, because some other catalog functions have the same problem.

How to repeat:
Get foreign key information from a table with _ or % in its name when there is a
similarly-named table that matches the name when interpreted as a LIKE wildcard.

[7 May 2007 19:28] Jim Winstead

patch to add function for escaping wildcards

Attachment: bug27723.patch (application/octet-stream, text), 6.63 KiB.

[11 May 2007 19:23] Jim Winstead

This is now fixed for 3.51.16.

[20 May 2007 8:30] MC Brown

A note has been added to the 3.51.16 changelog.