;
> There is a HASH function but only for string.
It works for blobs as well.
Dmitry
--
Tim Ward
dcc32 Hint] Project1.dpr(14): H2077 Value assigned to 'x' never used
(Line 14 is the one assigning zero.)
On Thu, 09 Feb 2017 04:30:06 -0500 *Tim Ward t...@telensa.com
[firebird-support] * wrote
It' the equivalent in a conventional programming language of sayi
stem to evaluate the *intent* of logic.
That is completely outside the purview of any application
environment that I know.
The only thing that a system can check/enforce is the correctness
of the code, not to check whether the developer has 2 brain cells.
Sean
--
Tim Ward
nction churns away and returns some number which you can't tell by
looking at it whether it's right or not.
--
Tim Ward
u can have fun when one of your production databases has
patterns of data that weren't included in your test data sets.
--
Tim Ward
On 13/01/2017 14:04, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 13.01.2017 13:09, Tim Ward t...@telensa.com [firebird-support] wrote:
>> I just don't believe this. Can anyone make any other suggestion as to
>> what is going on?
> Is timezone on
Brazilian time and sometimes the UK time.
I just don't believe this. Can anyone make any other suggestion as to
what is going on?
On 13/01/2017 11:21, Tim Ward wrote:
> On 12/01/2017 14:09, Tim Ward wrote:
>> Sorry if this is a really basic question, but some time spent
>>
On 12/01/2017 14:09, Tim Ward wrote:
> Sorry if this is a really basic question, but some time spent
> searching has failed to find for me the definitive detailed
> documentation on exactly how Firebird handles time zones (I'm
> particularly interested, to start with, in using
, and later reading it out and using it to display in a UI, but
that's only to start with).
Can someone point me in the right direction please?
--
Tim Ward
ction time to the db
05.01.2017 14:40, Marianne Castel - Titelive caste...@titelive.be
[firebird-support] wrote:
> Has somebody an idea, where is the sytem loosing time ?
Most often (x)inetd waste time trying to identify client by ident
protocol or reverse DNS to get host name.
--
WBR, SD.
--
Tim Ward
m subject?
>
> I would prepare myself for a table that grows rapidly.
>
> Is the same in FB 2.5.6 or 3.0.1?
>
> Thanks
--
Tim Ward
++
a half-second delay before data got flushed to disk, as an
optimisation in case you were just about to write something else. (Which
could, once you'd discovered what was going on, which might take a few
days or weeks, be turned off.)
I don't however expect to see exactly the same probl
collection for your deleted rows being done?
--
Tim Ward
ts of
selects and never does a commit it'll quite likely all be in one
transaction which can produce the symptoms you describe.
--
Tim Ward
... but having restored the database from backup the problem appears to
have gone away.
On 12/07/2016 12:52, Tim Ward wrote:
There was plenty of space on the disk partition containing the database.
But there had at some point been a disk full on some other partition.
So, having run out of
other partition filled up.
On 12/07/2016 12:50, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
W dniu 2016-07-12 11:54:52 użytkownik Tim Ward t...@telensa.com
[firebird-support] na
when run
against a 64 bit 2.5 database. What's going on please?
--
Tim Ward
circumstances - that's not terribly helpful
if all the process names are "python" and all the IP addresses are
"127.0.0.1", for example.
--
Tim Ward
sing different users. This means that
poking around in the database to see what's going on (performance,
long-lived transactions, etc) is a bit easier - we can instantly see
which process is doing what, as the users are named after the processes.
--
Tim Ward
effect on existing connections, or something?
--
Tim Ward
batch processes, so if we poke around in the database we can
see at least which part of the system any problematic (eg very long
running) user sessions or transactions or queries belong to.
--
Tim Ward
p and restore process)
B. table will be 100GB and in db will be 100GB free pages? (db size
will be 300GB and i need to bakup and restore?)
what is the answer for this A or B?
regards,
Karol Bieniaszewski
--
Tim Ward
sidered the possibility of
machine-generated code they might have reached a different decision
about the second parameter, or even the first, being mandatory?)
I'm just pointing out the typo in the book - there's no closing square
bracket
having first checked that
it doesn't exist, which it doesn't as far as transaction B is concerned,
because transaction A hasn't committed yet)
results in the error.
Have I remembered this behaviour of primary keys correctly? Please could
someone remind me where the documentation is if so?
--
Tim Ward
t's how it works - there's no overhead because
there's no concept of doing anything without a transaction.
--
Tim Ward
an characters, like ş and ţ.
As far as I can see, those characters do not exist in the Windows 1251
character set, so isn't the error message simply telling the truth?
--
Tim Ward
ansaction *is*
a potential performance problem, I imagine I can get rid of it simply by
doing "ibase_commit();" at the start of the PHP script?
--
Tim Ward
gbak:adjusting an invalid decompression length from -33 to -19
gbak: ERROR:value exceeds the range for valid timestamps
gbak: ERROR:gds_$send failed
gbak:Exiting before completion due to errors
Anyone any idea what any of that means?
--
Tim Ward
slightly different output and will not be researching it any further.
--
Tim Ward
code in the two different
versions of the library called by the UDF.)
--
Tim Ward
prevented the corruption event?
Thanks
--
Tim Ward
but with the 3 clients on LAN works
> very bad. It is very very slow to open and navigate a simple table with
> less of 5.000 rows!
>
> What i can do?
What are your queries, query plans, quer
n C/C++ accessing the database, partly
direct queries and partly stored procedure calls, as well as user
interface accesses via PHP. (Oh, and possibly some Python processes and
other stuff, but it's the interaction between a couple of the C/C++
processes that is currently confusing us.)
--
Tim Ward
hough you should, as vast
numbers of other tools understand it), you can add whatever custom
resources you like.
--
Tim Ward
("resource") and you're /supposed/ to use it properly.
Pity this doesn't apply portably to all file types, innit.
--
Tim Ward
Thanks for the replies.
Don't worry folks, I'm not going to try this, I was just curious.
Yes I do know it's not a real deadlock, I was using the word because I
knew it would be understood and because, I'm pretty sure?, I've seen it
in one of the relevant erro
's no reason why this shouldn't work, as either way the
record is going to end up deleted, which is what the user wants, but
would I be right in guessing that Firebird isn't that clever, and that
deadlocks are possible in this scenario?
--
Tim Ward
this error. Restart it, and it runs fine. Until
the next time.
--
Tim Ward
WHERE ACCT_CASE_COURT_ID = :iAcctCaseCourtID
ORDER BY ACCT_CASE_COURT_HIST_ID
INTO :ACCH_LEGAL_CASE_DATE, ACCH_NOTE;
IF (V_REPORT = 1) THEN
SUSPEND;
ELSE
UPDATE ACCT_CASE
SET LEGAL_CASE_DATE = :ACCH_LEGAL_CASE_DATE
WHERE ACCT_ID = :ACCT_ID
AND CASE_ID = :CASE_ID;
END
END
end ^^
SET TERM ; ^^
[Non-text
(I have asked a similar question some time ago but didn't end up with
any actual diagnosis of our problem.)
--
Tim Ward
++
Visit http://www.firebirds
ebird-support] wrote:
Hi Tim,
Thanks for the reply. You mentioned that you did it with a logging
procedure. Can you share what you exactly what you did to accomplish
this?
Mike
--
Tim Ward
twiz...@att.net [firebird-support] wrote:
Greetings All,
Firebird 2.5.4
I would like to know if there is any way that I can retrieve the
execution time of each SQL SELECT or EXECUTE PROCEDURE within a stored
procedure?
Any tool to accomplish this?
Thanks,
Mike
--
Tim Ward
e ORDER BY (under
the control of the user, remember) are ASC and some DESC?
I think we'll have to continue to think about it!
On 06/10/2015 21:50, setysvar setys...@gmail.com
<mailto:setys...@gmail.com> [firebird-support] wrote:
Den 06.10.2015 17:38, skrev Tim Ward t...@telensa.com
control of the user, remember) are ASC and some DESC?
I think we'll have to continue to think about it!
On 06/10/2015 21:50, setysvar setys...@gmail.com [firebird-support] wrote:
Den 06.10.2015 17:38, skrev Tim Ward t...@telensa.com [firebird-support]:
> Given that a query needed to retu
s of
pages of data to the grid sequentially until the right record appears is
not a reasonable solution! ID may or may not be the primary key, but we
can use an indexed unique field if that helps.
--
Tim Ward
rophe (millions of times slower if you're
really lucky). If that's your situation you may be better off deleting
and recreating.
--
Tim Ward
ction) and sort
the results
Nick Upson, Telensa Ltd, Senior Operations Network Engineer
direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200
On 9 September 2015 at 13:00, Tim Ward t...@telensa.com
<mailto:t...@telensa.com> [firebird-support]
<mailto:firebird-support@yahoogro
are there other
possibilities? I must say that
Oldest transaction390433636
Oldest active390433637
Oldest snapshot390433637
Next transaction391092651
doesn't look too encouraging, so I'd better investigate that.
--
Tim Ward
m with a change of approach, that's needed for other
reasons anyway, which eliminates the problem query.)
--
Tim Ward
. I can get why
the error is there, but any other suggestion?
with
CTE1 as
(
select 1 as ID from rdb$database
),
CTE2 as
(
select 2 as ID from rdb$database
),
COMBINED as
(
select * from CTE1
union
select * from CTE2
)
select * from CTE1
--
Tim Ward
*any* system using *any* tools is pointless
if you don't do regular test restores.
--
Tim Ward
ON
T2.TABLE_1_ID = T1.ID
After executing this query I am getting such plan:
PLAN JOIN (T1 NATURAL, T2 INDEX (FK_TABLE_2))
Why in case of TABLE_1 optimizer did not chose index PK_TABLE_1? And
why I am getting error when i try to enforce it with:
PLAN JOIN (T1 INDEX (PK_TABLE_1), T2 INDEX (FK_TABLE_2))
Thanks for any clues.
--
Tim Ward
, foreign keys, procedures, ...).
--
Tim Ward
o my question, re a process which keeps a
connection open permanently and repeatedly re-runs the same procedures
in different transactions? Does it need to drop and recreate the
connection in order to take account of any SET STATISTICS done by other
people, or not?
--
Tim Ward
On 14/04/2015 11:39, Tim Ward wrote:
If SET STATISTICS is done on one connection, when does it take effect?
What about a transaction that was already running at the time someone
else did SET STATISTICS, does that use the new statistics for any new
statements it runs (where all the code
a connection that was already in existence at the time
someone else did SET STATISTICS, does that use the new statistics for
any new transactions it runs (where all the code running is in stored
procedures)?
--
Tim Ward
phical drill-down calling tree like the ones you get from
profilers for conventional languages.
--
Tim Ward
--
Tim Ward
0" wouldn't get optimised out by constant folding, so it's not
something I'd have thought of trying for myself!
--
Tim Ward
itted stuff?
(Yes I do know that's what generators are for.)
--
Tim Ward
elds to be significant, it looks like.
--
Tim Ward
++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and othe
On 31/03/2015 20:00, Ann Harrison aharri...@ibphoenix.com
[firebird-support] wrote:
> On Mar 30, 2015, at 7:01 AM, Tim Ward t...@telensa.com
[firebird-support] wrote:
>
> Sorry about this, but I really can't work out what's going on here, and
> could do with some clue
con11/FbCon2011-Charsets-Heymann.pdf,
but that doesn't help - it suggests that Firebird will transliterate as
necessary, but padding an eight character string with 24 spaces
efully designed canonical
string representation, as the last stage of a potentially long and
complex sequence of operations.
I've never seen anyone go to remotely as much trouble to get this stuff
right since then. I can't, however, see such an approach having a
problem with the example above.
--
Tim Ward
On 24/03/2015 18:27, Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] wrote:
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
&
about anyway, but that's only because I happen to be lucky with the
data structures, it won't be a solution in general.
[#] 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.
--
Tim Ward
out the dependencies,
which really are a database internal gubbins issue that the database
should look after.
--
Tim Ward
this is a deliberate feature! - and I
must say it does rather look slightly more like an accident of
implementation than a deliberate feature to me.
--
Tim Ward
t-asleep snail" or "we do that all the time, there's no performance
issue in practice, setting up the connection is a fraction of the cost
of running a statement that actually does anything".
--
Tim Ward
ation first
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-psql-execstat.html
Regards,
Vlad
--
Tim Ward
arting a new server process, so it can't be *that* cheap?)
--
Tim Ward
course no such thing as a theoretically
perfect query optimiser.)
--
Tim Ward
s with radically different types of workload?
Or have I completely misunderstood the whole business?
--
Tim Ward
On 17/02/2015 09:44, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
On Tue, 17 Feb 2015 09:41:56 +, "Tim Ward t...@telensa.com
[firebird-support]" wrote:
> Why?? Why does that have to be a failure?? Why can't Firebird just
> ignore it??
>
> Is t
that isn't actually used anywhere. I've now got to fix that code to be
extremely careful about *ex*cluding unneeded CTEs - it's currently aimed
at being extremely careful to *in*clude CTEs that *ar
to be
portable between database engines.
--
Tim Ward
++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ a
descending index
> instead of sorting all the resulting rows?
> I am using Firebird 2.1 on Windows.
>
> Thanks in advance.
>
> Fulvio Senore
--
Tim Ward
+
r the decades, that SQL is not very good at
being time series.)
--
Tim Ward
the meaning of the query should not affect the
output of the optimiser), but this doesn't (always?) seem to be what's
happening.
--
Tim Ward
ever seen any
other behave like this one.
--
Tim Ward
ending XML
data to PHP scripts, it's not assuming an internet connection more than
once a day.
--
Tim Ward
river?
Agree with the other responses. We're doing this by having the Android
app access a URL on our server and send or receive an XML file which are
processed into and out of the database by serve
On 13/12/2014 09:14, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
On 12-12-2014 15:38, Tim Ward t...@telensa.com [firebird-support] wrote:
> On 12/12/2014 14:15, Mark Rotteveel m...@lawinegevaar.nl
> [firebird-support] wrote:
>>
>> What is the default cha
UTF8. Connection charset appears also to be UTF8.
--
Tim Ward
#x27;ve got a record which appears to have 'A' in this field.
But when I do a "SELECT * FROM ..." (from PHP using ibase_fetch_assoc) I
don't get the string
'A'
I get the string
'A '
(three spaces after the A). Yes this may be a PHP question, but just in
case it isn't, any ideas?
--
Tim Ward
to run. Does such a thing exist?
--
Tim Ward
often" but still gets it wrong sometimes
- there are dozens of languages all with slightly different rules for
regular expressions, it's not a surprise if any non-trivial regular
expression needs changing between languages, you just have to read the
rules for the new language.
--
Tim Ward
This email is free from viruses and malware because avast! Antivirus
<http://www.avast.com/> protection is active.
--
Tim Ward
ith the garbage.)
--
Tim Ward
irebird] SQL Error
SQL error code =-104
Invalid expression in the select list (not contained in either an
aggregate function or the GROUP BY clause)
Any advice is welcomed as this has me stumped as well as my SQL expert
mate
Thanks
Andy
--
Tim Ward
the result set.)
So, my questions:
(1) Have I got this right? Is the second query a correct expansion of
COALESCE that produces the same results as the first query?
(2) If so, is it indeed the case that the optimiser doesn't understand
how to expand COALESCE?
--
Tim Ward
with IBExpert but we are looking for a pure firebird sql solution. We
are using Firebrd 2.5.
Any pointers on how to do this will be much appreciated.
Regards,
-Ed
--
Tim Ward
;SELECT * FROM TABLEA" as part of the cleanup job, thus putting the
cost back with its owner. In other words you can't delay the garbage
collection, but you can make it happen earlier so that it's predictable.
--
Tim Ward
inux - you get the "file not found" message
when actually what it should say is "access denied".
--
Tim Ward
On 26/06/2014 12:58, Thomas Beckmann thomas.beckm...@assfinet.de
[firebird-support] wrote:
> userClause is probably null. Then the entire string will be null.
>
> Am 25.06.2014 16:08, schrieb Tim Ward t...@telensa.com [firebird-support]:
>>
>>
>> Anyone know what this erro
-2014 16:08, Tim Ward t...@telensa.com [firebird-support] wrote:
> Anyone know what this error message actually means?
May I suggest that you also include the error in the message body, when
reading e-mail on a mobile device, long subject lines have a tendency to
get truncated.
(The error in t
uot;argument", and the only reason I can think of that it might not
be a string - despite obviously looking like one!! - is that elementId
is null (neither of the other variables can ever be null). Does that
make sense?
--
Tim Ward
On 23/06/2014 13:12, Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] wrote:
23.06.2014 14:48, Tim Ward t...@telensa.com [firebird-support] wrote:
>
> I've got an INSERT statement like:
>
> INSERT INTO ( )
> SELECT
> FROM
> WHERE RETURNING generated_
Thanks - the procedure does actually compile if I do that, which is a
good indication! (I can't actually try running it just yet.)
On 23/06/2014 13:12, Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] wrote:
23.06.2014 14:48, Tim Ward t...@telensa.com [firebird-support]
Hi,
I see that this has been discussed before, but the only discussions I
could find were in Russian and I was not able to understand them.
I've got an INSERT statement like:
INSERT INTO ( )
SELECT
FROM
WHERE
On 27/05/2014 16:17, jakef...@yahoo.com [firebird-support] wrote:
In general, does it make a difference whether the filter conditions
are in the JOIN or WHERE clause?
In particular, if there are outer joins you can get different results.
--
Tim Ward
1 - 100 of 151 matches
Mail list logo