xref: /sqlite-3.40.0/test/dbpage.test (revision 3cd8aaa7) 
1# 2017-10-11
2#
3# The author disclaims copyright to this source code.  In place of
4# a legal notice, here is a blessing:
5#
6#    May you do good and not evil.
7#    May you find forgiveness for yourself and forgive others.
8#    May you share freely, never taking more than you give.
9#
10#***********************************************************************
11# This file implements regression tests for SQLite library.  The
12# focus of this file is testing the sqlite_dbpage virtual table.
13#
14
15set testdir [file dirname $argv0]
16source $testdir/tester.tcl
17set testprefix dbpage
18
19ifcapable !vtab||!compound {
20  finish_test
21  return
22}
23
24do_test 100 {
25  execsql {
26    PRAGMA auto_vacuum=0;
27    PRAGMA page_size=4096;
28    PRAGMA journal_mode=WAL;
29  }
30  execsql {
31    CREATE TABLE t1(a,b);
32    WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<100)
33      INSERT INTO t1(a,b) SELECT x, printf('%d-x%.*c',x,x,'x') FROM c;
34    PRAGMA integrity_check;
35  }
36} {ok}
37do_execsql_test 110 {
38  SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage('main') ORDER BY pgno;
39} {1 X'53514C6974' 2 X'0500000001' 3 X'0D0000004E' 4 X'0D00000016'}
40do_execsql_test 120 {
41  SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage WHERE pgno=2;
42} {2 X'0500000001'}
43do_execsql_test 130 {
44  SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage WHERE pgno=4;
45} {4 X'0D00000016'}
46do_execsql_test 140 {
47  SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage WHERE pgno=5;
48} {}
49do_execsql_test 150 {
50  SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage WHERE pgno=0;
51} {}
52do_execsql_test 160 {
53  ATTACH ':memory:' AS aux1;
54  PRAGMA aux1.page_size=4096;
55  CREATE TABLE aux1.t2(a,b,c);
56  INSERT INTO t2 VALUES(11,12,13);
57  SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage('aux1');
58} {1 X'53514C6974' 2 X'0D00000001'}
59
60do_execsql_test 200 {
61  CREATE TEMP TABLE saved_content(x);
62  INSERT INTO saved_content(x) SELECT data FROM sqlite_dbpage WHERE pgno=4;
63  UPDATE sqlite_dbpage SET data=zeroblob(4096) WHERE pgno=4;
64} {}
65do_catchsql_test 210 {
66  PRAGMA integrity_check;
67} {1 {database disk image is malformed}}
68do_execsql_test 220 {
69  SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage('main') ORDER BY pgno;
70} {1 X'53514C6974' 2 X'0500000001' 3 X'0D0000004E' 4 X'0000000000'}
71do_execsql_test 230 {
72  UPDATE sqlite_dbpage SET data=(SELECT x FROM saved_content) WHERE pgno=4;
73} {}
74do_catchsql_test 230 {
75  PRAGMA integrity_check;
76} {0 ok}
77do_execsql_test 240 {
78  DELETE FROM saved_content;
79  INSERT INTO saved_content(x)
80     SELECT data FROM sqlite_dbpage WHERE schema='aux1' AND pgno=2;
81} {}
82do_execsql_test 241 {
83  UPDATE sqlite_dbpage SET data=zeroblob(4096) WHERE pgno=2 AND schema='aux1';
84} {}
85do_catchsql_test 250 {
86  PRAGMA aux1.integrity_check;
87} {1 {database disk image is malformed}}
88do_execsql_test 260 {
89  UPDATE sqlite_dbpage SET data=(SELECT x FROM saved_content)
90   WHERE pgno=2 AND schema='aux1';
91} {}
92do_catchsql_test 270 {
93  PRAGMA aux1.integrity_check;
94} {0 ok}
95
96finish_test
97