This sentence in .../ext/async/sqlite3async.c for async_cond_wait()
** It is guaranteed that no other thread will call async_cond_wait() when
** there is already a thread waiting on the condition variable.
is wrong for both Win32 and POSIX implementations. It should be left out or read
On Wed, 23 Sep 2015 18:01:47 +0200
Michael Schlenker wrote:
> Hi,
>
> i just wondered if there is an API to detect if a sqlite database file
> is already opened by another process.
>
> I can make the assumptions that:
>
> 1. WAL mode is in use
> 2. Linux and Windows only
> 3. No network
On 2015-09-23 06:09 PM, Richard Hipp wrote:
> On 9/23/15, Michael Schlenker wrote:
>> Hi,
>>
>> i just wondered if there is an API to detect if a sqlite database file
>> is already opened by another process.
> Maybe try to change in or out of WAL mode? That only works if there
> is a single
Hi,
i just wondered if there is an API to detect if a sqlite database file
is already opened by another process.
I can make the assumptions that:
1. WAL mode is in use
2. Linux and Windows only
3. No network filesystems
4. I only care if the access is done by another SQLite library,
not
On 23 Sep 2015, at 5:01pm, Michael Schlenker wrote:
> i just wondered if there is an API to detect if a sqlite database file
> is already opened by another process.
Thanks for your use-case and assumptions which makes this far simpler to answer.
I don't know of any simple way to know if
Hugues Bruant wrote on Wednesday, September 23, 2015 2:06 AM
> > > in some cases the SIndex captured inside the first lambda (UPDATE
> > > statement) appeared to be null even though it wasn't null in the
> > > enclosing scope (setVersion_)
> >
> > Interesting (and disturbing) result. Is this with
On 23 September 2015 at 12:32, Hugues Bruant wrote:
> On Wed, Sep 23, 2015 at 12:00 AM, Rowan Worth wrote:
>
> > Has many possible explanations.
>
> I can't think of any that is consistent with the Java specification.
>
Yeah fair enough, SIndex looks watertight. It's still possible for some
On 9/23/15, Michael Schlenker wrote:
> Hi,
>
> i just wondered if there is an API to detect if a sqlite database file
> is already opened by another process.
Maybe try to change in or out of WAL mode? That only works if there
is a single connection to the database file.
>
> I can make the
> SIndex sidx is just a boxed immutable integer.
If it were me I'd be reviewing this assumption very carefully. The sequence
of events:
1. SIndex.getInt() returns 0
2. SIndex.toString() returns "1"
3. SIndex.getInt() returns 1
Has many possible explanations. You could also try 'final int sid =
> > in some cases the SIndex captured inside the first lambda
> > (UPDATE statement) appeared to be null even though it wasn't null in the
> > enclosing scope (setVersion_)
>
> Interesting (and disturbing) result. Is this with Oracle's java compiler?
>
Compiler is Oracle JDK 8u40-b25 on OSX
On Wed, Sep 23, 2015 at 12:00 AM, Rowan Worth wrote:
> > SIndex sidx is just a boxed immutable integer.
>
> If it were me I'd be reviewing this assumption very carefully. The sequence
> of events:
>
public class SIndex {
private final int _i;
public SIndex(int i) {
_i = i;
}
public int
I ran into some trouble building sqlite-autoconf-3081101 on SCO 5.0.7v with GNU
tools. I'm not so good with autoconf scripts, but I can tell you what changes
had to be made to sqlite3.c and the Makefile to get a successful build. I hope
this can get into a future configure script somehow...
1.
On 2015-09-22 11:17 PM, ChingChang Hsiao wrote:
> SELECT * FROM service_table AS a
> LEFT JOIN service_fib_table AS b ON a.service_no=b.service_no ;
>
>
> How about adding one more further conditional JOIN in one statement above.
>
> service_fib_table.fib_id=service_fib_port_table.fib_id
>
> It
On 2015-09-22 11:17 PM, ChingChang Hsiao wrote:
> SELECT * FROM service_table AS a
> LEFT JOIN service_fib_table AS b ON a.service_no=b.service_no ;
>
>
> How about adding one more further conditional JOIN in one statement above.
>
> service_fib_table.fib_id=service_fib_port_table.fib_id
>
> It
On 22 Sep 2015, at 5:40am, Hugues Bruant wrote:
> Forgot to include the db in the previous email.
You can't attach files to messages in this list. If it's important, please
post the file somewhere and send us -- or perhaps just a couple of people -- a
URL.
Simon.
15 matches
Mail list logo