On 1 Apr 2017, at 5:04am, J Decker wrote:
> Sqlite3 Err: (283) recovered 6942 frames from WAL file
> C:\eQube-Tools\flashboard\server\option.db-wal
>
> pretty much every time I restart the program now (espcially if it
> segfaults).
> There are no frames to recover... really... I mean it should
I get this ... from sqlite error log callback
Sqlite3 Err: (283) recovered 6942 frames from WAL file
C:\eQube-Tools\flashboard\server\option.db-wal
pretty much every time I restart the program now (espcially if it
segfaults).
There are no frames to recover... really... I mean it should have recov
Hi,
since commit 68f6dc7af1013f29, newlines in the .dump output are escaped
with char(). This can make the resulting SQL too complex:
$ sqlite3 test.db "create table t(x); insert into t
values(replace(printf('%1000s', ''), ' ', char(10)));"
$ sqlite3 test.db .dump | sqlite3
Error: near line 4:
On Fri, 31 Mar 2017, Richard Hipp wrote:
I don't understand it either. I was told that some systems required
it so I put it in. It did not break on any of the systems that we
test on, so I assumed that it was a good patch.
Unfortunately, the requirement for it depends on how libedit was
com
I don't understand it either. I was told that some systems required
it so I put it in. It did not break on any of the systems that we
test on, so I assumed that it was a good patch.
On 3/31/17, Lonnie Abelbeck wrote:
> Hi,
>
> This commit: [bf28a55d]
> http://www.sqlite.org/src/fdiff?v1=cacf261
Hi,
This commit: [bf28a55d]
http://www.sqlite.org/src/fdiff?v1=cacf2616abf6e4a5&v2=2893b823ecc86cea&sbs=0
Keeps libedit from be found and used.
Using SQLite 3.18.0: --enable-editline --disable-readline
--
checking editline/readline.h usability... yes
checking editline/readline.h presence... yes
Some examples of these would be great, Dr. Hipp. Thanks.
On 2017-03-31 09:06, Richard Hipp wrote:
> On 3/31/17, aotto wrote:
>
>> I already have a working implementation with [a] close [to] empty
>> *xBestIndex and *xFilter.
>>
>> 6) I expect for a primitive WHERE clause like "rep=XXX" some
On 3/31/17, aotto wrote:
> I already have a working implementation with [a] close [to] empty
> *xBestIndex and *xFilter.
>
> 6) I expect for a primitive WHERE clause like "rep=XXX" some kind of access
>optimization…
Your xBestIndex and xFilter functions must implement the desired optimization
Hi…
I'm new to this mailing-list because I have a problem to define a
"VIRTUAL TABLE"
sqlite3 extension. I already have a working implementation with close empty
*xBestIndex and *xFilter.
1) My data is already in a sorted list with ONE or MORE primary index
columns
2) Currently the VTAB is al
On 2017/03/31 12:08 PM, 邱朗 wrote:
Say my mobile app has a customer table, a product table, and an order table to
record who buys what, the order table basically has 2 foreign keys, customer_id
& product_id.
Now I got the order information first, within in it I can't find the customer informat
I’m trying to execute an FTS5 query using the C API, and need to restrict
the query to a specific column. In FTS4, this was possible by doing:
SELECT foo, bar FROM tableName WHERE columnName MATCH ?
and then binding the search string to the statement. However, with FTS5,
the LHS of the MATCH oper
Say my mobile app has a customer table, a product table, and an order table to
record who buys what, the order table basically has 2 foreign keys, customer_id
& product_id.
Now I got the order information first, within in it I can't find the customer
information in my local sqlite table. As it
12 matches
Mail list logo
