Hello, I'm trying to run some old code with a recent upgrade of MonetDB and the standard deviation function appears to have disappeared.  I'm running MonetDB on Windows.

This issue was previously discussed and resolved in this thread:  http://old.nabble.com/users-list-Digest%2C-Vol-3%2C-Issue-8-tt34660082.html#a34660082

I could re-open this bug report if appropriate?  http://bugs.monetdb.org/show_bug.cgi?id=2454#c18

My server specs are below, and the actual commands below that.

Thank you!!!


# MonetDB 5 server v11.15.1 "Feb2013"
# Serving database 'bsapuf', using 8 threads
# Compiled for x86_64-pc-winnt/64bit with 64bit OIDs dynamically linked
# Found 7.860 GiB available main-memory.
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2013 MonetDB B.V., all rights reserved
# Visit http://www.monetdb.org/ for further information
# Listening for connection requests on mapi:monetdb://127.0.0.1:50003/
# MonetDB/JAQL module loaded
# MonetDB/SQL module loaded
>


c:\Program Files\MonetDB\MonetDB5>mclient -p 50003 "bsapuf"
user(win32):monetdb
password:
Welcome to mclient, the MonetDB/SQL interactive terminal (Feb2013)
Database: MonetDB v11.15.1 (Feb2013), 'bsapuf'
Type \q to quit, \? for a list of available commands
auto commit mode: on
sql>select sum( hha_pmt_amt ) from hha08;
+-----------+
| L1        |
+===========+
| 675676300 |
+-----------+
1 tuple (2.311ms)
sql>select sum( hha_pmt_amt ), avg( hha_pmt_amt ) from hha08;
+-----------+--------------------------+
| L1        | L2                       |
+===========+==========================+
| 675676300 |       5412.8151310993435 |
+-----------+--------------------------+
1 tuple (63.559ms)
sql>select sum( hha_pmt_amt ), median( hha_pmt_amt ) from hha08;
+-----------+------+
| L1        | L2   |
+===========+======+
| 675676300 | 3500 |
+-----------+------+
1 tuple (9.601ms)
sql>select sum( hha_pmt_amt ), stddev( hha_pmt_amt ) from hha08;
SELECT: no such unary operator 'stddev(int)'
sql>select sum( hha_pmt_amt ), sd( hha_pmt_amt ) from hha08;
SELECT: no such unary operator 'sd(int)'
sql>select sum( hha_pmt_amt ), sddev( hha_pmt_amt ) from hha08;
SELECT: no such unary operator 'sddev(int)'
sql>select sum( hha_pmt_amt ), var( hha_pmt_amt ) from hha08;
SELECT: no such unary operator 'var(int)'
sql>select sum( hha_pmt_amt ), variance( hha_pmt_amt ) from hha08;
SELECT: no such unary operator 'variance(int)'
sql>select sum( hha_pmt_amt ), stdevp( hha_pmt_amt ) from hha08;
SELECT: no such unary operator 'stdevp(int)'
sql>