Updated: 2022/Sep/29

Please read Privacy Policy. It's for your privacy.


SQLITE_PREPARE_PERSISTENT(3)                          Library Functions Manual

NAME
     SQLITE_PREPARE_PERSISTENT, SQLITE_PREPARE_NORMALIZE,
     SQLITE_PREPARE_NO_VTAB - prepare flags

SYNOPSIS
     #include <sqlite3.h>

     #define SQLITE_PREPARE_PERSISTENT
     #define SQLITE_PREPARE_NORMALIZE
     #define SQLITE_PREPARE_NO_VTAB

DESCRIPTION
     These constants define various flags that can be passed into "prepFlags"
     parameter of the sqlite3_prepare_v3() and sqlite3_prepare16_v3()
     interfaces.

     New flags may be added in future releases of SQLite.

     SQLITE_PREPARE_PERSISTENT
             The SQLITE_PREPARE_PERSISTENT flag is a hint to the query planner
             that the prepared statement will be retained for a long time and
             probably reused many times.  Without this flag,
             sqlite3_prepare_v3() and sqlite3_prepare16_v3() assume that the
             prepared statement will be used just once or at most a few times
             and then destroyed using sqlite3_finalize() relatively soon.  The
             current implementation acts on this hint by avoiding the use of
             lookaside memory so as not to deplete the limited store of
             lookaside memory.  Future versions of SQLite may act on this hint
             differently.

     SQLITE_PREPARE_NORMALIZE
             The SQLITE_PREPARE_NORMALIZE flag is a no-op.  This flag used to
             be required for any prepared statement that wanted to use the
             sqlite3_normalized_sql() interface.  However, the
             sqlite3_normalized_sql() interface is now available to all
             prepared statements, regardless of whether or not they use this
             flag.

     SQLITE_PREPARE_NO_VTAB
             The SQLITE_PREPARE_NO_VTAB flag causes the SQL compiler to return
             an error (error code SQLITE_ERROR) if the statement uses any
             virtual tables.

IMPLEMENTATION NOTES
     These declarations were extracted from the interface documentation at
     line 4134.

     #define SQLITE_PREPARE_PERSISTENT              0x01
     #define SQLITE_PREPARE_NORMALIZE               0x02
     #define SQLITE_PREPARE_NO_VTAB                 0x04

SEE ALSO
     sqlite3_finalize(3), sqlite3_prepare(3), sqlite3_sql(3)

NetBSD 10.99                    August 24, 2023                   NetBSD 10.99