[GRASS-dev] [GRASS GIS] #3071: v.db.join: fails with SQLite because of lower/UPPER case issues

[GRASS GIS]

#3071: v.db.join: fails with SQLite because of lower/UPPER case issues
--------------------------+-------------------------
  Reporter:  sbl          |      Owner:  grass-dev@…
      Type:  defect       |     Status:  new
  Priority:  normal       |  Milestone:  7.0.5
 Component:  Default      |    Version:  unspecified
Resolution:               |   Keywords:
       CPU:  Unspecified  |   Platform:  Unspecified
--------------------------+-------------------------

Comment (by neteler):

 I checked the patches:

  * v.db.addcolumn_quote.diff​: contains backticks. This is unlikely to
 work in Python/SQL. Is this an encoding issue of the patch?
  * v.db.join.diff​: Not sure how SQLite behaves. I found an older
 discussion here:  http://stackoverflow.com/a/19933159/452464 - is there
 any official reference on the SQLite site?
  * v.db.join_quote.diff​: If quotes are needed then also the other SQL
 queries needs to undergo an audit. Then we need to write down our coding
 style somewhere near
 https://trac.osgeo.org/grass/wiki/Grass7/VectorLib/OGRInterface or better
 a dedicated SQL/DBMI page

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/3071#comment:2>
GRASS GIS <https://grass.osgeo.org>