firebird-test — Firebird engine testing, test flight/suite discussion/information

Re: [Firebird-test] Firebird testing tools for Windows

[Jeff J. - S. <J_...@MC...>]

Pavel,

Thank you very much for your assistance.  It has gotten me closer to my
goal (I think).

However, I still am unable to successfully run the qmtest gui.  I will
try to describe all that I have done.

I have installed ActivePython, the PyWin32 extensions, wxPython
(Unicode), KinterbasDB, QMTest, and the Subversion client.

The /Python25/ and /Python25/scripts/ directories are both in the PATH.

I used qadbm to create my test database at c:/fbtest/, and it
successfully copied the tests from your test suite.

In the test directory is a context file (context.txt).  Here are the
contents of this file:

---
temp_directory=c:/fbtest/temp/
server_location=localhost/3040:
database_location=c:/fbtest/temp/ 
suite_database_location=c:/fbtest/fdb/
backup_location=c:/fbtest/fbk/
files_location=c:/fbtest/files/
isc4_path="C:/Program Files/Firebird/Firebird_1_5/security.fdb"
user_name=SYSDBA
user_password=masterkey
isql_path="C:/Program Files/Firebird/Firebird_1_5/bin/isql"
gsec_path="C:/Program Files/Firebird/Firebird_1_5/bin/gsec"
gstat_path="C:/Program Files/Firebird/Firebird_1_5/bin/gstat"
gbak_path="C:/Program Files/Firebird/Firebird_1_5/bin/gbak"
#nbackup_path="C:/Program Files/Firebird/Firebird_1_5/bin/nbackup"
gfix_path="C:/Program Files/Firebird/Firebird_1_5/bin/gfix"
gpre_path="C:/Program Files/Firebird/Firebird_1_5/bin/gpre"
---

Does this look okay?  (I do have Firebird running on port 3040, because
Interbase is running on port 3050.  Also, I don't know if the values for
the paths need to have the double quotes around them, even though they
have a space embedded in them.  What do you think?)

Also in the c:/fbtest/ directory is a .bat file with which I want to run
the GUI.  Here are its contents:

---
cd..
cd /fbtest
qmtest.py gui -C context.txt
---

When I double-click this file, a command window opens, then my browser
(Mozilla Firefox) opens, it waits for a few seconds, then displays the
"Page cannot be displayed" message.  The address in the browser's
address line is:

http://127.0.0.1:1330/test/dir

It seems like I'm getting close, but still no success.  Any suggestions?

Thanks!
 
Jeff
 
-----Original Message-----
From: fir...@li...
[mailto:fir...@li...] On Behalf Of Pavel
Cisar
Sent: Tuesday, March 18, 2008 12:41 AM
To: fir...@li...
Subject: Re: [Firebird-test] Firebird testing tools for Windows

Philippe Makowski napsal(a):
> and you set up qmtest and kinterbasdb

There should be executable Windows installers for both, so installation
should be quite easy.

>> When I try to run the qmtest gui command from the Python prompt
(">>>"),
>> I always get a syntax error.  Since there are no examples to mimic,
it
>> is hard to know what the command should look like.

Don't run it from Python prompt, it has it's own script runnable from
shell. If you don't have c:\Python25\Scripts directory already in your
path, do so. It would make the life easier. If you have installed
ActivePython from ActiveState, you should have associations to directly
run .py and .pyw files. Or you can create a .bat file if you like.

> and if you wanted to create tests, you can use qmedit

