SQLITE_PREPARE_PERSISTENT(3) - NetBSD Manual Pages

Command:
Section:
Arch:
Collection:
>>>
SQLITE_PREPARE_PERSI... NetBSD Library Functions ManualSQLITE_PREPARE_PERSI...


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() inter-
     faces.

     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 looka-
             side memory.  Future versions of SQLite may act on this hint dif-
             ferently.

     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 pre-
             pared 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 vir-
             tual tables.


IMPLEMENTATION NOTES

     These declarations were extracted from the interface documentation at
     line 4137.

     #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                   January 24, 2024                   NetBSD 10.99