Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv22903/src/test/BugTracker-2009/Tests
Added Files:
union_where_combined.SF-2887282.sql
Log Message:
propagated changes of Wednesday Nov 11 2009 - Thursday Nov 12 2009
from the Nov2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/11/11 - nielsnes:
src/test/BugTracker-2009/Tests/union_where_combined.SF-2887282.sql,1.1.2.1
fixed bugs in push select down
in create table with data
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: union_where_combined.SF-2887282.sql ---
start transaction;
create table tblHistory2009 (name varchar(10));
create table tblHistory2008 (onename varchar(10));
create table tblHistory2007 (anothername varchar(10));
insert into tblHistory2009 values ('2009AAA');
insert into tblHistory2009 values ('2009BBB');
insert into tblHistory2009 values ('2009CCC');
insert into tblHistory2009 values ('2009ABC');
insert into tblHistory2008 values ('2008ABC');
insert into tblHistory2008 values ('2008BBB');
insert into tblHistory2008 values ('2008CDE');
insert into tblHistory2007 values ('2007ABC');
insert into tblHistory2007 values ('2007CDE');
commit;
select * from (select * from tblHistory2009
union all
select * from tblHistory2008
union all
select * from tblHistory2007
union all
select 'ABD' as name
union all
select 'ADD' as name
) as t
where t.name like '%ABC%';
start transaction;
drop table tblHistory2009;
drop table tblHistory2008;
drop table tblHistory2007;
commit;
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
