On 11/13/2014 05:26 AM, Shaun Seckman (Firaxis) wrote:
Greetings all,
I'm running into a situation in where our application is crashing during a call
to sqlite_backup_finish inside of btreeParseCellPtr because some of the
structure is corrupted.
Both the source and destination database are
Hi,
Does any of SQLite data Type support 23,10 precision format for Number?
If yes, could you pleas help with right data type or approach to achieve
this.
If No, then is there something that can be added to SQLite and how quickly?
Thanks,
Dinesh Navsupe
On 13 Nov 2014, at 12:23pm, Dinesh Navsupe dinesh.navs...@gmail.com wrote:
Does any of SQLite data Type support 23,10 precision format for Number?
If yes, could you pleas help with right data type or approach to achieve
this.
SQL stores REAL numbers in a REAL field which conforms to 64-bit
Data types are 64bit integer (~18 decimal digits) and 64 Bit IEEE Float(11 bit
exponent, 52 bit fraction), so no.
Store the numbers as TEXT (human readable) or BLOB (e.g. 128Bit binary) and
write user-defined functions to manipulate them.
-Ursprüngliche Nachricht-
Von: Dinesh Navsupe
Hi,
My need is 23 decimal digits of precision. We work on complex payout
calculation engine where in formula outputs are quite large numbers and
clients do not want to round off.
We want to use SQLite for local disk data store and calculations.
Thanks,
Dinesh Navsupe
On Thu, Nov 13, 2014 at
On 2014/11/13 15:01, Dinesh Navsupe wrote:
Hi,
My need is 23 decimal digits of precision. We work on complex payout
calculation engine where in formula outputs are quite large numbers and
clients do not want to round off.
I do not think that re-stating your need suffices as a good enough
On Thu, Nov 13, 2014 at 2:33 PM, RSmith rsm...@rsweb.co.za wrote:
On 2014/11/13 15:01, Dinesh Navsupe wrote:
My need is 23 decimal digits of precision. We work on complex payout
calculation engine where in formula outputs are quite large numbers and
clients do not want to round off.
If
On 13 Nov 2014, at 1:01pm, Dinesh Navsupe dinesh.navs...@gmail.com wrote:
My need is 23 decimal digits of precision. We work on complex payout
calculation engine where in formula outputs are quite large numbers and
clients do not want to round off.
If you're working with floating-point
On Thu, Nov 13, 2014 at 3:38 PM, Simon Slavin slav...@bigfraud.org wrote:
On 13 Nov 2014, at 1:01pm, Dinesh Navsupe dinesh.navs...@gmail.com
wrote:
My need is 23 decimal digits of precision. We work on complex payout
calculation engine where in formula outputs are quite large numbers and
You are right Dominique.
I mean Oracle's NUMBER(23, 10), and given [1], that's more
9,999,999,999,999.99
Thanks.
On Thu, Nov 13, 2014 at 9:14 PM, Dominique Devienne ddevie...@gmail.com
wrote:
On Thu, Nov 13, 2014 at 3:38 PM, Simon Slavin slav...@bigfraud.org
wrote:
On 13 Nov
On Thu, Nov 13, 2014 at 4:50 PM, Dinesh Navsupe dinesh.navs...@gmail.com
wrote:
I mean Oracle's NUMBER(23, 10), and given [1], that's more
My need is 23 decimal digits of precision. We work on complex payout
calculation engine where in formula outputs are quite large numbers
and
On 13 Nov 2014, at 3:44pm, Dominique Devienne ddevie...@gmail.com wrote:
On Thu, Nov 13, 2014 at 3:38 PM, Simon Slavin slav...@bigfraud.org wrote:
100,000,000,000,000,000,000
Assuming he means Oracle's NUMBER(23, 10), and given [1], that's more
9,999,999,999,999.99
i.e. just
On 2014/11/13 19:06, Simon Slavin wrote:
On Thu, Nov 13, 2014 at 3:38 PM, Simon Slavin slav...@bigfraud.org wrote:
100,000,000,000,000,000,000
But he's using the field to store an amount of money in. So why ask for
anything with ten places after the decimal point ? No genuine currency
IIRC there was a programmer working for a bank that managed to siphon off the
sub-unit fractions that the interest calculating software generated (how much
interest is owed for $1 at 0,25% p.a. for 2 days*) onto his own account and
temporarily got rich quick.
$1 * 0,25% = $25 (interest
The following SQL produces an incorrect result with sqlite-3.8.7.1:
CREATE TABLE A(
symbol TEXT,
type TEXT
);
INSERT INTO A VALUES('ABCDEFG','chars');
INSERT INTO A VALUES('1234567890','num');
CREATE TABLE B(
chars TEXT,
num TEXT
);
CREATE TABLE IF NOT EXISTS C AS
SELECT A.symbol AS
This is https://www.sqlite.org/src/info/094d39a4c95ee4 which has been fixed
in trunk and will be fixed in 3.8.7.2.
On Thu, Nov 13, 2014 at 1:05 PM, Hinrichsen, John jhinrich...@c10p.com
wrote:
The following SQL produces an incorrect result with sqlite-3.8.7.1:
CREATE TABLE A(
symbol TEXT,
In this example, bad data is returned. There is no assert. valgrind does
not complain either.
Is there an ETA on when 3.8.7.2 will be released?
On Thu, Nov 13, 2014 at 1:12 PM, Richard Hipp d...@sqlite.org wrote:
This is https://www.sqlite.org/src/info/094d39a4c95ee4 which has been
fixed
On Thu, Nov 13, 2014 at 4:41 PM, Hinrichsen, John jhinrich...@c10p.com
wrote:
In this example, bad data is returned. There is no assert. valgrind does
not complain either.
It asserts if you recompile with -DSQLITE_DEBUG
Is there an ETA on when 3.8.7.2 will be released?
Next week
Hi,
Can anyone tell me answers against below my queries?
Since I'm beginner of SQLite, please forgive me about
so basic queries.
1) For Windows platform, there are 2 dlls on SQLite download page.
means, for 32bits and 64bits Windows OS.
However, in my understanding, the dll for win
On Thursday, November 13, 2014 04:27:02 PM Shinichiro Yoshioka wrote:
Is there any special reason why there are 2 dlls on the page?
And the dll for win 32bits doesn't work on win 64bits OS
in spite of exsistance of WOW64?
While a 32 bit version will work on a 64 bit Windows as you
On 11/13/2014 7:27 PM, Shinichiro Yoshioka wrote:
1) For Windows platform, there are 2 dlls on SQLite download page.
means, for 32bits and 64bits Windows OS.
However, in my understanding, the dll for win 32bits can work
also on 64bits win OS with WOW64 as it is.
Is there any
Thank you for your explanation!.
I understood.
2014-11-14 9:33 GMT+09:00 Igor Tandetnik i...@tandetnik.org:
On 11/13/2014 7:27 PM, Shinichiro Yoshioka wrote:
1) For Windows platform, there are 2 dlls on SQLite download page.
means, for 32bits and 64bits Windows OS.
However, in my
Thank you for your promt answer!
I understood.
2014-11-14 9:33 GMT+09:00 sql...@charles.derkarl.org:
On Thursday, November 13, 2014 04:27:02 PM Shinichiro Yoshioka wrote:
Is there any special reason why there are 2 dlls on the page?
And the dll for win 32bits doesn't work on win
On Thu, 13 Nov 2014 14:38:10 +
Simon Slavin slav...@bigfraud.org wrote:
In summary, if you need ultimate precision, use integers. If not,
use 64-bit IEEE-571 like everyone else does without being sued. If
you somehow really need 23,10 maths, then you're going to have to
write your own
24 matches
Mail list logo
