Changeset: 3333fd26e816 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3333fd26e816 Added Files: sql/test/Skyserver/Skyserver_constraints.test sql/test/Skyserver/Skyserver_constraints_v6.test sql/test/Skyserver/Skyserver_dropConstraints.test sql/test/Skyserver/Skyserver_dropConstraints_v6.test sql/test/Skyserver/Skyserver_dropFunctions.test sql/test/Skyserver/Skyserver_dropFunctions_v6.test sql/test/Skyserver/Skyserver_dropTables.test sql/test/Skyserver/Skyserver_dropTables_v6.test sql/test/Skyserver/Skyserver_dropViews.test sql/test/Skyserver/Skyserver_dropViews_v6.test sql/test/Skyserver/Skyserver_functions.test sql/test/Skyserver/Skyserver_functions_v6.test sql/test/Skyserver/Skyserver_import.test sql/test/Skyserver/Skyserver_import_v6.test sql/test/Skyserver/Skyserver_tables.test sql/test/Skyserver/Skyserver_tables_v6.test sql/test/Skyserver/Skyserver_views.test sql/test/Skyserver/Skyserver_views_v6.test sql/test/Skyserver/create_user.test sql/test/Skyserver/drop_user.test sql/test/snodgrass/Tests/cast_select.test sql/test/snodgrass/Tests/cast_table.test sql/test/snodgrass/Tests/date_parsing.test sql/test/snodgrass/Tests/date_select.test sql/test/snodgrass/Tests/date_table.test sql/test/snodgrass/Tests/extract_select.test sql/test/snodgrass/Tests/extract_table.test sql/test/snodgrass/Tests/interval_parsing.test sql/test/snodgrass/Tests/interval_select.test sql/test/snodgrass/Tests/interval_table.test Modified Files: testing/SQLogicConvertNotes Branch: mtest Log Message:
add tests for Skyserver and snodgrass diffs (truncated from 17878 to 300 lines): diff --git a/sql/test/Skyserver/Skyserver_constraints.test b/sql/test/Skyserver/Skyserver_constraints.test new file mode 100644 --- /dev/null +++ b/sql/test/Skyserver/Skyserver_constraints.test @@ -0,0 +1,226 @@ +statement ok +START TRANSACTION + +statement error +ALTER TABLE "Match" ADD CONSTRAINT fk_Match_matchHead_MatchHead_obj FOREIGN KEY(matchHead) +REFERENCES MatchHead (objID) + +statement error +ALTER TABLE "Match" ADD CONSTRAINT fk_Match_objID1_PhotoObjAll_objI FOREIGN KEY(objID1) +REFERENCES PhotoObjAll (objID) + +statement error +ALTER TABLE SpecObjAll ADD CONSTRAINT fk_SpecObjAll_plateID_PlateX_pla FOREIGN KEY(plateID) +REFERENCES PlateX (plateID) + +statement error +ALTER TABLE HoleObj ADD CONSTRAINT fk_HoleObj_plateID_PlateX_plateI FOREIGN KEY(plateID) +REFERENCES PlateX (plateID) + +statement error +ALTER TABLE SpecPhotoAll ADD CONSTRAINT fk_SpecPhotoAll_specObjID_SpecOb FOREIGN KEY(specObjID) +REFERENCES SpecObjAll (specObjID) + +statement error +ALTER TABLE QuasarCatalog ADD CONSTRAINT fk_QuasarCatalog_specObjID_SpecO FOREIGN KEY(specObjId) +REFERENCES SpecObjAll (specObjID) + +statement error +ALTER TABLE SpecLineIndex ADD CONSTRAINT fk_SpecLineIndex_specobjID_SpecO FOREIGN KEY(specobjID) +REFERENCES SpecObjAll (specObjID) + +statement error +ALTER TABLE SpecLineAll ADD CONSTRAINT fk_SpecLineAll_specObjID_SpecObj FOREIGN KEY(specobjID) +REFERENCES SpecObjAll (specObjID) + +statement error +ALTER TABLE XCRedshift ADD CONSTRAINT fk_XCRedshift_specObjID_SpecObjA FOREIGN KEY(specObjID) +REFERENCES SpecObjAll (specObjID) + +statement error +ALTER TABLE ELRedShift ADD CONSTRAINT fk_ELRedshift_specObjID_SpecObjA FOREIGN KEY(specObjID) +REFERENCES SpecObjAll (specObjID) + +statement error +ALTER TABLE TargetInfo ADD CONSTRAINT fk_TargetInfo_targetID_Target_ta FOREIGN KEY(targetID) +REFERENCES Target (targetID) + +statement error +ALTER TABLE TiledTargetAll ADD CONSTRAINT fk_TiledTargetAll_tile_TileAll_t FOREIGN KEY(tile) +REFERENCES TileAll (tile) + +statement error +ALTER TABLE PlateX ADD CONSTRAINT fk_PlateX_tile_TileAll_tile FOREIGN KEY(tile) +REFERENCES TileAll (tile) + +statement error +ALTER TABLE Sector2Tile ADD CONSTRAINT fk_Sector2Tile_regionID_Region_r FOREIGN KEY(regionID) +REFERENCES Region (regionid) + +statement error +ALTER TABLE Sector2Tile ADD CONSTRAINT fk_Sector2Tile_tile_TileAll_tile FOREIGN KEY(tile) +REFERENCES TileAll (tile) + +statement error +ALTER TABLE TilingInfo ADD CONSTRAINT fk_TilingInfo_tileRun_TilingRun_ FOREIGN KEY(tileRun) +REFERENCES TilingRun (tileRun) + +statement error +ALTER TABLE TileAll ADD CONSTRAINT fk_TileAll_tileRun_TilingRun_til FOREIGN KEY(tileRun) +REFERENCES TilingRun (tileRun) + +statement error +ALTER TABLE TilingNote ADD CONSTRAINT fk_TilingNote_tileRun_TilingRun_ FOREIGN KEY(tileRun) +REFERENCES TilingRun (tileRun) + +statement error +ALTER TABLE TilingGeometry ADD CONSTRAINT fk_TilingGeometry_stripe_StripeD FOREIGN KEY(stripe) +REFERENCES StripeDefs (stripe) + +statement error +ALTER TABLE TilingGeometry ADD CONSTRAINT fk_TilingGeometry_tileRun_Tiling FOREIGN KEY(tileRun) +REFERENCES TilingRun (tileRun) + +statement error +ALTER TABLE RegionConvex ADD CONSTRAINT fk_RegionConvex_regionID_Region_ FOREIGN KEY(regionID) +REFERENCES Region (regionid) + +statement error +ALTER TABLE Region2Box ADD CONSTRAINT fk_Region2Box_boxID_Region_regio FOREIGN KEY(boxid) +REFERENCES Region (regionid) + +statement error +ALTER TABLE Sector ADD CONSTRAINT fk_Sector_regionID_Region_region FOREIGN KEY(regionID) +REFERENCES Region (regionid) + +statement error +ALTER TABLE RegionArcs ADD CONSTRAINT fk_RegionArcs_regionID_Region_re FOREIGN KEY(regionid) +REFERENCES Region (regionid) + +statement error +ALTER TABLE HalfSpace ADD CONSTRAINT fk_HalfSpace_regionID_Region_reg FOREIGN KEY(regionid) +REFERENCES Region (regionid) + +statement error +ALTER TABLE Inventory ADD CONSTRAINT fk_Inventory_name_DBObjects_name FOREIGN KEY(name) +REFERENCES DBObjects (name) + +statement error +ALTER TABLE DBColumns ADD CONSTRAINT fk_DBColumns_tablename_DBObjects FOREIGN KEY(tablename) +REFERENCES DBObjects (name) + +statement error +ALTER TABLE DBViewCols ADD CONSTRAINT fk_DBViewCols_viewname_DBObjects FOREIGN KEY(viewname) +REFERENCES DBObjects (name) + +statement error +ALTER TABLE IndexMap ADD CONSTRAINT fk_IndexMap_tableName_DBObjects_ FOREIGN KEY(tableName) +REFERENCES DBObjects (name) + +statement error +ALTER TABLE BestTarget2Sector ADD CONSTRAINT fk_BestTarget2Sector_objID_Photo FOREIGN KEY(objID) +REFERENCES PhotoObjAll (objID) + +statement error +ALTER TABLE BestTarget2Sector ADD CONSTRAINT fk_BestTarget2Sector_regionID_Se FOREIGN KEY(regionID) +REFERENCES Sector (regionID) + +statement error +ALTER TABLE Segment ADD CONSTRAINT fk_Segment_chunkId_Chunk_chunkId FOREIGN KEY(chunkID) +REFERENCES Chunk (chunkID) + +statement error +ALTER TABLE Segment ADD CONSTRAINT fk_Segment_stripe_StripeDefs_str FOREIGN KEY(stripe) +REFERENCES StripeDefs (stripe) + +statement error +ALTER TABLE Field ADD CONSTRAINT fk_Field_segmentID_Segment_segme FOREIGN KEY(segmentID) +REFERENCES Segment (segmentID) + +statement error +ALTER TABLE PhotoObjAll ADD CONSTRAINT fk_PhotoObjAll_fieldID_Field_fie FOREIGN KEY(fieldID) +REFERENCES Field (fieldID) + +statement error +ALTER TABLE RunQA ADD CONSTRAINT fk_RunQA_fieldID_Field_fieldID FOREIGN KEY(fieldID) +REFERENCES Field (fieldID) + +statement error +ALTER TABLE FieldProfile ADD CONSTRAINT fk_FieldProfile_fieldID_Field_fi FOREIGN KEY(fieldID) +REFERENCES Field (fieldID) + +statement error +ALTER TABLE PhotoTag ADD CONSTRAINT fk_PhotoTag_fieldID_Field_fieldI FOREIGN KEY(fieldID) +REFERENCES Field (fieldID) + +statement error +ALTER TABLE PhotoTag ADD CONSTRAINT fk_PhotoTag_objID_PhotoObjAll_ob FOREIGN KEY(objID) +REFERENCES PhotoObjAll (objID) + +statement error +ALTER TABLE Frame ADD CONSTRAINT fk_Frame_fieldID_Field_fieldID FOREIGN KEY(fieldID) +REFERENCES Field (fieldID) + +statement error +ALTER TABLE ObjMask ADD CONSTRAINT fk_ObjMask_objID_PhotoObjAll_obj FOREIGN KEY(objID) +REFERENCES PhotoObjAll (objID) + +statement error +ALTER TABLE MatchHead ADD CONSTRAINT fk_MatchHead_objID_PhotoObjAll_o FOREIGN KEY(objID) +REFERENCES PhotoObjAll (objID) + +statement error +ALTER TABLE MaskedObject ADD CONSTRAINT fk_MaskedObject_maskID_Mask_mask FOREIGN KEY(maskID) +REFERENCES Mask (maskID) + +statement error +ALTER TABLE MaskedObject ADD CONSTRAINT fk_MaskedObject_objID_PhotoObjAl FOREIGN KEY(objid) +REFERENCES PhotoObjAll (objID) + +statement error +ALTER TABLE Neighbors ADD CONSTRAINT fk_Neighbors_objID_PhotoObjAll_o FOREIGN KEY(objID) +REFERENCES PhotoObjAll (objID) + +statement error +ALTER TABLE Zone ADD CONSTRAINT fk_Zone_objID_PhotoObjAll_objID FOREIGN KEY(objID) +REFERENCES PhotoObjAll (objID) + +statement error +ALTER TABLE USNOB ADD CONSTRAINT fk_USNOB_objID_PhotoObjAll_objID FOREIGN KEY(objid) +REFERENCES PhotoObjAll (objID) + +statement error +ALTER TABLE USNO ADD CONSTRAINT fk_USNO_objID_PhotoObjAll_objID FOREIGN KEY(objID) +REFERENCES PhotoObjAll (objID) + +statement error +ALTER TABLE PhotoAuxAll ADD CONSTRAINT fk_PhotoAuxAll_objID_PhotoObjAll FOREIGN KEY(objid) +REFERENCES PhotoObjAll (objID) + +statement error +ALTER TABLE Photoz ADD CONSTRAINT fk_Photoz_objID_PhotoObjAll_objI FOREIGN KEY(objID) +REFERENCES PhotoObjAll (objID) + +statement error +ALTER TABLE First ADD CONSTRAINT fk_First_objID_PhotoObjAll_objID FOREIGN KEY(objID) +REFERENCES PhotoObjAll (objID) + +statement error +ALTER TABLE Rosat ADD CONSTRAINT fk_Rosat_objID_PhotoObjAll_objID FOREIGN KEY(objID) +REFERENCES PhotoObjAll (objID) + +statement error +ALTER TABLE PhotoProfile ADD CONSTRAINT fk_PhotoProfile_objID_PhotoObjAl FOREIGN KEY(objID) +REFERENCES PhotoObjAll (objID) + +statement error +ALTER TABLE FileGroupMap ADD CONSTRAINT fk_FileGroupMap_tableFileGroup_P FOREIGN KEY(tableFileGroup) +REFERENCES PartitionMap (fileGroupName) + +statement error +ALTER TABLE Chunk ADD CONSTRAINT fk_Chunk_stripe_StripeDefs_strip FOREIGN KEY(stripe) +REFERENCES StripeDefs (stripe) + +statement error +COMMIT + diff --git a/sql/test/Skyserver/Skyserver_constraints_v6.test b/sql/test/Skyserver/Skyserver_constraints_v6.test new file mode 100644 --- /dev/null +++ b/sql/test/Skyserver/Skyserver_constraints_v6.test @@ -0,0 +1,264 @@ +statement error +ALTER TABLE Ap7Mag ADD CONSTRAINT fk_Ap7Mag_objID_PhotoObjAll_objI FOREIGN KEY(objID) +REFERENCES PhotoObjAll (objID) + +statement error +ALTER TABLE BestTarget2Sector ADD CONSTRAINT fk_BestTarget2Sector_objID_Photo FOREIGN KEY(objID) +REFERENCES PhotoObjAll (objID) + +statement error +ALTER TABLE BestTarget2Sector ADD CONSTRAINT fk_BestTarget2Sector_regionID_Se FOREIGN KEY(regionID) +REFERENCES Sector (regionID) + +statement error +ALTER TABLE Chunk ADD CONSTRAINT fk_Chunk_stripe_StripeDefs_strip FOREIGN KEY(stripe) +REFERENCES StripeDefs (stripe) + +statement error +ALTER TABLE DBColumns ADD CONSTRAINT fk_DBColumns_tablename_DBObjects FOREIGN KEY(tablename) +REFERENCES DBObjects (name) + +statement error +ALTER TABLE DBViewCols ADD CONSTRAINT fk_DBViewCols_viewname_DBObjects FOREIGN KEY(viewname) +REFERENCES DBObjects (name) + +statement error +ALTER TABLE DR3QuasarCatalog ADD CONSTRAINT fk_DR3QuasarCatalog_specObjID_Sp FOREIGN KEY(specObjId) +REFERENCES SpecObjAll (specObjID) + +statement error +ALTER TABLE DR5QuasarCatalog ADD CONSTRAINT fk_DR5QuasarCatalog_specObjID_Sp FOREIGN KEY(specObjId) +REFERENCES SpecObjAll (specObjID) + +statement error +ALTER TABLE ELRedShift ADD CONSTRAINT fk_ELRedshift_specObjID_SpecObjA FOREIGN KEY(specObjID) +REFERENCES SpecObjAll (specObjID) + +statement error +ALTER TABLE Field ADD CONSTRAINT fk_Field_segmentID_Segment_segme FOREIGN KEY(segmentID) +REFERENCES Segment (segmentID) + +statement error +ALTER TABLE FieldProfile ADD CONSTRAINT fk_FieldProfile_fieldID_Field_fi FOREIGN KEY(fieldID) +REFERENCES Field (fieldID) + +statement error +ALTER TABLE FileGroupMap ADD CONSTRAINT fk_FileGroupMap_tableFileGroup_P FOREIGN KEY(tableFileGroup) +REFERENCES PartitionMap (fileGroupName) + +statement error +ALTER TABLE First ADD CONSTRAINT fk_First_objID_PhotoObjAll_objID FOREIGN KEY(objID) +REFERENCES PhotoObjAll (objID) + +statement error +ALTER TABLE Frame ADD CONSTRAINT fk_Frame_fieldID_Field_fieldID FOREIGN KEY(fieldID) +REFERENCES Field (fieldID) + +statement error +ALTER TABLE HalfSpace ADD CONSTRAINT fk_HalfSpace_regionID_Region_reg FOREIGN KEY(regionid) +REFERENCES Region (regionid) + +statement error +ALTER TABLE HoleObj ADD CONSTRAINT fk_HoleObj_plateID_PlateX_plateI FOREIGN KEY(plateID) +REFERENCES PlateX (plateID) + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
