[sqlite] Typo in docs

[Adam Levy]

The documentation for PRAGMA schema_version has a small grammar error
in the first sentence:

"The schema_version pragma will to get or set the value of the
schema-version integer at offset 40 in the database header. "

Note the "will to get or set". The "to" should be removed.

Thanks

Adam
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo - https://www.sqlite.org/see/doc/trunk/www/index.wiki

[Chris Locke]

On the page https://www.sqlite.org/see/doc/trunk/www/index.wiki in the 'key
links' section, there is a link to 'Files in the lastest release of SEE'.
This should be 'latest' and not 'lastest'.


Thanks,
Chris
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typo in FTS5 documentation

[Dan Kennedy]

On 17/2/62 02:21, J. King wrote:

 states:


the following three queries all specify the same phrase:

Four queries are then listed. Presumably it should read:


Thanks for pointing this out. Will be fixed next time the website is 
built and uploaded.


Dan.


___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo in FTS5 documentation

[J. King]

 states:

> the following three queries all specify the same phrase:

Four queries are then listed. Presumably it should read:

> the following four queries all specify the same phrase:
-- 
J. King
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo in Session extension documentation

[gwenn]

Hi,
https://sqlite.org/session/sqlite3changegroup_add_strm.html

int eConflict, /* DATA, MISSING, CONFLICT, CONSTRAINT */
should be
int eConflict, /* DATA, NOTFOUND, CONFLICT, CONSTRAINT, FOREIGN_KEY */

based on https://sqlite.org/session/c_changeset_conflict.html

Regards.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typo

[Richard Hipp]

Thanks.  Fixed at https://www.sqlite.org/docsrc/info/2ffc105f81a74dad
and on the website.

On 12/26/18, Wolfgang Enzinger  wrote:
>
> Another one in https://www.sqlite.org/security.html:
>
> "... even with presented with maliciously malformed SQL inputs or database
> files."
>
> Should be "... even when presented with ..." IMO.
>
> Wolfgang
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typo

[Wolfgang Enzinger]

Am Tue, 25 Dec 2018 08:59:45 +0100 schrieb gwenn:

> There is a typo here:
> https://sqlite.org/session/sqlite3changeset_op.html
>> If pbIncorrect is not NULL, then *pbIndirect is set to true
> Should be pbIndirect instead of pbIncorrect.

Another one in https://www.sqlite.org/security.html:

"... even with presented with maliciously malformed SQL inputs or database
files."

Should be "... even when presented with ..." IMO.

Wolfgang 

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typo

[Mike King]

Sadly by the time you get here it will be over for another year. Still
seasons greetings from the UK.

On Tue, 25 Dec 2018 at 13:45, Richard Hipp  wrote:

> On 12/25/18, Mike King  wrote:
> > It’s
> > Christmas Day so surely you deserve a mince pie and a fine single malt :)
>
> Sounds great!  Send me your address and I'll be right over!  ;-)
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typo

[Richard Hipp]

On 12/25/18, Mike King  wrote:
> It’s
> Christmas Day so surely you deserve a mince pie and a fine single malt :)

Sounds great!  Send me your address and I'll be right over!  ;-)

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typo

[Mike King]

Surely I speak for all of when I say I hope you have a fantastic Christmas
Richard and thanks for everything you do. Do you ever stop though? It’s
Christmas Day so surely you deserve a mince pie and a fine single malt :)

Cheers

On Tue, 25 Dec 2018 at 11:18, Richard Hipp  wrote:

> Thanks.  Fixed here: https://www.sqlite.org/src/info/a1f50d57ce76f6c0
>
> On 12/25/18, gwenn  wrote:
> > Hi,
> > There is a typo here:
> > https://sqlite.org/session/sqlite3changeset_op.html
> >> If pbIncorrect is not NULL, then *pbIndirect is set to true
> > Should be pbIndirect instead of pbIncorrect.
> > Regards.
> > ___
> > sqlite-users mailing list
> > sqlite-users@mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typo

[Richard Hipp]

Thanks.  Fixed here: https://www.sqlite.org/src/info/a1f50d57ce76f6c0

