[Firebird-devel] [FB-Tracker] Created: (CORE-5033) File fb_user_mapping could be left in Firebird lock directory after correct shutdown of all Firebird worker processes

2015-11-24 Thread Vlad Khorsun (JIRA)
File fb_user_mapping could be left in Firebird lock directory after correct shutdown of all Firebird worker processes - Key: CORE-5033 URL:

[Firebird-devel] [FB-Tracker] Created: (CORE-5034) At least 5 seconds delay on disconnect could happen if disconnect happens close after Event Manager initialization

2015-11-24 Thread Vlad Khorsun (JIRA)
At least 5 seconds delay on disconnect could happen if disconnect happens close after Event Manager initialization -- Key: CORE-5034 URL:

Re: [Firebird-devel] Reported datatype

2015-11-24 Thread Jiří Činčura
On Tue, Nov 24, 2015, at 19:30, Mark Rotteveel wrote: > What is the query you use? select sum(field1 * (field2 + field3)) from ... But basically any operation with these fields gives me subtype 0. > I know that Firebird sometimes doesn't reports the subtype for > decimal/numeric, and then you

Re: [Firebird-devel] Reported datatype

2015-11-24 Thread Jiří Činčura
On Wed, Nov 25, 2015, at 07:39, Jiří Činčura wrote: > Not sure if it's correct (or where I found that information ;)). Ha, looks like I was already there: http://markmail.org/message/skkpcjl3wnnjzqfl. -- Mgr. Jiří Činčura Independent IT Specialist

Re: [Firebird-devel] Reported datatype

2015-11-24 Thread Mark Rotteveel
Ah, that simple :). I do think it is a bug though. Mark - Reply message - Van: "Jiří Činčura" Aan: Onderwerp: [Firebird-devel] Reported datatype Datum: wo, nov. 25, 2015 07:39 On Tue, Nov 24, 2015, at 19:30, Mark Rotteveel wrote:

[Firebird-devel] Reported datatype

2015-11-24 Thread Jiří Činčura
Hi *, I have a query where (only) one field (expression) is this: OUTPUT SQLDA version: 1 sqln: 20 sqld: 1 01: sqltype: 581 INT64 Nullable sqlscale: -9 sqlsubtype: 0 sqllen: 8 When I do "show view ..." the datatype is reported as BIGINT. Is that correct? Looks like it should be NUMERIC/DECIMAL

Re: [Firebird-devel] Reported datatype

2015-11-24 Thread Mark Rotteveel
What is the query you use? I know that Firebird sometimes doesn't reports the subtype for decimal/numeric, and then you only have the scale to go on. Or at least, Jaybird has code to handle cases like this (subtype 0, negative scale) so I assume Firebird does or has done this, I have never

[Firebird-devel] [FB-Tracker] Created: (CORE-5032) Cannot connect to a database which have own security database without security3.fdb

2015-11-24 Thread Gabor Boros (JIRA)
Cannot connect to a database which have own security database without security3.fdb --- Key: CORE-5032 URL: http://tracker.firebirdsql.org/browse/CORE-5032 Project: