Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv26918/src/test/BugTracker-2009/Tests
Added Files:
assert_in_update.SF-2807336.sql
Log Message:
propagated changes of Friday Aug 07 2009
from the Aug2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/08/07 - nielsnes:
src/test/BugTracker-2009/Tests/assert_in_update.SF-2807336.sql,1.1.2.1
add test script for bug in handling 'ambiguous' column names
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: assert_in_update.SF-2807336.sql ---
CREATE TABLE "sys"."anbi" ( "naam" varchar(256), "vestigingsplaats"
varchar(32), "beschikking" date, "intrekking" date, kvk bigint);
CREATE TABLE "sys"."kvk" ("kvk" bigint, "bedrijfsnaam" varchar(255),
"adres" varchar(64), "postcode" varchar(6), "plaats" varchar(32), "type"
varchar(16));
select kvk.kvk from kvk,anbi where lower(naam) = lower(bedrijfsnaam)
and lower(plaats) = lower(vestigingsplaats);
update anbi set kvk = (select kvk.kvk from kvk,anbi where lower(naam)
= lower(bedrijfsnaam) and lower(plaats) = lower(vestigingsplaats));
update anbi set kvk = (select kvk from kvk,anbi where lower(naam)
= lower(bedrijfsnaam) and lower(plaats) = lower(vestigingsplaats));
drop table anbi;
drop table kvk;
------------------------------------------------------------------------------
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
