Documentation Source Text

Check-in [39b1d19256]
Login

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

Overview
Comment:Tweaks to the FTS4 documentation. Add Bentley to the sponsor list on the front page.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 39b1d192560963b2d1d746589e08d89ceb216007
User & Date: drh 2012-03-06 13:11:18.999
Context
2012-03-06
13:24
Reduce the size of the Bentley logo from 600KB to about 8KB. (check-in: 36e8f98b78 user: drh tags: trunk)
13:11
Tweaks to the FTS4 documentation. Add Bentley to the sponsor list on the front page. (check-in: 39b1d19256 user: drh tags: trunk)
2012-03-05
19:40
Fix typos in the FTS4 languageid option documentation. Add entries to the 3.7.11 change log. (check-in: eb26f05574 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Added images/foreignlogos/bentley.jpg.

cannot compute difference between binary files

Changes to pages/fts3.in.
︙︙
1685
1686
1687
1688
1689
1690
1691
1692
1693
1694
1695
1696
1697
1698
1699

<codeblock>
  SELECT * FROM t1 WHERE t1 MATCH 'abc' AND lid=5;
</codeblock>

<p>
  It is not possible for a single FTS query to return rows with
  different languageid values. The results of adding WHERE clauses
  that use other operators (e.g.  lid!=5, or lid<=5) are undefined.

<p>
  If the content option is used along with the languageid option,
  then the named languageid column must exist in the content= table
  (subject to the usual rules - if a query never needs to read the
  content table then this restriction does not apply).









|








1685
1686
1687
1688
1689
1690
1691
1692
1693
1694
1695
1696
1697
1698
1699

<codeblock>
  SELECT * FROM t1 WHERE t1 MATCH 'abc' AND lid=5;
</codeblock>

<p>
  It is not possible for a single FTS query to return rows with
  different languageid values. The results of adding WHERE clauses
  that use other operators (e.g.  lid!=5, or lid&lt;=5) are undefined.

<p>
  If the content option is used along with the languageid option,
  then the named languageid column must exist in the content= table
  (subject to the usual rules - if a query never needs to read the
  content table then this restriction does not apply).
︙︙
Changes to pages/index.in.
︙︙
61
62
63
64
65
66
67







68
69
70
71
72
73
74
75
76
77

    <a href="http://www.nokia.com/">\
    <img src="images/foreignlogos/nokia.gif" alt="nokia.com" border="0">\
    </a></td><td>\
    <a href="http://www.nokia.com/">Nokia</a> is the world leader in mobility,\
    driving the transformation and growth of the converging internet and\
    communications industries.</td></tr>'








  count = 5
  while( count>0 ){
    i = Math.floor(Math.random()*5)
    if( sponsor[i]!=null ){
      document.write(sponsor[i])
      sponsor[i] = null
      count--
    }
  }
</script>








>
>
>
>
>
>
>
|

|








61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84

    <a href="http://www.nokia.com/">\
    <img src="images/foreignlogos/nokia.gif" alt="nokia.com" border="0">\
    </a></td><td>\
    <a href="http://www.nokia.com/">Nokia</a> is the world leader in mobility,\
    driving the transformation and growth of the converging internet and\
    communications industries.</td></tr>'

  sponsor[5] = '<tr><td align="center">\
    <a href="http://www.bentley.com/">\
    <img src="images/foreignlogos/bentley.jpg" alt="bentley.com" border="0">\
    </a></td><td>\
    <a href="http://www.bentley.com/">Bentley</a> - Comprehensive software \
    solutions for Sustaining Infrastructure.</td></tr>'

  count = 6
  while( count>0 ){
    i = Math.floor(Math.random()*6)
    if( sponsor[i]!=null ){
      document.write(sponsor[i])
      sponsor[i] = null
      count--
    }
  }
</script>
︙︙