[Qgis-user] Detecting Geometry Type For Oracle Object

[Jürgen E. Fischer]

Hi Simon,

On Sun, 29. Jan 2017 at 22:42:22 -0700, Simon Greener wrote:
> QGIS, when querying Oracle to determine the geometry type in a table's
> sdo_geometry column executes the following SQL:
> 
> SELECT DISTINCT gtype FROM (SELECT t."GEOMETRY".sdo_gtype AS gtype FROM
> "<XXXX>"."<TABLENAME>" t WHERE t."GEOMETRY" IS NOT NULL AND rownum<1000)
> WHERE rownum<=2
> 
> If there any way that I can force QGIS to change the number it samples?

No, that's hardwired - but it's 100 on 2.18 and master.


Jürgen

-- 
Jürgen E. Fischer           norBIT GmbH             Tel. +49-4931-918175-31
Dipl.-Inf. (FH)             Rheinstraße 13          Fax. +49-4931-918175-50
Software Engineer           D-26506 Norden             http://www.norbit.de
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 827 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20170131/331429dd/attachment.sig>