Date: 2011-05-23 11:30:19 +0200
From: George Garbis <>
To: SQL devs <>
Version: -- development
CC: charnik, @yzchang

Last updated: 2016-06-23 10:24:08 +0200

Comment 15829

Date: 2011-05-23 11:30:19 +0200
From: George Garbis <>

User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:2.0.1) Gecko/20100101 Firefox/4.0.1
Build Identifier:

I create a table with geometries and insert 2 points with different SRID.
When i ask for these SRID i get the same (0) for every point.
Also, if i ask whether these points overlap i don't get the right result.
I get 'true' while the points are totally different, considering their reference systems.

Reproducible: Always

Steps to Reproduce:

1. sql>create table geom(id int, g geometry);
2. sql>insert into geom values(1, GeomFromText('POINT(100 100)', 4326));
3. sql>insert into geom values(2, GeomFromText('POINT(100 100)', 27700));
4. sql>select id, srid(g) from geom;
5. sql>select equals(g1.g, g2.g) from geom g1, geom g2 where g1.id=1 and g2.id=2;

Actual Results:

Results of steps 4 and 5 are:
4.
+------+--------+
| id | srid_g |
+======+========+
| 2 | 0 |
| 1 | 0 |
+------+--------+
5.
+-----------------+
| overlaps_g |
+============+
| true |
+------------+

Expected Results:

Results of steps 4 and 5 are supposed to be:
4.
4.
+------+--------+
| id | srid_g |
+======+========+
| 2 | 27700 |
| 1 | 4326 |
+------+--------+
5.
+-----------------+
| overlaps_g |
+============+
| false |
+------------+

I have noticed that function wkbFromText (in file geom/monetdb5/geom.mx), which is used in SQL functions GeomFromText, PointFromText e.t.c., returns a wkb datatype (defined in geom/lib/libgeom.mx) which has not any field for srid.

Is srid stored somewhere else (e.g. as metadata of a geometry collumn)?

Comment 15866

Date: 2011-07-01 09:56:41 +0200
From: @sjoerdmullender

It seems there is no support for storing the SRID into the database. For some reason the GET function was implemented, but since no value is stored, it always returns 0.

Comment 16041

Date: 2011-07-29 11:00:06 +0200
From: @sjoerdmullender

Apr2011-SP2 has been released.

Comment 16280

Date: 2011-09-16 15:10:40 +0200
From: @sjoerdmullender

The Aug2011 version has been released.

Comment 17684

Date: 2012-08-24 14:56:00 +0200
From: @sjoerdmullender

Jul2012-SP1 has been released.

Comment 18121

Date: 2012-11-27 15:30:20 +0100
From: @yzchang

No test for feature request

Comment 22028

Date: 2016-04-11 12:24:34 +0200
From: @sjoerdmullender

The upcoming Jun2016 release (whether or not it'll arrive in June 2016) will have support for SRID.