/ Check-in [c8bfd99b]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:When generating the hash on the sqlite_master table in dbselftest, use an ORDER BY clause, since the sqlite_master table is reordered by VACUUM.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: c8bfd99b96608a08f934f46b4e1a4d0f1cc69ea7
User & Date: drh 2017-02-07 21:44:40
Context
2017-02-08
12:18
Round up the size of all memory allocations to a multiple of 8 bytes when using the system memory allocator. check-in: c46e06fa user: drh tags: trunk
2017-02-07
21:44
When generating the hash on the sqlite_master table in dbselftest, use an ORDER BY clause, since the sqlite_master table is reordered by VACUUM. check-in: c8bfd99b user: drh tags: trunk
21:09
MSVC makefile enhancments for several command line tools and the session extensions. check-in: fc1dfe87 user: mistachkin tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Show Whitespace Changes Patch

Changes to test/dbselftest.c.

   564    564        "  ans TEXT                  -- expected answer\n"
   565    565        ");"
   566    566        "INSERT INTO selftest"
   567    567        " VALUES(100,'memo','Hashes generated using --init',NULL);"
   568    568     );
   569    569     if( rc ) return 1;
   570    570     tno = 110;
   571         -  zSql = "SELECT type,name,tbl_name,sql FROM sqlite_master";
          571  +  zSql = "SELECT type,name,tbl_name,sql FROM sqlite_master ORDER BY name";
   572    572     sha1Exec(db, zSql, zHash);
   573    573     rc = runSql(db, 
   574    574         "INSERT INTO selftest(tno,op,sql,ans)"
   575    575         " VALUES(%d,'sha1',%Q,%Q)", tno, zSql, zHash);
   576    576     tno += 10;
   577    577     pStmt = prepareSql(db,
   578    578       "SELECT lower(name) FROM sqlite_master"