/ Check-in [701b8a23]
Login

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

Overview
Comment:Update the documentation to state that any parameter that is optimized out of a prepared statement becomes an anonymous parameter for which sqlite3_bind_parameter_name() returns NULL.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 701b8a23e3ea2c94454af5d9bd1e72acb66d0fe2
User & Date: drh 2011-05-31 11:56:15
Context
2011-05-31
16:50
Fix a problem in the sqlite3TestErrorName() function (used only for testing) that appears to have originated from a bad merge. check-in: a0ae314c user: drh tags: trunk
11:56
Update the documentation to state that any parameter that is optimized out of a prepared statement becomes an anonymous parameter for which sqlite3_bind_parameter_name() returns NULL. check-in: 701b8a23 user: drh tags: trunk
2011-05-30
23:42
Minor performance improvements. check-in: f9950c6a user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/sqlite.h.in.

  3064   3064   ** ^(SQL parameters of the form "?NNN" or ":AAA" or "@AAA" or "$AAA"
  3065   3065   ** have a name which is the string "?NNN" or ":AAA" or "@AAA" or "$AAA"
  3066   3066   ** respectively.
  3067   3067   ** In other words, the initial ":" or "$" or "@" or "?"
  3068   3068   ** is included as part of the name.)^
  3069   3069   ** ^Parameters of the form "?" without a following integer have no name
  3070   3070   ** and are referred to as "nameless" or "anonymous parameters".
         3071  +** ^Any parameter that is optimized out of the prepared statement by the 
         3072  +** query planner becomes a nameless or anonymous parameter.
  3071   3073   **
  3072   3074   ** ^The first host parameter has an index of 1, not 0.
  3073   3075   **
  3074   3076   ** ^If the value N is out of range or if the N-th parameter is
  3075   3077   ** nameless, then NULL is returned.  ^The returned string is
  3076   3078   ** always in UTF-8 encoding even if the named parameter was
  3077   3079   ** originally specified as UTF-16 in [sqlite3_prepare16()] or