Bugs item #1774312, was opened at 2007-08-14 13:28
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1774312&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL 2.18
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Colin Foss (cgfoss)
Assigned to: Niels Nes (nielsnes)
Summary: SQL: conversion from decimal to varchar error
Initial Comment:
MonetDB will throw an error on this SQL:
select tr, cast(tr as varchar(10)) from (select 11.34555 as tr) as foo;
ERROR = !TypeException:user.s7_1[13]:'sql.trunc' undefined in: _47:any :=
sql.trunc(_45:int, _12:int)
!TypeException:user.s7_1[14]:'bat.insert' undefined in: _48:any :=
bat.insert(_39:bat[:oid,:int], _44:oid, _47:any)
% .foo, . # table_name
% tr, truncate_tr # name
% decimal, varchar # type
% 9, 0 # length
Here is my environment:
uname -a : Linux 2.6.9-55.ELsmp #1 SMP Wed May 2 14:04:42 EDT 2007 x86_64
x86_64 x86_64 GNU/Linux
g++ --version: 3.4.6 20060404 (Red Hat 3.4.6-8)
autoconf --version: 2.59
automake --version: 1.9.2
libtool --version: 1.5.6 (1.1220.2.95 2004/04/11 05:50:42)
last src compiled 2007/08/02 at 13:26 PDT.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1774312&group_id=56967
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
