Using both mclient and C#/C++ test clients connected via 64bit ODBC I am
encountering this type mismatch error for no obvious reason. This is
something of a show-stopper for what had proved to be a very interesting
experiment!
# MonetDB 5 server v11.19.3 "Oct2014"
# Serving database 'dbfarm', using 4 threads
# Compiled for x86_64-pc-winnt/64bit with 64bit OIDs dynamically linked
# Found 15.982 GiB available main-memory.
An example query below, weight is a double, all other columns are integer.
There are no NULL values, nor any oddities
sql>SELECT count(weight) , sum(weight) , avg(weight) , stddev_pop(weight)
FROM test_1 WHERE ((severity = 1 OR severity = 2) AND (iat = 2) AND (ilit =
3));
Type mismatch
But a family of closely related queries do succeed:
sql>SELECT count(weight) , sum(weight) , avg(weight) , stddev_pop(weight)
FROM test_1 WHERE ((severity = 1 OR severity = 2) AND (iat = 2) AND (ilit =
11));
| L1 | L2 | L3 |>
| 290517 | 290517 | 1 |
1 tuple (200.115ms) !1 column dropped!
Enabling ODBC logging does not reveal a great deal more than this:
dbc-con.vshost 13d8-2ac4 ENTER SQLExecDirectW
HSTMT 0x000000000048F370
WCHAR * 0x000000000256458C [
-3] "SELECT count(weight) as cnt, sum(weight) as total, avg(weight) as
average, stddev_pop(weight) as stddev FROM test_1 WHERE ((severity = 1 OR
severity = 2) AND (iat = 2) AND (ilit = 3))\ 0"
SDWORD -3
odbc-con.vshost 13d8-2ac4 EXIT SQLExecDirectW with return code -1
(SQL_ERROR)
HSTMT 0x000000000048F370
WCHAR * 0x000000000256458C [
-3] "SELECT count(weight) as cnt, sum(weight) as total, avg(weight) as
average, stddev_pop(weight) as stddev FROM test_1 WHERE ((severity = 1 OR
severity = 2) AND (iat = 2) AND (ilit = 3))\ 0"
SDWORD -3
DIAG [HY000] [MonetDB][ODBC Driver
11.19.3]Type mismatch (0)
odbc-con.vshost 13d8-2ac4 ENTER SQLGetDiagRecW
SQLSMALLINT 3
participants (1)
-
g4＠novadsp.com