Here is the code of my TestStatusDate
public static void main(String[] args) throws Exception
{
String jobQuery = "SELECT j.jobId, c.channelName ,
datetime(j.jobCreateDate, 'localtime'), j.jobStatus, j.jobQuality,
j.jobCompleteDate FROM Job j, Channel c where c.channelId =
j.jobCh
Simon Slavin wrote:
> On 3 Jun 2011, at 3:50am, Sarkar, Arup wrote:
>
>> I am using sqlite3 primarily from c++, everything is working fine, except
>> when I switch off my computer I loose all data, is there any setting I need
>> to do to make the data and table object persistent in the .db file?
>
On 3 Jun 2011, at 3:50am, Sarkar, Arup wrote:
> I am using sqlite3 primarily from c++, everything is working fine, except
> when I switch off my computer I loose all data, is there any setting I need
> to do to make the data and table object persistent in the .db file?
Are you correctly closing
Hi:
I am using sqlite3 primarily from c++, everything is working fine, except
when I switch off my computer I loose all data, is there any setting I need
to do to make the data and table object persistent in the .db file?
Environment: Windows 7 Professional 64 bit.
Dev Env: Visual Studio 2010.
R
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/02/2011 02:17 PM, Simon Slavin wrote:
> Do you understand the strange result the OP reported ?
There is no evidence that Python is any way relevant to this issue and the
OP appears to have gone silent. I expect the actual cause is how SQLite w
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/02/2011 07:09 PM, Igor Tandetnik wrote:
> For a subselect like the one in question, SQLite picks the value from
> the first row - whichever row this happens to be - and ignores the rest.
> Providing an explicit LIMIT 1, or for that matter LIMIT
On 6/2/2011 9:57 PM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 06/02/2011 12:31 PM, Jay A. Kreibich wrote:
>>I suppose it would be technically correct to allow a LIMIT to 0, but
>>that seems like a highly questionable approach. Any parameter value
>>ou
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/02/2011 12:31 PM, Jay A. Kreibich wrote:
> I suppose it would be technically correct to allow a LIMIT to 0, but
> that seems like a highly questionable approach. Any parameter value
> outside of 0 and 1 *is* non-sense and should be dutiful
"I can't find any documentation for using that library with C++."
Yeah--tell me about it. I've been searching and searching without much
luck at all. The only examples I've seen talk about including sqlite.h
and then using sqlite functions as opposed to using objects and namespaces.
But when I
Hello,
On Fri, Jun 3, 2011 at 00:08, Rense Corten wrote:
[...]
> So I searched the archives of this list and found two threads on this:
>
> http://www.mail-archive.com/sqlite-users@sqlite.org/msg51574.html
> http://www.mail-archive.com/sqlite-users@sqlite.org/msg48649.html
>
> The first thread go
Hi all,
I'm trying to import a large file of about 13GB using SQLite 3.7.6.3
on Ubuntu. I use the precompiled Linux binary.
The commands are:
=
.separator ";"
.import largefile.csv mytable
=
but then I get: "Error: cannot open "largefile.csv" "
I
Op 2-jun-2011, om 23:17 heeft Simon Slavin het volgende geschreven:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
> On 2 Jun 2011, at 7:24pm, Roger Binns wrote:
>
>> (Incidentally I am the author of a "competing" Python SQLite
>> binding and
>> hence know exactly which SQLite API calls r
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 2 Jun 2011, at 7:24pm, Roger Binns wrote:
> (Incidentally I am the author of a "competing" Python SQLite binding and
> hence know exactly which SQLite API calls result from bits of Python hence
> being very pedantic about getting these tests the s
Roger Binns писал(а) в своём письме Fri, 03 Jun 2011
00:30:12 +0600:
> SQLite was actually in error IMHO. The subquery is the right hand side of
> an equality and SQLite was looking for a single row/value. The query
> generation code specifically added a LIMIT to ensure that only one row was
>
On Thu, Jun 02, 2011 at 11:30:12AM -0700, Roger Binns scratched on the wall:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 06/02/2011 01:18 AM, Dagdamor wrote:
> > Patrick Earl ?(?) ? ? ?? Wed, 01 Jun 2011
> > 22:24:10 +0600:
> >
> >> Is there another work-around?
> >
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/02/2011 01:18 AM, Dagdamor wrote:
> Patrick Earl писал(а) в своём письме Wed, 01 Jun 2011
> 22:24:10 +0600:
>
>> Is there another work-around?
>
> Yes. Do not feed SQLite with stupid queries. ;)
The query was actually correct and not stupid
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/02/2011 04:38 AM, Simon Slavin wrote:
> Python is a bytecode language.
That isn't relevant in this case. The code that interfaces Python to SQLite
is written in C. The amount of Python bytecode involved in this benchmark
is irrelevant.
On 0
On 2 Jun 2011, at 6:01pm, Jan Hudec wrote:
> - Inside one transaction, running select may or may not see data inserted or
> updated in parallel.
Sorry to go on about this but you underestimate the problem.
Suppose you're part-way through _step()ing through the results of a SELECT and
an UPDA
On Wed, Jun 01, 2011 at 12:09:35 -0700, hmas wrote:
> Actually, I managed to make it work by selecting "Windows Mobile 5.0 Pocket
> PC SDK" instead of "Pocket PC 2003" for the SDK in the procedure described
> in my first post.
Than it might be that WM5.0 already supports that interface while PPC20
On Wed, Jun 01, 2011 at 19:23:16 +0100, Simon Slavin wrote:
> On 1 Jun 2011, at 7:12pm, Jan Hudec wrote:
> >> Do not update a table if there is some select statement currently
> >
> > Actually insert, update and delete are OK. Drop and alter table are
> > a problem.
>
> Pavel is right. He left
And your TestStatusDate code is?
I'd bet now that the problem is in the way you get that time from
jdbc. It can convert the time back to utc for you, although it looks a
little strange that it converts one date and doesn't convert other
one...
Pavel
On Thu, Jun 2, 2011 at 11:52 AM, Sridhar Pol
On Thu, Jun 2, 2011 at 10:53 AM, Richard Hipp wrote:
> http://www.sqlite.org/src/ci/efb20b9da6
>
> Note, however, that lemon.c is not a deliverable component of SQLite, but
> rather a code generator program that generates some of the C code for
> SQLite, and lemon always runs on a workstation, and
On Thu, Jun 2, 2011 at 11:38 AM, Ronald Burgman <
r.w.burg...@student.utwente.nl> wrote:
> Hi,
>
> I've found a strange piece of code. The print_stack_union function
> allocates some memory to the types variable (line 3436) and terminates
> with an error code if this allocation fails (line 3450).
I am on Windows 7 64 bit; I have tested the program as you mentioned,
the good point here was the issue still appears please find logs . Let
me know if you infer anything from below.
C:\development\SignalCoreClient\test\com\Rimage\Starfish\AutomatedTests>java
TestStatusDate
Today's Locale is en
Hi,
I've found a strange piece of code. The print_stack_union function
allocates some memory to the types variable (line 3436) and terminates
with an error code if this allocation fails (line 3450). But types is
already accessed before this check. So shouldn't the check be earlier
in the code, or
> I have verified my locale and default time zone in the same program.The
> values are correct and it is not UTC timezone. Any help appreciated.
How did you do that? What OS are you running it on?
Can you extract the code accessing SQLite database from your program
and create a mini-program that d
I have verified my locale and default time zone in the same program.The
values are correct and it is not UTC timezone. Any help appreciated.
Sridhar
On 02-06-2011 19:34, Sridhar Polavarapu wrote:
> The returned value is displayed to the user. We are not storing back
> the returned column.
>
> S
This line seems erroneous: SQLiteCommand sqlCmd(%conn); Isn't the
percent the modulus operator?
Shouldn't it be: SQLiteCommand sqlCmd(&conn);
On 6/1/2011 5:06 PM, Don Ireland wrote:
> I'm hoping someone can help me with this.
>
> Using Visual Studio C++, the following code DOES create the DB fil
Thanks for the response, Shane. When would you expect that support to be
restored?
On Thu, Jun 2, 2011 at 10:11 AM, Shane Harrelson wrote:
> You'll have to go back to one of the "legacy versions" from
> http://sqlite.phxsoftware.com .
> Compact framework support was one of the features that had
You'll have to go back to one of the "legacy versions" from
http://sqlite.phxsoftware.com .
Compact framework support was one of the features that had to be temporarily
dropped when maintenance was moved to http://www.sqlite.org .
Restoring compact framework is currently one of our top priorities.
The returned value is displayed to the user. We are not storing back the
returned column.
Sridhar
On 02-06-2011 19:28, Pavel Ivanov wrote:
>> but is returning the value stored in the database when executed
>> as a part of a java program. Can anyone help me if I am missing
>> something here ?
>
On 2 Jun 2011, at 2:40pm, Ronald Burgman wrote:
> I'm currently using a tool to find bugs in the SQLite source code. I've
> found some interesting things and want to submit some bug reports so the
> developers can also have a look at it.
Report them here.
Although you may be using a tool to /fi
> but is returning the value stored in the database when executed
> as a part of a java program. Can anyone help me if I am missing
> something here ?
Looks like your java program runs with a different locale than SQLite
Manager. I'm not sure why it thinks that you are in a UTC timezone.
Maybe th
> I did try sending a mail over the dev-list, but got no reply. Could
> someone tell me how it should be done?
You should send it here with the exact steps of reproducing the bug.
Hopefully your tool is not code analyzer because "potential bugs"
without any real life steps to catch it won't be pa
Hi everybody,
I'm currently using a tool to find bugs in the SQLite source code. I've
found some interesting things and want to submit some bug reports so the
developers can also have a look at it.
However I'm new to SQLite so I'm not sure where and how to submit these
reports. I did try sending
On 2 Jun 2011, at 8:55am, Dominique Pellé wrote:
> Roger Binns wrote:
>
>> While those are all valid, they don't address the underlying issue which is
>> C code taking five times longer than Python code for the same SQLite
>> operations. In addition that same "redundant" code is executed behind
Hi
I am preparing a string sql query as follows
String jobQuery = "SELECT j.jobId, c.channelName ,
datetime(j.jobCreateDate,'localtime') as jobCreateDate, j.jobStatus,
CASE WHEN j.jobQuality='md' THEN 'Medium' WHEN j.jobQuality='hi' THEN
'High' WHEN j.jobQuality='lo' THEN 'Low' ELSE 'Unsp
Patrick Earl писал(а) в своём письме Wed, 01 Jun 2011
22:24:10 +0600:
> Is there another work-around?
Yes. Do not feed SQLite with stupid queries. ;)
If, according to SQLite standards, LIMIT shouldn't be specified in that
subquery, then you shouldn't use it. Especially with bind parameters.
Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 06/01/2011 12:25 PM, Dominique Pellé wrote:
>> [Various optimisations]
>
> While those are all valid, they don't address the underlying issue which is
> C code taking five times longer than Python code for the same SQLite
39 matches
Mail list logo