Thanks a lot Richard for your inputs.
the link indeed looks positive enough :).
Would like to know if anyone else has gone through similar experiences .
Best Regards,
Saurav
On Mon, Mar 23, 2015 at 5:26 PM, Richard Hipp wrote:
> On 3/23/15, Saurav Sarkar wrote:
> > Hi All,
> >
> > We use SQ
Hi All,
We use SQLite in our application. Ours is an windows store application
internally uses SQlite to store data (embedded). I use SQLitePCL library
which is a C# .NET based library
I was asked to perform Fortify scans on the SQLite code of 3.8.8.3
I used the amalgamation code.
Since it is a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
This was originally reported as a problem in APSW (Python SQLite wrapper):
https://github.com/rogerbinns/apsw/issues/184
The important bits are that a cursor (sqlite3_stmt) is created, and
step called once, but *not* reset or finalised:
cursor.e
On 2015-03-23 01:59 PM, Saurav Sarkar wrote:
> Thanks a lot Richard for your inputs.
>
> the link indeed looks positive enough :).
>
> Would like to know if anyone else has gone through similar experiences .
Often.
Just to add - many times people have posted here about some or other
static ana
On 23 Mar 2015, at 11:59am, Saurav Sarkar wrote:
> Thanks a lot Richard for your inputs.
>
> the link indeed looks positive enough :).
>
> Would like to know if anyone else has gone through similar experiences .
SQLite depends on people calling certain library routines in a certain way.
So
On Thu, Mar 19, 2015 at 11:29 PM, Joe Prostko wrote:
> In any case, this is more an FYI than me asking for a fix, as Fossil and
SQLite can be built just fine using our GCC 4 compiler. That said, if
SQLite is expected to build with older GCC compilers, then it would affect
other platforms as well
Sorry, i was too fast.
Correction
SELECT engine,coalesce(groupname,'*') as
groupname,databasename,key,value FROM EnginePreferences left join groups
on (groups.groupid = EnginePreferences.groupid);
OR
SELECT engine,groupname,databasename,key,value
FROM EnginePreferences
left join (selec
Hi,
SELECT engine,coalesce(groupname,*) as groupname,databasename,key,value
FROM EnginePreferences left join groups on (groups.groupid =
EnginePreferences.groupid);
OR
SELECT engine,coalesce(groupname,*) as groupname,databasename,key,value
FROM EnginePreferences
left join (select groupi
I have a table EnginePreference:
CREATE TABLE EnginePreferences (engine TEXT COLLATE NOCASE, databasename TEXT
COLLATE NOCASE, key TEXT COLLATE NOCASE, value TEXT, groupid INTEGER,
UNIQUE(engine,databasename,key))
and a table Groups:
CREATE TABLE Groups (groupid INTEGER PRIMARY KEY, groupname TE
On 3/23/15, Saurav Sarkar wrote:
> Hi All,
>
> We use SQLite in our application. Ours is an windows store application
> internally uses SQlite to store data (embedded). I use SQLitePCL library
> which is a C# .NET based library
>
> I was asked to perform Fortify scans on the SQLite code of 3.8.8.3
The sub-select is within an "inner namespace" to the whole query. You are free
to reference fields defined in all tables occuring in the subselect's FROM list
IN ADDITION TO any fields defined in tables occurring in the main query's FROM
list. This is a requirement for correlated subqueries. Whe
SQLite creates an ephemeral table for the IN list,giving O(log n) performance
for lookups.
>-Urspr?ngliche Nachricht-
>Von: James K. Lowden [mailto:jklowden at schemamania.org]
>Gesendet: Samstag, 21. M?rz 2015 20:43
>An: sqlite-users at mailinglists.sqlite.org
>Betreff: Re: [sqlite] Quer
12 matches
Mail list logo