Documentation Source Text: Check-in [39b1d19256]

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 \| SQL archive
Timelines:	family \| ancestors \| descendants \| both \| trunk
Files:	files \| file ages \| folders
SHA1:	39b1d192560963b2d1d746589e08d89ceb216007
User & Date:	drh 2012-03-06 13:11:18

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

Hide Diffs Unified Diffs Ignore Whitespace Patch

Added images/foreignlogos/bentley.jpg.

cannot compute difference between binary files

Changes to pages/fts3.in.

<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).

<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.

    <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>








>
>
>
>
>
>
>
|

|

    <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>