Tests could be created, edited, inspected and run in qmtest gui (qmtest
web interface) just fine, but qmedit makes development of
Firebird-related tests more easy (our qmtest extension has a lot of
built-in functionality parametrized by test options. They're harder to
navigate using a web page, so qmedit is specialized editor with more
concise interface). However, it requires wxPython installed (easy and
straightforward using windows installer
(http://www.wxpython.org/download.php, install the unicode version, not
ansi).

best regards
Pavel Cisar
IBPhoenix

------------------------------------------------------------------------
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: [Firebird-test] Firebird testing tools for Windows

[Pavel C. <pc...@ib...>]

Philippe Makowski napsal(a):
> and you set up qmtest and kinterbasdb

There should be executable Windows installers for both, so installation
should be quite easy.

>> When I try to run the qmtest gui command from the Python prompt (">>>"),
>> I always get a syntax error.  Since there are no examples to mimic, it
>> is hard to know what the command should look like.

Don't run it from Python prompt, it has it's own script runnable from
shell. If you don't have c:\Python25\Scripts directory already in your
path, do so. It would make the life easier. If you have installed
ActivePython from ActiveState, you should have associations to directly
run .py and .pyw files. Or you can create a .bat file if you like.

> and if you wanted to create tests, you can use qmedit

Tests could be created, edited, inspected and run in qmtest gui (qmtest
web interface) just fine, but qmedit makes development of
Firebird-related tests more easy (our qmtest extension has a lot of
built-in functionality parametrized by test options. They're harder to
navigate using a web page, so qmedit is specialized editor with more
concise interface). However, it requires wxPython installed (easy and
straightforward using windows installer
(http://www.wxpython.org/download.php, install the unicode version, not
ansi).

best regards
Pavel Cisar
IBPhoenix

Re: [Firebird-test] Firebird testing tools for Windows

[Philippe M. <mak...@fi...>]

Jeff Jones - SHERIFFX  [08-03-17 21.15] :
> Well, let's start at the beginning.
> 
> I have downloaded and/or installed all the applications listed.  I did
> get Python 2.5, so I hope that is not a problem.
> 
and you set up qmtest and kinterbasdb

> I downloaded the test suite from Subversion to a directory on my hard
> drive named SVNRepository.
> 
> I added the Python directory to my PATH, and I can run Python in a
> command window.
> 
> I am able to run the qadbm utility and create a "runnable" test suite
> using the instructions given, but nothing is copied into any of the
> directories.  I don't know if that is correct or not.
> 
no you should get something

here an example :
go to the directory where all tests are

cd /home/test/firebird/firebird/qa/trunk/testsuite

python qadbm.py

QADBM>platform linux
QADBM>target 2.0
QADBM> create /home/test/firebird/test2.1
QADBM> copy /home/test/firebird/test2.1


> Although I can create a context file with all the variables listed,
> there is no indication of where the file should be placed.
> 
where you wanted

> I would try to run a test, but (as far as I know) I haven't created any.
> 
not yet yes

> When I try to run the qmtest gui command from the Python prompt (">>>"),
> I always get a syntax error.  Since there are no examples to mimic, it
> is hard to know what the command should look like.
> 
no to run test you should do the following (example continuing)
cd /home/test/firebird/test2.1
to run all tests :
qmtest run -C /mypath/context.txt

to launch gui
qmtest gui

and if you wanted to create tests, you can use qmedit
you have to launch it from the directory where you have your tests
(you can put if you wanted all the files that are into the qmedit directory from svn into 
the directory where you have you tests)
and then launch qmedit
python qmedit.py

or under windows, I think you can double click on qmedit.py to launch it

now you can see how we wrote tests, and you can get inspiration from that

Re: [Firebird-test] Firebird testing tools for Windows

[Jeff J. - S. <J_...@MC...>]

Well, let's start at the beginning.

I have downloaded and/or installed all the applications listed.  I did
get Python 2.5, so I hope that is not a problem.

I downloaded the test suite from Subversion to a directory on my hard
drive named SVNRepository.

I added the Python directory to my PATH, and I can run Python in a
command window.

I am able to run the qadbm utility and create a "runnable" test suite
using the instructions given, but nothing is copied into any of the
directories.  I don't know if that is correct or not.

Although I can create a context file with all the variables listed,
there is no indication of where the file should be placed.

I would try to run a test, but (as far as I know) I haven't created any.

When I try to run the qmtest gui command from the Python prompt (">>>"),
I always get a syntax error.  Since there are no examples to mimic, it
is hard to know what the command should look like.

So, that is as far as I have gotten.  My frustration tolerance is rather
low after attempting to get this going all of Friday afternoon and
Monday morning, but if you have some suggestions on how to proceed,
please let me know.  I haven't given up yet, but that time may be coming
soon.

Thanks!
 
Jeff Jones
MCSO Technology Bureau
602-876-4048
 
-----Original Message-----
From: fir...@li...
[mailto:fir...@li...] On Behalf Of
Philippe Makowski
Sent: Monday, March 17, 2008 12:30 PM
To: fir...@li...
Subject: Re: [Firebird-test] Firebird testing tools for Windows

Jeff Jones - SHERIFFX  [08-03-17 19.38] :
> 
> I have tried to get QMTest up and running on my Windows XP machine,
with
> no success.  
> 
What problem do you have ?


-- 
Philippe Makowski
http://www.ibphoenix.com
Supporting users of Firebird
Tel +33 (0) 561058813



------------------------------------------------------------------------
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: [Firebird-test] Firebird testing tools for Windows

[Philippe M. <mak...@fi...>]

Jeff Jones - SHERIFFX  [08-03-17 19.38] :
> 
> I have tried to get QMTest up and running on my Windows XP machine, with
> no success.  
> 
What problem do you have ?


-- 
Philippe Makowski
http://www.ibphoenix.com
Supporting users of Firebird
Tel +33 (0) 561058813

Re: [Firebird-test] Firebird testing tools for Windows

[Jeff J. - S. <J_...@MC...>]

Dear all,

 

I have tried to get QMTest up and running on my Windows XP machine, with
no success.  It seems like the instructions at
http://www.firebirdsql.org/index.php?op=devel&sub=qa make a lot of
assumptions about the level of knowledge of the user, assumptions which
are proven invalid in my case.  I am a SQL programmer and database
developer, not a Python programmer.  While Python looks cool, my goal is
not to learn how to install and run Python, or to develop Python
programs.  My goal is to build a testing system for some Firebird
databases.

 

If there is someone who can give me some guidance as to how to set up
QMTest in a Windows XP environment so that I can run it relatively
easily, I would appreciate hearing from you.  If you want to go offline,
that is fine with me, too, although there may be someone else out there
who could benefit from your knowledge.

 

Another alternative is to point me toward a different database testing
package (preferably free or very inexpensive) that will work with
Firebird on a Windows XP platform.  If you have any suggestions, please
let me know.

 

Thanks!

 

Jeff Jones

J_...@mc...

MCSO Technology Bureau

602-876-4048

 

data < information < knowledge < understanding < wisdom

 

 

Re: [Firebird-test] Firebird testing tools for Windows

[Jeff J. - S. <J_...@MC...>]

Okay, the problem was a proxy setting at my end, nothing was wrong at
SourceForge.  I am downloading the files right now.

Thanks!
 
Jeff
 
-----Original Message-----
From: fir...@li...
[mailto:fir...@li...] On Behalf Of
Philippe Makowski
Sent: Friday, March 14, 2008 12:48 PM
To: fir...@li...
Subject: Re: [Firebird-test] Firebird testing tools for Windows

Jeff Jones - SHERIFFX  [08-03-14 19.58] :
> I have downloaded and installed all of the tools listed at
> http://www.firebirdsql.org/index.php?op=devel&sub=qa&id=qmtest_howto,
as
> suggested by Philippe, but I have been unable to download the test
suite
> PROPFIND request failed on '/svnroot/firebird/qa/trunk/testsuite'
> 
perhaps it was a problem at SF
now it seems to work

> Can you help me?
> 
use :
https://firebird.svn.sourceforge.net/svnroot/firebird/qa/trunk/

with this you will get all tools


------------------------------------------------------------------------
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: [Firebird-test] Firebird testing tools for Windows

[Philippe M. <mak...@fi...>]

Jeff Jones - SHERIFFX  [08-03-14 19.58] :
> I have downloaded and installed all of the tools listed at
> http://www.firebirdsql.org/index.php?op=devel&sub=qa&id=qmtest_howto, as
> suggested by Philippe, but I have been unable to download the test suite
> PROPFIND request failed on '/svnroot/firebird/qa/trunk/testsuite'
> 
perhaps it was a problem at SF
now it seems to work

> Can you help me?
> 
use :
https://firebird.svn.sourceforge.net/svnroot/firebird/qa/trunk/

with this you will get all tools

[Firebird-test] Firebird testing tools for Windows

[Jeff J. - S. <J_...@MC...>]

I have downloaded and installed all of the tools listed at
http://www.firebirdsql.org/index.php?op=devel&sub=qa&id=qmtest_howto, as
suggested by Philippe, but I have been unable to download the test suite
(https://firebird.svn.sourceforge.net/svnroot/firebird/qa/trunk/testsuit
e) with Subversion using TortoiseSVN.  I get two error messages:

 

PROPFIND request failed on '/svnroot/firebird/qa/trunk/testsuite'

PROPFIND of '/svnroot/firebird/qa/trunk/testsuite': could not connect to
server (https://firebird.svn.sourceforge.net
<https://firebird.svn.sourceforge.net/> )

 

Can you help me?

 

Thanks!

 

Jeff Jones

 

[Firebird-test] Firebird testing tools for Windows

[Jeff J. - S. <J_...@MC...>]

I have downloaded and installed all of the tools listed at
http://www.firebirdsql.org/index.php?op=devel&sub=qa&id=qmtest_howto, as
suggested by Philippe, but I have been unable to download the test suite
(https://firebird.svn.sourceforge.net/svnroot/firebird/qa/trunk/testsuit
e) with Subversion using TortoiseSVN.  I get two error messages:

 

PROPFIND request failed on '/svnroot/firebird/qa/trunk/testsuite'

PROPFIND of '/svnroot/firebird/qa/trunk/testsuite': could not connect to
server (https://firebird.svn.sourceforge.net
<https://firebird.svn.sourceforge.net/> )

 

Can you help me?

 

Thanks!

 

Jeff Jones

 

[Firebird-test] Firebird testing tools for Windows

[Philippe M. <mak...@fi...>]

Jeff Jones  [08-03-14 19.13] :
> 
> What are the tools you use for Q/A?  Are they free?  Do they run on
> Windows XP?
> 
I will reply here, but please, I suggest that we follow this thread on the firebird-test list

All basic informations are here :
http://www.firebirdsql.org/index.php?op=devel&sub=qa&id=qmtest_howto
and others pages of the Firebird QA

So we are using QMtest and since it is a Python tool, we can use it under Linux, Windows,
MacOsX, Solaris, ...

What it is not said in the web pages, is that Pavel wrote a gui to create tests, and that
he created also a tool to generate html reports for tests results.

So the use of all this is not difficult.
For example, since January two french students that never used Firebird and Qmtest before,
created for us 71 new tests for Fb2.1
(I have to check them and commit them into our svn)

The way the tools are design, there is no problem to use them for your own test, on the
database you wanted.
And if more people use these tools, I hope that in return, they will give us some of their
tests sor we can improve our test suite.
The more tests we make, the more we have chance to give you a robust product.
So you're welcome.
And please come on the firebird-test AT lists.sourceforge.net, we will be pleased to help you.

[Firebird-test] script formatter

[Wiesław P. <wi...@mr...>]

Hi,
I am finishing my work on formatter
for firebird database scripts.
It will be free and open source.
I need scripts to test it.
Can anybody help me with it?
I attached a sample formatted procedure.

regards
Wiesiek

[Firebird-test] Firebird 2.1 Beta 2 Released

[Helen B. <he...@tp...>]

The Firebird Project is pleased to announce the release of the second 
beta of Firebird 2.1, with kits for Win64, Win32, and all x64 and x86 
flavours for Linux. This beta is considered feature-complete and you 
are strongly encouraged to test it heavily and report back.

For downloads, link from 
http://firebirdsql.org/index.php?op=files&id=fb210_beta02

Release notes are available in PDF and HTML.  URL for the HTML:
http://www.firebirdsql.org/devel/doc/rlsnotes/html/rlsnotes21.html

Helen Borrie
for Firebird Project Admins

Re: [Firebird-test] FB2.1 - aggregate function thoughts

[Ann W. H. <aha...@ib...>]

Poul,

    I think that Firebird is behaving consistently and following
the rules of the SQL standard (favoring the latter when the two
conflict).  However, you'll get more informed answers if you
send your question to fir...@ya...


Cheers,


Ann

[Firebird-test] FB2.1 - aggregate function thoughts

[Poul D. <pd...@ta...>]

If I do a=20

1)
select
   a.activity_date,
   sum(a.endtime-a.starttime)/3600 as man_hours_this_day
from activitytable a
group by activity_date

I will get the expected result, i.e. in my case the total man hours =
spent on activities each date.

If I do a=20
2)
select
   a.activity_date,
   CONSTANT + sum(a.endtime-a.starttime)/3600 as man_hours_this_day
from activitytable a
group by activity_date

setting the constant to e.g. 10, there will  be added 10 hours to the =
result each day, just as I expect.

If, however, the constant is defined in a separat table

3)
select
   a.activity_date,
   c.constant + sum(a.endtime-a.starttime)/3600 as man_hours_this_day
from activitytable a
inner join constanttable c on c.id =3D a.constant_id
group by activity_date

then I get the error message

"Invalid expression in the select list (not contained in either an =
aggregate function or the GROUP BY clause)."

