Stefan Manegold wrote: > 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" ... SQL god father will confirm this... I think SQLServer is dumping out the NULLs as "" At least it was what I understood from the load of Skyserver v6, but as I said I am waiting for the reaction of SQL god father...
Romulo > > 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 >> > ------------------------------------------------------------------------------ _______________________________________________ Monetdb-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
