Home
last modified time | relevance | path

Searched refs:block (Results 1 – 25 of 128) sorted by relevance

123456

/sqlite-3.40.0/ext/fts5/test/
H A Dfts5rowid.test71 SELECT count(fts5_decode(rowid, block)) FROM x1_data;
75 UPDATE x1_data SET block = X'';
76 SELECT count(fts5_decode(rowid, block)) FROM x1_data;
86 SELECT count(fts5_decode(rowid, block)) FROM x1_data;
91 # UPDATE x1_data SET block = X'';
92 # SELECT count(fts5_decode(rowid, block)) FROM x1_data;
126 SELECT count(fts5_decode(rowid, block)) FROM x2_data;
157 SELECT count(fts5_decode(rowid, block)) FROM x3_data;
185 SELECT count(fts5_decode(rowid, block)) FROM x4_data;
202 SELECT count(fts5_decode_none(rowid, block)) FROM x5_data;
[all …]
H A Dfts5corrupt2.test48 # * unless the deleted block was a b-tree node, a query for "t1 MATCH 'x*'"
60 2 { UPDATE t1_data SET block=14 WHERE rowid=$rowid }
100 set nbyte [db one {SELECT length(block) FROM t1_data WHERE rowid=$lrowid}]
106 UPDATE t1_data SET block = substr(block, 1, $i) WHERE rowid=$lrowid;
154 set fd [db incrblob main x3_data block $rowid]
201 UPDATE x4_data SET block = substr(block, 1, length(block)-$nCut)
237 set fd [db incrblob main x5_data block $rowid]
H A Dfts5corrupt6.test28 proc editblock {block} {
29 binary format Sa* 20000 [string range $block 2 end]
42 UPDATE ft_data SET block = editblock(block) WHERE id=(
H A Dfts5determin.test26 SELECT (SELECT md5sum(id, block) FROM t1_data)==
27 (SELECT md5sum(id, block) FROM t2_data),
28 (SELECT md5sum(id, block) FROM t1_data)==
29 (SELECT md5sum(id, block) FROM t3_data)
H A Dfts5corrupt.test56 UPDATE t1_data set block = X'00000000' || substr(block, 5) WHERE
63 #db eval {SELECT rowid, fts5_decode(rowid, block) aS r FROM t1_data} {puts $r}
H A Dfts5detail.test78 #db eval {SELECT rowid, fts5_decode(rowid, block) aS r FROM t2_data} {puts $r}
235 (SELECT sum(length(block)) from t1_data) <
236 (SELECT sum(length(block)) from t2_data)
241 (SELECT sum(length(block)) from t2_data) <
242 (SELECT sum(length(block)) from t3_data)
H A Dfts5corrupt4.test48 UPDATE ttt_data SET block = mutate(block, $i) WHERE id>10;
H A Dfts5fault1.test181 SELECT count(fts5_decode(rowid, block)) FROM x1_data WHERE rowid=1
188 SELECT count(fts5_decode(rowid, block)) FROM x1_data WHERE rowid=10
195 SELECT count(fts5_decode(rowid, block)) FROM x1_data WHERE rowid = (
204 SELECT count(fts5_decode(rowid, block)) FROM x1_data WHERE rowid = (
/sqlite-3.40.0/test/
H A Dfts3defer2.test32 # This block of tests - fts3defer2-1.* - test the interaction of deferred NEAR
51 SELECT count(*) FROM t1_segments WHERE length(block)>10000;
52 UPDATE t1_segments SET block = zeroblob(length(block)) WHERE length(block)>10000;
98 3 { UPDATE t2_segments SET block = zeroblob(length(block))
99 WHERE length(block)>10000;
153 3 { UPDATE t3_segments SET block = zeroblob(length(block))
154 WHERE length(block)>10000;
H A DcorruptD.test37 # free block of space.
39 # 2. The first two bytes of all but the last free block on the free-block
40 # list (the offset to the next free block).
109 # containing the offset of the first free block in a page.
125 # in the first 2 byte of each free-block on the free-list.
H A Dfts3corrupt2.test75 db eval {SELECT rowid, length(block), block FROM t2_segments}
81 execsql { UPDATE t2_segments SET block = $b2 WHERE rowid = $rowid }
87 execsql { UPDATE t2_segments SET block = $blob WHERE rowid = $rowid }
H A Dwal5.test166 # This block of tests explores checkpoint operations on more than one
252 # Check that checkpoints block on the correct locks. And respond correctly
254 # may block on (in the following order):
256 # 1. The writer lock: FULL and RESTART checkpoints block until any writer
259 # 2. Readers using part of the log file. FULL and RESTART checkpoints block
263 # database file, RESTART checkpoints block until readers using any part
395 # Test that FULL, RESTART and TRUNCATE callbacks block on other clients
H A Dfts3defer.test64 SELECT count(*) FROM t1_segments WHERE length(block)>10000;
66 SET block = zeroblob(length(block))
67 WHERE length(block)>10000;
210 UPDATE t1_segments SET block=zeroblob(length(block)) WHERE length(block)>10000
257 SELECT count(*) FROM t1_segments WHERE length(block)>10000
368 # The following block of tests runs normally with FTS3 or FTS4 without the
H A Dorderby6.test12 # focus of this file is testing that the block-sort optimization.
37 # Run various ORDER BY queries that can benefit from block-sort.
54 # LIMIT and OFFSET clauses on block-sort queries.
85 # alignments with block-sort boundaries.
H A Dfts4growth.test66 SELECT length(block) FROM x1_segments;
100 SELECT sum(length(block)) FROM x1_segments WHERE blockid IN (224,225,226)
144 SELECT sum(length(block)) FROM x2_segdir, x2_segments WHERE
155 SELECT sum(length(block)) FROM x2_segdir, x2_segments WHERE
437 SELECT sum(length(block)) FROM x6_segments
H A Dcrash3.test41 # This block tests crash-recovery when the IOCAP_ATOMIC flags is set.
106 # This block tests both the IOCAP_SEQUENTIAL and IOCAP_SAFE_APPEND flags.
172 # The following block tests an interaction between IOCAP_ATOMIC and
H A Dfts3defer3.test49 SELECT blockid, length(block) FROM t1_segments;
65 set fd [db incrblob t1_segments block 2]
H A Dexists.test26 # This block of tests is targeted at CREATE XXX IF NOT EXISTS statements.
81 # This block of tests is targeted at DROP XXX IF EXISTS statements.
124 # This block of tests is targeted at DROP XXX IF EXISTS statements with
H A Dfts3corrupt.test49 # This block of tests checks that corruption is correctly detected if the
224 UPDATE f_segments SET block = (
225 SELECT block FROM f_segments WHERE blockid=1
H A Dspeed4.test161 # The following block tests the speed of some DML statements that cause
198 # The following block contains the same tests as the above block that
/sqlite-3.40.0/tool/
H A Ddbhash.c69 #define blk0le(i) (block[i] = (ror(block[i],8)&0xFF00FF00) \
70 |(rol(block[i],8)&0x00FF00FF))
71 #define blk0be(i) block[i]
72 #define blk(i) (block[i&15] = rol(block[(i+13)&15]^block[(i+8)&15] \
73 ^block[(i+2)&15]^block[i&15],1))
106 unsigned int block[16]; in SHA1Transform() local
107 memcpy(block, buffer, 64); in SHA1Transform()
H A Dmksourceid.c547 #define blk0le(i) (block[i] = (ror(block[i],8)&0xFF00FF00) \
548 |(rol(block[i],8)&0x00FF00FF))
549 #define blk0be(i) block[i]
550 #define blk(i) (block[i&15] = rol(block[(i+13)&15]^block[(i+8)&15] \
551 ^block[(i+2)&15]^block[i&15],1))
587 unsigned int block[16]; in SHA1Transform() local
588 memcpy(block, buffer, 64); in SHA1Transform()
/sqlite-3.40.0/ext/misc/
H A Dsha1.c46 #define blk0le(i) (block[i] = (ror(block[i],8)&0xFF00FF00) \
47 |(rol(block[i],8)&0x00FF00FF))
48 #define blk0be(i) block[i]
49 #define blk(i) (block[i&15] = rol(block[(i+13)&15]^block[(i+8)&15] \
50 ^block[(i+2)&15]^block[i&15],1))
77 unsigned int block[16]; in SHA1Transform() local
78 memcpy(block, buffer, 64); in SHA1Transform()
/sqlite-3.40.0/ext/fts3/
H A Dfts3_write.c3916 rc = fts3WriteSegment(p, pNode->iBlock, pNode->block.a, pNode->block.n); in fts3IncrmergePush()
3920 pNode->block.n = 1 + sqlite3Fts3PutVarint(&pNode->block.a[1], iPtr+1); in fts3IncrmergePush()
4037 if( pLeaf->block.n>0 && (pLeaf->block.n + nSpace)>p->nNodeSize ){ in fts3IncrmergeAppend()
4038 rc = fts3WriteSegment(p, pLeaf->iBlock, pLeaf->block.a, pLeaf->block.n); in fts3IncrmergeAppend()
4060 pLeaf->block.n = 0; in fts3IncrmergeAppend()
4069 blobGrowBuffer(&pLeaf->block, pLeaf->block.n + nSpace, &rc); in fts3IncrmergeAppend()
4154 rc = fts3WriteSegment(p, pNode->iBlock, pNode->block.a, pNode->block.n); in fts3IncrmergeRelease()
4169 pRoot->block.a, pRoot->block.n /* root */ in fts3IncrmergeRelease()
4351 rc = nodeReaderInit(&reader, pNode->block.a, pNode->block.n); in fts3IncrmergeLoad()
4705 rc = fts3WriteSegment(p, iNewStart, block.a, block.n); in fts3TruncateSegment()
[all …]
/sqlite-3.40.0/ext/fts2/
H A Dfts2.c4083 if( block ){ in interiorBlockNew()
4084 memset(block, 0, sizeof(*block)); in interiorBlockNew()
4093 return block; in interiorBlockNew()
4179 InteriorBlock *block; in interiorWriterInit() local
4254 block = block->next; in interiorWriterDestroy()
4281 if( block==pWriter->last && block->data.nData<ROOT_MAX ){ in interiorWriterRootInfo()
4291 rc = block_insert(v, block->data.pData, block->data.nData, &iBlockid); in interiorWriterRootInfo()
4297 block->term.pData, block->term.nData, in interiorWriterRootInfo()
4303 for(block=block->next; block!=NULL; block=block->next){ in interiorWriterRootInfo()
4305 rc = block_insert(v, block->data.pData, block->data.nData, &iBlockid); in interiorWriterRootInfo()
[all …]

123456