Documentation Source Text

Check-in [5a0203cdca]
Login

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

Overview
Comment:Caution users to have well-defined column names in VIEWs.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256:5a0203cdca057c66c90f4b331589a774cbd0c829538138eb2a509890e3249a7c
User & Date: drh 2018-11-26 18:57:57
Context
2018-11-28
10:08
Fix a typo on the quirks.html page. check-in: dd1def55d8 user: drh tags: trunk
2018-11-26
18:57
Caution users to have well-defined column names in VIEWs. check-in: 5a0203cdca user: drh tags: trunk
12:01
Merge typo fix from the 3.25 branch. check-in: 121aeee579 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/lang.in.

  1458   1458   with the [DROP VIEW] command.</p>
  1459   1459   
  1460   1460   <p>^If a <yyterm>column-name</yyterm> list follows 
  1461   1461   the <yyterm>view-name</yyterm>, then that list determines
  1462   1462   the names of the columns for the view.  ^If the <yyterm>column-name</yyterm>
  1463   1463   list is omitted, then the names of the columns in the view are derived
  1464   1464   from the names of the result-set columns in the [select-stmt].
  1465         -Note that the <yyterm>column-name</yyterm> list syntax is only
  1466         -supported in SQLite versions 3.9.0 ([dateof:3.9.0]) and later.
         1465  +The use of <yyterm>column-name</yyterm> list is recommended.  Or, if
         1466  +<yyterm>column-name</yyterm> list is omitted, then the result
         1467  +columns in the [SELECT] statement that defines the view should have
         1468  +well-defined names using the 
         1469  +"[result-column|AS column-alias]" syntax.
         1470  +SQLite allows you to create views that depend on automatically 
         1471  +generated column names, but you should avoid using them since the 
         1472  +rules used to generate column names are not a defined part of the
         1473  +interface and might change in future releases of SQLite.
         1474  +
         1475  +<p>The <yyterm>column-name</yyterm> list syntax was added in
         1476  +SQLite versions 3.9.0 ([dateof:3.9.0]).
  1467   1477   
  1468   1478   <tcl>
  1469   1479   ##############################################################################
  1470   1480   Section {CREATE VIRTUAL TABLE} {createvtab} {{CREATE VIRTUAL TABLE}}
  1471   1481   
  1472   1482   RecursiveBubbleDiagram create-virtual-table-stmt
  1473   1483   </tcl>