GeezerVison is showing github.com — sqlite: enable Percentile extension · nodejs/node@637bda0
File treeExpand file treeCollapse file tree Open diff view settings Expand file treeCollapse file tree Open diff view settings Collapse file Copy file name to clipboardExpand all lines: deps/sqlite/sqlite.gyp +1Lines changed: 1 addition & 0 deletions | Original file line number | Diff line number | Diff line change |
|---|
| 21 | 21 | 'SQLITE_ENABLE_FTS5', | 22 | 22 | 'SQLITE_ENABLE_GEOPOLY', | 23 | 23 | 'SQLITE_ENABLE_MATH_FUNCTIONS', | | 24 | + 'SQLITE_ENABLE_PERCENTILE', | 24 | 25 | 'SQLITE_ENABLE_PREUPDATE_HOOK', | 25 | 26 | 'SQLITE_ENABLE_RBU', | 26 | 27 | 'SQLITE_ENABLE_RTREE', | |
Collapse file Copy file name to clipboardExpand all lines: deps/sqlite/unofficial.gni +1Lines changed: 1 addition & 0 deletions | Original file line number | Diff line number | Diff line change |
|---|
@@ -15,6 +15,7 @@ template("sqlite_gn_build") { | 15 | 15 | "SQLITE_ENABLE_FTS5", | 16 | 16 | "SQLITE_ENABLE_GEOPOLY", | 17 | 17 | "SQLITE_ENABLE_MATH_FUNCTIONS", | | 18 | + "SQLITE_ENABLE_PERCENTILE", | 18 | 19 | "SQLITE_ENABLE_PREUPDATE_HOOK", | 19 | 20 | "SQLITE_ENABLE_RBU", | 20 | 21 | "SQLITE_ENABLE_RTREE", | |
Collapse file Copy file name to clipboardExpand all lines: test/parallel/test-sqlite.js +14-1Lines changed: 14 additions & 1 deletion | Original file line number | Diff line number | Diff line change |
|---|
@@ -204,6 +204,19 @@ suite('SQL APIs enabled at build time', () => { | 204 | 204 | ); | 205 | 205 | }); | 206 | 206 |
| | 207 | + test('percentile is enabled', (t) => { | | 208 | + const db = new DatabaseSync(':memory:'); | | 209 | + db.exec(` | | 210 | + CREATE TABLE t1 (x INTEGER); | | 211 | + INSERT INTO t1 (x) VALUES (1), (2), (3), (4), (5); | | 212 | + `); | | 213 | + | | 214 | + t.assert.deepStrictEqual( | | 215 | + db.prepare('SELECT percentile(x, 50) AS p50 FROM t1;').get(), | | 216 | + { __proto__: null, p50: 3 }, | | 217 | + ); | | 218 | + }); | | 219 | + | 207 | 220 | test('dbstat is enabled', (t) => { | 208 | 221 | const db = new DatabaseSync(nextDb()); | 209 | 222 | t.after(() => { db.close(); }); | @@ -244,7 +257,7 @@ suite('SQL APIs enabled at build time', () => { | 244 | 257 | ); | 245 | 258 | }); | 246 | 259 |
| 247 | | - test('fts3 parenthesis', (t) => { | | 260 | + test('fts3 parenthesis is enabled', (t) => { | 248 | 261 | const db = new DatabaseSync(':memory:'); | 249 | 262 | db.exec(` | 250 | 263 | CREATE VIRTUAL TABLE t1 USING fts3(content TEXT); | |
|