I've been waiting for Firebird-test Approval. Please advise.
-
Key: CORE-6209
URL: http://tracker.firebirdsql.org/browse/CORE-6209
Project: Firebird Core
Issue Type: New Feature
16.12.2019 18:03, Adriano dos Santos Fernandes wrote:
Using internal (BLB_*) or external API, looks like garbage is read when
one creates a blob and tries to read from it (using the same handle,
before it's closed).
Should this return an error (writing from an opened existing BLOB does)?
Hi!
Using internal (BLB_*) or external API, looks like garbage is read when
one creates a blob and tries to read from it (using the same handle,
before it's closed).
Should this return an error (writing from an opened existing BLOB does)?
Adriano
Firebird-Devel mailing list, web interface
Mark Rotteveel a écrit :
In other words, your number has 39 digits and is too big to fit in a signed
int128, and therefor is too big for NUMERIC(38)
BTW, as a DECFLOAT(16), that number would be
2039748092580420E+23, so you would lose +/- 23 digits of precision (more due
to rounding)
Mark
Mark Rotteveel a écrit :
On 2019-12-16 15:42, Norbert Saint Georges wrote:
Mark Rotteveel a écrit :
I can't answer that without information what the problem is.
Mark
okay :-)
I was actually referring to what you meant with:
"""
t = kb
t1 = ok
"""
Especially regarding the 'kb', I had no
> BTW: Such an extremely high part-number seems rather odd, and could
> indicate those numbers encode additional information, which may indicate
> this should be a string anyway.
>
Could these number be GUID encoded as Int128 ? If so they could be stored
as CHAR(16) CHARACTER SET OCTETS
On 2019-12-16 15:42, Norbert Saint Georges wrote:
Mark Rotteveel a écrit :
I can't answer that without information what the problem is.
Mark
okay :-)
I was actually referring to what you meant with:
"""
t = kb
t1 = ok
"""
Especially regarding the 'kb', I had no clue what you meant, but
On 2019-12-16 16:18, Norbert Saint Georges wrote:
Dimitry Sibiryakov a écrit :
16.12.2019 15:42, Norbert Saint Georges wrote:
I am developing an application to import Oracle DBs to Firebird 4.
Do you mean "automatic import"?
yes, for people like me, who don't like tinkering with
Dimitry Sibiryakov a écrit :
16.12.2019 15:42, Norbert Saint Georges wrote:
I am developing an application to import Oracle DBs to Firebird 4.
Do you mean "automatic import"?
yes, for people like me, who don't like tinkering with something other
than Firebird :-)
part_id is a number
16.12.2019 15:42, Norbert Saint Georges wrote:
I am developing an application to import Oracle DBs to Firebird 4.
Do you mean "automatic import"?
part_id is a number that has the value:203974809258041991228294191469794647457
what should i use in firebird 4 to import part_id?
For
Mark Rotteveel a écrit :
I can't answer that without information what the problem is.
Mark
okay :-)
I am developing an application to import Oracle DBs to Firebird 4.
when for example, a table is declared like this:
CREATE TABLE part (
part_id NUMBER GENERATED BY DEFAULT AS IDENTITY,
On 2019-12-16 14:05, Norbert Saint Georges wrote:
Thank you for your answer.
but when i do the test
create table t (id numeric (38,0));
insert into t (id) values (203974809258041991228294191469794647457);
create table t1 (id decfloat (16));
insert into t1 (id) values
Thank you for your answer.
but when i do the test
create table t (id numeric (38,0));
insert into t (id) values (203974809258041991228294191469794647457);
create table t1 (id decfloat (16));
insert into t1 (id) values (203974809258041991228294191469794647457);
t = kb
t1 = ok
I have to import
On 2019-12-16 09:43, Norbert Saint Georges wrote:
Hello,
can't an identity column be a decfloat (16)?
RECREATE TABLE FIREBIRD_PARTS (
PART_ID DECFLOAT (16) GENERATED BY DEFAULT AS IDENTITY
not null
, PART_NAME varchar (255) not null
, BUY_PRICE
Hello,
can't an identity column be a decfloat (16)?
RECREATE TABLE FIREBIRD_PARTS (
PART_ID DECFLOAT (16) GENERATED BY DEFAULT AS IDENTITY
not null
, PART_NAME varchar (255) not null
, BUY_PRICE decimal (9, 2)
);
error: 336068881
description found in
15 matches
Mail list logo
