On 2006-10-12 17:27, Fabian Groffen wrote:
How about some bug reports on our BugTracker?
One for each issue, please.
On 12-10-2006 14:51:43 +0200, Romulo Goncalves wrote:
Dear all,
I founded some problems in SQL module. Maybe they are not problems just a misunderstood.
To see the problems in your computer just start a mserver5, load sql module, and sql.start(); Then start a mclient -lsql.
First Problem:
Execute this two queries in the mclient:
CREATE FUNCTION zero(id int) RETURNS int BEGIN IF id > 0 THEN RETURN 1; ELSE RETURN 0; END IF; END;
CREATE FUNCTION TEST() RETURNS BOOLEAN BEGIN DECLARE x int; SET x = zero(1); IF x > 0 THEN RETURN TRUE; ELSE RETURN FALSE; END IF; END;
UNTIL now you should not find any problems. Lets see the first problem:
In the mclient execute: SELECT test();
I got this error:
Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 1098918240 (LWP 14589)] 0x00002aaaaaaba2c1 in idcmp (n=0x2aaab485227b "destroy", m=0x0) at /ufs/goncalve/MonetDB/MonetDB5/monet5/src/mal/mal_type.mx:251 251 if (* n == * m) (gdb) up #1 0x00002aaab483ab94 in isUpdated (mb=0xf59548, pc=9) at /ufs/goncalve/MonetDB/MonetDB5/monet5/src/optimizer/opt_support.mx:885 885 if (idcmp("destroy", getFunctionId(q)) = = 0) (gdb) up #2 0x00002aaab483f287 in OPTcommonTermsImplementation (mb=0xf59548, stk=0x0, pci=0x0) at /ufs/goncalve/MonetDB/MonetDB5/monet5/src/optimizer/opt_commonTerms.mx:17 6 176 if (hasSameSignature(p, q) && (gdb) up #3 0x00002aaab483f718 in OPTcommonTerms (mb=0xf59548, stk=0x0, p=0x0) at /ufs/goncalve/MonetDB/MonetDB5/monet5/src/optimizer/opt_commonTerms.mx:24 9 Line number 249 out of range; /ufs/goncalve/MonetDB/MonetDB5/monet5/src/optimize r/opt_commonTerms.mx has 220 lines. (gdb) up #4 0x00002aaab4efb73a in addQueryToCache (c=0x503a10) at /ufs/goncalve/MonetDB/SQL/sql/src/backends/monet5/sql_optimizer.mx:434 434 OPTcommonTerms(mb,0,0); /* common terms */ (gdb) up #5 0x00002aaab4efa84e in backend_create_func (be=0x10e1218, f=0x10e80b8) at /ufs/goncalve/MonetDB/SQL/sql/src/backends/monet5/sql_gencode.mx:1938 1938 addQueryToCache(c);
If you want all the details, run your mserver with gdb (I know that you know the procedures for debugging). ;)
Second problem:
If I restart the mclient and restart the mserver: The mclient can see the functions in the table sys.functions, but the client started in the server by sql.start() does see the functions created.
Third problem: Just execute the following query: select * from functions where name like 'hash';
Why they are so many rows with the same information for the function hash?
Fourth problem:
Just create the following function:
CREATE FUNCTION niels(id_val int) RETURNS TABLE (id int) BEGIN DECLARE TABLE roro(id int); RETURN TABLE (SELECT id from functions where id = id_val order by id); END;
I will try to correct this bugs, but until there I will appreciate some help.
This problems are delaying the translation of Skyserver functions and also the my implementation of Dependency Control table.
Best Regards, Romulo Goncalves
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- Sjoerd Mullender