[GRASS-dev] [GRASS GIS] #2769: v.in.ogr not supporting OFTInteger64 field type

#2769: v.in.ogr not supporting OFTInteger64 field type
--------------------------------+-------------------------
Reporter: zarch | Owner: grass-dev@…
     Type: defect | Status: new
Priority: normal | Milestone: 7.1.0
Component: Default | Version: svn-trunk
Keywords: v.in.ogr Integer64 | CPU: All
Platform: Linux |
--------------------------------+-------------------------
It seems that GRASS does not support vector columns with type int64, in
most of the cases this fields are just normal int32.

I've written a small patch that treat this field as normal integer (with a
warning). It works without problems on my test file... but I'm not sure
about the consequences if a real int64 is met.

What do you think? It is safe to move this changes to trunk?

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/2769&gt;
GRASS GIS <https://grass.osgeo.org>

#2769: v.in.ogr not supporting OFTInteger64 field type
----------------------+--------------------------------
  Reporter: zarch | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone: 7.1.0
Component: Default | Version: svn-trunk
Resolution: | Keywords: v.in.ogr Integer64
       CPU: All | Platform: Linux
----------------------+--------------------------------
Changes (by zarch):

* Attachment "v.in.ogr_OFTInteger64.diff" added.

Patch to treat OFTInteger64 field as OFTInteger64

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/2769&gt;
GRASS GIS <https://grass.osgeo.org>

#2769: v.in.ogr not supporting OFTInteger64 field type
---------------------+--------------------------------
  Reporter: zarch | Owner: martinl
      Type: defect | Status: assigned
  Priority: normal | Milestone: 7.1.0
Component: Vector | Version: svn-trunk
Resolution: | Keywords: v.in.ogr Integer64
       CPU: All | Platform: Linux
---------------------+--------------------------------
Changes (by martinl):

* status: new => assigned
* cc: grass-dev@… (added)
* component: Default => Vector
* owner: grass-dev@… => martinl

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/2769#comment:1&gt;
GRASS GIS <https://grass.osgeo.org>

#2769: v.in.ogr not supporting OFTInteger64 field type
---------------------+--------------------------------
  Reporter: zarch | Owner: martinl
      Type: defect | Status: assigned
  Priority: normal | Milestone: 7.1.0
Component: Vector | Version: svn-trunk
Resolution: | Keywords: v.in.ogr Integer64
       CPU: All | Platform: Linux
---------------------+--------------------------------

Comment (by martinl):

Replying to [ticket:2769 zarch]:
> It seems that GRASS does not support vector columns with type int64, in
most of the cases this fields are just normal int32.
>
> I've written a small patch that treat this field as normal integer (with
a warning). It works without problems on my test file... but I'm not sure
about the consequences if a real int64 is met.

support of int64 will depend on DB driver, eg. SQLite integers can hold
whatever you put into it: from a 1-byte char to an 8-byte long long (1).
PostgreSQL uses `int` and `bigint` (2), ...

(1) http://www.sqlite.org/datatype3.html
(2) http://www.postgresql.org/docs/9.4/static/datatype-numeric.html

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/2769#comment:2&gt;
GRASS GIS <https://grass.osgeo.org>

#2769: v.in.ogr not supporting OFTInteger64 field type
---------------------+--------------------------------
  Reporter: zarch | Owner: martinl
      Type: defect | Status: assigned
  Priority: normal | Milestone: 7.1.0
Component: Vector | Version: svn-trunk
Resolution: | Keywords: v.in.ogr Integer64
       CPU: All | Platform: Linux
---------------------+--------------------------------

Comment (by martinl):

Please test r66564.

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/2769#comment:3&gt;
GRASS GIS <https://grass.osgeo.org>

#2769: v.in.ogr not supporting OFTInteger64 field type
---------------------+--------------------------------
  Reporter: zarch | Owner: martinl
      Type: defect | Status: assigned
  Priority: normal | Milestone: 7.1.0
Component: Vector | Version: svn-trunk
Resolution: | Keywords: v.in.ogr Integer64
       CPU: All | Platform: Linux
---------------------+--------------------------------

Comment (by martinl):

Can we close the ticket (with milestone 7.1)?

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/2769#comment:4&gt;
GRASS GIS <https://grass.osgeo.org>

#2769: v.in.ogr not supporting OFTInteger64 field type
---------------------+--------------------------------
  Reporter: zarch | Owner: martinl
      Type: defect | Status: assigned
  Priority: normal | Milestone: 7.1.0
Component: Vector | Version: svn-trunk
Resolution: | Keywords: v.in.ogr Integer64
       CPU: All | Platform: Linux
---------------------+--------------------------------

Comment (by zarch):

Replying to [comment:4 martinl]:
> Can we close the ticket (with milestone 7.1)?

yes, it works for me.
Thanks

Pietro

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/2769#comment:5&gt;
GRASS GIS <https://grass.osgeo.org>

#2769: v.in.ogr not supporting OFTInteger64 field type
---------------------+--------------------------------
  Reporter: zarch | Owner: martinl
      Type: defect | Status: assigned
  Priority: normal | Milestone: 7.0.4
Component: Vector | Version: svn-trunk
Resolution: | Keywords: v.in.ogr Integer64
       CPU: All | Platform: Linux
---------------------+--------------------------------
Changes (by martinl):

* milestone: 7.1.0 => 7.0.4

Comment:

Backported to relbr70 in r67742. Closing.

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/2769#comment:6&gt;
GRASS GIS <https://grass.osgeo.org>

#2769: v.in.ogr not supporting OFTInteger64 field type
---------------------+--------------------------------
  Reporter: zarch | Owner: martinl
      Type: defect | Status: closed
  Priority: normal | Milestone: 7.0.4
Component: Vector | Version: svn-trunk
Resolution: fixed | Keywords: v.in.ogr Integer64
       CPU: All | Platform: Linux
---------------------+--------------------------------
Changes (by martinl):

* status: assigned => closed
* resolution: => fixed

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/2769#comment:7&gt;
GRASS GIS <https://grass.osgeo.org>