Ticket #1789 (closed bug: fixed)

Opened 4 years ago

Last modified 4 years ago

PostGIS query: put '' around field values when appropriate

Reported by: pcav Owned by: nobody
Priority: minor: annoyance Milestone: Version 1.2.0
Component: Data Provider Version: Trunk
Keywords: Cc:
Platform Version: Platform: All
Must Fix for Release: No Awaiting user input: no

Description

When using the query builder from PostGIS provider, if the user selects a boolean, date, time etc. field that requires to be surrounded by , they are written without them, so the query fails, eg:

fieldname=t

(where fieldname is a boolean, true/false) instead of

fieldname='t'

Change History

Changed 4 years ago by jef

  • status changed from new to closed
  • resolution set to fixed

fixed in r11105

Changed 4 years ago by pcav

Fixed for boolean, not for date and time (possibily also other types)

Changed 4 years ago by pcav

  • status changed from closed to reopened
  • resolution fixed deleted

Changed 4 years ago by jef

  • status changed from reopened to closed
  • resolution set to fixed

fixed in r11106

Note: See TracTickets for help on using tickets.