/ Check-in [fc6193af]

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

Comment:Add the ".expert" command to the shell tool's ".help" output.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: fc6193af5d216b4066fbc47e75a7d0538fd5fda40b94ee15e2ff4037ea89221b
User & Date: dan 2017-12-21 18:55:24
Add the ".eqp trigger" option to the ".eqp" command in the command-line shell. Implemented using the new SQLITE_DBCONFIG_TRIGGER_EQP control. (check-in: 2c51644a user: drh tags: trunk)
Add the ".expert" command to the shell tool's ".help" output. (check-in: fc6193af user: dan tags: trunk)
Change the name of SQLITE_DBCONFIG_FULL_EQP to be SQLITE_DBCONFIG_TRIGGER_EQP (which we can do without breaking compatibility because the former name has not yet appeared in an official release) and streamline its implementation. (check-in: fffc7685 user: drh tags: trunk)
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/shell.c.in.

  2775   2775     ".dbinfo ?DB?           Show status information about the database\n"
  2776   2776     ".dump ?TABLE? ...      Dump the database in an SQL text format\n"
  2777   2777     "                         If TABLE specified, only dump tables matching\n"
  2778   2778     "                         LIKE pattern TABLE.\n"
  2779   2779     ".echo on|off           Turn command echo on or off\n"
  2780   2780     ".eqp on|off|full       Enable or disable automatic EXPLAIN QUERY PLAN\n"
  2781   2781     ".exit                  Exit this program\n"
         2782  +  ".expert                EXPERIMENTAL. Suggest indexes for specified queries\n"
  2782   2783   /* Because explain mode comes on automatically now, the ".explain" mode
  2783   2784   ** is removed from the help screen.  It is still supported for legacy, however */
  2784   2785   /*".explain ?on|off|auto? Turn EXPLAIN output mode on or off or to automatic\n"*/
  2785   2786     ".fullschema ?--indent? Show schema and the content of sqlite_stat tables\n"
  2786   2787     ".headers on|off        Turn display of headers on or off\n"
  2787   2788     ".help                  Show this message\n"
  2788   2789     ".import FILE TABLE     Import data from FILE into TABLE\n"