On Thu, Feb 12, 2015 at 1:35 PM, R.Smith rsm...@rsweb.co.za wrote:
Now one could argue the warning should not be issued for it, or some
warnings are fine as information. Personally I prefer zero unneeded
warnings/clutter but that's just my pedantism.
My pedantism is to prefer the warning
Well, if TERM_VNULL is 0, then the code is truly unreachable, so I wouldn't
call it a compiler bug.
e
On Thu, Feb 12, 2015 at 9:26 AM, Richard Hipp d...@sqlite.org wrote:
Dan is right. I think I'd calling this a clang bug.
On Feb 12, 2015 9:06 AM, Dan Kennedy danielk1...@gmail.com wrote:
For those interested in the initial misuse of aggregate issue of this
thread, there is now a ticket:
http://www.sqlite.org/src/tktview?name=2f7170d73b
e
On Mon, Feb 9, 2015 at 9:19 AM, Keith Medcalf kmedc...@dessus.com wrote:
Not exactly since aggregates are implemented as functions.
In
Thank you, Richard. It works for me now.
e
On Mon, Feb 9, 2015 at 1:30 PM, Richard Hipp d...@sqlite.org wrote:
On 2/7/15, Doug Currie doug.cur...@gmail.com wrote:
In response to this SO question:
http://stackoverflow.com/questions/28377210/how-to-retrieve-rank-based-on-total-mark
In response to this SO question:
http://stackoverflow.com/questions/28377210/how-to-retrieve-rank-based-on-total-mark-in-sqlite-table
I tried to formulate a query without temp tables using an ordinary
CTE, but received an error misuse of aggregate: sum().
tonypdmtr
In response to this SO question:
http://stackoverflow.com/questions/28377210/how-to-retrieve-rank-based-on-total-mark-in-sqlite-table
I tried to formulate a query without temp tables using an ordinary CTE, but
received an error misuse of aggregate: sum().
This works:
sqlite with tt (S_id,
The query is on a visits table from a google chrome history database. The
query seems to work OK if a single bit is set, but fails (a blank string is
returned) when multiple bits are set. Any ideas why?
It's because none of the WHEN 0x... cases, except 0xC0..., have multiple
bits set. The
There is this range of negative
values smack in the middle of an otherwise uniformly increasing sequence of
positive numbers. That negative range seems discombobulating.
Why are hex literals interpreted as signed at all? You could simply
consider all hex literals as unsigned values. If you
Why are hex literals interpreted as signed at all? You could simply
consider all hex literals as unsigned values. If you need a negative
value,
prefix it with the - operator, e.g., -0x77.
With this approach (a) there is no discombobulating segment, (b) all 64
bit
bit-masks are
Here's an analogy: a sequence of decimal digits is unsigned; it only
becomes negative when you put a - in front of it.
Why shouldn't hex work the same way? (to eliminate the discombobulating
segment)
Because then you would not be able to write (in hex) a 64-bit bitmap that
had the
On Dec 5, 2013, at 8:55 PM, Warren Young war...@etr-usa.com wrote:
On 12/5/2013 17:00, Scott Robison wrote:
Might there be a way to implement a custom VFS for Mac to deal with this?
Wouldn't it be a lot simpler to just put the DB file into a Mac package (i.e.
directory) so the associated
On Nov 24, 2013, at 6:47 AM, Alek Paunov a...@declera.com wrote:
BTW, I see the term deterministic in the SQL99 BNFs:
…
but different in PostgreSQL (immutable, stable, etc):
There is value in compatibility, but those adjectives are awful. In computer
science we have referential
Paul Bainter wrote:
Not sure what happened to this post previously, so I guess I'll try it
again with some additional information
GMail considered these messages spam for some reason. Check your spam
folder.
e
___
sqlite-users mailing list
On Sep 10, 2013, at 6:23 PM, Scott Robison sc...@casaderobison.com wrote:
I think I prefer something along the lines of unlikely or likely. The
problem with a term like selective (at least in my brain) is that it
doesn't imply (for the single argument version) in what way it is being
I'm unable to reproduce the problem using C. Maybe it is in lsqlite3.
Yes, lsqlite3 still uses the old sqlite3_prepare() API to maintain
compatibility with some legacy systems. It is long past time that it should
have changed to use sqlite3_prepare_v2().
Running Richard's example with
On Mar 7, 2013, at 11:07 AM, Ryan Johnson ryan.john...@cs.utoronto.ca wrote:
That does leave the question of what to do with cast ('1.0' as integer),
though. Without the prefix-based matching that would now return NULL rather
than 1, even though cast(1.0 as integer) would still return 1.
On Oct 23, 2012, at 4:58 PM, Igor Korot ikoro...@gmail.com wrote:
1. I know on Mac I need to build an application bundle. Where do I
store the .db file relative to the bundle?
Inside it? Home directory? Somewhere on the hard drive? What is the
usual place for it?
If the database is
On Aug 6, 2012, at 8:26 AM, Simon Slavin slav...@bigfraud.org wrote:
So either Apple has made a change between versions, or we have different
paths.
I use fully qualified pathnames here:
~ e$ /usr/bin/sqlite3 :memory: 'SELECT sqlite_source_id()'
2012-04-03 19:43:07
On Aug 6, 2012, at 4:51 PM, Simon Slavin slav...@bigfraud.org wrote:
On 6 Aug 2012, at 7:48pm, Doug Currie doug.cur...@gmail.com wrote:
~ e$ /usr/local/bin/sqlite3 :memory: 'SELECT sqlite_source_id()'
2012-05-14 01:41:23 8654aa9540fe9fd210899d83d17f3f407096c004
I think this copy has been
On Aug 3, 2012, at 2:33 PM, Dan Kennedy danielk1...@gmail.com wrote:
There was a problem similar to your description at one point, but
it should have been fixed before the 3.7.12 release. What do you
get from the shell command SELECT sqlite_source_id(); on
Mountain Lion?
e$ /usr/bin/sqlite3
On Aug 3, 2012, at 3:32 PM, Tobias Giesen tobiasgie...@gmail.com wrote:
Apparently Apple prevents starting other versions of it and redirects
everything to
their current version in /usr/bin.
On ML here I can launch my version in /user/local/bin just fine.
e$ which sqlite3
The SQLite3 date time functions are designed assuming
[…] that every day is exactly 86400 seconds in duration.
Before I start implementing TAI (or GPS time) to/from UTC translator plugin,
has anyone already done this?
Why? In a device that logs data with sub-second resolution, in my case a
On Jun 28, 2012, at 4:05 PM, Nico Williams wrote:
It's also possibly a good idea to just not have autoincrement. Let
the application implement it, no? After all, it can, including via
triggers.
Or with PostgreSQL-style sequences
On Jun 17, 2012, at 12:23 PM, Keith Medcalf wrote:
SQLITE_SIGNIFICANT_DIGITS defaults to 14, but you can override it. No matter
what is requested, the maximum number of significant digits is limited to the
specification, and rounding is applied to the remaining bits of the
significand,
On Mar 27, 2012, at 3:46 PM, Larry Brasfield wrote:
A DBMS is a good way to keep your raw data. But I highly doubt that a
majority of your analysis algorithms are going to be expressible in SQL
without going way beyond the intended purpose of the language. You will
either find yourself
On Nov 9, 2011, at 11:39 PM, Bhautik Kothadia wrote:
Is there any Operating System Required for that?
See: http://www.sqlite.org/custombuild.html
especially section 5.0 Porting SQLite To A New Operating System
If not then How much Memory is required?
See: http://www.sqlite.org/malloc.html
The PIC32MX664F064L has
64 KiB Program Memory Size
32 KiB RAM
SQLite as it presently stands will not fit within these constraints.
e
On Nov 9, 2011, at 7:47 AM, Parthiv Shah wrote:
Respected Sir,
We want to use DB SQLite in our product.
We are using PIC32MX664F064L microcontroller
On Oct 25, 2011, at 10:59 AM, Sébastien Escudier wrote:
CREATE TRIGGER my_trigger INSTEAD OF INSERT ON my_view
BEGIN
INSERT INTO table1(type) VALUES(NEW.table1.type);
INSERT INTO table2(type) VALUES(NEW.table2.type);
END;
...
Why this syntax does not work anymore ?
You haven't given
On Oct 24, 2011, at 11:07 AM, Dilip Ranganathan wrote:
But as you all know, this doesn't work:
select datetime(time) from table where time =
julianday(datetime(max(time)),'-2 hour','localtime') order by time desc
Try replacing datetime(max(time)) with (select datetime(max(time)) from
On Sep 23, 2011, at 9:17 PM, Richard Hipp wrote:
paper above completely ignores this issue. It is as if the authors had
never heard of short-circuit evaluation. Or, perhaps they are familiar with
the problem but could not reach agreement on its solution so simply didn't
bring it up.
On Aug 10, 2011, at 12:39 PM, NOCaut wrote:
I work in VS2008 c++
i create data base my.db and wont use U N I C O D E function from this DLL
i find class or unit for connect to my base from VS2008
http://sqlite.org/download.html - this link help me?
you understand me?
No, but maybe
On Jul 27, 2011, at 9:22 AM, Baruch Burstein wrote:
Is there an easier way to get a single value (for instance select
last_insert_rowid(); ) then prepare - step - column - finalize?
http://www.sqlite.org/capi3ref.html#sqlite3_last_insert_rowid
e
On Jun 17, 2011, at 2:56 PM, john darnell wrote:
I am attempting to open an SQLite database on the Mac (OSX Snow Leopard) and
am getting an error. This is the code I am using:
char DBEnginePath[1000];
strcpy(DBEnginePath, Macintosh HD:Applications:Adobe InDesign
On May 26, 2011, at 2:54 AM, Jan Hudec wrote:
Gotcha! No, it's not. -1-x is equivalent, but -x-1 is not:
sqlite select -1-(163), -(163)-1;
9223372036854775807|9.22337203685478e+18
Besides my point was not that it's not possible, but that it would
be more readable with dedicated
On Mar 31, 2011, at 2:27 PM, Mike Rychener wrote:
I have tried the latest Explorer and it gets a syntax error on STDEV.
However, that function works in Eclipse just fine, to take the standard
deviation of a column (like min, max, avg). Is there a workaround or
other fix available?
See
On Dec 7, 2010, at 10:49 AM, Csom Gyula wrote:
It clarified the situation, that is backup-restore seems to be the best
choice:) Just one more question. As you put backup-restore is based upon data
pages (that could be binary a format I guess) not on plain SQL/data records.
After all: Is
On Nov 29, 2010, at 9:37 AM, Rick Regan wrote:
For IEEE 754 double-precision numbers and 64-bit integers roughly
99.4% of all numbers can be processed efficiently. The remaining 0.6% are
rejected and need to be printed by a slower complete algorithm.
Hmmm. What's involved in the slower
On Nov 28, 2010, at 11:18 AM, Rick Regan wrote:
Michael,
Thanks for the very thorough analysis.
This is a difficult problem; fortunately it was solved 20 years ago...
http://www.mail-archive.com/sqlite-users@sqlite.org/msg09529.html
e
___
On Nov 28, 2010, at 5:37 PM, Rick Regan wrote:
On Sun, Nov 28, 2010 at 4:01 PM, Doug Currie doug.cur...@gmail.com wrote:
On Nov 28, 2010, at 11:18 AM, Rick Regan wrote:
Michael,
Thanks for the very thorough analysis.
This is a difficult problem; fortunately it was solved 20 years ago
On Nov 28, 2010, at 6:19 PM, Rick Regan wrote:
On Sun, Nov 28, 2010 at 5:52 PM, Doug Currie doug.cur...@gmail.com wrote:
There is a new publication on this subject that may be of interest to those
looking at providing solutions:
http://portal.acm.org/citation.cfm?id=1806623
On Aug 24, 2010, at 10:57 AM, Nikolaus Rath wrote:
Nikolaus Rath nikolaus-bth8mxji...@public.gmane.org writes:
Still no one able to clarify the issues raised in this thread?
Let me try to summarize what I still don't understand:
- Will SQLite acquire and release an EXCLUSIVE lock while
On Aug 19, 2010, at 4:00 PM, David Bicking wrote:
I haven't tried RAISE(ROLLBACK... as that seems to severe.
RAISE(ABORT... removes the initial insert to Table1, which I want to avoid.
RAISE(FAIL.. on lets say the fourth record inserted in to Table2, would leave
the first three there,
On Jun 1, 2010, at 2:24 PM, Gilles Ganault wrote:
Actually, it's a Blackfin processor, and since it's an embedded
environment, RAM and storage (NAND) are an issue.
You may find eLua interesting. http://www.eluaproject.net/
The supported platforms are heavily ARM based, but in the same
On May 18, 2010, at 4:14 AM, Sylvain Pointeau wrote:
but is it 64 bits? or do I have to add a special option?
Last time I built a Universal Binary sqlite3 on OS X (March 2010 3.6.22) I had
to
CFLAGS='-arch i686 -arch x86_64' LDFLAGS='-arch i686 -arch x86_64' ./configure
On Feb 15, 2010, at 1:43 PM, Roger Binns wrote:
Shane Harrelson wrote:
I'm looking at how this can be improved.
It seems that everyone else is converging on using David Gay's dtoa.c
We've been converging for a few years!
http://www.mail-archive.com/sqlite-users@sqlite.org/msg09529.html
e
On Jan 4, 2010, at 6:35 AM, sasikuma...@tcs.com wrote:
I'm using SQLite DB version 3.6.12. I recently read about the feature of
In-Memory Database and tried to implement it. I was able to create a new
DB connection in memory, able to create a table and insert some set of
records into the
On Dec 13, 2009, at 3:16 PM, Alexey Pechnikov wrote:
As we can see, the unique index can check equlity of REAL values
but the = operator can not. it's fantastic I think :-)
The problem is not the = operator...
sqlite create table test (save_date REAL unique);
sqlite insert into test values
On Nov 5, 2009, at 5:15 PM, Beau Wilkinson wrote:
I really think this warrants further discussion. Perhaps the correct
answer (that ARMs implement a non-standard FP type which is
incompatible with Sqlite) is already out there, but I think the
issues I raised with that answer should at
On Oct 30, 2009, at 10:14 AM, P Kishor wrote:
Actually, there can be one bad effect of Darren's suggestion, now that
I think of it, and that would be for those who don't care for strong
typing. They will end up getting strong typing for all non-UNIVERSAL
columns whether they like it or not,
On Aug 23, 2009, at 6:46 AM, Chris Dew wrote:
Note: this is not for production code, just an experiment in keeping a
history of application 'state', allowing current state to be
recalculated if an historic input is received 'late'. See
On Jul 27, 2009, at 10:33 AM, CityDev wrote:
It's true that Codd and Date used the term 'relational' (They
championed the
N-ary Relational Model - others were around at the same time) but
it's not
easy to track the origin of the term in mathematics.
On Jul 24, 2009, at 8:44 AM, D. Richard Hipp wrote:
SQLite database files are cross-platform. All you have to do is copy
the file to the new machine. There is no separate external format.
The same database file format work on all platforms.
Just make sure that if you are moving to a new
On Jul 7, 2009, at 4:36 PM, nixonron wrote:
conn = sqlite3.connect('c:\Ujimadata\aid.sqlite')
Perhaps you meant
conn = sqlite3.connect('c:\\Ujimadata\\aid.sqlite')
or
conn = sqlite3.connect('c:/Ujimadata/aid.sqlite')
e
___
sqlite-users mailing
On Jun 12, 2009, at 3:46 PM, Allen Fowler wrote:
sqlite
select *, min((strftime('%s', end) - strftime('%s', start))) as
length
from
... events where
... start datetime('now', '+1 day','start of day',
'+9 hours','+30 minutes')
... and end datetime('now', '+1 day','start
of
On May 19, 2009, at 10:05 AM, Jean-Denis Muys wrote:
On 5/19/09 2:44 PM, Igor Tandetnik itandet...@mvps.org wrote:
Wikipedia gives a definition different from yours, for what it's
worth:
http://en.wikipedia.org/wiki/Remainder#The_case_of_general_integers
Also to support my version, the
On May 18, 2009, at 5:32 PM, Allen Fowler wrote:
The simple solution would just create a race condition... i think:
1) INSERT INTO status_table FROM SELECT oldest task in queue
2) DELETE oldest task in queue
Right?
It might work fine if you wrap it in an exclusive
transaction.
On May 15, 2009, at 9:07 AM, Sam Carleton wrote:
I would like CURRENT_TIMESTAMP to be more accurate than just one
second, any suggestions on how I might do that once? My solution is
all a C/C++ interface, so all features are open to me.
Option 1 - use: julianday('now') instead of
On Apr 22, 2009, at 4:38 PM, Pavel Ivanov wrote:
I've tried to set pragma synchronous = on (it's off by default for
me), but it makes application to work 5 times slower which is not
acceptable for me. I would be happy if there was some solution in
between that, i.e. for example just a bit
On Mar 12, 2009, at 12:01 AM, jonwood wrote:
PaymentDate=2009/01/05
Note the '/'s
And then I ran the following query:
SELECT * FROM Payments WHERE FK_CustomerID=5 AND DATE(PaymentDate) =
DATE('2009-01-01') AND DATE(PaymentDate) = DATE('2009-03-11')
Note the '-'s.
'2009/' '2009-'
e
On Mar 12, 2009, at 12:08 AM, jonwood wrote:
Doug Currie-2 wrote:
Note the '/'s
What does this mean? What does DATE('2009-1-1') or DATE('2009/1/1')
return?
Does DATE() simply have no effect whatsoever?
Sorry to be cryptic.
sqlite select date('2009/12/03');
sqlite select date('2009
On Nov 25, 2008, at 1:44 PM, Igor Augusto Guzzo wrote:
I get an ARM based embedded system (AT91SAM9260 - ATMEL), linux based,
with uclibc library and my code, developed in C with the sqlite3
library, runs fine only in my host linux (Fedora).
Firstly, I compiled the code on Makefile project
On Nov 18, 2008, at 5:10 AM, Roshan Sullad wrote:
[...]
I have another Visual studio test application where I am using this
Sqlite3.dll functionality, I have linked statically to Sqlite3.dll by
including *sqlite3.c,sqlite3.h,sqlite3ext.h* , files in to my test
application project. And am
On Nov 12, 2008, at 10:31 PM, henry wrote:
my app, I opened a database handler, insert some records, delete some
records, then closed the database handler. The problem is the next
time
when I connect the Sqlite, the actions I did last time has all gone
away, it did not take any effect to
On Aug 10, 2008, at 2:12 PM, CAVALO SCHMIDT wrote:
salutations, using VC++ in WinXP.
I would like to know if it's possible to import and use the
sqlite3.dll file and/or the sqlite database file as a resource in a
C++ project, so that it will be integrated to the final Win32
executable. how
is because you need a
different one for each compiler you use to link.
Right, and with gcc on Windows (mingw/msys or cygwin), you don't need
an import library at all; gcc will link against the DLL itself.
e
--
Doug Currie
Londonderry, NH, USA
___
sqlite
other mailing list behaves differently... some default to the
list, others to the OP. Why can't we all get along.
Please set the list so default reply is to the list.
http://www.unicom.com/pw/reply-to-harmful.html
e
--
Doug Currie
Londonderry, NH, USA
sequence has
the NO PAD attribute, and the pad character is NUL.
Jeff, can you solve your problem with a custom collating sequence?
e
--
Doug Currie
Londonderry, NH, USA
-
To unsubscribe, send email to [EMAIL
On Wednesday, September 05, 2007 Arjen Markus wrote:
Doug Currie wrote:
I suspect the bug is in the functions that convert between string and
double; that's why I keep harping on Steele and White's (and
Clinger's) PLDI 1990 papers. What I don't know is why this bug appears
in the binary from
as LONGDOUBLE_TYPE (long double).
http://msdn2.microsoft.com/en-us/library/9c3yd98k(VS.80).aspx
http://msdn2.microsoft.com/en-us/library/9cx8xs15(vs.80).aspx
e
--
Doug Currie
Londonderry, NH, USA
-
To unsubscribe, send email
on Steele and White's (and
Clinger's) PLDI 1990 papers. What I don't know is why this bug appears
in the binary from sqlite.org but not in the version I build myself
with gcc 3.4.5 from SQLite version 3.4.2 source.
e
--
Doug Currie
Londonderry, NH, USA
numbers
readably. http://portal.acm.org/citation.cfm?id=93559
e
--
Doug Currie
Londonderry, NH, USA
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
that Serena expects.
e
--
Doug Currie
Londonderry, NH, USA
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
\sqlite-3.4.2\bld.\sqlite3
SQLite version 3.4.2
Enter .help for instructions
sqlite select round(98926650.5, 1);
98926650.5
I am using:
$ gcc --version
gcc.exe (GCC) 3.4.5 (mingw special)
e
--
Doug Currie
Londonderry, NH, USA
Microsoft Visual C++ compiled and gcc compiled
versions of sqlite3 are bound to produce different results.
Why my gcc 3.4.5 compiled sqlite3.exe and the one from the sqlite.org
downloads page produce different results is still a mystery to me.
e
--
Doug Currie
Londonderry, NH, USA
on the event;
they all wake up and compete for the resource again. For better
solutions, see: http://world.std.com/~jmhart/batons.htm
e
--
Doug Currie
Londonderry, NH, USA
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
there to be intervals when there are no
waiting threads, and you can afford to wait for that interval for a
synchronization point, and you don't care the order in which the
inserts are performed, the Automatic Reset event might work.
e
On 6/1/07, Doug Currie [EMAIL PROTECTED] wrote:
On Friday
Chamberlin and Ray
Boyce at the ACM–SIGFIDET Workshop on Data Description, whereas ess
cue ell is used for subsequent standardized versions of the language.
e
--
Doug Currie
Londonderry, NH, USA
-
To unsubscribe, send email
12:00:00');
1721753.0
There is no year 0. The calendar goes from -1 BCE to 1 CE. -11-24
is 1 BCE. So, if you want November 24, 4714 B.C. you need to say
sqlite Select julianday('-4713-11-24 12:00:00');
0.0
e
--
Doug Currie
Londonderry, NH, USA
a reason to do this
since gcc will link against the DLL directly.
e
--
Doug Currie
Londonderry, NH, USA
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
for this purpose, so sqlite3_interrupt couldn't be used
there, either.
Igor Tandetnik
--
Doug Currie
Londonderry, NH
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Monday, September 25, 2006, 1:46:12 PM, David Champagne wrote:
and then I execute a query
SELECT * FROM License WHERE FORM = form;
I get all rows returned
Try:
SELECT * FROM License WHERE FORM = 'form';
e
--
Doug Currie
Londonderry, NH
the shadow pager.
Note, I'm not suggesting that you should implement anything like this
in SQLite...
Me neither. ;-)
e
--
Doug Currie
Londonderry, NH
Thursday, May 4, 2006, 1:27:49 PM, Dennis Cote wrote:
More mysteries. To investigate this low insert performance under WinXP I
wrote a simple test program that loops writing one character to a file
and then flushing the file. The strange thing is that it seems to
alternate between two
with you.
Thanks for the help!
Regards,
-- Tito
--
Doug Currie
Londonderry, NH
on Media (key,source);
create index key_source_val_idx on Media (key,source,value);
I wonder what effect
create table Media (id INTEGER PRIMARY KEY, key, value, source integer);
would have on your query time. This would use the already built-in
BTree index.
e
--
Doug Currie
Londonderry, NH
A brief report on building sqlite-3.3.4 with MinGW/MSYS and tcl84 on
WinXP...
1. After configure, a small edit was necessary to the Makefile; for
some reason libtool doesn't put .lo objects into .libs subdirectory
anymore; there was also an issue reported on the mailing list with
stripping the
, that permits any value. Summarizing and seconding Dennis
Cote's suggestion, perhaps columns that have no type declared, or that
are declared DYNAMIC, behave as SQLite does today, and columns that
have static declarations behave as if they are statically typed.
Regards,
e
--
Doug Currie
Londonderry
://mathworld.wolfram.com/RationalNumber.html
--
Doug Currie
Londonderry, NH
KW I downloaded the raw source and ran 'configure' and 'make' from a
KW separate folder. The resulting output I copied to /usr/lib/sqlite. In
KW it a see the bunch of .lo, .o and the two .la files (libsqlite3.la,
KW libtclsqlite3.la)
KW I am use to a Visual Studio build environment, but from
See http://lists.debian.org/debian-arm/2003/10/msg00030.html
ARM has at least two FL formats.
from the ARM Architecture Reference Manual, Page C2-4:
The word order [for DP format] defined here for the VFP architecture
differs from that of the earlier FPA floating-point architecture. In
the
Thursday, August 18, 2005, 3:18:56 PM, Frank wrote:
I repeated the test using the value 1.2345678 in order to be
able to identify the position of each byte:
linux i386:
1bde8342cac0f33f
0100
linux arm:
cac0f33f1bde8342
0100
So, it indeed looks like 32bits
Wednesday, August 10, 2005, 5:57:50 AM, Ivo wrote:
IK Hello,
IK It seems that at least under windows there are rounding problems with the
IK milliseconds:
IK sqlite select strftime(%f, 2005-01-01 12:34:55.122);
IK 55.121
IK [...]
IK Is this maybe a problem of the underlying c-library?
IK
Tuesday, July 19, 2005, 12:19:48 PM, Aaron wrote:
We are inserting records into SQLite databases, and in our testing
have discovered that in some circumstances it is possible to be
inserting records inside a transaction, yet not have the fact that
the database journal file is growing be
Before binding an address to a statement using sqlite3_bind_int64() I apply an
offset to the address to translate it to a signed value. And when reading out
an address using sqlite3_column_int64() I reverse the process. I.e.
dbase_value = addr_value - offset
addr_value = dbase_value
The actual test I'm doing is something like:
WHERE ?1 = (base + begin) AND ?1 (base + end)
where ?1, base, begin, and end are all 64-bit addresses.
This is a test with a well known optimization for unsigned values:
WHERE (?1 - base - begin) end
To make the test unsigned in SQL
Thursday, March 31, 2005, 5:53:12 PM, you wrote:
The actual test I'm doing is something like:
WHERE ?1 = (base + begin) AND ?1 (base + end)
where ?1, base, begin, and end are all 64-bit addresses.
This is a test with a well known optimization for unsigned values:
WHERE (?1 -
Friday, February 4, 2005, 3:09:59 PM, Clark Christensen wrote:
So, my question is, true or false:, if I want to use
SQLite's date/time functions against field values, my only
real option is to store -MM-DD HH:MM:SS time strings.
Any other value, whether MMDD, julian day number,
create table each_transaction(datetime int);
insert into each_transaction values( datetime('%s', 'now'));
Perhaps you should say
insert into each_transaction values( strftime('%s', 'now'));
?
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
e
this is how I create table and
Friday, January 21, 2005, 1:33:35 PM, DRH wrote:
Version 3.1.0 (alpha) of SQLite is now available on the website.
Compiling with MinGW MSYS on WinXP...
1. I had to modify my lib/tclConfig.sh to have
TCL_LIB_SPEC='-L/mingw/lib -ltcl84'
instead of
TCL_LIB_SPEC=''
or else testfixture wouldn't
Friday, January 21, 2005, 5:41:00 PM, Dan wrote:
autovacuum-ioerr2.4.0...
Error: error copying test.db to backup.db: no such file or
directory autovacuum-ioerr2-4.1.1...
Error: error copying backup.db to test.db: no such file or
directory autovacuum-ioerr2-4.1.2... Ok
1 - 100 of 140 matches
Mail list logo