On Thu, Sep 13, 2018 at 2:05 AM Urs Wagner wrote:
>
> SQLite 3.24.0
> Entity Framework 6.2.0
>
> The result cannot be coerced into a string (compiler error).
Maybe I'm misreading this, but the subject line shows "foreign_keys =
[zero][en]" ... it appears the word ON ([oh][en]) is being written
On Tue, Sep 4, 2018 at 4:11 PM Keith Medcalf wrote:
>
> On Tuesday, 4 September, 2018 14:00, Clemens Ladisch
> wrote:
>
> >Keith Medcalf wrote:
> >> 6) If the column type is SQLITE_BLOB
> >> a) Retrieve the column value pointer using column_blob
> >> b) If the returned pointer is
On Tue, Sep 4, 2018 at 1:31 PM Keith Medcalf wrote:
>
> Well, that is not exactly true. If you attempt to retrieve the column
> values properly, either no errors can occur or if they do, they are obvious.
>
> 1) Query the column_type
> 2) If the column_type is SQLITE_NULL then return a NULL
This also fixes the problem I mentioned here:
https://www.mail-archive.com/sqlite-users@mailinglists.sqlite.org/msg108340.html
(BEGIN IMMEDIATE fails with "cannot start a transaction within a transaction
(1)" without nested transsactions)
Thanks,
Detlef.
-Ursprüngliche Nachricht-
Von:
On 9/13/18, Jens Alfke wrote:
> The geopoly docs says that only the geopoly_overlap(P1,P2) and
> geopoly_within(P1,P2) functions are optimized to use the R-tree index when
> used as a WHERE test; so that means the geopoly_contains_point function is
> not.
>
> This implies that, if I want to query
On 13 Sep 2018, at 3:49pm, Brian Vincent wrote:
> From my testing, it appears that this information isn't exactly correct.
> In my tests, when I call sqlite3_column_int64 for example, and it's
> successful, sqlite_errcode() immediately afterwards is returning
> SQLITE_ROW, which leads me to
The geopoly docs says that only the geopoly_overlap(P1,P2) and
geopoly_within(P1,P2) functions are optimized to use the R-tree index when used
as a WHERE test; so that means the geopoly_contains_point function is not.
This implies that, if I want to query for polygons containing a given point,
PRAGMA x[=xx] is DML not DDL, though it might not return any rows, but it
is a query. Have you tried running the pragma foreign_keys=1; as a DML (which
may return results) rather than as DDL (which do not). Perhaps the entity
framework is not executing the statement completely.
---
The
On 09/12/2018 08:56 PM, Nic Ramage wrote:
Hi,
I think I have found a regression/bug in Sqlite with respect to
the sqlite3_get_autocommit() function.
Hi,
Thanks for putting in the work to create the bug demo. Bisecting the
latest SQLite commits using it shows that this bug was fixed here:
On Wed, Sep 5, 2018 at 5:22 AM Richard Hipp wrote:
> On 9/4/18, Brian Vincent wrote:
> > Hi, I'm currently writing a Go sqlite package, go-sqlite-lite. I think
> it
> > provides a good "pure" SQLite experience with Go.
> >
> > If I want to make sure that the sqlite3_column_* functions never
Urs Wagner wrote:
> I get three lines
With some other tool, or executed through the EF?
Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Thanks for Your help
I get three lines
explain pragma foreign_keys = on
"0" "Init" "0" "1" "0" "" "00"
"1" "Expire""0" "0" "0" "" "00"
"2" "Halt" "0" "0" "0" "" "00"
explain pragma do_what_i_want
"0"
Urs Wagner wrote:
> Simon Slavin:
>> On 12 Sep 2018, at 2:04pm, Urs Wagner wrote:
>>> The following code is returning 0. Why?
>>>
>>> ExecuteStoreQuery("PRAGMA foreign_keys;").First();
>>
>> You coerce the result of the call into an integer. Can you make the call
>> and display (or use a
SQLite 3.24.0
Entity Framework 6.2.0
The result cannot be coerced into a string (compiler error).
PRAGMA compilie_options does not return any of
SQLITE_OMIT_FOREIGN_KEY
SQLITE_OMIT_TRIGGER
Regards Urs
-Original Message-
From: sqlite-users
14 matches
Mail list logo
