You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
It looks like the geom.MakePoint implementation is called but interpreted as if it is batgeom.MakePoint. This means that the return value is interpreted incorrectly as BAT id, and that causes the crash.
Date: 2016-07-06 15:22:33 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.23.3 (Jun2016)
Last updated: 2016-07-22 09:56:16 +0200
Comment 22238
Date: 2016-07-06 15:22:33 +0200
From: @PedroTadim
User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.106 Safari/537.36
Build Identifier:
Created a SQL function that uses geospatial extension to make a geographic to Cartesian coordinates conversion.
Reproducible: Always
Steps to Reproduce:
CREATE FUNCTION geographic_to_cartesian(lat FLOAT, lon FLOAT) RETURNS POINT /* convert geographic coordinates to Cartesian while creating a point */
BEGIN
DECLARE deg_to_rad FLOAT, lat_rad FLOAT, lon_rad FLOAT, aux1 FLOAT, aux2 FLOAT;
SET deg_to_rad = pi() / 180;
SET lat_rad = lat * deg_to_rad;
SET lon_rad = lon * deg_to_rad;
SET aux1 = sys.cos(lat_rad);
SET aux2 = 6371 * aux1;
RETURN sys.st_makepoint(aux2 * sys.cos(lon_rad), aux2 * sys.sin(lon_rad), 6371 * sys.sin(lat_rad));
END;
CREATE TABLE test_table (lat FLOAT, lon FLOAT);
SELECT geographic_to_cartesian(lat, lon) AS calc_point FROM test_table;
Actual Results:
The client crashes.
Expected Results:
The query result, a table with a single column showing the results of the function call.
The client breaks after performing the select query, and the log message:
2016-07-06 13:54:35 ERR iotdb[15513]: mserver5: ../../gdk/gdk.h:2494: BBPcheck: Assertion `x > 0' failed.
I reproduced it on the default branch, and it happens whatever the table has rows on it or not.
Comment 22239
Date: 2016-07-06 16:47:34 +0200
From: @sjoerdmullender
It looks like the geom.MakePoint implementation is called but interpreted as if it is batgeom.MakePoint. This means that the return value is interpreted incorrectly as BAT id, and that causes the crash.
Comment 22243
Date: 2016-07-11 16:46:58 +0200
From: MonetDB Mercurial Repository <>
Changeset ae042233e063 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=ae042233e063
Changeset description:
Comment 22244
Date: 2016-07-11 17:36:49 +0200
From: @sjoerdmullender
Should be fixed now.
The text was updated successfully, but these errors were encountered: