SQLite Forum

How can I compile the newest percentile.c?
Login
The newest percentile.c:
https://sqlite.org/src/file/ext/misc
https://sqlite.org/src/artifact/b9086e223d583bda

Has the flag:
SQLITE_INNOCUOUS

When I try to compile it using the instructions here:
https://www.sqlite.org/loadext.html

`gcc -g -fPIC -dynamiclib percentile.c -o percentile.dylib`

I get the error:

```
percentile.c:217:44: error: use of undeclared identifier 'SQLITE_INNOCUOUS'
                               SQLITE_UTF8|SQLITE_INNOCUOUS, 0,
                                           ^
1 error generated.
```

That flag was introduced as part of this change:
https://sqlite.org/src/info/4c21373c21c9b17b

Can someone toll me how I can compile this dylib without getting the error above?

Thanks!