and the dumps usign the .dump sqlite3.exe command are also identical. On Tue, Dec 19, 2017 at 2:19 PM, Karl Forner <karl.for...@gmail.com> wrote:
> > 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
