[Monetdb-developers] Problems with SQL module...
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
How about some bug reports on our BugTracker? 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
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
participants (3)
-
Fabian Groffen
-
Romulo Goncalves
-
Sjoerd Mullender