SQLite Forum

balance_quick() add a new leaf page which contain only 1 cell
Login

balance_quick() add a new leaf page which contain only 1 cell

(1) By sqlite3_preupdate_count (XiongZaiBingGan) on 2021-05-07 11:33:45 [source]

I found when insert a new record,if it cause overflow, insert operation invokes balance_quick(),in balance_quick(),it create a new leaf page,contain the overflow cell,make it to the right most leaf page of tree.

The right most leaf page only contain 1 cell(overflow cell),does sqlite still treat it as a b+tree page ? in my idea, m-way b-tree cell count is in (m/2-1,m-1)。

I find database file header only has 'Min leaf payload fraction' but no 'Max leaf payload fraction'.