Bugs item #1999354, was opened at 2008-06-21 11:27
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=1999354&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.24
Status: Open
Resolution: None
Priority: 6
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: mdb starts with sql_debug 64
Initial Comment:
If I run the following example against a M5 server with option sql_debug=64
CREATE FUNCTION f2(deg float, truncat int , precision int)
RETURNS varchar(32)
BEGIN
DECLARE
d float,
nd int,
np int,
q varchar(10),
t varchar(16);
--
SET t = '00:00:00.0';
IF (precision < 1)
THEN SET precision = 1;
END IF;
IF (precision > 10)
THEN SET precision = 10;
END IF;
SET np = 0;
WHILE (np < precision-1) DO
SET t = t||'0';
SET np = np + 1;
END WHILE;
SET d = ABS(deg/15.0);
-- degrees
SET nd = FLOOR(d);
SET q = LTRIM(CAST(nd as varchar(2)));
SET t = MS_STUFF(t,3-LENGTH(q),LENGTH(q), q);
-- minutes
SET d = 60.0 * (d-nd);
SET nd = FLOOR(d);
SET q = LTRIM(CAST(nd as varchar(4)));
SET t = MS_STUFF(t,6-LENGTH(q),LENGTH(q), q);
-- seconds
SET d = MS_ROUND( 60.0 * (d-nd),precision,truncat );
SET q = LTRIM(STR(d,precision));
SET t = MS_STUFF(t,10+precision-LENGTH(q),LENGTH(q), q);
-- SET d = 60.0 * (d-nd);
-- SET q = LTRIM(STR(d,3));
-- SET t = MS_STUFF(t,13-LENGTH(q),LENGTH(q), q);
--
RETURN(t);
END;
SELECT f2(1,2,3);
--SELECT fIAUFromEq(p.ra,p."dec") FROM PhotoPrimary as p;
drop function f2;
I get the following errors:
MAPI = [EMAIL PROTECTED]:50000
QUERY = SELECT f2(1,2,3);
ERROR = !TypeException:user.f2[120]:'calc.str' undefined in: _135:any :=
calc.str(_133:dbl, _134:int)
mdb># Ad := nil:dbl;
mdb>#EOD
MAPI = [EMAIL PROTECTED]:50000
QUERY = SELECT f2(1,2,3);
ERROR = !TypeException:user.s0_1[183]:'calc.str' undefined in: _171:any :=
calc.str(_169:dbl, _170:int)
Plus the mdb prompt:
mdb># _4 := A0;
Romulo
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1999354&group_id=56967
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