If I then add the c.constant to the group by clause
4)
select
   a.activity_date,
   c.constant + sum(a.endtime-a.starttime)/3600 as man_hours_this_day
from activitytable a
inner join constanttable c on c.id =3D a.constant_id
group by activity_date, c.constant

I get the same result as in 1) except that the constant being added to =
each day. Assuming the constant =3D 0 I will get the exact same result =
as in 1).

I would, however, expect that=20

  c.constant + sum(a.endtime-a.starttime)/3600 as man_hours_this_day

is as a whole an aggregate function because a part of it is an aggregate =
function.=20

Is the above correct behaviour of the db-engine?

Kind regards
Poul Dige
Tabulex

Re: [Firebird-test] UDFs in procedure

[Helen B. <he...@tp...>]

At 01:35 AM 11/11/2006, you wrote:
>Hello,
>how to call UDFs function in procedure ?
>
>For example, I would like to create an alias of the UDF ASCII_CHAR  :
>
>
>CREATE FUNCTION CHR(num NUMBER)
>  RETURN CHAR
>   IS chrRet CHAR(1);
>BEGIN
>  RETURN(ASCII_CHAR(num));
>END;
>
>This doesn't work....and I don't know why

Where on earth did you dig up this syntax?  It's not part of 
Firebird's SQL language.

