Documentation Source Text

Check-in [21beb4719d]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Added comments for SQLITE_OMIT_UNIQUE_ENFORCEMENT.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 21beb4719d9ed02c5fd8122a5e6046ffddd623ad
User & Date: shaneh 2011-03-12 05:01:21.941
Original Comment: Added comments for SQLITE_OMIT_UNIQUE_ENFORCEMENT.

Added comments for SQLITE_OMIT_UNIQUE_ENFORCEMENT.

Context
2011-03-12
05:03
Fixed typo. (check-in: 12e0a9369a user: shaneh tags: trunk)
05:01
Added comments for SQLITE_OMIT_UNIQUE_ENFORCEMENT. (check-in: 21beb4719d user: shaneh tags: trunk)
2011-03-07
13:40
Fix typos in Appendix A of fts3.html. (check-in: b3c69199b5 user: dan tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/compile.in.
862
863
864
865
866
867
868









869
870
871
872
873
874
875
COMPILE_OPTION {SQLITE_OMIT_TRUNCATE_OPTIMIZATION} {
  A default build of SQLite, if a [DELETE] statement has no WHERE clause
  and operates on a table with no triggers, an optimization occurs that
  causes the DELETE to occur by dropping and recreating the table.  
  Dropping and recreating a table is usually much faster than deleting
  the table content row by row.  This is the "truncate optimization".
}










COMPILE_OPTION {SQLITE_OMIT_UTF16} {
  This macro is used to omit support for UTF16 text encoding. When this is
  defined all API functions that return or accept UTF16 encoded text are
  unavailable. These functions can be identified by the fact that they end
  with '16', for example [sqlite3_prepare16()], [sqlite3_column_text16()] and
  [sqlite3_bind_text16()].







>
>
>
>
>
>
>
>
>







862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
COMPILE_OPTION {SQLITE_OMIT_TRUNCATE_OPTIMIZATION} {
  A default build of SQLite, if a [DELETE] statement has no WHERE clause
  and operates on a table with no triggers, an optimization occurs that
  causes the DELETE to occur by dropping and recreating the table.  
  Dropping and recreating a table is usually much faster than deleting
  the table content row by row.  This is the "truncate optimization".
}

COMPILE_OPTION {SQLITE_OMIT_UNIQUE_ENFORCEMENT} {
  This macro is used to omit support for enforcing unique constraints.
  Constraints may still be defined, and all code and optimizations
  function as if they are enforced, however, the OP_IsUnique VDBE 
  opcode is not generated.  This may be useful for users who can 
  guarantee uniqueness of inputs, or have other means of enforcing
  the constaint.  See also [SQLITE_OMIT_CHECK], [EXPLAIN].
}

COMPILE_OPTION {SQLITE_OMIT_UTF16} {
  This macro is used to omit support for UTF16 text encoding. When this is
  defined all API functions that return or accept UTF16 encoded text are
  unavailable. These functions can be identified by the fact that they end
  with '16', for example [sqlite3_prepare16()], [sqlite3_column_text16()] and
  [sqlite3_bind_text16()].