On 4 Jan 2020, at 7:23am, Mike King wrote:
> This is the subject:
>
> Hex Password with System.Data.Sqlite (.Net Core)
I suppose the bot thought you wanted to change your password for accessing the
mailing list.
___
sqlite-users mailing list
Hi,
We found a crash bug in sqlite. Here’s the POC:
—
CREATE VIRTUAL TABLE v0 USING rtree ( v3 AS( '1994-01-01' ) CHECK( v3 ) CHECK(
v3 NOT LIKE 'y' ) GENERATED ALWAYS AS( ( SELECT 10.10 * AVG ( v3 ) FROM v0
WHERE v1 = v3 ) ) , v2 , v1 ) ;
SELECT count ( * ) , max ( v3 ) FROM v0 ;
CREATE
Hi,
We found an assertion failed in sqlite. Here’s the POC:
—
CREATE TABLE v0 ( v2 INTEGER PRIMARY KEY UNIQUE ON CONFLICT FAIL , v1 DOUBLE
CHECK( ( v2 > 10 AND v1 >= 10 AND v2 <= 10 + 10 AND v1 BETWEEN 0 AND 10 AND v2
IN ( '' , 'AIR REG' ) AND v2 NOT IN ( 0 , NULL , 10 ) AND v2 >= 10 ) + CASE
This is the subject:
Hex Password with System.Data.Sqlite (.Net Core)
Very to the point I’d say :)
Cheers
On Fri, 3 Jan 2020 at 23:10, Warren Young wrote:
> On Jan 2, 2020, at 3:47 PM, Mike King wrote:
> >
> > ...suspected administrivia! (not sure what that is -
> > I guess it's a US
> On Jan 2, 2020, at 11:54 AM, Doug wrote:
>
> I know there has been a lot of talk about what can and cannot be done with
> the C calling interface because of compatibility issues and the myriad set of
> wrappers on various forms. I’m having a hard time letting go of a possible
> 25%
haha, that is a mangled way of saying I wrapped my db functions in a dll
for multiple app use. I did not expose this config setting as I never knew
its impact. To be honest, I still don't. ;)
On Fri, Jan 3, 2020 at 5:18 PM Tim Streater wrote:
> On 03 Jan 2020, at 22:08, sky5walk wrote:
>
> >
On Jan 2, 2020, at 3:47 PM, Mike King wrote:
>
> ...suspected administrivia! (not sure what that is -
> I guess it's a US English word but it's certainly not an English one).
It’s not defined in any of the mainstream dictionaries I have on my phone —
three of them, because I’m a word nerd —
On 03 Jan 2020, at 22:08, sky5walk wrote:
> Querying the config state is helpful for a dll wrapped database, ...
What's one of them?
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
Well, I told you I'm getting SQLITE_MISUSE so that kinda answers your side
question?
I am only interested in this topic for the performance gain so quoted.
I need to create a personal test case(my use model) to verify these
statements.
Querying the config state is helpful for a dll wrapped
Mike _ wrote:
> The trigger documentation says: "An ON CONFLICT clause may be specified as
> part of an UPDATE or INSERT action within the body of the trigger. However
> if an ON CONFLICT clause is specified as part of the statement causing the
> trigger to fire, then conflict handling policy of
Hello mailing list, happy new year! I was wondering if anyone can help
explain why this is an error:
---
sqlite> pragma foreign_keys = on;
sqlite> drop table if exists child;
sqlite> drop table if exists parent;
sqlite> drop table if exists changelog;
sqlite> create table parent (
...>
On 1/3/20, sky5w...@gmail.com wrote:
> Is there a query function for these and other config settings?
> I see no sqlite3_config_get() in sqlite3.h.
There is no query function for the SQLITE_CONFIG_MEMSTATUS setting.
--
D. Richard Hipp
d...@sqlite.org
On Friday, 3 January, 2020 11:32, sky5w...@gmail.com wrote:
> Is there a query function for these and other config settings?
> I see no sqlite3_config_get() in sqlite3.h.
No. There are config options to get specific config data where that might be
useful.
Otherwise, you simply set the
Is there a query function for these and other config settings?
I see no sqlite3_config_get() in sqlite3.h.
On Fri, Jan 3, 2020 at 11:36 AM Keith Medcalf wrote:
> On Friday, 3 January, 2020 09:30, sky5w...@gmail.com wrote:
>
> >I get SQLITE_MISUSE when attempting
>
I'm currently updating a C# .NET application that uses SQLite 3.6.16 to
run under a new Siemens Sinumerik version and I'd also like to update it
to use the latest SQLite, which is 3.30.1.
Does anyone know of any potential issues I might encounter and how to
correct them please? I've tried a
> Indeed turning off memstatus leads to a 500% (from ~3s to ~0.5s)
performance increase.
> Changing the threading mode or the indirection level of the mutexes calls
seems to have no significant effect.
That is quite significant.
Looking at the code, it seems the mutex requirement is mostly for
On Friday, 3 January, 2020 09:30, sky5w...@gmail.com wrote:
>I get SQLITE_MISUSE when attempting
>sqlite3_config(SQLITE_CONFIG_MEMSTATUS, 0);
>immediately after opening a db connection?
>My connection has THREADSAFE = 1.
That is correct. You must configure the library before it is initialized,
I get SQLITE_MISUSE when attempting
sqlite3_config(SQLITE_CONFIG_MEMSTATUS, 0);
immediately after opening a db connection?
My connection has THREADSAFE = 1.
On Thu, Jan 2, 2020 at 7:32 PM Keith Medcalf wrote:
>
> Indeed turning off memstatus leads to a 500% (from ~3s to ~0.5s)
> performance
Hi,
We found a crash bug in sqlite. Here’s the POC:
—
CREATE VIRTUAL TABLE v0 USING fts4 ( v1 AS( typeof ( v5 ) ) , v6 UNIQUE
GENERATED ALWAYS AS( v5 ) , v2 INT , v3 INT UNIQUE GENERATED ALWAYS AS( NULL )
, v4 INTEGER UNIQUE , v5 DOUBLE PRIMARY KEY CHECK( v4 ) , v7 VARCHAR(20) UNIQUE
) ;
On Thursday, 2 January, 2020 15:48, Mike King wrote:
>I'm porting some code from .Net 4.8 to .Net Core 3.1 using the latest
>System.Data.Sqlite. How do I change / set a database password if my
>password is a byte array? It looks like I can use Pragma Key= if my
>password is text but I use hex
Hi,
We found an assertion failed in sqlite. And this assertion seems not to be
fixed completely. Here’s the POC:
—
CREATE TABLE v0 ( v1 INTEGER PRIMARY KEY ) ;
INSERT INTO v0 ( v1 ) VALUES ( NULL ) ,( NULL ) ;
SELECT ifnull ( v1 , max ( ( SELECT printf ( 's%' , 3 , 0 , 0.10 ) ) ) ) ,
max (
21 matches
Mail list logo