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
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
