> Using the sqlite3 shell tool please give the command > SELECT * FROM sqlite_master;
the results are identical table|_meta|_meta|2|CREATE TABLE "_meta"( "TABLENAME" TEXT NOT NULL , "COLNAME" TEXT NOT NULL , "VARNAMES" TEXT , "LABELS" TEXT , "PREFS" TEXT , PRIMARY KEY(TABLENAME,COLNAME)) index|sqlite_autoindex__meta_1|_meta|3| table|pk_model|pk_model|39020|CREATE TABLE "pk_model"( "MODEL" TEXT , PRIMARY KEY(MODEL)) index|sqlite_autoindex_pk_model_1|pk_model|39021| table|tumor_data|tumor_data|39027|CREATE TABLE "tumor_data"( "CRO" TEXT , "MODEL" TEXT , "SUBTYPE" TEXT , "QB_SUBTYPE" TEXT , "SUBTYPE_DEFINED_FOR_QUARTZBIO_INTERNAL_HISTO_SUBTYPING_CRO_SUBTYPING_ CONSIDERED_IN_CASE_IT_IS_MORE_SUBTYPE_SPECIFIC" TEXT , "TREATMENT_ARM_NO" INTEGER , "TREATMENT" TEXT , "DAY" TEXT , "MEASURE" TEXT , "LBSTRESC" TEXT , FOREIGN KEY(MODEL) REFERENCES pk_model(MODEL) ON UPDATE NO ACTION ON DELETE NO ACTION) table|sequencing_metadata|sequencing_metadata|7|CREATE TABLE "sequencing_metadata"( "ANALYSIS_ANALYSIS_NAME" TEXT , "ANALYSIS_DATASET_NAME" TEXT , "ANALYSIS_PROJECT_NAME" TEXT , "METADATA_NAME" TEXT , "METADATA_NUM" TEXT , "METADATA_STR" TEXT , "SAMPLE_BATCH" TEXT , "SAMPLE_NAME" TEXT , "MODEL" TEXT , FOREIGN KEY(MODEL) REFERENCES pk_model(MODEL) ON UPDATE NO ACTION ON DELETE NO ACTION) table|excluded_mice|excluded_mice|1319|CREATE TABLE "excluded_mice"( "MODEL" TEXT , "TREATMENT" TEXT , "COMMENT" TEXT , "X" TEXT , FOREIGN KEY(MODEL) REFERENCES pk_model(MODEL) ON UPDATE NO ACTION ON DELETE NO ACTION) table|excluded_visits|excluded_visits|1320|CREATE TABLE "excluded_visits"( "MODEL" TEXT , "TREATMENT" TEXT , "VISIT" TEXT , "COMMENT" TEXT , FOREIGN KEY(MODEL) REFERENCES pk_model(MODEL) ON UPDATE NO ACTION ON DELETE NO ACTION) table|tumor_lungsubtypes|tumor_lungsubtypes|1321|CREATE TABLE "tumor_lungsubtypes"( "MODEL" TEXT , "SUBTYPE_COMBINED" TEXT , FOREIGN KEY(MODEL) REFERENCES pk_model(MODEL) ON UPDATE NO ACTION ON DELETE NO ACTION) Here's a screenshot of some of the diffs using vbindiff https://ibb.co/kNm0X6 On Tue, Dec 19, 2017 at 1:48 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > > On 19 Dec 2017, at 12:43pm, Karl Forner <karl.for...@gmail.com> wrote: > > > All the software in the docker container. so it is exactly the same > version > > of all software and libraries, except the linux kernel. Moreover the > > differences are not in the header, rather interspersed with what looks > like > > CREATE statements. > > Using the sqlite3 shell tool please give the command > > SELECT * FROM sqlite_master; > > on one copy of the database. Are the CREATE commands in the result the > same as the CREATE command you just told us about ? > > Issue the same SELECT command for the other copy of the database. Do you > get identical output, in the same order, as you got from the first copy of > the database ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
