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 means there is a hierarchy
select * from service_table a,service_fib_table b where
a.service_no=b.service_no;
In this statement, the entry of service_fib_table must be existing to get the
service_table and service_fib_table data.
How can I write in one statement to get the service_table data no matter what
the entry
On 22 Sep 2015, at 5:44pm, Hugues Bruant wrote:
> Memory corruption seems unlikely: I would expect more errors to follow once
> some piece of memory is corrupted. Valgrind is unfortunately not very
> useful in this case as its OS X support is limited and it doesn't like JIT
> very much.
If a
Not important.
On Tue, Sep 22, 2015 at 6:00 PM, Simon Slavin wrote:
>
> 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 --
On 9/22/15, John McKown wrote:
> On Tue, Sep 22, 2015 at 3:15 PM, ChingChang Hsiao <
> ChingChang.Hsiao at overturenetworks.com> wrote:
>>
>> How can I write in one statement to get the service_table data no matter
>> what the entry of service_fib_table is existing or not.
>>
>
> SELECT * FROM
On 2015-09-22 03:58 PM, Hugues Bruant wrote:
> On Tue, Sep 22, 2015 at 6:22 AM, Richard Hipp wrote:
>
>> On 9/22/15, Hugues Bruant wrote:
If you can capture a malfunctioning trace, and send in the database
file and the SQL statement that is running, that should allow us to
On Tue, Sep 22, 2015 at 3:15 PM, ChingChang Hsiao <
ChingChang.Hsiao at overturenetworks.com> wrote:
>
>
> select * from service_table a,service_fib_table b where
> a.service_no=b.service_no;
>
> In this statement, the entry of service_fib_table must be existing to get
> the service_table and
R.Smith wrote on Tuesday, September 22, 2015 10:08 AM
>
> On 2015-09-22 03:58 PM, Hugues Bruant wrote:
> > SIndex sidx is just a boxed immutable integer. Its value is bound to
> > the UPDATE and the trace shows it to be 0 But the log line printed
> > when the number of rows updated is zero
A quick update on handling the the select query. We have some speed results
which are quite illuminating and positive.
We?ve been playing around with building a few web services, one of which was
the postcode lookup that people have kindly helped with.
We have one service that is a simple
On 2015-09-22 06:37 AM, Hugues Bruant wrote:
>> If you can capture a malfunctioning trace, and send in the database
>> file and the SQL statement that is running, that should allow us to
>> localize the problem.
>>
> Trace for the failing UPDATE:
>
> cv_s=1
> cv_o=b8b9f4...
> cv_t=28 -> 29
>
>
>
> That does look a bit like magic - and as is 99.9% the case when
> inexplicable magic happens, memory is getting corrupt or overwritten. You
> are obviously prudent about this, but is there no clue when running under
> Valgrind or similar for OSX? Nothing out of the ordinary or warnings?
>
On 2015-09-22 04:36 AM, James K. Lowden wrote:
> On Mon, 21 Sep 2015 11:19:16 +0200
> "R.Smith" wrote:
>
>>
>> This is the entire point of a database - allowing multiple things to
>> see the data. A system which only allows one thread to read data is
>> just a file-handler.
> ..//
> Not to be
On Tue, Sep 22, 2015 at 6:22 AM, Richard Hipp wrote:
> On 9/22/15, Hugues Bruant wrote:
> >>
> >> If you can capture a malfunctioning trace, and send in the database
> >> file and the SQL statement that is running, that should allow us to
> >> localize the problem.
> >>
> >
> > Trace for the
thanks for the hint. I've tried with SQLITE_ENABLE_MEMORY_MANAGEMENT to
call sqlite3_release_memory() each time after sqlite3_step(). The memory
usage is different during the whole runtime of the device. At the beginning
it is 80 K and each time the released memory ranges from 0 to 1,7 K, only
On Tue, Sep 22, 2015 at 12:47 AM, Shuhrat Rahimov
wrote:
> thanks for the hint. I've tried with SQLITE_ENABLE_MEMORY_MANAGEMENT to
> call sqlite3_release_memory() each time after sqlite3_step(). The memory
> usage is different during the whole runtime of the device. At the beginning
> it is 80 K
On 9/22/15, Hugues Bruant wrote:
>>
>> If you can capture a malfunctioning trace, and send in the database
>> file and the SQL statement that is running, that should allow us to
>> localize the problem.
>>
>
> Trace for the failing UPDATE:
>
> cv_s=1
The trace shows that you have this value set
Forgot to include the db in the previous email.
On Tue, Sep 22, 2015 at 12:37 AM, Hugues Bruant wrote:
> If you can capture a malfunctioning trace, and send in the database
>> file and the SQL statement that is running, that should allow us to
>> localize the problem.
>>
>
> Trace for the
>
> If you can capture a malfunctioning trace, and send in the database
> file and the SQL statement that is running, that should allow us to
> localize the problem.
>
Trace for the failing UPDATE:
cv_s=1
cv_o=b8b9f4...
cv_t=28 -> 29
SQL: [update cv set cv_t=? where cv_s=? and cv_o=?]
VDBE
On 21 Sep 2015, at 10:44pm, Hugues Bruant wrote:
> We've only observed this on OS X so far, with both 3.8.7 and 3.8.11.1. The
> new value is always exactly the old value +1 when the statement fails.
Can you reproduce this problem with the SQLite shell tool included with Mac OS
X ? You should
19 matches
Mail list logo