Changeset: 07abe27c1804 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=07abe27c1804 Modified Files: sql/src/test/BugTracker-2010/Tests/hibernate0.sql sql/src/test/BugTracker-2010/Tests/hibernate1.sql Branch: default Log Message:
Sample hibernate files output should be collected. First shot shows that the optimizers are not optimal. Common terms are not found. diffs (99 lines): diff -r 3ed42ada3b9e -r 07abe27c1804 sql/src/test/BugTracker-2010/Tests/hibernate0.sql --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/sql/src/test/BugTracker-2010/Tests/hibernate0.sql Sun Oct 03 20:32:51 2010 +0200 @@ -0,0 +1,54 @@ +-- This example comes from A. Nicu from Sybase +start transaction; + +CREATE TABLE device( + ID integer, + dbId integer, + dcrDeviceId integer, + Name varchar(255), + sName varchar(255) +); +insert into device values(1,2,3,'SSTB0','XHFH0'); +insert into device values(2,1,3,'XHFH0','SSTB0'); + +CREATE TABLE Entry( + dd integer, + ss varchar(255) +); +insert into Entry values(1,'129.196.9.001'); + +SELECT DISTINCT Device.ID,Device.Name +FROM Device +WHERE Device.ID IN + (SELECT DISTINCT Device.ID + FROM Device + WHERE Device.ID IN + (SELECT DISTINCT Device.ID + FROM Device + WHERE Device.ID IN + (SELECT DISTINCT Device.ID + FROM Device + WHERE Device.ID IN + (SELECT DISTINCT Device.ID + FROM Device + WHERE Device.ID IN + (SELECT DISTINCT Device.ID + FROM Device + WHERE Device.ID IN + (SELECT DISTINCT Device.ID + FROM Device + WHERE Device.ID IN (SELECT Device.ID + FROM Device,Entry + WHERE Device.dbId = Entry.dd + AND UPPER(Entry.ss) LIKE '%192.16.%') + OR Device.ID IN ( ( SELECT ID FROM Device + WHERE ( UPPER(Device.sName) LIKE '%SSMC%' ) ) ) ) +OR Device.ID IN ( ( SELECT ID FROM Device WHERE ( UPPER(Device.sName) LIKE '%SSTB%' ) ) ) ) + OR Device.ID IN ( ( SELECT dcrDeviceId FROM Device WHERE ( UPPER(Device.sName) LIKE '%XHFH%' ) ) ) ) +OR Device.ID IN ( ( SELECT ID FROM Device WHERE ( UPPER(Device.Name) LIKE '%SSTB%' ) ) ) ) +OR Device.ID IN ( ( SELECT ID FROM Device WHERE ( UPPER(Device.Name) LIKE '%XHFH%' ) ) ) ) +OR Device.ID IN ( ( SELECT Device.ID FROM Device,Entry WHERE ( ( Device.dbId = Entry.dd ) ) AND ( UPPER(Entry.ss) LIKE '%129.196.9.%' ) ) ) ); + +drop table device; +drop table entry; +rollback; diff -r 3ed42ada3b9e -r 07abe27c1804 sql/src/test/BugTracker-2010/Tests/hibernate1.sql --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/sql/src/test/BugTracker-2010/Tests/hibernate1.sql Sun Oct 03 20:32:51 2010 +0200 @@ -0,0 +1,37 @@ +-- example provide by A. Nicu from Sybase +start transaction; +CREATE TABLE device( + ID integer, + dbId integer, + dcrDeviceId integer, + Name varchar(255), + sName varchar(255) +); +insert into device values(1,2,3,'SSTB0','XHFH0'); +insert into device values(2,1,3,'XHFH0','SSTB0'); + +CREATE TABLE Entry( + dd integer, + ss varchar(255) +); +insert into Entry values(1,'129.196.9.001'); + +SELECT DISTINCT W0.ID,W0.Name +FROM Device W0 +WHERE ( W0.ID IS NOT NULL and +( W0.ID IN + (SELECT W9.ID + FROM Device W9,Entry + WHERE W9.dbId = Entry.dd + AND UPPER(Entry.ss) LIKE '%192.16.%') ) +OR ( UPPER(W0.sName) LIKE '%SSMC%' ) +OR ( UPPER(W0.sName) LIKE '%SSTB%' ) +OR ( UPPER(W0.sName) LIKE '%XHFH%' ) +OR (UPPER(W0.Name) LIKE '%SSTB%' ) +OR (UPPER(W0.Name) LIKE '%XHFH%' ) +OR W0.ID IN ( ( SELECT W12.ID FROM Device W12,Entry WHERE W12.dbId = Entry.dd AND UPPER(Entry.ss) LIKE '%129.196.9.%' ); + +DROP TABLE device; +DROP TABLE entry; + +rollback; _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
