Opened 13 years ago

Closed 13 years ago

Last modified 9 years ago

#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


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.

Change History (2)

comment:1 by warmerdam, 13 years ago

Cc: assefa added
Resolution: fixed
Status: newclosed

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).

comment:2 by Even Rouault, 9 years ago

Milestone: 1.5.5

Milestone 1.5.5 deleted

Note: See TracTickets for help on using tickets.