27.05.2014 12:41, Tony Christiansen wrote:
I just tried to manually unlock the db.fdb file and that got rid of the
delta file but the file size is still 309 555 - I would have expected it
to change if the delta is merged with the database. Is there an
explanation of what is happening
28.05.2014 02:41, Tony Christiansen wrote:
Just to clarify, If I do a gbak of a database with a delta file does
that backup include the pending changes in the delta file?
Sure it does (if those changes are committed ones).
Dmitry
30.05.2014 06:11, s3057...@yahoo.com wrote:
CREATE INDEX IX_TA BLE2_EXPECTED ON TABLE2 (TABLE1ID, VALIDFROM, VALIDTO);
COMMIT;
-- SIMPLE QUERY
SELECT *
FROM TABLE2 T
WHERE T.TABLE1ID BETWEEN 1000 AND 1999
AND T.VALIDFROM = CURRENT_DATE
AND T.VALIDTO = CURRENT_DATE
The simple query
23.06.2014 14:48, Tim Ward t...@telensa.com [firebird-support] wrote:
I've got an INSERT statement like:
INSERT INTO table( list of columns )
SELECT list of columns
FROM table whose name is not known until run time
WHERE something
RETURNING
02.07.2014 15:06, Loris Luise wrote:
I noticed there are NO MORE FB 2.5 build strating from May 27 for linux
http://web.firebirdsql.org/download/snapshot_builds/linux/fb2.5/
For WIN platform snapshot builds are regularly updated.
http://web.firebirdsql.org/download/snapshot_builds/win/2.5/
07.07.2014 21:14, Thomas Steinmaurer wrote:
I would like to know if the TempCacheLimit parameter in SuperClassic is
like Classic or like SuperServer? So if it's per client connection or
it's for server process?
As in Classic, thus per connection.
Nope, it's per server process.
Dmitry
08.07.2014 15:07, Alexey Kovyazin wrote:
Ï am not sure that Dmitry wins here, since original question is not 100%
correct.
Cache is always per server process - each server process has own cache,
in all architectures, and difference is in connection/server process model.
Not really correct
13.07.2014 01:31, slu...@iquanta.com wrote:
CREATE TRIGGER ROVMRS_AU FOR ROVMRS AFTER UPDATE
AS
DEC LARE VARIABLE ff SMALLINT;
BEGIN
SELECT FIRING FROM TRIGGER_CONTROL WHERE EVENT = GL_UPDATE INTO :ff;
IF ((OLD.GL = NEW.GL) AND (:ff = 0)) THEN BEGIN
IF (OLD.RCHARGE NEW.RCHARGE)
28.07.2014 06:15, Robert martin wrote:
Have the following (cut down) ordered SQL
SELECT *
FROM Document d
LEFT JOIN DocumentCreator dc ON dc.DocCreatorRef = d.DocCreatorRef
ORDER BY dc.Description
There is an Index on dc.Description but it is not used. Plan shown below..
PLAN SORT
28.07.2014 12:56, Svein Erling Tysvær wrote:
The server where I ran the queries is a Firebird 2.5.1 SuperServer
installation.
It might be an interesting challenge to try v3.0 Beta, as it has a
completely different FULL JOIN implementation.
Dmitry
30.07.2014 18:05, Xifeng Wen wrote:
Recently I find the nbackup is very very slow. For my 40G database, it
takes almost 24 hours to finish the 0 level, for the rest levels it also
takes several hours.
Did you try playing with the -D switch for nbackup?
Dmitry
31.07.2014 13:32, Xifeng Wen wrote:
Did you try playing with the -D switch for nbackup?
I do not understand this parameter and can not find any documentation
about it. What does this direct I/O mean? Does it help anything?
Direct I/O means database copying without help of a filesystem
18.08.2014 23:39, 'Carlos H. Cantu' wrote:
LSSBcfs While this would avoid the error, you will not know when/if your
change will be applied.
LSSBcfs A connection can hold an object in use for an indeterminant period
of time.
Dmitry said to me sometime ago that procedures changes will be
18.08.2014 22:51, Aldo Caruso wrote:
For reliability reasons, I decided to turn on forced writes on a
database running on Linux.
What is FB architecture: SS / CS / SC? I suspect SS given your default
cache size (2048 pages) but it's worth double checking.
1) Does it makes sense to activate
19.08.2014 21:56, Hugo Eyng wrote:
Sorry, but I didn´t, yet, understand why I can´t exceute an ALTER
PROCEDURE without _*closing all conections and restarting the FB
service.*__*
You can.
I notice that i am not the only one facing this trouble:
30.08.2014 11:25, Jaume Llunell Gómez wrote:
Hi, i would like to understand this plan
PLAN (TABLE1 ORDER TABLE1_IDX1 INDEX (TABLE1_UK))
And the select that generets it is this one:
SELECT first 1 PREU_COST
FROM TABLE1
WHERE ARTICLE = :p_article
AND DATA = :P_DATA
AND
30.08.2014 14:25, bert_herngr...@yahoo.com wrote:
Should the Execute statement work on an ODBC datasource already with FB 3.0?
No.
The ability to access foreign database engines using providers should
not be overlooked, either. It might seem
strange to consider this, given the number of
03.09.2014 09:44, Macma wrote:
I found that after upgrade from FireBird 2.1.5 Update 1 to 2.1.6 my
query stop working with error Dynamic SQL Error SQL error code = -104
Invalid expression in the select list (not contained in either an
aggregate function or the GROUP BY clause). The same error
19.09.2014 13:16, Maya Opperman wrote:
I’m not sure if this is a problem or not, but I have quite a few entries
like this with NULL transaction ID’s in the MON$STATEMENTS table:
Is this a sign that my code isn’t cleaning something up properly, or is
it perfectly normal?
Any idea under what
21.09.2014 20:46, Mark Rotteveel wrote:
I don't know enough about reading below The Firebird stacktraces, but it
looks like apart for process 14830 that they are all waiting for a lock.
More precisely, they're waiting for active transaction # 17348466 that
blocks concurrent inserts into some
22.09.2014 17:09, Maya Opperman wrote:
Is that not going to be affecting performance in a bad way?
Nope.
Dmitry
++
Visit
27.09.2014 21:01, abad...@tut.by [firebird-support] wrote:
Is bug http://tracker.firebirdsql.org/browse/CORE-2848 fixed in FB 2.5.3?
We have had this bug in two FB 2.5.2 classic server installs and it
still appears sometimes after updating to 2.5.3.
Did you migrate via backup/restore? It's a
28.09.2014 16:19, abad...@tut.by wrote:
Also, is it possible to just delete all data from offending tables? If
all pages with records are cleared, shouldn`t it also get rid of record
fragments?
Delete and garbage collect (to really clear data pages).
Dmitry
30.09.2014 19:19, Geoff Worboys wrote:
CREATE INDEX MyIndex1 ON MyTable1 (Field1, Field2);
where Field1 is VARCHAR(80)
Field2 is VARCHAR(255)
both use the database default CHARACTER SET WIN1252 with
collation WIN1252_NOCASE as defined like this:
CREATE COLLATION WIN1252_UNICODE
02.10.2014 11:55, brucedickin...@wp.pl wrote:
The thing is that I am not able to find any information about XNET in
the Internet. I've looked thorougly. Could you point me to any reliable
source that describes this protocol?
XNET is just a Firebird specific abbrevation, WNET (aka Named Pipes)
02.10.2014 16:24, brucedickin...@wp.pl wrote:
Dmitry, few years ago there was a rumour that connecting through TCP/IP
was slower than through XNET / pipes. Could you clarify on this? Is
there any difference in terms of performance when retrieving/inserting
data from/to database depending on
06.10.2014 02:36, Malcolm Gray wrote:
This gives the following possible combinations:
(32-bit software) (32-bit fbclient.dll) (32-bit Firebird) (32-bit computer)
(32-bit software) (32-bit fbclient.dll) (32-bit Firebird) (64-bit computer)
(32-bit software) (32-bit fbclient.dll) (64-bit
12.10.2014 23:25, 'Walter R. Ojeda Valiente' wrote:
I can not understand those numbers.
Why the Next Transaction was 304 and not 3?
Why after a SELECT the OIT, OAT and OST had changed so much?
Someone can explain me?
Without connections to the database, OAT/OIT/OST means virtually
13.10.2014 00:22, 'Walter R. Ojeda Valiente' wrote:
Thank you very much for your answer Dmitry. However my first question
remains: why after a cycle backup/restore the Next Transaction was 304
and not 3?
My understanding so far is that after a cycle backup/restore the ID of
all transactions
28.10.2014 03:34, av...@telusplanet.net wrote:
perhaps it takes some time for FB to delete the attachment?
True.
can I delete from mon$transactions?
No, you cannot.
can i delete from mon$attachments?
Sure you can.
Dmitry
31.10.2014 09:03, 'Louis van Alphen' wrote:
and coalesce(R.FINISH,-1) = coalesce(STOCK.FINISH,-1)
and R.FINISH is not distinct from STOCK.FINISH
Dmitry
12.11.2014 16:14, Svein Erling Tysvær wrote:
I have an EXECUTE BLOCK statement, for which a small part goes NATURAL where
I'd expect it to use an index associated with a UNIQUE CONSTRAINT.
I would expect
JOIN icd10_purres p ON p.icd10 IN (t.icd10, substring(t.icd10 from 1 for 3))
to use
12.11.2014 21:48, 'Leyne, Sean' wrote:
2) ON p.icd10 = t.icd10 OR p.icd10 = t.icd10
I think you meant
ON p.icd10 = t.icd10 OR p.icd10 = substring(t.icd10 from 1 for 3)
Nope, I was interested exactly in that [useless] condition. I want to be
sure that both ORed parts are trivially
13.11.2014 14:39, Svein Erling Tysvær wrote:
D1) ON p.icd10 = t.icd10
These change the plan to:
PLAN JOIN (MERGE (SORT (JOIN (P NATURAL, G INDEX (I_ICD10_GRUPPE_ICD10))),
SORT (JOIN (T KID INDEX (U_NPR_KRG_ID_FNRK), T N INDEX (I_NPR_KRG_ID), T T
INDEX (I_NPR_TILSTAND_ID_NPR, I INDEX
14.11.2014 00:13, 'Leyne, Sean' wrote:
Do you think that a CAST() within T would help?
It could help if my guess was correct. Although the situation is a bit
weird, as text columns are comparable regardless of their length. Maybe
charset/collation of the expression has been altered/lost after
12.12.2014 23:08, 'Martijn Tonies wrote:
But using ROWS instead of FIRST makes using a parameter possible
FIRST (:CNT) does the trick as well.
Dmitry
15.12.2014 23:27, bjoern.rei...@fau.de wrote:
select min(t.Id) FROM test t
group by t.reference, t.key
having count(*) 1
costs 1000 Non indexed reads
select * from test where Id in (
select min(t.Id) FROM test t
group by t.reference, t.key
having count(*) 1
)
costs 1001000 non
22.12.2014 21:18, Hugo Eyng wrote:
I added the settings SharedDatabase = true and SharedCache = false like
you told and everything worked fine.
Shouldn´t those settings be present in firebird.conf? I had to add them
manually.
They do exist in v3 firebird.conf, be it official Beta or
23.12.2014 05:35, s3057...@yahoo.com wrote:
I just tried to download the Win32 version of FB Classic from here:
http://www.firebirdsql.org/en/firebird-2-5-3/
The link to
http://sourceforge.net/projects/firebird/files/firebird-win32/2.5.3-Release/Firebird-2.5.3.26778_0_Win32.exe/download
24.12.2014 11:22, brucedickin...@wp.pl wrote:
I've set my transaction parameters like this:
FtraMain.TRParams.Add('isc_tpb_write');
FtraMain.TRParams.Add('isc_tpb_read_committed');
FtraMain.TRParams.Add('isc_tpb_wait');
FtraMain.TRParams.Add('isc_tpb_no_rec_version');
As far as I
03.01.2015 03:08, André Knappstein wrote:
I created a test table on both old and new server to play with updates
and inserts (~ 150.000 records)
Performance with 2.5.3 x64 on Win2008 is constantly
changing, but at best its some 8 seconds and worst even 2 minutes!
Performance with
21.01.2015 20:11, Martijn Tonies wrote:
Oh bugger.
Now, I tried the following in the procedure to work around the above:
exception test _utf8 'unicode string here';
When I look at RDB$PROCEDURES.RDB$PROCEDURE_SOURCE I can see
the text is inserted as a hex string.
But this doesn't seem
21.01.2015 19:45, 'Martijn Tonies wrote:
I have an EXCEPTION object with a Unicode text in it, a stored procedure
raises this exception.
The client application can view the Unicode text just fine when it
retrieves the Exception meta data, but when the exception is raised,
Firebird doesn’t
20.02.2015 17:36, Thomas Beckmann wrote:
I wonder whether this still holds true, 'cause reading in current how
tos and web pages even on firebirdsql.org makes me assume sweeping and
garbage collection are the same today.
They're still different beasts. I'm wondering what pages say the
29.01.2015 19:15, Martijn Tonies wrote:
2) Create SP with EXCEPTION ERROR 'some Cyrillic string';
Done. In the source, I see the following:
begin
exception test _utf8
X'31D0A2D095D0A1D0A220D09DD09020D091D0AAD09BD093D090D0A0D0A1D09AD098';
end
You don't need the _utf8 prefix with HEX
27.01.2015 14:48, Martijn Tonies wrote:
btw, in Firebird 3, the RDB$EXCEPTIONS.RDB$MESSAGE is still NONE.
Would it make sense to encode the message according to the given connection
character set?
Do you mean changing RDB$EXCEPTIONS.RDB$MESSAGE to UTF8? It was
discussed but ended nowhere.
24.03.2015 18:42, Tim Ward wrote:
[#] Yes, well, there's then the question about how come you're allowed
to get a database into such an illegal state in the first place, isn't
there.
I'd say this is what should be asked first. And it's no longer possible
starting with FB3.0.
Dmitry
25.03.2015 12:20, Tim Ward wrote:
The fix in 3.0 sounds good! - but it'll be a while for us, we're
currently looking at upgrading to 2.5.
Instead of going for the -o switch and losing one table completely, I'd
rather use the -n switch. As a result, you have all data but some
constraints are
25.03.2015 19:43, 'checkmail' wrote:
one short question, why is the Result of
coalesce(:variableVarchar(10),‘NULL‘) not ‚NULL‘ but rather ‘NULL ‘
with blanks from varchar(10) length?
Because the resulting length is determined by the longest argument. It's
fixed at the compile time.
27.03.2015 15:13, Fernando P. Nájera Cano wrote:
I have a few questions about the transaction numbers.
The documentation at
http://www.firebirdsql.org/manual/gstat-example-header.html says that
OST is normally the same as OAT.
I'd replace normally with ideally ;-)
* When could OST be
27.02.2015 13:07, Alberto albe...@winperfil.com wrote:
I´m working with Delphi. I have an application in 64bits and I need to
know what is the engine version installed (32bits or 64bits) from
firebird. Any idea?
Why would you need to know that? For a standalone FB server, both 32-bit
and
25.02.2015 22:38, martin_gorr...@yahoo.es wrote:
I have this SQL:
select t1.*, t2.* from
(select a1.BJAR,a1.TKEY,a2.OWNR,a2.TIPO,a2.DSCR as ADSCR
from TL1_1 a1 left outer join BJAR a2 on a1.BJAR=a2.BJAR) t1
left outer join
(select b1.BJTX,b1.TKEYT,b2.OWNR as
25.02.2015 23:29, martin_gorr...@yahoo.es wrote:
select t1.*, t2.* from
(select a1.BJAR,a1.TKEY,a2.OWNR,a2.TIPO,a2.DSCR as ADSCR
from TL1_1 a1 left outer join BJAR a2 on a1.BJAR=a2.BJAR) t1
left outer join
(select b1.BJTX,b1.TKEYT,b2.OWNR as TOWNR,b2.BJAR,b2.DSCR as
24.03.2015 19:58, Ann Harrison wrote:
The theory is that the constraints are all there, just inactive.
There's no (and never was) ability to deactivate/activate constraints.
It's possible only for indices backing those constraints. But obviously,
it does not apply to NOT NULL constraints.
26.03.2015 21:49, Mark Rotteveel wrote:
The MON$STATEMENTS contains the statement handles in Firebird. The
lifetime of a statement handle is separate from the transaction.
Therefor if there is currently no transaction associated with the
statement (eg: the statement handle has been created
30.04.2015 12:04, Wolfgang Rohdewald wrote:
Reading the mailing list I just learned that this is possible.
Experimenting shows that (using FB 2.5) this does have limitations.
There's no such FB version. It should work on v2.5.4.
Dmitry
02.05.2015 18:10, Wolfgang Rohdewald wrote:
Sorry for being inexact. I meant the 2.5.x series. Since the documentation
only describes features and since
there hopefully is no change of features between any 2.5.x version and since
changing index expressions to
accept arbitrarily complex
07.05.2015 20:23, sboyd...@gmail.com wrote:
The following query:
SELECT PB_LOAD_TYPE,
/* If already picked up use the pick up date.
If already delivered us the delivered date.
If appointment date present, use it.
Otherwise, use today's date */
15.04.2015 20:44, Dmitry Yemanov wrote:
TempDirectories always takes precedence over [almost] everything else.
If empty, FIREBIRD_TMP is used. If empty, system TMP/TEMP is used.
Re. [almost] above - the only exception is GTTs, they ignore
TempDirectories. All other temp usage (sorts, temp
15.04.2015 16:31, Edward Mendez wrote:
I always wondered about that. If I have set in my “firebird.conf” a
list of directories, but my FIREBIRD_TMP environment variable has one,
do you know if one setting take precedence over the other?
TempDirectories always takes precedence over [almost]
15.04.2015 22:06, Mark Rotteveel wrote:
Isn't it a bug that it ignores the setting?
I'd rather call it a design pitfall, as GTT cannot be splitted among
multiple directories. Maybe we could just use the first entry from the
list and ignore others.
Anyway, it's already registered:
16.04.2015 16:56, Michael Schwarze wrote:
It is about the general direction Firebird is heading: will it come closer to
NoSQL approaches, for instance?
It depends on what you mean by closer and what NoSQL features you're
interested in. Many aspects of SQL vs NoSQL are orthogonal and I don't
14.04.2015 18:56, Trond tro-d...@online.no [firebird-support] wrote:
The environment variables are as follow
TEMP and TMP is F:\TEMP
and FIREBIRD_TMP is F:\TEMP;C:\UTVIKLING\TEMP
Temporary directories in firebird.conf are all commented out.
TempDirectories in firebird.conf supports
02.06.2015 03:51, firebirdbest...@yahoo.com [firebird-support] wrote:
There seems to be contradictory information about maximum number of
simultaneous distinct user connections to Firebird. This document:
How many users can connect to Firebird simultaneously?
08.06.2015 10:02, Marianne Castel wrote:
We were working with Firebird 2.5.2 on Debian . At that time, in the
monitoring table MON$ATTACHEMENTS I could see the IP address of the
client connected to a database.
Now our administrators have decided to work with CentOS and the last
available
05.06.2015 08:55, brucedickin...@wp.pl wrote:
As you can see DETAILS_DATA takes 5 times more of space. I was
completely surprised by this result, after all I am not wasting space
for 50+ columns. Could you explain me this phenomenon?
How long are actual strings inside PARAM_VALUE? It's worth
17.06.2015 18:00, 'Neil Pickles' wrote:
Hopefully Dmitry will come up with some answers.
I don't see anything really wrong in the lock print. However, I recall
one improvement to the high mutex ratio committed to v2.1.4, so
upgrading to a newer FB version could be helpful.
Dmitry
16.06.2015 11:54, 'Neil Pickles' wrote:
Does anyone have any ideas as to what might be causing the high mutex
wait %?
Outputs for gstat -h and fb_lock_print could be helpful. As well as what
exactly custom firebird.conf contents you use (what parameters are set
to non-default values).
25.05.2015 13:25, Stefan Heymann wrote:
when I call SELECT * FROM MON$ATTACHMENTS (logged in as the database
owner), the MON$ROLE field always shows 'NONE', even when the user is
logged in with a specific role.
It means that the role wasn't actually applied (even if it was
specified). Maybe
25.05.2015 17:43, Hugo Eyng hugoe...@msn.com wrote:
1 - I created a column NOT NUL in a table (ALTER TABLE MYTABLE ADD
NEW_COLUMN INTEGER NOT NULL). There were already some records in the
table. FB didn´t raise any warning or exception.
2 - I created a backup file from MYDB.FDB using gbak.
12.08.2015 21:58, Jeferson Sisto wrote:
1) In firebird.conf, in session about parameter DummyPacketInterval,
there is a warning DO NOT USE THIS OPTION. I can or cannot use this
parameter? This parameter only can be used with the changes in OS,
quoted in the Microsoft article?
You can use
19.08.2015 14:29, 'Mr. John' wrote:
This time,adding condition this way WHERE FIEL1=:F1 AND FIEL2=:F2 AND
* (FIEL3=:F3 OR **:F3 IS NULL) * INTO .. DO ..
is causing query to be much slower ...
this WHERE FIEL1=:F1 AND FIEL2=:F2 AND * (FIEL3=:F3 **) * INTO .. DO ..
takes *0.563s*
because
21.08.2015 12:14, 'Louis van Alphen' wrote:
Dmitry thanks for the insight. This actual puts FB in quite a different
light. I have used FB since IB 5 and is my DB of choice. However this issue
may prove quite problematic.
It does not cover all cases with views, only the ones when you need to
21.08.2015 13:58, 'Louis van Alphen' wrote:
Dmitry, re your point 4, do you mean:
create view SKIN as
select
ID,
(select NAME from COLOUR_ C where C.ID = S.COLOUR_ID)
from SKIN_ S;
Right. Not very good option when you need many lookup fields from the
same table, but could still be
22.08.2015 16:06, tvd...@ymail.com wrote:
Rebuilding the indices is not the issue. It's just that the warning
implies that rebuilding the whole database is really better than just
rebuilding the indices. Am I still at any kind of risk if I just rebuild
the indices? What is the worst thing
21.08.2015 10:26, 'Louis van Alphen' wrote:
Dmitry, if I then understand you correctly, if a view contains an outer join,
then FB will table scan? Is this documented somewhere so that I can read up?
It depends on a number of factors, but generally your conclusion is
correct. The problem is
19.08.2015 10:26, 'Mr. John' wrote:
now index is used if I call
SELECT * FROM MYPROC(...)
but I use it in other procedures,no join on it just simply SELECT ..
FROM MYPROC(...) in this case I can see in the plan :
...(MYPROC NATURAL)...
That' OK. In complex plans, (MY_PROC NATURAL) just
20.08.2015 16:53, 'Louis van Alphen' wrote:
The same thing happens in many other queries where I use views and IMHO
I find it non-sensical. I have come to the conclusion that FB does not
choose great query plans when using views.
True, when views contain outer joins.
It is really hard to
02.11.2015 19:21, Russell Weetch russ...@smxi.com wrote:
>
> Not sure whether I have been looking in the right place, but is data
> encryption included in Firebird 3?
Technology is built in, but the encryption plugin should be developed by
you or someone else. Firebird itself does not provide
05.11.2015 14:12, Josef Kokeš j.ko...@apatykaservis.cz wrote:
>
> I wonder: Was there any change in FB 2.5.4 which would slow down
> processing of WHERE field IN (subselect) a lot, compared to FB 2.5.3? I
> have been performing tests because a user of mine complained about slow
> speed of my
08.07.2015 15:18, Mark Rotteveel wrote:
Another reason could be restoring with a different page size than the
original database.
Or some tables were altered to a longer record format after filling them
with data. The original database contains records in the old (shorter)
format while the
18.11.2015 19:39, 'Leyne, Sean' s...@broadviewsoftware.com wrote:
>
> We are investigating a client report of performance problems and are
> looking at the MON$IO_Stats values but they look very large.
> We are wondering if for prepared statements the values represent the
> total of all
31.08.2015 17:31, Martijn Tonies wrote:
>
> This works:
>
> CREATE TABLE BMP_BLOBS
> (
>ID INTEGER NOT NULL,
>BMP BLOB SUB_TYPE 0 SEGMENT SIZE 80,
>"COMMENT" VARCHAR(20) COLLATE ISO8859_1,
> CONSTRAINT PK_BMP_BLOBS PRIMARY
31.08.2015 15:03, Martijn Tonies wrote:
>
> I wonder, should this be possible:
> select f_blobsize(X'10')
> from rdb$database
> DECLARE EXTERNAL FUNCTION F_BLOBSIZE
> BLOB
> RETURNS INTEGER FREE_IT
> ENTRY_POINT 'blobsize' MODULE_NAME 'FreeAdhocUDF';
> I’m getting this error:
> “
01.09.2015 17:24, Dalton Calford wrote:
> With firebird 2.5 we received some wonderful tools that allowed us to create,
> update and drop users without needlessly mucking about with smacking the
> security database. Yea!
>
> But, we also where locked out from reading the security database so
26.09.2015 05:59, 'Walter R. Ojeda Valiente' wrote:
>
> Is there some SELECT that can give me the number of context a stored
> procedure has?
No, it's impossible.
> Other question:
>
> Which are the comands that count as context?
>
> I know: INSERT, UPDATE, DELETE, SELECT, UNION. Is there some
23.12.2015 01:36, Ann Harrison wrote:
> Like I said, I have always kept transactions very short. I am
> thinking of something like this instead:
>
> a) begin a transaction, update FIELD_1 of MYTABLE.
> b) update FIELD_2 of MYTABLE.
> c) update FIELD_3 of MYTABLE.
> d)
24.12.2015 05:31, 'Leyne, Sean' wrote:
>
> With today's unlimited availability of disk space and silly-low cost per GB
> for storage, would an argument to dispense with the delta and simply store a
> full copy of the record (not including BLOB) be worthy of discussion?
It's not about storage
08.06.2016 11:36, m.djo...@yahoo.com wrote:
>
> First I thought it's because of the results' type after the different
> operations, but even in cases when the result before ROUND is a DOUBLE
> PRECISION (according IBExpert) the round gives different results if the
> NULL in the COALESCE function
03.06.2016 17:59, Svein Erling Tysvær wrote:
>
> I simplified the query to
>
> WITH TMP( TJENESTEENHETRESHID, TJENESTEENHETLOKAL, IMPORT_DATO ) AS
> ( SELECT TJENESTEENHETRESHID, TJENESTEENHETLOKAL, MAX( IMPORT_DATO )
> FROM NPR
> WHERE TJENESTEENHETRESHID > 0
> AND
03.06.2016 11:27, Svein Erling Tysvær wrote:
> This query:
> WITH TMP( TJENESTEENHETRESHID, TJENESTEENHETLOKAL, IMPORT_DATO ) AS
> ( SELECT TJENESTEENHETRESHID, TJENESTEENHETLOKAL, MAX( IMPORT_DATO )
> FROM NPR
> WHERE TJENESTEENHETRESHID > 0
> AND TJENESTEENHETLOKAL > ''
> GROUP
03.06.2016 05:24, trsk...@yahoo.com wrote:
>
> 1) Since FB 3.0 support WireCompression, should I still use Zebedee?
No point anymore.
> 2) Is that possible to hide stored procedure/trigger codes in FB 3.0 ?
> Usually I used this statement :
>
> UPDATE RDB$TRIGGERS a set a.RDB$TRIGGER_SOURCE =
14.06.2016 15:52, fabia...@itbizolutions.com.au wrote:
> 1) The variable "RemoteBindAddress" in firebird.conf is a Server Wide
> value, or it can be set per database in databases.conf?
Server wide.
Dmitry
26.05.2016 14:50, dondondonje...@yahoo.com wrote:
>
> "C:\Program Files\Firebird\Firebird_3_0\gbak.exe" -b -v -t -se
> service_mgr employee e:\xxx.bak -user SYSDBA
> works if no one is connected else i always get error "file is used by
> another process".
gbak.exe -b -v -t -se
02.06.2016 03:44, trsk...@yahoo.com wrote:
>
> Am I correct that maximum allowed RAM for database cache on SS FB 3.0 in
> Win64 is only 2 GB? Calculated from max DefaultDbCachePages (131072) x
> max Page Size (16384) = 2 GB.
Correct for 32-bit builds. 64-bit builds don't have such a limit.
>
02.06.2016 07:42, trsk...@yahoo.com wrote:
>
> I have a table with existing data & got a problem to add field that must
> have a value -> alter table Tbl1 add Fld1 int not null.
What value must it have? Add a default clause to this statement. Or add
the field as nullable, populate with data and
01.06.2016 04:16, Fabian Ernesto Chocron wrote:
>
> We are having trouble setting up the database cache size on FB 3.0
> running on Windows 2008 R2 64 bits with 32 GB ram.
>
> The problem we have is we cannot get the server to allocate the ram for
> the cache as we intend. With FB 2.54 we had the
13.06.2016 00:18, 'livius' wrote:
>
> what are + and – with working with schema?
> What benefits are between
> schema_name__table_name and real schema implementation?
> schema_name.table_name
Ability to have a default schema (per user, per connection). So that you
may have multiple completely
22.06.2016 11:25, 'Martijn Tonies wrote:
>
> Firebird 3 fails to back up when the database is in use
It does not, as long as you don't use a "hostless" connection string.
Dmitry
22.06.2016 12:49, 'Martijn Tonies wrote:
>
>> I understood you as that regular gbak does not work when the database is
>> in use, so now you try the -se switch.
>
> That is correct, but as you can see, using -se resulted in an error.
So what was the error using gbak without -se? And what was the
1 - 100 of 189 matches
Mail list logo
