Opened 16 years ago
Closed 16 years ago
#2315 closed defect (fixed)
MySQL driver doesn't escape table and column names
| Reported by: | Even Rouault | Owned by: | warmerdam |
|---|---|---|---|
| Priority: | normal | Milestone: | 1.6.0 |
| Component: | OGR_SF | Version: | unspecified |
| Severity: | normal | Keywords: | mysql |
| Cc: |
Description
The MySQL driver doesn't escape table and column names, thus making it impossible to use names that are keywords. For example the 'desc' column name (one of the columns of the GPX schema) is a SQL keyword.
The solution is to use backquotes (`) around table and column names
Change History (2)
comment:1 by , 16 years ago
comment:2 by , 16 years ago
| Milestone: | → 1.6.0 |
|---|---|
| Resolution: | → fixed |
| Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
Fixed in trunk in r14209