Hi Stefan,     I had installed monetdb and now wanted to start mclient. So first i started Mserver5.bat and then when i click on mclient.bat that time "api-ms-win-crt-runtime-l1-1-0.dll is missing issue" this error is coming in alert box.  Is monetdb is only usefull for windows server 2003,vista and Windows 7 or it can be used with Windows 2012 server also? On Monday 23 October 2017 03:30 PM, users-list-request@monetdb.org wrote:

Send users-list mailing list submissions to users-list@monetdb.org

To subscribe or unsubscribe via the World Wide Web, visit https://www.monetdb.org/mailman/listinfo/users-list or, via email, send a message with subject or body 'help' to users-list-request@monetdb.org

You can reach the person managing the list at users-list-owner@monetdb.org

When replying, please edit your Subject line so it is more specific than "Re: Contents of users-list digest..."

Today's Topics:

1. Why does corr(int,int) return int? (Stefan Manegold) 2. Re: Why does corr(int,int) return int? (Anthony Damico) 3. Problem in installation (Amit Ambekar) 4. Re: Why does corr(int,int) return int? (Stefan Manegold) 5. Re: Problem in installation (Stefan Manegold)

----------------------------------------------------------------------

Message: 1 Date: Sun, 22 Oct 2017 19:48:27 +0200 (CEST) From: Stefan Manegold To: Communication channel for MonetDB users Subject: Why does corr(int,int) return int? Message-ID: <1997044866.6459538.1508694507470.JavaMail.zimbra@cwi.nl> Content-Type: text/plain; charset=utf-8

Hi,

could some one possible explain to me why the MonetDB corr() aggregate function, that IMHO is supposed to calculate the correlation between two attributes, does return the same type as (the larger of) its input type(s)?

IMHO the correlation between two attributes (or (samples of) random variables is a factional value between -1 and 1.

Consequently, MonetDB corr() on two integer columns returns an integer results, i.e., one of {-1,0,1} ...

Shouldn't corr() --- much like avg(), var_pop(), var_samp(), stddev_samp(), stddev_pop() always return type double ?

Thanks!

Best, Stefan

-- Amit Ambekar Technology Associate Office: Ist floor, Poddar Chambers, Mathruradas Mill Compound, Lower Parel, Mumbai 400013 | Landline: +91 22 43470408 Cell: +91-7741823310 | Email: amit@g-square.in| Website: www.g-square.in cid:image003.png@01D2A947.80D76E60