Hi, I'm using MonetDB on Windows with the MonetDB.R connector.  I'm getting some very strange errors on a particular column (called `rx_cso_num`) where *some* of the math functions work and others do not?  I tested the median() function using mclient - I get the same error - so this has nothing to do with the fact that I'm connecting through R.

I'm running these queries on a confidential data set, so unfortunately I cannot provide a reproducible example with this..  I'm sorry for the hassle, and hoping the error messages below might provide enough of a clue to resolve the issue?  If this really isn't enough, I can send some snipped mclient -X output and/or try my best to create some fake data that also creates some of these problems?


Thanks!!  :)


Here's a list of functions that *work* on the column without a problem:

"count","distinct","min", "max", "sum","avg","abs","sqrt","floor","ceiling","exp","log","cos","sin","tan","acos","asin","atan","cosh","sinh","tanh"


Here's the errors I get for each of the functions that do not:

[1] "median"
Error in dbGetQuery(db, paste0("select ", i, "(rx_cso_num) from x07")) :
  Unable to execute statement 'select median(rx_cso_num) from x07'. Server says '!22003!overflow in conversion of 133 to bte.'.

[1] "sign"
Error in dbGetQuery(db, paste0("select ", i, "(rx_cso_num) from x07")) :
  Unable to execute statement 'select sign(rx_cso_num) from x07'. Server says '!TypeException:user.s5_1[25]:'bat.insert' undefined in: _93:any := bat.insert(_83:bat[:oid,:int], _91:oid, _90:bte)'.

[1] "stddev_pop"
Error in dbGetQuery(db, paste0("select ", i, "(rx_cso_num) from x07")) :
  Unable to execute statement 'select stddev_pop(rx_cso_num) from x07'. Server says '!SELECT: no such unary operator 'stddev_pop(wrd)''.

[1] "stddev"
Error in dbGetQuery(db, paste0("select ", i, "(rx_cso_num) from x07")) :
  Unable to execute statement 'select stddev(rx_cso_num) from x07'. Server says '!SELECT: no such unary operator 'stddev(wrd)''.

[1] "prod"
Error in dbGetQuery(db, paste0("select ", i, "(rx_cso_num) from x07")) :
  Unable to execute statement 'select prod(rx_cso_num) from x07'. Server says '!22003!overflow in conversion of 133 to bte.'.


Here's my mserver window:

# MonetDB 5 server v11.15.3 "Feb2013-SP1"
# Serving database 'medicare_sample', 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:49800/
# MonetDB/JAQL module loaded
# MonetDB/SQL module loaded
>


Thanks!!!