If you want tech support, please don't use this list for it.  This is 
strictly for reporting field test problems and results.  Subscribe to 
the firebird-support list at 
http://www.yahoogroups.com/community/firebird-support.

fwiw, you don't "alias" external functions by recreating them.  You 
can use whatever name you like for a UDF when you declare it to your 
database, e.g.

DECLARE EXTERNAL FUNCTION CHR
         INTEGER
         RETURNS CSTRING(1) FREE_IT
         ENTRY_POINT 'IB_UDF_ascii_char' MODULE_NAME 'ib_udf';

Helen
(list admin)

[Firebird-test] (no subject)

[Andrew <anl...@in...>]

Hello All!

When I restore database using fb2.0.1.
I receive this message:

gbak:    committing metadata
gbak: ERROR:unsuccessful metadata update
gbak: ERROR:    T_JUR_PERSONS
gbak: ERROR:    Implementation of text subtype 65332 not located.
gbak:Exiting before completion due to errors

What can I do to fix it?

If I use fb1.5 all is OK.

[Firebird-test] terminated abnormally (127)

[<sk...@em...>]

file: test.c=20
CODE:
 =20
#include <stdio.h>=20
#include <stdlib.h>=20
#if TIME_WITH_SYS_TIME=20
# include <sys/time.h>=20
# include <time.h>=20
#else=20
# if HAVE_SYS_TIME_H=20
#  include <sys/time.h>=20
# else=20
#  include <time.h>=20
# endif=20
#endif=20

#include <string.h>=20
#include <math.h>=20
#include <ibase.h>=20
#include "example.h"=20

#include "ib_util.h"=20

#ifdef  CPU386  /* Fast assembler version exists for 386/486 */=20
#pragma inline=20
#endif=20

char* TEST_replace(char *source, char *replace_this, char *replacement){=20
  char *result =3D NULL;=20
  result =3D (char *)ib_util_malloc(strlen(source)+1);=20
  result=3Dstrcpy(result, source);=20
  *(result+strlen(source))=3D'\0';=20
  return result;=20

}=20

main(){=20
}=20
 =20

File: test.def=20
Code:

IBRARY         test=20
DESCRIPTION     'test.dll'=20
DATA    READ WRITE=20
EXPORTS=20
    TEST_replace =20


DECLARE:

DECLARE EXTERNAL FUNCTION REPLACEME=20
    CSTRING(5000) CHARACTER SET NONE,=20
    CSTRING(200) CHARACTER SET NONE,=20
    CSTRING(200) CHARACTER SET NONE=20
RETURNS CSTRING(5000) FREE_IT=20
ENTRY_POINT 'TEST_replace' MODULE_NAME 'test'=20


gcc test.c -shared -fPIC -o test.so -I/opt/firebird/include
-I/opt/firebird/examples -I/opt/firebird/lib

UDF are written on C, has faced a problem.=20
Earlier compiled UDF worked under FireBird 1.5, on FireBird 2.0 - the bas=
e
falls.=20

Has altered malloc on ib_util_malloc with include ib_util.h compiled unde=
r
Windows=20
on VC 6.0 - works on FB 1.5 and FB 2.0=20

Now a problem under Linux and FreeBSD, UDF I compile: mistakes are not pr=
esent,
UDF does not work.=20
but if I try use:=20
on FireBird 1.5.3
opt/firebird/bin/fbguard: bin/fbserver terminated abnormally (127)=20

Re: [Firebird-test] UDFs in procedure

[Martijn T. <m.t...@up...>]

> how to call UDFs function in procedure ?
>
> For example, I would like to create an alias of the UDF ASCII_CHAR  :
>
>
> CREATE FUNCTION CHR(num NUMBER)
>  RETURN CHAR
>   IS chrRet CHAR(1);
> BEGIN
>  RETURN(ASCII_CHAR(num));
> END;
>
> This doesn't work....and I don't know why

CREATE FUNCTION won't work cause Firebird is the only DBMS that
doesn't support Stored Functions ;-)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

[Firebird-test] =?koi8-r?b?7uE6ICBVREZzIGluIHByb2NlZHVyZQ==?=

[Valentin K. <v.k...@st...>]

SGVsbG8NClVERiBPTkxZIGV4dGVybmFsIDooDQoNCmRlY2xhcmUgZXh0ZXJuYWwgZnVuY3Rpb24g
aW52bA0KaW50IGJ5IGRlc2NyaXB0b3IsIGludCBieSBkZXNjcmlwdG9yDQpyZXR1cm5zIGludCBi
eSBkZXNjcmlwdG9yDQplbnRyeV9wb2ludCAnaWROdmwnIG1vZHVsZV9uYW1lICdmYnVkZic7DQoN
Cg0KQ3JlYXRlIG9ubHkgUHJvY2VkdXJlIA0KDQoNCmkgYW0gdG9vIGhhdmUgY3JlYXRlIGZ1bmN0
aW9uIGluIHNxbCwgYnV0Li4uLi4gbGlmZSBpcyBsaWZlDQoNCg0KDQoNCg0KImdyZWciIDxuYXBu
YXBAZnJlZS5mcj4NCu/UOiBmaXJlYmlyZC10ZXN0LWJvdW5jZXNAbGlzdHMuc291cmNlZm9yZ2Uu
bmV0DQoxMC4xMS4yMDA2IDE3OjM1DQrz0s/LIM/U18XUwSAgxMzROiAgZ3JlZzsg89LPyyDP1NfF
1MEgIMTM0TogIGZpcmViaXJkLXRlc3QNCiANCiAgICAgICAg68/N1TogICBmaXJlYmlyZC10ZXN0
QGxpc3RzLnNvdXJjZWZvcmdlLm5ldA0KICAgICAgICDrz9DJ0TogDQogICAgICAgIPTFzcE6ICAg
W0ZpcmViaXJkLXRlc3RdIFVERnMgaW4gcHJvY2VkdXJlDQoNCg0KSGVsbG8sDQpob3cgdG8gY2Fs
bCBVREZzIGZ1bmN0aW9uIGluIHByb2NlZHVyZSA/DQoNCkZvciBleGFtcGxlLCBJIHdvdWxkIGxp
a2UgdG8gY3JlYXRlIGFuIGFsaWFzIG9mIHRoZSBVREYgQVNDSUlfQ0hBUiAgOg0KDQoNCkNSRUFU
RSBGVU5DVElPTiBDSFIobnVtIE5VTUJFUikNCiBSRVRVUk4gQ0hBUg0KICBJUyBjaHJSZXQgQ0hB
UigxKTsNCkJFR0lODQogUkVUVVJOKEFTQ0lJX0NIQVIobnVtKSk7DQpFTkQ7DQoNClRoaXMgZG9l
c24ndCB3b3JrLi4uLmFuZCBJIGRvbid0IGtub3cgd2h5DQoNClRoYW5rcy4gDQoNCg0KDQotLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tDQpUYWtlIFN1cnZleXMuIEVhcm4gQ2FzaC4gSW5mbHVlbmNlIHRoZSBGdXR1
cmUgb2YgSVQNCkpvaW4gU291cmNlRm9yZ2UubmV0J3MgVGVjaHNheSBwYW5lbCBhbmQgeW91J2xs
IGdldCB0aGUgY2hhbmNlIHRvIHNoYXJlIA0KeW91cg0Kb3BpbmlvbnMgb24gSVQgJiBidXNpbmVz
cyB0b3BpY3MgdGhyb3VnaCBicmllZiBzdXJ2ZXlzIC0gYW5kIGVhcm4gY2FzaA0KaHR0cDovL3d3
dy50ZWNoc2F5LmNvbS9kZWZhdWx0LnBocD9wYWdlPWpvaW4ucGhwJnA9c291cmNlZm9yZ2UmQ0lE
PURFVkRFVg0KX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18N
CkZpcmViaXJkLXRlc3QgbWFpbGluZyBsaXN0DQpGaXJlYmlyZC10ZXN0QGxpc3RzLnNvdXJjZWZv
cmdlLm5ldA0KaHR0cHM6Ly9saXN0cy5zb3VyY2Vmb3JnZS5uZXQvbGlzdHMvbGlzdGluZm8vZmly
ZWJpcmQtdGVzdA0KDQoNCg0K

[Firebird-test] UDFs in procedure

[greg <na...@fr...>]

Hello,
how to call UDFs function in procedure ?

For example, I would like to create an alias of the UDF ASCII_CHAR  :


CREATE FUNCTION CHR(num NUMBER)
 RETURN CHAR
  IS chrRet CHAR(1);
BEGIN
 RETURN(ASCII_CHAR(num));
END;

This doesn't work....and I don't know why

Thanks. 

Re: [Firebird-test] FB2 rc4: RDB$INDICES acting strange

[Andy <an...@ca...>]

Frank Schlottmann-G=F6dde wrote:
> Andy schrieb:
>> select *  from RDB$INDICES
>>
>> work ok and shows RDB$SYSTEM_FLAG as either 1 or 0.
>=20
> I think its 1 or null.
>> select distinct RDB$SYSTEM_FLAG from RDB$INDICES;
>>
>> ok, and returns two records, 1 and 0.
>=20
> In fact it usually returns 1 and *NULL*
>=20
>> but this returns nothing:
>>
>> select *  from RDB$INDICES where RDB$SYSTEM_FLAG =3D 0;
>=20
> should be
> select *  from RDB$INDICES where RDB$SYSTEM_FLAG is null;
>=20
>> in code I can:
>>
>> select *  from RDB$INDICES
>>
>> and
>>
>> q.fieldByName('RDB$SYSTEM_FLAG').asInteger =3D 0 and see it ok
>=20
> Your components seem to translate null to 0;
>=20
>=20
>=20
>=20
> hth
> Frank
>=20
>=20

Oh!  Crap!  You're correct.  I can't believe I made that mistake.  And=20
yes, asInteger will return null's as zero (which is probably what I was=20
displaying too)

Sorry 'bout that, and thanks for the help.

-Andy

Re: [Firebird-test] FB2 rc4: RDB$INDICES acting strange

[<fs...@us...>]

Andy schrieb:
> select *  from RDB$INDICES
> 
> work ok and shows RDB$SYSTEM_FLAG as either 1 or 0.

I think its 1 or null.
> 
> select distinct RDB$SYSTEM_FLAG from RDB$INDICES;
> 
> ok, and returns two records, 1 and 0.

In fact it usually returns 1 and *NULL*

> but this returns nothing:
> 
> select *  from RDB$INDICES where RDB$SYSTEM_FLAG = 0;

should be
select *  from RDB$INDICES where RDB$SYSTEM_FLAG is null;

> 
> in code I can:
> 
> select *  from RDB$INDICES
> 
> and
> 
> q.fieldByName('RDB$SYSTEM_FLAG').asInteger = 0 and see it ok

Your components seem to translate null to 0;




hth
Frank


-- 
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
   their tears have healing powers and they make highly faithful pets."
       - J.K. Rowling

[Firebird-test] FB2 rc4: RDB$INDICES acting strange

[Andy <jac...@Xg...>]

select *  from RDB$INDICES

work ok and shows RDB$SYSTEM_FLAG as either 1 or 0.

select distinct RDB$SYSTEM_FLAG from RDB$INDICES;

ok, and returns two records, 1 and 0.

but this returns nothing:

select *  from RDB$INDICES where RDB$SYSTEM_FLAG = 0;


in code I can:

select *  from RDB$INDICES

and

q.fieldByName('RDB$SYSTEM_FLAG').asInteger = 0 and see it ok

Not sure if its supposed to act like that or not.

-Andy

[Firebird-test] Bug in DSQL parameter?

[<fe...@gm...>]

Hi people!

Look this (Test in FB 2.0 RC4 with IBExpert):
------------------------------------------------------------------------------------------
CREATE TABLE TEST (MYDATE DATE NOT NULL PRIMARY KEY);
COMMIT;

INSERT INTO TEST VALUES (CURRENT_DATE);
INSERT INTO TEST VALUES (CURRENT_DATE + 1);
INSERT INTO TEST VALUES (CURRENT_DATE + 2);
INSERT INTO TEST VALUES (CURRENT_DATE + 3);
COMMIT;

-- This expression fails
SELECT * FROM TEST WHERE MYDATE + CAST(:days AS INTEGER) >= :dateparam;
--Error:
--Dynamic SQL Error.
--SQL error code = -804.
--Data type unknown.

--But in this is okay
SELECT * FROM TEST WHERE MYDATE + 5 >= :dateparam;
------------------------------------------------------------------------------------------
Is a bug???


Another question:

In FB 1.5 and oldest this query fails:
SELECT 1 FROM RDB$DATABASE :myparam IS NULL;

With the feature in FB 2.0 (Bug fix #1371274) this situation can be
corrected thus:
SELECT 1 FROM RDB$DATABASE CAST(:myparam AS INTEGER) IS NULL;

But I think that in this situation is not necessary for engine know a
datatype, because the parameter "myparam" is verified with null state.
Is not a bug, right? But a feature?

Thanks
Maycon Ferraça - Brazil

PS.:
(1) Sorry if this wrong place for this message.
(2) Sorry for my bad bad english... :S