Date: 2012-05-24 15:09:25 +0200
From: @bartscheers
To: SQL devs <>
Version: 11.9.5 (Apr2012-SP1) [obsolete]

Last updated: 2012-06-19 11:20:26 +0200

Comment 17283

Date: 2012-05-24 15:09:25 +0200
From: @bartscheers

User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:12.0) Gecko/20100101 Firefox/12.0
Build Identifier: At least since Dec2011

Modulo function MOD() does not work in select from table

Reproducible: Always

Steps to Reproduce:

1. CREATE TABLE t (d DOUBLE);
2. INSERT INTO t VALUES (0.011);
3. SELECT MOD(0.011 + 180, 360) gives correct results
4. SELECT MOD(d + 180, 360) FROM t gives TypeException

Actual Results:

TypeException:user.s8_1[17]:'calc.fmod' undefined in: _53:any := calc.fmod(_51:dbl, A1:dbl)
TypeException:user.s8_1[18]:'bat.insert' undefined in: _54:any := bat.insert(_45:bat[:oid,:dbl], _50:oid, _53:any)
39000!program contains errors

Expected Results:

result set containing one entry with value 180.011

Comment 17284

Date: 2012-05-24 16:40:08 +0200
From: @sjoerdmullender

Changeset e907dd8ed60c 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=e907dd8ed60c

Changeset description:

Added test for bug #3086.

Comment 17285

Date: 2012-05-24 16:42:18 +0200
From: @sjoerdmullender

Fixed with changeset 2b43985d0e8.

Comment 17286

Date: 2012-05-24 16:43:01 +0200
From: @sjoerdmullender

(In reply to comment 2)

Fixed with changeset 2b43985d0e8.

Make that 2b43985d0e82