On Mon, Dec 29, 2008 at 04:50:00PM +0000, Romulo Goncalves wrote: > Update of /cvsroot/monetdb/sql/src/test/Skyserver > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv383 > > Modified Files: > Skyserver_import.sql Skyserver_tables.sql > Log Message: > Correct some copy from statements to make the test green > At the same time remove some NULL constraints from the columns because "" is > now seen as NULL
IMHO, "" (i.e., an empty string of length 0) is *not* NULL --- but I don't know, whether the SQL standard has a different "opinion" ... Stefan > > > > U Skyserver_tables.sql > Index: Skyserver_tables.sql > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_tables.sql,v > retrieving revision 1.4 > retrieving revision 1.5 > diff -u -d -r1.4 -r1.5 > --- Skyserver_tables.sql 1 Apr 2008 11:45:51 -0000 1.4 > +++ Skyserver_tables.sql 29 Dec 2008 16:49:58 -0000 1.5 > @@ -451,7 +451,7 @@ > eta float NOT NULL, > lambdaMin float NOT NULL, > lambdaMax float NOT NULL, > - htmArea varchar(1024) NOT NULL, > + htmArea varchar(1024), --NOT NULL, > CONSTRAINT pk_StripeDefs_stripe PRIMARY KEY > ( > stripe > @@ -1155,11 +1155,11 @@ > ); > CREATE TABLE DBColumns( > tablename varchar(128) NOT NULL, > - name varchar(64) NOT NULL, > - unit varchar(64) NOT NULL, > - ucd varchar(128) NOT NULL, > - enum varchar(64) NOT NULL, > - description varchar(2000) NOT NULL, > + name varchar(64), -- NOT NULL, > + unit varchar(64), -- NOT NULL, > + ucd varchar(128), --NOT NULL, > + enum varchar(64), -- NOT NULL, > + description varchar(2000),-- NOT NULL, > rank int NOT NULL DEFAULT (0), > CONSTRAINT pk_DBColumns_tableName_name PRIMARY KEY > ( > > U Skyserver_import.sql > Index: Skyserver_import.sql > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_import.sql,v > retrieving revision 1.3 > retrieving revision 1.4 > diff -u -d -r1.3 -r1.4 > --- Skyserver_import.sql 6 Jun 2008 11:54:58 -0000 1.3 > +++ Skyserver_import.sql 29 Dec 2008 16:49:58 -0000 1.4 > @@ -60,7 +60,7 @@ > > COPY 1000 RECORDS INTO SDSSConstants FROM 'DATA/SDSSConstants1.dat.bz2' > USING DELIMITERS '|', '\015\n'; > > -COPY 1000 RECORDS INTO StripeDefs FROM 'DATA/StripeDefs1.dat.bz2' USING > DELIMITERS '\t', '\015\n'; > +COPY 1000 RECORDS INTO StripeDefs FROM 'DATA/StripeDefs1.dat.bz2' USING > DELIMITERS '\t', '\015\n', '"' NULL as ''; > > COPY 1000 RECORDS INTO RunShift FROM 'DATA/RunShift.dat.bz2' USING > DELIMITERS '\t', '\015\n'; > > @@ -116,7 +116,7 @@ > > COPY 1000 RECORDS INTO Inventory FROM 'DATA/Inventory.dat.bz2' USING > DELIMITERS '\t', '\015\n'; > > -COPY 3000 RECORDS INTO DBColumns FROM 'DATA/DBColumns1.dat.bz2' USING > DELIMITERS '\t', '\015\n'; > +COPY 3000 RECORDS INTO DBColumns FROM 'DATA/DBColumns1.dat.bz2' USING > DELIMITERS '\t', '\015\n', '"' NULL as ''; > > COPY 1000 RECORDS INTO DBViewCols FROM 'DATA/DBViewCols.dat.bz2' USING > DELIMITERS '\t', '\015\n'; > > > > ------------------------------------------------------------------------------ > _______________________________________________ > Monetdb-sql-checkins mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins > -- | Dr. Stefan Manegold | mailto:[email protected] | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 | ------------------------------------------------------------------------------ _______________________________________________ Monetdb-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