On 12/25/18, gwenn  wrote:
> Hi,
> There is a typo here:
> https://sqlite.org/session/sqlite3changeset_op.html
>> If pbIncorrect is not NULL, then *pbIndirect is set to true
> Should be pbIndirect instead of pbIncorrect.
> Regards.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo

[gwenn]

Hi,
There is a typo here:
https://sqlite.org/session/sqlite3changeset_op.html
> If pbIncorrect is not NULL, then *pbIndirect is set to true
Should be pbIndirect instead of pbIncorrect.
Regards.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typo in window function docs

[Dan Kennedy]

On 07/06/2018 03:59 AM, Charles Leifer wrote:

In section 2, the docs read:

The default  is:

RANGE BETWEEN UNBOUNDED PRECEDING TO CURRENT ROW

I believe it should read instead:

RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW


Thanks. Now fixed here:

  http://localhost:8080/ci/463da73728db95b3?sbs=0

Dan.

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo in window function docs

[Charles Leifer]

In section 2, the docs read:

The default  is:

RANGE BETWEEN UNBOUNDED PRECEDING TO CURRENT ROW

I believe it should read instead:

RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typo in window function docs

[Dan Kennedy]

On 07/02/2018 03:14 PM, Domingo Alvarez Duarte wrote:

Hello !

This sql example on the new window function docs is missing the 
parenthesis on the "rank" function:


Thanks for pointing this out. New version uploaded now.

Dan.





===

SELECT x, y, row_number() OVER*win1*, rank OVER*win2*  FROM t0 --< 
here the rank function is missing "()"
WINDOW*win1*  AS (ORDER BY y RANGE BETWEEN UNBOUNDED PRECEDING AND 
CURRENT ROW),

   *win2*  AS (PARTITION BY y ORDER BY x)
ORDER BY x;

===

Cheers !

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo in window function docs

[Domingo Alvarez Duarte]

Hello !

This sql example on the new window function docs is missing the 
parenthesis on the "rank" function:


===

SELECT x, y, row_number() OVER*win1*, rank OVER*win2*  FROM t0  --< here the rank 
function is missing "()"
WINDOW*win1*  AS (ORDER BY y RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW),
   *win2*  AS (PARTITION BY y ORDER BY x)
ORDER BY x;

===

Cheers !

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typo in documentation for .sha3sum CLI command

[Richard Hipp]

Thank you for the bug report.  Should now be fixed on trunk.

On 5/10/18, Aaron Zeng  wrote:
> Hi folks,
>
> The documentation
>  for
> the .sha3sum CLI command indicates that the default variety of SHA-3 used
> is SHA-256, but (at least on 3.19.3) when the command is run without
> options, I get a 56-hex digit output, indicating SHA3-224.  SHA3-256 would
> produce a 64-hex digit output.  I suppose this could be a bug in the CLI
> rather than documentation.
>
> Also, there is a minor typo in the options help for .sha3sum that is shown
> when an unrecognized option is passed:
>
>> .sha3sum -h
> Unknown option "-h" on "sha3sum"
> Should be one of: --schema --sha3-224 --sha3-255 --sha3-384 --sha3-512
>
> "sha3-255" should be "sha3-256".  The command recognizes the latter but not
> the former.
>
> Best,
> Aaron
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo in documentation for .sha3sum CLI command

[Aaron Zeng]

Hi folks,

The documentation
 for
the .sha3sum CLI command indicates that the default variety of SHA-3 used
is SHA-256, but (at least on 3.19.3) when the command is run without
options, I get a 56-hex digit output, indicating SHA3-224.  SHA3-256 would
produce a 64-hex digit output.  I suppose this could be a bug in the CLI
rather than documentation.

Also, there is a minor typo in the options help for .sha3sum that is shown
when an unrecognized option is passed:

> .sha3sum -h
Unknown option "-h" on "sha3sum"
Should be one of: --schema --sha3-224 --sha3-255 --sha3-384 --sha3-512

"sha3-255" should be "sha3-256".  The command recognizes the latter but not
the former.

Best,
Aaron
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo on https://www.sqlite.org/draft/c3ref/c_trace.html

[Olivier Mascia]

