[sqlite] Is it possible that dropping a big table takes very long

[Cecil Westerhof]

2016-04-20 22:21 GMT+02:00 Scott Robison <scott at casaderobison.com>:

> On Wed, Apr 20, 2016 at 2:00 PM, Cecil Westerhof <cldwesterhof at gmail.com>
> wrote:
>
> > How stupid that I did not think about Google Drive. :'-( Here it is:
> >     https://drive.google.com/file/d/0BzW5q7uL-6z0SDdya2REaFNFUVE
> >
> > ?I am very curious.
> >
>
> I downloaded this and opened it with sqlite3.exe shell version 3.11.0.
>
> D:\>\bin\sqlite3.exe checkUUID.sqlite
> SQLite version 3.11.0 2016-02-15 17:29:24
> Enter ".help" for usage hints.
> sqlite> .schema
> sqlite>
>
> It's a big enough file, but there is no schema present.
>

?That is strange, because I get:
sqlite3 checkUUID.sqlite
SQLite version 3.8.7.1 2014-10-29 13:59:56
Enter ".help" for usage hints.
sqlite> .schema
CREATE TABLE testUniqueUUID (
    UUID    blob,

    PRIMARY KEY(UUID)
    CHECK(TYPEOF(UUID) = 'blob'           AND
          LENGTH(UUID) = 16               AND
          SUBSTR(HEX(UUID), 13, 1) == '4' AND
          SUBSTR(HEX(UUID), 17, 1) IN ('8', '9', 'A', 'B')
    )
);
?

?I am going to investigate.?