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

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

[9 Apr 2007 23: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 17:28] Jim Winstead

patch to add function for escaping wildcards

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

[11 May 2007 17:23] Jim Winstead

This is now fixed for 3.51.16.

[20 May 2007 6:30] MC Brown

A note has been added to the 3.51.16 changelog.