Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/test/Skyserver Skyserver_import.sql, , 1.3, 1.4 Skyserver_tables.sql, , 1.4, 1.5
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 Monetdb-sql-checkins@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | 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 |
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 Monetdb-sql-checkins@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
participants (2)
-
Romulo Goncalves -
Stefan Manegold