Re: [sqlite] BLOB and TEXT comparisons

What's going on is that a Blob and a Text are logically different values and so can never possibly equal each other. Also they aren't represented by the same bytes either, because every value includes its type and the comparison is comparing the bytes indicating the type as well, which

Re: [sqlite] Bug in all-bnf.html documentation?

Fantastic, thank you! > On Jul 13, 2019, at 1:48 PM, Richard Hipp wrote: > > On 7/13/19, George King wrote: >> Is there any written description of the Sqlite grammar or is it >> now only described by the images? If nothing else, I'd be interested to peek >> at any sort of grammar

Re: [sqlite] Bug in all-bnf.html documentation?

On 7/13/19, George King wrote: > Is there any written description of the Sqlite grammar or is it > now only described by the images? If nothing else, I'd be interested to peek > at any sort of grammar representation in the source code. The images are the definitive description of the language.

Re: [sqlite] Bug in all-bnf.html documentation?

Thank you. Is there any written description of the Sqlite grammar or is it now only described by the images? If nothing else, I'd be interested to peek at any sort of grammar representation in the source code. > On Jul 13, 2019, at 12:28 PM, Richard Hipp wrote: > > On 7/13/19, George King

Re: [sqlite] Bug in all-bnf.html documentation?

On 7/13/19, George King wrote: > I found > the all-bnf.html page after a quick google search. That file is obsolete cruft in the Fossil repository that hosts the SQLite documentation. The BNF representation has not been supported for years. Shane added that support for us almost 10 years ago,

[sqlite] Bug in all-bnf.html documentation?

Hello, I'm writing to report an apparent error in the Sqlite documentation. I found the all-bnf.html page after a quick google search. https://www.sqlite.org/docsrc/doc/trunk/art/syntax/all-bnf.html It appears that the page is

[sqlite] Unreachable Breaks with ICC on Windows

Hello, ICC reports two unreachable "break;" statements as warnings: SQLite 3.29 Windows 2019 Visual Studio 16.2.0 Preview 3.0 Intel Parallel Studio XE 2019 Update 4 1>-- Rebuild All started: Project: SQLite, Configuration: Release x64 -- 1>sqlite3.c 1>D:\Dropbox\Chaos\SQLite

Re: [sqlite] "unable to use function highlight in the requested context" in group by

Thank you, that works! I still think highlight() not working in this case may be a bug, though, since it only operates on a single row and in theory shouldn't be affected by the group by (but there may be limitations not obvious to me). Thanks again, Adrian