Bug report #15874

Tables with SRID=0 appear twice in the Browser

Added by Paolo Cavallini almost 8 years ago. Updated over 6 years ago.

Status:Open
Priority:Normal
Assignee:-
Category:Browser
Affected QGIS version:3.0.0 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:23792

Description

A table created with SRID=0:

CREATE TABLE pt
 (id INTEGER, name text, geom GEOMETRY(Point,0,2));
INSERT INTO pt (id, name, geom)
 VALUES (1, 'Origin', ST_GeomFromText('POINT(0 0)', 0));

results in two entries: one with mouseover= geom as Point in 0 and one geom as Point in -2147483648

History

#1 Updated by Giovanni Manghi over 7 years ago

  • Easy fix? set to No
  • Regression? set to No

#2 Updated by Paolo Cavallini over 6 years ago

  • Affected QGIS version changed from 2.18.0 to 3.0.0
  • Description updated (diff)

Still true in QGIS 3

Also available in: Atom PDF