-
Notifications
You must be signed in to change notification settings - Fork 16
Open
Description
Hello, I've been interested in the internal structure of the pages of sqlite, so I'm using this tool interestingly.
When I try to insert a large index key such as the following, the browser doesn't seem to be able to express it. The user console also seems to have an error.
create table t1 (c1 varchar(4000));
create index it1 on t1(c1);
insert into t1 values ('aaaa.. more than 1000 characters?');
index-BiIP6wEu.js:95 Uncaught RangeError: Offset is outside the bounds of the DataView
at DataView.prototype.getUint32 (<anonymous>)
at index-BiIP6wEu.js:95:4156
at Array.map (<anonymous>)
at VA (index-BiIP6wEu.js:95:4012)
at ZA (index-BiIP6wEu.js:95:8258)
at index-BiIP6wEu.js:95:8365
at Array.map (<anonymous>)
at WA (index-BiIP6wEu.js:95:8358)
at index-BiIP6wEu.js:107:30687
at index-BiIP6wEu.js:107:30979
TMI: The reason I wanted to check out these minor cases (which the average user is unlikely to ever use) is,
When trying to manage a key that exceeds half the page (or block) size supported by db as a B+ tree,
I wanted to observe it because I think that if splits occur, the skew of trees will inevitably occur unless there is a process of distributing keys from branch nodes to sabling.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels