a "good" coder,
you document the business logic in SPs and Triggers with at least some comments
(and sometimes withoutthose comments it's hard to tell what the code is really
doing ;-) ).You can reverse-engineer the SQL from BLR, but not those
comments(!).cheers,Frank
---
Nutze
tdown, isc_dpb_shut_attachment |
isc_dpb_shut_single);
dpb.insertInt(isc_dpb_shutdown_delay, 0);
Any ideas are welcome.
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets."
On 27/06/12 11:45, Alex Peshkoff wrote:
> On 06/25/12 16:52, Frank wrote:
>> Any ideas are welcome.
>>
>
> Frank, is this error still reproduced?
No, it is gone, must have been a real rare race condition.
> If yes - can you provide me remote access to that box? (reviewi
On 16/07/12 10:05, Mark Rotteveel wrote:
> On Mon, 16 Jul 2012 01:01:31 +0200, Roman Rokytskyy
> wrote:
>> - should be integrated with Eclipse at least on the same level as CVS.
>
> The latest versions of Eclipse supports git and the Eclipse project itself
> has moved all their code to git, so I
LATION_NAME
-At line 8, column 32
in head.
I'm not sure whether this is a bug or a new restriction according to
some obscure standard.
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithf
On 23/10/12 11:21, Kjell Rilbe wrote:
> Den 2012-10-23 10:32 skrev Frank såhär:
>> select R1.RDB$RELATION_NAME
>> from RDB$RELATION_FIELDS F1
>> join RDB$RELATIONS R1 on F1.RDB$RELATION_NAME = R1.RDB$RELATION_NAME
>> where F1.RDB$FIELD_NAME ='EMP_N
On 23/10/12 11:24, Dmitry Yemanov wrote:
>
> It smells like a bug caused by the new restriction ;-)
> I will investigate that, thanks.
>
thank you
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and
from RDB$RELATION_FIELDS F2
> where F2.RDB$FIELD_NAME ='PHONE_EXT'
> and F2.RDB$RELATION_NAME=R1.RDB$RELATION_NAME
> );
Sure, but this query doesn't throw the error I wanted to demonstrate :-)
Frank
--
"Fascinating creatures, phoenixes,
ill vanish when
these issues are fixed, I didn't create an tracker entry for our
original problem.
hth
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pe
On 11/20/2012 11:03 AM, Dmitry Yemanov wrote:
> 20.11.2012 13:53, Frank Schlottmann-Gödde wrote:
>>
>> I asked this in the support list, but got no answer:
>
> First of all, what FB version are you talking about?
>
Sorry,
2.5.2.26510 and 3.0.0.30126
Frank
--
On 11/20/2012 10:53 AM, Frank Schlottmann-Gödde wrote:
> Hi,
> I asked this in the support list, but got no answer:
>
>
> I do not understand why
>
> set planonly;
> with recursive
> CTE_CNT1 as (select 0 as I
> from RDB$DATABASE
> union all
On 12/01/2012 02:49 PM, Vlad Khorsun wrote:
> I think, this is a bug.
I added it to the tracker.
kind regards
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets."
-
ation). When recovering from such an exception, a deadlock will
occur. Is there any reason why fbclient should not be built using the
asynchronous exception model (i.e. using the /EHa option)?
Thanks,
Frank
--
Benefiting
.. e) ?
(i'm VERY interested in the "(...)" part of option d) as well as
everything in option e) :-) )
cheers,
Frank
--
All the data continuously generated in your IT infrastructure
contains
st" - which is where it hits the hard-coded limit
for the maximum recursion depth i guess. The good news: it doesn't
crash the server, so you can try again :-)
cheers,
Frank
--
All the data continuously generated i
Hi Adriano,
Am 21.11.2011 20:04, schrieb Adriano dos Santos Fernandes:
> On 21/11/2011 16:45, Frank Ingermann wrote:
>> So this would mean option b) is correct:
>>
>> b) [ ] window functions are not supposed to work in the "child select"
>> part o
ese lines. ( Security/grants will have to be
carefully considered here, obviously! :-) )
Does the "standard" say anything about these things?
cheers,
Frank
--
All the data continuously generated in your IT i
Hi Helen e.a.,
Am 30.11.2011 19:32, schrieb Helen Borrie:
>>>On 11/30/11 02:42, Frank Ingermann wrote:
>>>> DROP SOURCE OF [||*]
>>>> or
>>>> CHANGE OWNER OF [|*] TO
>> I don't think bloat the language with non-standard syntax for
>
Hi Claudio,
>> From: Frank Ingermann [mailto:fr...@fingerman.de]
>>
>> Still i think it's a no-go to just take the ability _away_ to
>> clear out those sources. It IS common practise.
(+1 for the COMMENTs!)
> The problem is that we lack equivalent commands for
Hi Adriano,
Am 04.12.2011 19:36, schrieb Adriano dos Santos Fernandes:
> On 30-11-2011 23:36, Adriano dos Santos Fernandes wrote:
>> On 16-11-2011 22:39, Frank Ingermann wrote:
>>> Hi all,
>>>
>>> i'm trying to combine the new Window functions in Fb3 w
Hi Frank,
Am 29.11.2012 07:51, schrieb Frank:
> On 11/20/2012 10:53 AM, Frank Schlottmann-Gödde wrote:
>
> No idea, anybody?
>
Isn't it so that a CTE Select can only have one recursive member?
(at least that's what i remember from Vlad's presentation back
in Bergamo, b
Hi Frank,
Am 30.11.2012 17:42, schrieb Frank Schlottmann-Gödde:
> On 29.11.2012 11:08, Frank Ingermann wrote:
>> Isn't it so that a CTE Select can only have one recursive member?
> I don't think so, because the construct we have problems with, already
> contains two
ll put that in a list for a
> possible pro/con discussion.
And they should better be distinct :-)
mit freundlichen Grüßen
Frank Schlottmann-Gödde
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly f
many databases)
I hope I can switch from our udf to built in uuids in the near future.
mit freundlichen Grüßen
Frank Schlottmann-Gödde
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly f
p after using a hex-editor to rename
rdb$admin to e.g rdbxadmin.
mit freundlichen Grüßen
Frank Schlottmann-Gödde
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly fa
x27;D':
+ QLI_nod = true;
+ break;
+
+
case 'F': // fetch password
{
if (argv >= arg_end || **argv == '-')
On 09/01/12 07:41, Alex Peshkoff wrote:
> On 01/06/12 20:18, Michal Kubecek wrote:
>> Hello,
>>
>> HEAD currently doesn't build on Linux if LibTomMath is not installed
...
> Builtin source is added only to make windows happy. On linux we should
> always use system library.
It is not available out
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/01/12 08:49, Alex Peshkoff wrote:
> On 01/09/12 11:27, Frank Schlottmann-Gödde wrote:
>> On 09/01/12 07:41, Alex Peshkoff wrote:
>>> On 01/06/12 20:18, Michal Kubecek wrote:
>>>> Hello,
>>>>
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/01/12 10:42, Philippe Makowski wrote:
> Frank Schlottmann-Gödde [2012-01-09 10:26] :
>> You could argue that this is too old to run Firebird 3.0
> yes like RHEL5 is too old too
> you can try to backport the package from Ubun
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/01/12 12:30, Alex Peshkoff wrote:
> On 01/09/12 13:26, Frank Schlottmann-Gödde wrote:
>
>> E: Couldn't find package libtommath-dev
>
> Yes, libtommath is relatively new library, better say - it became enough
> pop
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/01/12 15:34, Alex Peshkoff wrote:
> On 01/09/12 18:30, Frank Schlottmann-Gödde wrote:
>
>> Oldest still active server has glibc 2.6.1
>
> Very interesting. We did not have reliable information, does it work
> with FB 2.5
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/01/12 12:30, Alex Peshkoff wrote:
>
> Installing library from source is certainly possible.
I had to change makefile a bit to get it installed:
I replaced GROUP=wheel with GROUP=root
and added -fPIC to CFLAGS.
fsg
-BEGIN PGP SIGNATUR
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/01/12 08:13, Alex Peshkoff wrote:
> On 01/09/12 18:45, Frank Schlottmann-Gödde wrote:
>
>>> Anyway - I suppose that for FB 3.0 it will be much better to upgrade
>>> servers. Moreover, for the time of release of FB
Hi,
I'm trying to compile head with --with-editline=yes and get the
following linker error:
g++-pthread -Wl,-rpath,'$ORIGIN/../lib'
-Wl,-rpath,'$ORIGIN/../intl' -Wl,--version-script,empty.vers
/home/fsg/src/fbbuild/build_posix/firebird2/temp/Release/isql/ColList.o
/home/fsg/src/fbbuild/buil
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/01/12 09:25, Michal Kubecek wrote:
> You can try this patch:
>
> (3.0)
> https://api.opensuse.org/public/source/home:mkubecek:firebird30/firebird/firebird-3.0.0-libs.patch?rev=ce5aa283de19c37aa77873e4f2fc1cc6
>
> (2.5)
> https://api.opensuse
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/01/12 10:14, Frank Schlottmann-Gödde wrote:
> Thank you, Alex and Michal, I will try your suggestions this evening and
> report back.
- - $(EXE_LINK) $(EXE_LINK_OPTIONS) $^ -o $@ $(FIREBIRD_LIBRARY_LINK)
$(LINK_LIBS) $(LIBED
On 19.01.2012 09:14, Claudio Valderrama C. wrote:
>> -Original Message-
>> From: Frank Schlottmann-Gödde [mailto:fr...@schlottmann-goedde.de]
>> Sent: Viernes, 09 de Diciembre de 2011 12:47
>>
>> I would like to see a switch added to qli to stop it fro
n't know
> where it's coming from. Any help here would be greatly appreciated.
in /builds/install/arch-specific/darwin/Makefile.in are lots of
invocations of "sed -e", so the resulting Makefile should have them
also. I can't check it, as I don't have a Mac at han
than UTF8 and ISO8859_1.
Here is what i have so far:
You may ignore the SWITCH_NOHEADINGS part.
mit freundlichen Grüßen
Frank Schlottmann-Gödde
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they ma
Hi,
while trying to get our admittedly not so trivial database running under
FB3.0 I ran into some more bugs/issues.
I don't know whether to discuss them here first or directly create
issues in the tracker?
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely h
Am 24.10.2012 10:19, schrieb Mark Rotteveel:
> On Wed, 24 Oct 2012 10:05:10 +0200, Frank Schlottmann-Gödde
> wrote:
>> Hi,
>> while trying to get our admittedly not so trivial database running under
>> FB3.0 I ran into some more bugs/issues.
>>
>> I don'
s with
PLAN (CTE_CNT2 RDB$DATABASE NATURAL, CTE_CNT2 CTE_CNT1 RDB$DATABASE
NATURAL, JOIN ())
Frank
-- "Fascinating creatures, phoenixes, they can carry immensely heavy
loads, their tears have healing powers and they make highly faithful
pets
On 29.11.2012 11:08, Frank Ingermann wrote:
> Hi Frank,
>
> Am 29.11.2012 07:51, schrieb Frank:
>> On 11/20/2012 10:53 AM, Frank Schlottmann-Gödde wrote:
>>
>> No idea, anybody?
>>
> Isn't it so that a CTE Select can only have one recursive member?
I don&
is finally useable as a drop-in replacement for the extern/editline stuff.
Just replace the contents of extern/editline with the archive above,
apply the attached patches, configure with --with-editline=yes and you
will get an isql with UTF8 enabled line editing.
Frank
--
"Fascinating c
Am 05.08.2013 09:23, schrieb Alex Peshkoff:
> Does 'Del' key work?
Yes, only Ins, Pageup and Pagedown show '~' instead of doing sth.
useful, but this is the same as with the old editline version.
Frank
--
"Fascinating creatures, phoenixes, they can carry immensel
could be fixed by either including editline to the autogen.sh
script or adding calls to autoreconf etc. to Makefile.in.extern.editline.
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healin
Am 03.09.2013 09:13, schrieb Michal Kubecek:
> On Tue, Sep 03, 2013 at 07:14:45AM +0200, Frank Schlottmann-Gödde wrote:
>> On 02.09.2013 17:04, Alex Peshkoff wrote:
>>>
>>> I think that all distros, not debian only, support fresh editline
>>> library. An
Am 03.09.2013 09:08, schrieb Alex Peshkoff:
> On 09/03/13 09:14, Frank Schlottmann-Gödde wrote:
>> On 02.09.2013 17:04, Alex Peshkoff wrote:
>>> On 09/02/13 16:06, marius adrian popa wrote:
>>>> libedit will be updated and patched for 2.5.x branch also ?
>>
Am 03.09.2013 10:02, schrieb Alex Peshkoff:
> The main reason why do we include libedit at all is licensing
Yes we had a discussion on this topic with a debian maintainer back in
2002 when we had to replace calls to readline with editline.
> - built
> into all known to me distros libreadline (it
Am 03.09.2013 10:47, schrieb Alex Peshkoff:
> On 09/03/13 11:43, Frank Schlottmann-Gödde wrote:
>
> To be precise I'm not sure why did that guy need automake at all :-)
> It's required only if one touch Makefile.am. For regular builds existing
> in the tree configure is
Am 10.09.2013 23:34, schrieb Ann Harrison:
> On Tue, Sep 10, 2013 at 5:23 PM, Vlad Khorsun
> mailto:hv...@users.sourceforge.net>> wrote:
>
>
> >
> > First, thanks for the details (BTW, is there a link for the spec)
>
> AFAIR, SQL standard is not free, so there is no link for free
On 03.09.2013 10:47, Alex Peshkoff wrote:
> On 09/03/13 11:43, Frank Schlottmann-Gödde wrote:
>
>> Hm, I had to run autoreconf etc. on it to build it on Ubuntu 8.04
>>
>
> Did you try with initial package or with one we have in the tree?
> Must say I've generated c
Am 05.05.2014 08:48, schrieb Molnár Attila:
>> I believe that there are UDFs available for this already, no?
> A very old and unsuppoted udf. In my case I do not expect to read back
> from file to DB just one way.
It's old but not unsupported :-)
And works as expected.
ftp://freeadhocudf.org/adh
tribute using git?
The other requests can be handled with svn too.
frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets.&
Am 02.07.2014 04:21, schrieb Adriano dos Santos Fernandes:
> Frank,
>
> Please don't mess with obj.h for ISQL support.
>
> I think you should do it different, for example, passing extra
> parameters instead of the new constants.
I will m
Am 02.07.2014 04:50, schrieb Claudio Valderrama C.:
>
> I have my reservations about the extraction order, but since I didn't try, I
> didn't voice my concern yet. This was the old order:
> list_functions();
> list_generators();
> list_domains(default_char_
Am 02.07.2014 12:41, schrieb Adriano dos Santos Fernandes:
> On 02/07/2014 04:40, Frank Schlottmann-Gödde wrote:
>> Am 02.07.2014 04:21, schrieb Adriano dos Santos Fernandes:
>>> Frank,
>>>
>>> Please don't mess with obj.h for ISQL support.
>>>
&
ideas?
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets."
- J.K. Rowling
--
Meet PCI DSS 3.0 Complian
On 02.10.2014 20:49, Dmitry Yemanov wrote:
> 02.10.2014 20:18, Frank Schlottmann-Gödde wrote:
>>
>> I'm getting
>> gbak: ERROR:action cancelled by trigger (3) to preserve data integrity
>> gbak: ERROR:object has non-SQL security class defined
>> gbak:E
o recreate the package, as I was not able to assign rights to it
afterwards.
If required, I can provide the fbk too.
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they ma
On 06.11.2014 19:44, Dimitry Sibiryakov wrote:
> 06.11.2014 19:24, Mark Rotteveel wrote:
>> I don't really understand why you would want to disable replication for
>> a single transaction.
>
> There may be a number of reason. The main one is that this transaction is
> performed by
> replicator
Am 29.03.2017 um 18:04 schrieb Dimitry Sibiryakov:
>Hello, All.
>
>Which Pascal compiler is supposed to be used with GPRE'd programs? Is
> there an example
> of a Pascal program with ESQL?
>
From the stone age:
http://firebird.cvs.sourceforge.net/viewvc/firebird/interbase/examples/
ht
Environment: any
Reporter: Frank Schlottmann-Goedde
Priority: Critical
The following statement that used to work in fb2.5 throws an error in 2.5.1:
Here are the results for both versions:
First FB 2.5.0:
SQL> show version;
ISQL Version: LI-P2.5.0.26091 Firebird 2.5
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.2
Environment: Linux x86_64 (tested on Ubuntu 11.10)
Firebird 2.5.2 64bit
Reporter: Frank Schlottmann-Goedde
create a simple freepascal udf:
library test64;
uses
strings;
procedure str_same(instring
Issue Type: Improvement
Components: ISQL
Affects Versions: 3.0 Initial
Environment: probably all
Reporter: Frank Schlottmann-Goedde
Priority: Minor
Using the following script in isql against the employee database shows the
issue:
/*
isql doesn&
ebird Core
Issue Type: Bug
Affects Versions: 3.0 Initial
Environment: probably all platforms (tested on Windows 7.0 and Ubuntu
12.04)
Reporter: Frank Schlottmann-Goedde
Using the following script in isql against the employee database demonstrates
the error
/*
It is no
ebird Core
Issue Type: Bug
Affects Versions: 3.0 Initial
Environment: probably all (tested on Windows 7 and Ubuntu 12.04)
Reporter: Frank Schlottmann-Goedde
Priority: Blocker
Using the following script in isql against the employee database demonst
/CORE-3966
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 Initial
Environment: probably all (tested with Windows 7 and Ubuntu 12.04)
Reporter: Frank Schlottmann-Goedde
Priority: Critical
Using the following script in isql against th
Environment: probably all (tested with Windows 7 and Ubuntu 12.04)
Reporter: Frank Schlottmann-Goedde
Using the following script in isql against the employee database demonstrates
the error
/*
subselect with reference to outer select
fails with:
Statement failed, SQLSTATE = 42S22
ebird Core
Issue Type: Bug
Affects Versions: 3.0 Initial
Environment: probably all (tested with Windows 7 and Ubuntu 12.04)
Reporter: Frank Schlottmann-Goedde
Using the following script in isql against the employee database demonstrates
the error
/*
Creatin
: 2.5.2
Environment: all
Reporter: Frank Schlottmann-Goedde
with recursive
CTE_CNT1 as (select 0 as I
from RDB$DATABASE
union all select I + 1
from CTE_CNT1
where I < 9),
CTE_CNT2 as (select I, 0 as J
from CTE_CNT1
union all select J * 10 + c1.I, c
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1
Environment: all
Reporter: Frank Schlottmann-Goedde
Priority: Blocker
The following script demonstrates the issue
Project: Firebird Core
Issue Type: Bug
Components: GBAK
Affects Versions: 3.0 Alpha 2
Reporter: Frank Schlottmann-Goedde
The following isql script creates a database that can't be restored by gbak:
SET SQL DIALECT 3;
/* CREATE DATABASE 'localhost:C:
73 matches
Mail list logo
