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 Email Updates:
Status: Closed Impact on me:
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
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.