#3144 closed defect (fixed)
JOIN on strings uses improperly quoted values
Reported by: | warmerdam | Owned by: | assefa |
---|---|---|---|
Priority: | normal | Milestone: | |
Component: | OGR_SF | Version: | unspecified |
Severity: | normal | Keywords: | join |
Cc: | assefa |
Description
Attempts to do an OGR join on a string column fails in some cases as double quotes are used instead of single quotes on the literal value looked up. This fails, for instance, if the joined database is an .mdb file through ODBC.
Note:
See TracTickets
for help on using tickets.
Corrected as suggested by Assefa (use single quotes). I also added SQL quoting of the values in case they include single quotes.
In trunk (r17648), 1.6 branch (r17650) and 1.5 branch (r17651).