sqlite: enable SQL math functions

cjihrig · aduh95 · commit b6c2e9136562 · 2025-02-03T20:09:54.000+01:00
This commit enables SQLite math functions. Fixes: #56435 PR-URL: #56447 Reviewed-By: Michaël Zasso <targos@protonmail.com> Reviewed-By: Luigi Pinca <luigipinca@gmail.com> Reviewed-By: James M Snell <jasnell@gmail.com>
diff --git a/deps/sqlite/sqlite.gyp b/deps/sqlite/sqlite.gyp
@@ -13,6 +13,7 @@
         'GCC_SYMBOLS_PRIVATE_EXTERN': 'YES',  # -fvisibility=hidden
       },
       'defines': [
+        'SQLITE_ENABLE_MATH_FUNCTIONS',
         'SQLITE_ENABLE_SESSION',
         'SQLITE_ENABLE_PREUPDATE_HOOK'
       ],
diff --git a/deps/sqlite/unofficial.gni b/deps/sqlite/unofficial.gni
@@ -8,6 +8,7 @@ template("sqlite_gn_build") {
   config("sqlite_config") {
     include_dirs = [ "." ]
     defines = [
+      "SQLITE_ENABLE_MATH_FUNCTIONS",
       "SQLITE_ENABLE_SESSION",
       "SQLITE_ENABLE_PREUPDATE_HOOK",
     ]
diff --git a/test/parallel/test-sqlite.js b/test/parallel/test-sqlite.js
@@ -103,3 +103,11 @@ test('PRAGMAs are supported', (t) => {
     { __proto__: null, journal_mode: 'wal' },
   );
 });
+
+test('math functions are enabled', (t) => {
+  const db = new DatabaseSync(':memory:');
+  t.assert.deepStrictEqual(
+    db.prepare('SELECT PI() AS pi').get(),
+    { __proto__: null, pi: 3.141592653589793 },
+  );
+});

Original file line number	Diff line number	Diff line change
`@@ -8,6 +8,7 @@ template("sqlite_gn_build") {`
`8`	`8`	`config("sqlite_config") {`
`9`	`9`	`include_dirs = [ "." ]`
`10`	`10`	`defines = [`
	`11`	`+ "SQLITE_ENABLE_MATH_FUNCTIONS",`
`11`	`12`	`"SQLITE_ENABLE_SESSION",`
`12`	`13`	`"SQLITE_ENABLE_PREUPDATE_HOOK",`
`13`	`14`	`]`