If I'm not mistaken, on https://www.sqlite.org/draft/c3ref/c_trace.html 
, the sentence "The third 
argument to sqlite3_trace_v2() is an OR-ed combination..." should read "The 
second argument...", according to 
https://www.sqlite.org/draft/c3ref/trace_v2.html 
.

:)
-- 
Best Regards, Meilleures salutations, Met vriendelijke groeten,
Olivier Mascia

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo on VFS webpage

[Luke Shumaker]

On https://www.sqlite.org/vfs.html
in the paragraph about test_quota.c, in one instance
it says "quote groups" instead of "quota groups"
 ^ ^

-- 
Happy hacking,
~ Luke Shumaker
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typo & missing link

[Richard Hipp]

Thanks.  The README has now been converted into a README.md and has
been updated with the latest project status and the typo has been
fixed.

On 10/27/17, Mark Summerfield  wrote:
> On this page:
>
> https://sqlite.org/src4/tree?ci=trunk
>
> It says:
>
> The developers do not use teh configure script.
>
> Which has a typo; should be:
>
> The developers do not use the configure script.
>
> Also, this page mentions linux and windows binaries, but provides no
> link to them. Nor can I find links on the main SQLite download page.
>
> Best wishes,
> --
> Mark Summerfield, Qtrac Ltd.
> XindeX - easy to learn and use software for creating book indexes
> http://www.qtrac.eu/xindex.html
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo & missing link

[Mark Summerfield]

On this page:

https://sqlite.org/src4/tree?ci=trunk

It says:

The developers do not use teh configure script.

Which has a typo; should be:

The developers do not use the configure script.

Also, this page mentions linux and windows binaries, but provides no
link to them. Nor can I find links on the main SQLite download page.

Best wishes,
-- 
Mark Summerfield, Qtrac Ltd.
XindeX - easy to learn and use software for creating book indexes
http://www.qtrac.eu/xindex.html
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] typo in documentation

[Richard Hipp]

Should be fixed now.  Thanks.

On 8/20/17, Dennis Cote  wrote:
> On the web page at http://sqlite.org/csv.html the following text appears:
>
>  The CVS virtual table is not built into the SQLite amalgamation.
>
> The acronym CVS should be CSV.
>
> HTH
>
> Dennis Cote
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] typo in documentation

[Dennis Cote]

On the web page at http://sqlite.org/csv.html the following text appears:

    The CVS virtual table is not built into the SQLite amalgamation.

The acronym CVS should be CSV.

HTH

Dennis Cote

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo in documentation

[J. King]

The first paragraph in Section 2 of  states in 
part:

 ... And the SQLITE_OMIT_PROGESS_CALLBACK option is only usable by 
applications...

Note the missing R in PROGRESS.
-- 
J. King
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo in the docs

[Igor Korot]

Hi,
Page https://www.sqlite.org/see/doc/trunk/www/readme.wiki

[quote]

Do decrypt a database do this:

   .rekey old-key ""
[/quote]

I think it should be "To decrypt..."

Thank you.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo in website

[Philip Newton]

http://www.sqlite.org/tempfiles.html says, in section "2.1 Rollback Journals":

"The OFF journal mode causes SQLite to the rollback journal."

There seems to be a verb missing in that sentence.

(Unless you were referencing the meme: "I switched the journal mode to
OFF and accidentally the rollback journal", or the like.)

Cheers,
Philip
-- 
Philip Newton 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] typo in vdbe.c

[li yusheng]

