SQLite: Check-in [c8bfd99b]

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"