Re: [sqlite] Improper error message

On 2/20/18, Etienne Sanchez wrote: > > As for "left", it's maybe due to the ambiguity with "left join", but then > what about "right"? (There is no ambiguity with "right join" since it is > not supported.) "left" and "right" are keywords in SQL. SQLite understands the

[sqlite] Improper error message

Hi, Some other DBMS such as Postgres and SQL-Server implement the functions "left" and "right". SQLite does not. But why do I get confusing error messages when I (mistakenly) attempt to use them? To illustrate my point: select foo('abc', 2) Error: no such function: foo select left('abc', 2)

Re: [sqlite] Improper error message

Hello, On 2018-02-20 23:59, Etienne Sanchez wrote: Some other DBMS such as Postgres and SQL-Server implement the functions "left" and "right". SQLite does not. But why do I get confusing error messages when I (mistakenly) attempt to use them? To illustrate my point: select foo('abc', 2)

Re: [sqlite] Clarification on Storage

Thanks all. I'll consider this thread done. With Ryan and Bills comments, I've decided that I'll truck on as is, and not worry about special string considerations. Thinking about how Delphi Berlin is handling strings at the compiler level, and how the wrapper I use is handling the strings based

Re: [sqlite] Strange behavior with wal_checkpoint PRAGMA

On Wed, 2018-02-14 at 08:13 -0600, Joshua Watt wrote: > Hello, > > I observed the following behavior when using the wal_checkpoint > PRAGMA > in TRUNCATE mode: > > SQLite version 3.22.0 2018-01-22 18:45:57 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

On Mon, Feb 19, 2018 at 7:49 PM, petern wrote: > There are other uses for padding strings besides user reports. Consider > scalar representations of computations for example. Also: > > 1.There was no mention of user display formatting in Ralf's original > report.

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

There are other uses for padding strings besides user reports. Consider scalar representations of computations for example. Also: 1.There was no mention of user display formatting in Ralf's original report. It was a bug report about missing inverse functionality for padding/trimming strings.

Re: [sqlite] Clarification on Storage

On 20 Feb 2018, at 4:21pm, Stephen Chrzanowski wrote: > What I'm not entirely sure of is whether SQLite Expert is understanding and > handling the BLOB_TEXT field and just not doing the actual query to get the > text, or, if it understand if there is some kind of special

Re: [sqlite] Clarification on Storage

I'm absolutely clear that the SQLite3 developers have absolutely NOTHING to do with SQLite Expert. I apologize if there was any indication that I was thinking that I was asking for the devs of SQLite3 would have a direct answer to how that 3rd party tool works. My hope was that someone who uses

Re: [sqlite] Clarification on Storage

One thing that it is important to be clear on is that SQLite Expert is a 3rd-party product that is not supported nor even understood by the official SQLite developers. SQLite Expert, if I am not mistaken, does try to do some magic under the hood to make SQLite function more like how the

[sqlite] Clarification on Storage

I'm fully aware that any kind of data can be stored in any kind of field. Strings can be in integer declared fields, etc. What I'm interested in finding out, without changing my code at this time, is if SQLITE3.EXE is handling things differently than what SQLite Expert is. In "SQLite Expert", if

Re: [sqlite] Clarification on Storage

That was NOT supposed to happen. :P CREATE TABLE [Test]( [ID] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [T1] TEXT, [T2] BLOB_TEXT); insert into Test (T1,T2) values ('Test 1','Test 2'); In SQLite Expert, it hides "Test 2" as a (blob). I'm fine with that. In SQLITE3.exe, it shows

Re: [sqlite] Clarification on Storage

Well, according to the standard that field should have a text affinity. http://www.sqlite.org/datatype3.html#determination_of_column_affinity And using single quotes makes what you're giving it text values rather than blobs http://www.sqlite.org/lang_expr.html "A string constant is formed by

Re: [sqlite] Clarification on Storage

At 17:35 20/02/2018, you wrote: SQLite Expert, if I am not mistaken, does try to do some magic under the hood to make SQLite function more like how the SQLite-Expert authors think it should function, rather than how it actually functions. So your theory of the difference in output being due to

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

> On Feb 19, 2018, at 7:49 PM, petern wrote: > > 3. Why can't SQLite have the expected common static SQL functions for > getting rapid development done without external tools? Because its primary use case is as an embedded library for programs, not as a

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

On Tue, Feb 20, 2018 at 11:44 AM, Jens Alfke wrote: > > > > On Feb 19, 2018, at 7:49 PM, petern wrote: > > > > 3. Why can't SQLite have the expected common static SQL functions for > > getting rapid development done without external tools? > >

Re: [sqlite] Clarification on Storage

On 2018/02/20 6:35 PM, Richard Hipp wrote: All that said, I'm not exactly sure what you are asking. I had some trouble with that too, but I think his question boils down to: Considering that SQLiteExpert is doing seemingly funny things under the hood on top of SQLite, would those be safe

Re: [sqlite] Strange behavior with wal_checkpoint PRAGMA

On 02/14/2018 09:13 PM, Joshua Watt wrote: Hello, I observed the following behavior when using the wal_checkpoint PRAGMA in TRUNCATE mode: SQLite version 3.22.0 2018-01-22 18:45:57 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on

Re: [sqlite] Clarification on Storage

> What I'm interested in finding out, without changing my code at this time, is > if > SQLITE3.EXE is handling things differently than what SQLite Expert is. It absolutely is. I am a heavy user of SQLite Expert and was stumped by weird problems in my databases until I realized the SQLite Expert