Bugs item #1999354, was opened at 2008-06-21 11:27
Message generated for change (Comment added) made by mlkersten
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: Closed
>Resolution: Fixed
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
----------------------------------------------------------------------
>Comment By: Martin Kersten (mlkersten)
Date: 2008-07-30 12:30
Message:
Logged In: YES
user_id=490798
Originator: NO
--readonly and --single-user have been added to the system
escape to debugger fixed
----------------------------------------------------------------------
Comment By: Martin Kersten (mlkersten)
Date: 2008-07-19 19:28
Message:
Logged In: YES
user_id=490798
Originator: NO
The sql_debug 64, 32 should be moved to proper environment variables.
----------------------------------------------------------------------
Comment By: Romulo Goncalves (romulog)
Date: 2008-06-24 13:44
Message:
Logged In: YES
user_id=1498628
Originator: YES
The test was improved and now the mserver is crashing....
To the test I added 3 statements:
create table
select on this table to then call the function f2
drop table
The mserver crashes when we drop the table...
Romulo
----------------------------------------------------------------------
Comment By: Romulo Goncalves (romulog)
Date: 2008-06-22 16:46
Message:
Logged In: YES
user_id=1498628
Originator: YES
test added at:
sql/src/test/BugTracker/Tests/mdb_starts_with_sql_debug_64.SF-1999354.py
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1999354&group_id=56967
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