file vdbe.c
line 659: /* On any opcode with the "out2-prerelase" tag, free any

should be "out-prerelease"
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo in documentation for fts trigger

[AJ ONeal]

http://www.sqlite.org/fts3.html

CREATE TRIGGER t2_bu AFTER UPDATE ON t2 BEGIN
  INSERT INTO t3(docid, b, c) VALUES(new.rowid, new.b, new.c);
END;
CREATE TRIGGER t2_bd AFTER INSERT ON t2 BEGIN
  INSERT INTO t3(docid, b, c) VALUES(new.rowid, new.b, new.c);
END;



should have the _bu and _bd postfixes changed to _au and _ad.



CREATE TRIGGER t2_au AFTER UPDATE ON t2 BEGIN
  INSERT INTO t3(docid, b, c) VALUES(new.rowid, new.b, new.c);
END;
CREATE TRIGGER t2_ad AFTER INSERT ON t2 BEGIN
  INSERT INTO t3(docid, b, c) VALUES(new.rowid, new.b, new.c);
END;

AJ ONeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typo on hwaci.com website (cerod.html)

[Bernd]

Am 12.08.2012 02:32, schrieb Theodore M. Rolle, Jr. (Ted):

And "You will" is _so_ geek.  As are passive sentences.  "Will"
indicates that the object that is in the future.  It should never be
used for currently-running software, licensing, ...


.
.
.


It might be good to be consistent about whether the user will "log in"
or "login" between the first and the last of those three sentences.
(In the second sentence, it's a noun, so it can only be the one-word
variant.) Good catch.  Users can "log in" if they have a "login."

Cheers,
Philip

Is this good for a promotion in the grammar police?

Ted, ex-IBM documentation writer.


I guess, you forgot the  ...  tags.

Bernd, not a native English speaker, nonetheless understood everything 
on the afore-mentioned site (but then again, that may be why I'm not so 
picky about grammar).


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo on hwaci.com website (cerod.html)

[Philip Newton]

Hi there,

http://www.hwaci.com/sw/sqlite/cerod.html contains the sentence " This
utility program (called cerod_build.exe) reads an ordinary,
uncompressed and unencrypted SQLite database built by a public-domain
version of SQLite and constructs and equivalent compressed and
encrypted CEROD database."

The second "and" should be "an": "... and constructs _an_ equivalent ...".

It also goes on to say that "After you purchase a license to use
CEROD, we will be issued a userid and password to the on-line software
configuration management system for CEROD. "

I presume that should either be "you will be issued" or "we will issue
you"; rather than "we will be issued".

And then, "You can then log in and download the latest CEROD source
code and documentation whenever you like. Your license is perpetual,
so your login never expires. You can login as often as you like to
obtain the latest updates. "

It might be good to be consistent about whether the user will "log in"
or "login" between the first and the last of those three sentences.
(In the second sentence, it's a noun, so it can only be the one-word
variant.)

Cheers,
Philip
-- 
Philip Newton 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo in documentation

[Barbu Paul Gheorghe]

Hello!

I just found a typo in http://www.sqlite.org/fileformat.html

Search for "stored with the must significant byte first" that should read:
"stored with the most significant byte first".

A one letter typo, no big deal.

--
Barbu Paul - Gheorghe
Common sense is not so common - Voltaire
Visit My GitHub profile to see my open-source projects - 
https://github.com/paullik
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo in source code comment

[gwenn]

/*** EXPERIMENTAL ***
**
** Register a function to be invoked when a transaction comments.
** If the invoked function returns non-zero, then the commit becomes a
** rollback.
*/
SQLITE_API void *sqlite3_commit_hook(

:s/comments/commits/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] typo in sqlite.c

[marcus eber]

Hi,

I guess there is a typo at the beginning of sqlite.c

Orignal text:
...Performance improvements of 5% are more are commonly seen when SQLite is 
compiled as a single translation unit. 

Should be (are->AND)
... of 5% AND more are commonly ...


Regards,
Marcus

-- 
Neu: GMX De-Mail - Einfach wie E-Mail, sicher wie ein Brief!  
Jetzt De-Mail-Adresse reservieren: http://portal.gmx.net/de/go/demail
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] typo fixing patch for http://www.sqlite.org/version3.html

[Adrian Aichner]

Here is the little patch verbatim.

Regards,

Adrian

diff -u c:\Hacking\sqlite3\version3.html.~1~
c:\Hacking\sqlite3\version3.html
--- c:\Hacking\sqlite3\version3.html.~1~ 2010-08-08 17:54:51.12500 +0200
+++ c:\Hacking\sqlite3\version3.html 2010-08-08 17:54:51.140625000 +0200
@@ -235,8 +235,8 @@
 feature is retained in version 3.0, though in a slightly modified form.
 Each table column will store any type of data, though columns have an
 affinity for the format of data defined by their declared datatype.
