Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv1678/src/test/BugTracker-2009/Tests
Added Files:
updating_non-loaded_columns.SF-2864313_OK-4.sql.in
Log Message:
propagated changes of Tuesday Sep 22 2009 - Wednesday Sep 23 2009
from the Aug2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/09/22 - stmane:
src/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-4.sql.in,1.1.2.1
added test for
ID: 2864313 "SQL: Update changes all columns with same type and default"
https://sourceforge.net/tracker/?func=detail&aid=2864313&group_id=56967&atid=482468
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: updating_non-loaded_columns.SF-2864313_OK-4.sql.in ---
CREATE TABLE "t0" (
"d0" double
);
CREATE TABLE "t1" (
"d1" double,
"v1" varchar(255) default 'x',
"v2" varchar(255) default 'y'
);
COPY 1025 RECORDS INTO t0 FROM
'$TSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING DELIMITERS
'\t';
select count(*) from t0;
INSERT INTO t1 (d1) SELECT d0 FROM t0;
select count(*) from t1;
select d1, v2, v1 from t1 limit 1;
Update t1 Set v2 = 'AA';
select d1, v2, v1 from t1 limit 1;
Update t1 Set d1 = -1.2;
select d1, v2, v1 from t1 limit 1;
Update t1 Set v1 = 'BB';
select d1, v2, v1 from t1 limit 1;
drop table t1;
drop table t0;
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
