Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Back out the SQLITE_OMIT_UNIQUE_ENFORCEMENT compile-time option. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | 4e49b51557dc725eb196647cf8050b211131fb2e |
| User & Date: | drh 2011-04-09 03:04:48 |
Context
|
2011-04-11
| ||
| 23:23 | Add a news entry for the release. Update the homepage. check-in: 9f0051f622 user: drh tags: trunk | |
|
2011-04-09
| ||
| 03:04 | Back out the SQLITE_OMIT_UNIQUE_ENFORCEMENT compile-time option. check-in: 4e49b51557 user: drh tags: trunk | |
|
2011-04-07
| ||
| 18:17 | Fix a typo in SQLITE_OMIT_UNIQUE_ENFORCEMENT. check-in: 8870b75865 user: drh tags: trunk | |
Changes
Changes to pages/compile.in.
863 864 865 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 |
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. Unique 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 constraint. 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()]. } |
< < < < < < < < < |
863 864 865 866 867 868 869 870 871 872 873 874 875 876 |
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()].
}
|