-When data is inserted into a column, that column will make at attempt
-to convert the data format into the columns declared type.   All SQL
+When data is inserted into a column, that column will make an attempt
+to convert the data format into the column's declared type.   All SQL
 database engines do this.  The difference is that SQLite 3.0 will
 still store the data even if a format conversion is not possible.
 
@@ -297,9 +297,9 @@

 
 When creating new user-defined SQL functions and collating sequences,
-each function or collating sequence can specify it if works with
+each function or collating sequence can specify if it works with
 UTF-8, UTF-16be, or UTF-16le.  Separate implementations can be registered
-for each encoding.   If an SQL function or collating sequences is required
+for each encoding.   If an SQL function or collating sequence is required
 but a version for the current text encoding is not available, then
 the text is automatically converted.  As before, this conversion takes
 computation time, so programmers are advised to pick a single


On Sun, Aug 8, 2010 at 6:00 PM, Adrian Aichner <
adrian.aich...@googlemail.com> wrote:

> Greetings!
>
> I hope you'll find this little patch useful.
>
> I'm not sure whether this webpage is auto-generated.
>
> In that case the patch should still be useful to spot the typos.
>
> Thanks for this great SQL database engine!
>
> --
> Adrian Aichner
>  mailto:adrian.aich...@gmail.com
>
>


-- 
Adrian Aichner
 mailto:adrian.aich...@gmail.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] typo fixing patch for http://www.sqlite.org/version3.html

[Simon Slavin]

On 9 Aug 2010, at 12:37pm, Richard Hipp wrote:

> On Mon, Aug 9, 2010 at 7:23 AM, Simon Slavin  wrote:
> 
>> On 8 Aug 2010, at 5:00pm, Adrian Aichner wrote:
>> 
>>> I hope you'll find this little patch useful.
>> 
>> Attachments are stripped from messages to this list.  Please describe what
>> your patch does in your message, and post the URL where interested people
>> can download it.
> 
> I was looking at the mailing list setup yesterday, and if I read am reading
> the settings correctly, attachments are only stripped if their mimetype is
> not text/plain.  As an experiment, I added a short text attachment to this
> message to see if it will go through...

I received that with attachment intact.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] typo fixing patch for http://www.sqlite.org/version3.html

[Richard Hipp]

On Mon, Aug 9, 2010 at 7:23 AM, Simon Slavin  wrote:

>
> On 8 Aug 2010, at 5:00pm, Adrian Aichner wrote:
>
> > I hope you'll find this little patch useful.
>
> Attachments are stripped from messages to this list.  Please describe what
> your patch does in your message, and post the URL where interested people
> can download it.
>

I was looking at the mailing list setup yesterday, and if I read am reading
the settings correctly, attachments are only stripped if their mimetype is
not text/plain.  As an experiment, I added a short text attachment to this
message to see if it will go through


>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
This is a test to see if a text/plain attachment will make it
through on the sqlite-users mailing list.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] typo fixing patch for http://www.sqlite.org/version3.html

[Simon Slavin]

On 8 Aug 2010, at 5:00pm, Adrian Aichner wrote:

> I hope you'll find this little patch useful.

Attachments are stripped from messages to this list.  Please describe what your 
patch does in your message, and post the URL where interested people can 
download it.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] typo fixing patch for http://www.sqlite.org/version3.html

[Adrian Aichner]

Greetings!

I hope you'll find this little patch useful.

I'm not sure whether this webpage is auto-generated.

In that case the patch should still be useful to spot the typos.

Thanks for this great SQL database engine!

-- 
Adrian Aichner
 mailto:adrian.aich...@gmail.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] typo in src/os_os2.c

[Michael Knigge]

> Do you have an OS/2 compile capability?  The SQLite developers do not.  We
> would appreciate your assistance in testing SQLite on OS/2.  If you can

You don't have OS/2 or you can't get it working?

OS/2 is about $US 5 on eBay. AFAIK it runs not under VMWare but I've 
read that it runs under bochs, qemu and MS Virtual PC


Bye,
Michael
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] typo in src/os_os2.c

[Richard Hipp]

On Wed, Jul 28, 2010 at 4:46 PM, Tamas TEVESZ  wrote:

>
> hello,
>
> diff says it all:
>
> -  OSTRACE( "OPEN want %d\n", flags ));
> +  OSTRACE(( "OPEN want %d\n", flags ));
>
>


