Opened 12 years ago

Closed 12 years ago

Last modified 8 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

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.

Change History (2)

comment:1 Changed 12 years ago by warmerdam

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 Changed 8 years ago by Even Rouault

Milestone: 1.5.5

Milestone 1.5.5 deleted

Note: See TracTickets for help on using tickets.