Previously found and fixed here:  http://www.sqlite.org/src/ci/a6bb2108bf

Do you have an OS/2 compile capability?  The SQLite developers do not.  We
would appreciate your assistance in testing SQLite on OS/2.  If you can
download periodic development snapshots from
http://www.sqlite.org/draft/download.html and test them on OS/2 and alert us
to any problems you find, that would be very helpful.  Thanks!


-- 
-
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] typo in src/os_os2.c

[Tamas TEVESZ]

hello,

diff says it all:

diff -urN sqlite-3.7.0.orig/src/os_os2.c sqlite-3.7.0/src/os_os2.c
--- sqlite-3.7.0.orig/src/os_os2.c  2010-07-18 21:30:41.0 
+0200
+++ sqlite-3.7.0/src/os_os2.c   2010-07-28 22:34:26.784414844 +0200
@@ -779,7 +779,7 @@
 
   memset( pFile, 0, sizeof(*pFile) );
 
-  OSTRACE( "OPEN want %d\n", flags ));
+  OSTRACE(( "OPEN want %d\n", flags ));
 
   if( flags & SQLITE_OPEN_READWRITE ){
 ulOpenMode |= OPEN_ACCESS_READWRITE;


thanks,

-- 
[-]

mkdir /nonexistent
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo in SQLite documentation

[Nicolas Kaiser]

Hi there!

I just spotted a typo in the SQLite documentation at
http://www.sqlite.org/lang_datefunc.html
"SQL As Understood By SQLite: Date And Time Functions"


In the "Examples" section,

 Compute the number of days since the signing of the US Declaration of 
Independent.

 SELECT julianday('now') - julianday('1776-07-04');

should better be

 Compute the number of days since the signing of the US Declaration of 
Independence.


Moreover, according to its Wikipedia article,
http://en.wikipedia.org/wiki/United_States_Declaration_of_Independence#Signing

 quote "Although the wording of the Declaration was approved on July 4, the 
date of its signing has been disputed. Most historians have concluded that it 
was signed nearly a month after its adoption, on August 2, 1776, and not on 
July 4 as is commonly believed."

it might be safer to say

 Compute the number of days since the ratification of the US Declaration of 
Independence.


:)

Best wishes,
Nicolas Kaiser
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typo on website

[D. Richard Hipp]

On Oct 2, 2008, at 5:05 PM, Alexey Pechnikov wrote:

> Hello!
>
> В сообщении от Thursday 02 October 2008 18:15:01 John  
> Elrick написал(а):
>> While I was reading http://sqlite.org/lang_corefunc.html, I noticed  
>> what
>> appears to be a typo:
>>
>> 'Return a copy of string /X/ will all ASCII characters converted to
>> lower case.'
>>
>> I believe this is supposed to read:
>>
>> 'Return a copy of string /X/ with all ASCII characters converted to
>> lower case.'
>
> You may create ticket
> http://www.sqlite.org/cvstrac/captcha?nxp=/cvstrac/tktnew
>
The problem has already been fixed.  See  
http://www.sqlite.org/docsrc/vinfo/31aaf2c3f5275e43bf301ace914056203f3fccd3

D. Richard Hipp
[EMAIL PROTECTED]



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typo on website

[Alexey Pechnikov]

Hello!

В сообщении от Thursday 02 October 2008 18:15:01 John Elrick написал(а):
> While I was reading http://sqlite.org/lang_corefunc.html, I noticed what
> appears to be a typo:
>
> 'Return a copy of string /X/ will all ASCII characters converted to
> lower case.'
>
> I believe this is supposed to read:
>
> 'Return a copy of string /X/ with all ASCII characters converted to
> lower case.'

You may create ticket
http://www.sqlite.org/cvstrac/captcha?nxp=/cvstrac/tktnew

Best regards, Alexey.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo on website

[John Elrick]

While I was reading http://sqlite.org/lang_corefunc.html, I noticed what 
appears to be a typo:

'Return a copy of string /X/ will all ASCII characters converted to 
lower case.'

I believe this is supposed to read:

'Return a copy of string /X/ with all ASCII characters converted to 
lower case.'



John Elrick
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users