Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4660) IB Error Number: 335544721 when i execute a insert statement

[Thomas Beckmann]

Dear Vicente,

I admit to not have checked all your DML provided in detail (but in
overview), but your description points to a non firebird problem: If
your problem would be related to the number of rows, the specification
of indices or any other database specific stuff, it would be probably
the same one or the other day (Did you check plans of your statements?
If they are really poor, heavy load could cause problems). We have quite
some firebird systems running, and that type of problem is almost always
related to network trouble: Cable defect, network adapter defect, DHCP
problems (specificly in M$ environment)...

Hope that helps! Thomas
-- 
Diplom-Informatiker


Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de 

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de  • www.assfinet.de


Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.


--
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Fb 3: recursive local sub routines or routines calling eachother?

[Thomas Beckmann]

Hi Martijn,

maybe, that behavior changed intentionally, but in one of the alpha, it
sure was possible.

Cu you next conference ;-) Thomas

Am 12.11.2014 11:10, schrieb Martin Tonies (Upscene Productions):
> Hi,
>  
> Fb 3 introduces local sub routines in stored procedures.
>  
> It seems these sub routines cannot call themselves nor can then call
> previously declared routines, this is, I assume, by design?
>  
> With regards,
> 
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
> 
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
> 
> 
> --
> Comprehensive Server Monitoring with Site24x7.
> Monitor 10 servers for $9/Month.
> Get alerted through email, SMS, voice calls or mobile push notifications.
> Take corrective actions from your mobile device.
> http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
> 
> 
> 
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
> 

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker


Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.


--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Prague

[Thomas Beckmann]

If there will be any betas, they probably are not going to be the most
stable ones..

Anyways, I'm really looking forward to see you in Prague - sorry to
James: Our train (hopefully - german train services are on strikes)
arrives thursday evening...

Have wonderful days in Prague! Thomas


Am 20.10.2014 21:28, schrieb Robbert-Jan:
> Probably no beta release this week with all those drunken
> developers...Knipogende emoticonKnipogende emoticon
>  
> *From:* Martijn Tonies (Upscene Productions) <mailto:m.ton...@upscene.com>
> *Sent:* Monday, October 20, 2014 7:24 PM
> *To:* For discussion among Firebird Developers
> <mailto:firebird-devel@lists.sourceforge.net>
> *Subject:* Re: [Firebird-devel] Prague
>  
> Raising the bar, Mark?
>  
> --
> Martijn
>  
>  
> 
> 
> --
> Comprehensive Server Monitoring with Site24x7.
> Monitor 10 servers for $9/Month.
> Get alerted through email, SMS, voice calls or mobile push notifications.
> Take corrective actions from your mobile device.
> http://p.sf.net/sfu/Zoho
> 
> 
> 
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
> 

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker


Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.


--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Hiding source code of procedures and triggers will not work in FB 3

[Thomas Beckmann]

>> 02.09.2014 00:22, James Starkey wrote:
>>
>>> What possible user applications are going to be doing procedure and
>>> trigger definitions that require the source be omitted?
>>
>> Whatever user application that works with the database and executes 
>> metadata upgrade scripts itself, without invoking ISQL.
> 
> Do you really think there are any?  Seriously? Really?

Oh yes, sure, at least I wrote stuff doing it myself...

And I found it quite handy - but I don't disagree in changing the system
tables to be read only, as long as the features Firebird provides are
still available by other means.

Greetings, Thomas
-- 
Diplom-Informatiker


Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de 

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de  • www.assfinet.de


Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.


--
Slashdot TV.  
Video for Nerds.  Stuff that matters.
http://tv.slashdot.org/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Hiding source code of procedures and triggerswill not work in FB 3

[Thomas Beckmann]

> And it might not be feasible to rewrite PSQL code to UDRs, given
> time and money constraints.

Hey, PSQL words fine in may ways, is natively integrated - why should we
even consider of moving the code to anything else?

Greetings, Thomas

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker


Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.


--
Slashdot TV.  
Video for Nerds.  Stuff that matters.
http://tv.slashdot.org/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Hiding source code of procedures and triggers will not work in FB 3

[Thomas Beckmann]

Am 29.08.2014 14:53, schrieb Dimitry Sibiryakov:
> 29.08.2014 14:47, Carlos H. Cantu wrote:
>> You can ask them:)
> 
>Actually, they have to ask themselves if the sources are precious enough 
> to waste time 
> for their protection. AFAIK, database itself is usually pointless without 
> application that 
> works with it.

That really depends: Most of the business logic in our accounting system
is covered by PSQL in triggers and procedures. The application(s) just
visualize the UI...

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker


Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.


--
Slashdot TV.  
Video for Nerds.  Stuff that matters.
http://tv.slashdot.org/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Hiding source code of procedures and triggers will not work in FB 3

[Thomas Beckmann]

Am 29.08.2014 14:18, schrieb Dimitry Sibiryakov:
> 29.08.2014 13:57, Carlos H. Cantu wrote:
>> The matter is that most companies who uses FB in Brazil are really
>> small. Some one them has only one developer. Changing to UDR may
>> require big changes in the way those companies updates and maintain
>> their softwares (this means cost).
> 
>How much money they will loose if someone see the sources of their source 
> procedures?

Sorry, this is not the question.

The main point is: We want FB3 to spread fast and easily.

As it has been pointed out, erasing source is a familiar way to
obfuscate source code, we have been using this from time to time ourselves.
Moreover, you can restore an FB2-DB without sources to a working FB3-DB,
but you can not create it by FB3 natively - that's inconsitent.

I think we should provide a way to erase source code.

Thomas
-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker


Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.


--
Slashdot TV.  
Video for Nerds.  Stuff that matters.
http://tv.slashdot.org/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4456) Problem with Recursive CTE with "deep tree"

[Thomas Beckmann]

Hi Ben,

isn't recusion depth limited to 1024 levels by definition?

Thomas

Am 09.06.2014 10:11, schrieb BenLaz (JIRA):
> Problem with Recursive CTE with "deep tree"
> ---
> 
>  Key: CORE-4456
>  URL: http://tracker.firebirdsql.org/browse/CORE-4456
>  Project: Firebird Core
>   Issue Type: Bug
>  Environment: Windows 7 32 bits / Firebird embedded
> Reporter: BenLaz
> 
> 
> Hello,
> 
> I have a problem with a CTE Query (recursive). Here is the query :
> 
> WITH RECURSIVE BTREE (ID) AS
>   (SELECT ID
>FROM BINDERS WHERE PARENTID = 0
>UNION ALL SELECT L.ID
>FROM BINDERS L 
>INNER JOIN BTREE T ON T.ID = L.PARENTID)
> SELECT BINDERS.* FROM BTREE INNER JOIN BINDERS ON BINDERS.ID = BTREE.ID
> 
> The table Binders have the folowing structure :
> 
> ID : Int not null primary key
> PARENTID : Int not null
> BINDERNAME : varchar(100)
> 
> And it's filled that way :
> 
> 1, 0, 'toto'
> 2, 1, 'toto'   
> 3, 2, 'toto'   
> 4, 3, 'toto'  
> . 
> .
> .
> 1, , 'toto'
> 
> When executing the request there is no problem, but when retrieving the 
> results there is an error : Fetch "too many concurrent executions of the same 
> request".
> 
> This can be reproduced either with a lazarus program or FlameRobin
> 
> Best regards
> 

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker


Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.


--
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://www.hpccsystems.com
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] DDL Triggers, how to retrieve type?

[Thomas Beckmann]

>> This "useless garbage" is required for self-documenting
> 
>Self-documenting of what? Isn't list in header enough for this purpose?..

No: Not everybody using firebird reads C-code.

Thomas
-- 
Diplom-Informatiker


Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de 

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de  • www.assfinet.de


Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.


--
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Planning the post v3 development

[Thomas Beckmann]

We are right now discussing this in our (new) company again. We
implemented replication mechanisms similar to ibreplicator (and probably
others) on our own, as probably did many people. Yes, having this kind
of feature build in would be a big help. Current application design
leads to more and more diverse platforms that still can not handle data
access online all the time - thus leading to what ever replication needs.

Main focus should be in asynchronous multi master scenarios, as Carlos
pointed out. Everything else seems to be as specialization...

Thomas

Am 28.04.2014 21:05, schrieb Carlos H. Cantu:
>>> 2) I second Jesus Garcia request for native replication, since people at
>>> FDD and in FireBase's list are always claiming about the lack of such
>>> feature.
> 
> DY> Replication is a too common word. What do they really need? Warm 
> DY> standby? Hot standby? Sync replication? Async replication? Multi-master?
> DY> Maybe point-in-time recovery? Maybe FB->Oracle or vice versa?
> 
> I think most of them needs basic asynchronous replication, covering
> single and multi-master scenarios. For those who needs more complex
> scenarios, there are third party comercial tools. Anyway, I'm not the
> right person to answer, since I didn't need replication in my projects
> so far, so I'll leave this for Jesus or any others to answer. If you
> are interested, I can run a poll at firebirdnews.org and firebase
> about what users would expect in "native" FB replication.

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker


Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.


--
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.  Get 
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Bug with JOIN/LEFT JOIN?

[Thomas Beckmann]

> In fact, this behaves as:
> 
> select i.I, j.I, k.I
> from ( CTE_CNT i left join CTE_CNT j on i.I = j.I and j.I<10 )
> join CTE_CNT k on j.I = k.I
> 
> and this is not a bug.
> 
> You should be writing:
> 
> select i.I, j.I, k.I from CTE_CNT i
> left join CTE_CNT j on i.I = j.I and j.I<10
> left join CTE_CNT k on j.I = k.I
> 
> to keep the LEFT behaviour for all the streams depending on J.

Thank you, Dimitry!

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker


Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.


--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Bug with JOIN/LEFT JOIN?

[Thomas Beckmann]

 

I'm sorry for asking this question here: In firebird-support, I got 2
answers of people who where obviously as little sure than I whether the
described behaviour is a bug or SQL standard compliant, so:



Please consider the following example:

with recursive
CTE_CNT as (select 1 as I from RDB$DATABASE
union all select I + 1 from CTE_CNT where I < 20)

select i.I, j.I, k.I from CTE_CNT i
left join CTE_CNT j on i.I = j.I and j.I<10
join CTE_CNT k on j.I = k.I

I would expect this to behave as

select i.I, j.I, k.I from CTE_CNT i
left join (CTE_CNT j
   join CTE_CNT k on j.I = k.I) on i.I = j.I and j.I<10

But it does not: It behaves like

select i.I, j.I, k.I from CTE_CNT i
join CTE_CNT j on i.I = j.I and j.I<10
join CTE_CNT k on j.I = k.I

Can someone explain this to me? Is this as intended or is this a bug?

Thanks alot! Thomas

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht KoblenI HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

__._,_.___
Reply via web post
<https://groups.yahoo.com/neo/groups/firebird-support/conversations/messages/124148;_ylc=X3oDMTJyM2x2bzdiBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lkAzEyNDE0OARzZWMDZnRyBHNsawNycGx5BHN0aW1lAzEzOTUzMzgzMjE-?act=reply&messageNum=124148>
Reply to sender
<mailto:thomas.beckm...@assfinet.de?subject=Re%3A%20Bug%20with%20JOIN%3F>
Reply to group
<mailto:firebird-supp...@yahoogroups.com?subject=Re%3A%20Bug%20with%20JOIN%3F>
Start a New Topic
<https://groups.yahoo.com/neo/groups/firebird-support/conversations/newtopic;_ylc=X3oDMTJlZzdrZzlyBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA250cGMEc3RpbWUDMTM5NTMzODMyMQ-->
Messages in this topic
<https://groups.yahoo.com/neo/groups/firebird-support/conversations/topics/124148;_ylc=X3oDMTM4dWUyaDh2BF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lkAzEyNDE0OARzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEzOTUzMzgzMjEEdHBjSWQDMTI0MTQ4>
(1)

++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++
Visit Your Group
<https://groups.yahoo.com/neo/groups/firebird-support/info;_ylc=X3oDMTJlbWlkZmwwBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTM5NTMzODMyMQ-->


  * New Members

<https://groups.yahoo.com/neo/groups/firebird-support/members/all;_ylc=X3oDMTJmMTlsbHFuBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZtYnJzBHN0aW1lAzEzOTUzMzgzMjE->
2

Yahoo! Groups
<https://groups.yahoo.com/neo;_ylc=X3oDMTJkODByc29zBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzk1MzM4MzIx>

• Privacy <https://info.yahoo.com/privacy/us/yahoo/groups/details.html>
• Unsubscribe
<mailto:firebird-support-unsubscr...@yahoogroups.com?subject=Unsubscribe> •
Terms of Use <https://info.yahoo.com/legal/us/yahoo/utos/terms/>
.

__,_._,___

--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] RFC: stop fiddling with sys tables

[Thomas Beckmann]

Hm, I'm using read access to system tables quite a bit, particularly to
create some triggers or automatically build some statements (find all
fields and field types of a table) or checking dependencies between
tables - if there will be appropriate ways to still do this, it's fine
with me - though I don't see the need to change current behavior: If you
want to, you can restrict working with system tables by database and
role design and if you mess up your system tables, it's up to you to get
out of it...
-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker


Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.


--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4252) Specify the name of the table, if an exception occurs when insert

[Thomas Beckmann]

>> NOT NULL constraints have such name and other constraints implemented
>> using system triggers and have names like CHECK_NNN. Are you sure it will
>> be really useful to show such name ?
>>
>>
> If ISQL and others tools does not hidden them, just because they were
> generated names, yes, it will be useful.

I definitely agree: If it's not too much hazle to show them, I'd really
appreciate to see them. With the tools I use, I can see them and it
would lead me to the error much faster.

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker


Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.


--
Android is increasing in popularity, but the open development platform that
developers love is also attractive to malware creators. Download this white
paper to learn more about secure code signing practices that can help keep
Android apps secure.
http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Procedure size in package limited?

[Thomas Beckmann]

Hi Adriano,

with my latest snapshot 3.0-server, I've been able to compile the
procedure, though. I don't mind if this is the bug, but as Dimitri
stated, it would be weird if the behavior of packaged and non-packaged
procedures would be different. So, you get the error with the standalone
procedure, too?

Have a good night, Thomas

>> The standalone procedure is raising the same "sort record size".
> 
>> Please create a bug ticket.
>>
> 
> Or no, don't do it for now. The only problem I'm seeing is an assert
> error in the debug build.
> 
> Your query just bypass the sort limit (it's not only about the ORDER BY
> I DESC), but all query fields that goes to the sort and is greater than
> 65535.
> 
> 
> Adriano
> 
> --
> See everything from the browser to the database with AppDynamics
> Get end-to-end visibility with application monitoring from AppDynamics
> Isolate bottlenecks and diagnose root cause in seconds.
> Start your free trial of AppDynamics Pro today!
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
> 

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Procedure size in package limited?

[Thomas Beckmann]

Ok, Dimitri,

I'm sorry for this quite unhandy example - but it does what it's
supposed to do...

Regards, Thomas

>> I get this error
>>
>> Statement failed, SQLSTATE = 2F000
>> sort record size of 187704 bytes is too big
>> -Error while parsing procedure PKG$.P_SOMEPROCEDURE's BLR
>>
>> on recreating the package body.
> 
> It has nothing to do with the package/procedure size, it's about size of 
> the explicit or implicit sorting set ("select * order/group by" etc) 
> inside that procedure.
> 
>> Creating the procedure outside a package works fine.
> 
> That's weird. A test case would be appreciated.
> 
> Dmitry

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.
create domain D_DBENTITY as char(31) character set UNICODE_FSS collate 
UNICODE_FSS;
create domain D_VC120 as varchar(120) character set NONE default ''  collate 
NONE;
create domain D_SQL_STMT as varchar(12500) character set NONE collate NONE;

set term ^ ;

create or alter  procedure P_RBLD_VW (TBL D_DBENTITY) returns (RESULT D_VC120)
as
declare variable V D_SQL_STMT;
declare variable TI D_SQL_STMT;
declare variable TU D_SQL_STMT;
declare variable TD D_SQL_STMT;
declare variable CV D_SQL_STMT;
declare variable CI D_SQL_STMT;
declare variable CU D_SQL_STMT;
declare variable CD D_SQL_STMT;
begin
  for with recursive
CTE_FLDLST as
 (select
TBL,
I,
FLD_P,
FLD_S,
FLD_IP,
FLD_IV,
FLD_U
  from (select first 1
  rf.RDB$RELATION_NAME as TBL,
  rf.RDB$FIELD_POSITION as I,
  cast(trim(rf.RDB$FIELD_NAME) as D_SQL_STMT) as FLD_P,
  cast('x.' || trim(rf.RDB$FIELD_NAME) as D_SQL_STMT) as FLD_S,
  cast(iif(f.RDB$COMPUTED_BLR is null, trim(rf.RDB$FIELD_NAME), null) 
as D_SQL_STMT) as FLD_IP,
  cast(iif(f.RDB$COMPUTED_BLR is null, 'new.' || 
trim(rf.RDB$FIELD_NAME), null) as D_SQL_STMT) as FLD_IV,
  cast(iif(f.RDB$COMPUTED_BLR is null, trim(rf.RDB$FIELD_NAME) || 
'=new.' || trim(rf.RDB$FIELD_NAME), null) as D_SQL_STMT) as FLD_U
from (select
rf.RDB$RELATION_NAME
  from RDB$RELATION_FIELDS rf
  where rf.RDB$RELATION_NAME = :TBL and rf.RDB$RELATION_NAME starting 
with 'T_' and rf.RDB$FIELD_SOURCE = 'D_PK_UUID') t
join RDB$RELATION_FIELDS rf on rf.RDB$RELATION_NAME = 
t.RDB$RELATION_NAME and rf.RDB$SYSTEM_FLAG = 0
join RDB$FIELDS f on f.RDB$FIELD_NAME = rf.RDB$FIELD_SOURCE
order by rf.RDB$FIELD_POSITION)
  union all select
TBL,
rf.RDB$FIELD_POSITION as I,
coalesce(FLD_P || ',', '') || iif(rf.RDB$SYSTEM_FLAG = 0, 
trim(rf.RDB$FIELD_NAME), '') as FLD_P,
coalesce(FLD_S || ',', '') || iif(rf.RDB$SYSTEM_FLAG = 0, 'x.' || 
trim(rf.RDB$FIELD_NAME), '') as FLD_S,
coalesce(FLD_IP || ',', '') || iif(rf.RDB$SYSTEM_FLAG = 0 and 
f.RDB$COMPUTED_BLR is null, trim(rf.RDB$FIELD_NAME), '') as FLD_IP,
coalesce(FLD_IV || ',', '') || iif(rf.RDB$SYSTEM_FLAG = 0 and 
f.RDB$COMPUTED_BLR is null, 'new.' || trim(rf.RDB$FIELD_NAME), '') as FLD_IV,
coalesce(FLD_U || ',', '') || iif(rf.RDB$SYSTEM_FLAG = 0 and 
f.RDB$COMPUTED_BLR is null, trim(rf.RDB$FIELD_NAME) || '=new.' || 
trim(rf.RDB$FIELD_NAME), '') as FLD_U
  from CTE_FLDLST t
  join RDB$RELATION_FIELDS rf on rf.RDB$RELATION_NAME = t.TBL and 
rf.RDB$FIELD_POSITION = I + 1
  join RDB$FIELDS f on f.RDB$FIELD_NAME = rf.RDB$FIELD_SOURCE)

select
  RESULT,
  'create or alter view ' || VW || '(' || x'0a' ||
  '  ' || FLD_P || ')' || x'0a' ||
  'as' || x'0a' ||
  'select' || x'0a' ||
  '  ' || FLD_S || x'0a' ||
  'from ' || TBL || ' x' || x'0a' ||
  'join T_MANDANT_UID m on m.UID = x.UID a

[Firebird-devel] Procedure size in package limited?

[Thomas Beckmann]

I get this error

Statement failed, SQLSTATE = 2F000
sort record size of 187704 bytes is too big
-Error while parsing procedure PKG$.P_SOMEPROCEDURE's BLR

on recreating the package body.

Creating the procedure outside a package works fine.

Is this an error or am I exceeding package size in adding this procedure?

Best regards, Thomas
-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] FB30: What is table SEC$USERS for?

[Thomas Beckmann]

>> I'm still struggling with getting my user priviledges set up the proper
>> way in FB3.0, and stumbled across table SEC$USERS - can someone give me
>> a hint what this is for or where I can find some informations about it?
> 
> It's a virtual (read-only) table that shows users allowed to be  managed 
> (ALTER/DROP USER) by the current user. For SYSDBA, it returns the full 
> list of known users.

Thank you, Dimitry!

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] FB30: What is table SEC$USERS for?

[Thomas Beckmann]

I'm still struggling with getting my user priviledges set up the proper
way in FB3.0, and stumbled across table SEC$USERS - can someone give me
a hint what this is for or where I can find some informations about it?

Thank you!

Regards, Thomas

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] execute statement on external from FB3.0 into FB2.5

[Thomas Beckmann]

>>> I'd like to select from a FB2.5-DB with FB3.0 and get the error
>>> "username and password are not defined" (they sure are, I can run the
>>> statement from another FB2.5-database), and I assume, the problem is the
>>> encrypted password.
>>>
>>> Is there a parameter for "execute statement" to tell that "Legacy_Auth"
>>> plugin is to be used?
>>  FB3 acts as a client for FB25 in your case. So, AuthClient should 
>> contain
>> Legacy_Auth plugin.
> 
> Contains it by default

Hm, but if I omit it, it does not work, if I add it, it works...

>> Probably, it should be the first plugin in the list...
> 
> Not necessary

Hm, I made a couple of tests and it seems to make a difference...

Regards, Thomas
-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] execute statement on external from FB3.0 into FB2.5

[Thomas Beckmann]

>> I just tried and get the message "unsupported on-disk structure; found
>> 11.2, support 12.0" :-( ...
>>
>> Is there a way to get around that?
> 
> Because you attaching to the FB3 :) Tell us more about your setup:
> 1. host name and TCP port for fb3 instance
> 2. host name and TCP port for fb25 instance
> 3. parameters of EXECUTE STATEMENT ON EXTERNAL issued at fb3 instance

I found the solution:

Explicitly using 127.0.0.1/3050:PathToDB would do the trick! My FB3.0
runs on the same machine as application on port 3051...

it seems that execute statement assumes same port as original connection...

Ok, thank you for your hints!

Best regards and have a nice weekend, Thomas
-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] execute statement on external from FB3.0 into FB2.5

[Thomas Beckmann]

Thank you Vlad!

I just tried and get the message "unsupported on-disk structure; found
11.2, support 12.0" :-( ...

Is there a way to get around that?

Regards, Thomas

Am 05.07.2013 16:26, schrieb Vlad Khorsun:
>> I'd like to select from a FB2.5-DB with FB3.0 and get the error
>> "username and password are not defined" (they sure are, I can run the
>> statement from another FB2.5-database), and I assume, the problem is the
>> encrypted password.
>>
>> Is there a parameter for "execute statement" to tell that "Legacy_Auth"
>> plugin is to be used?
> 
> FB3 acts as a client for FB25 in your case. So, AuthClient should contain
> Legacy_Auth plugin. Probably, it should be the first plugin in the list...
> 
> Regards,
> Vlad
> 
> --
> This SF.net email is sponsored by Windows:
> 
> Build for Windows Store.
> 
> http://p.sf.net/sfu/windows-dev2dev
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
> 

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] execute statement on external from FB3.0 into FB2.5

[Thomas Beckmann]

Hi everybody,

I'd like to select from a FB2.5-DB with FB3.0 and get the error
"username and password are not defined" (they sure are, I can run the
statement from another FB2.5-database), and I assume, the problem is the
encrypted password.

Is there a parameter for "execute statement" to tell that "Legacy_Auth"
plugin is to be used?

Thank you! Thomas
-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] gsec-issues with FB3.0

[Thomas Beckmann]

>> Finally
>> gbak -b c:\temp\test.fdb c:\temp\test.fbk
>> gbak: ERROR:Unable to perform operation.  You must be either SYSDBA or
>> owner of the database
>> gbak:Exiting before completion due to errors
>> I still am the owner of the database (I hope ;-))
>> gbak -b c:\temp\test.fdb c:\temp\test.fbk -user beckmann -password SomePwd
>> returns the same error (this behavior is already in the tracker and
>> confirmed as beeing erroneous).
> 
> This one has already been fixed.

Yes, working is now:
gbak -b test.fdb test.fbk
gbak -b test.fdb test.fbk -user sysdba -password masterkey
gbak -b 127.0.0.1/3051:test.fdb test.fbk -user beckmann -password SomePwd

Not working is still:
gbak -b 127.0.0.1/3051:test.fdb test.fbk -user sysdba -password masterkey
gbak: ERROR:Your user name and password are not defined. Ask your
database administrator to set up a Firebird login.
gbak:Exiting before completion due to errors

gsec with server/port does not crash any more but still does not work:
gsec -database 127.0.0.1/3051:test.fdb -user sysdba -password masterkey
GSEC> display
Your user name and password are not defined. Ask your database
administrator to set up a Firebird login.

isql 127.0.0.1/3051:test.fdb -user sysdba -password masterkey
leads to the same result

gsec -database 127.0.0.1/3051:test.fdb -user beckmann -password SomePwd
GSEC> display
Dynamic SQL Error
SQL error code = -204
Table unknown
PLG$SRP_VIEW
At line 1, column 129

Very interesting...
-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] gsec-issues with FB3.0

[Thomas Beckmann]

> This one has already been fixed.

Thank you, I'll update and check again!

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] gsec-issues with FB3.0

[Thomas Beckmann]

Hi everybody,

I'm having quite some problems with the permissions in FB3.0 and would
appreciate some hints on this.

I'm using gsec version WI-T3.0.0.30472 Firebird 3.0 Alpha 1.

First question:

gsec -user sysdba -password masterkey
GSEC> display
 user nameuid   gid admin full name

SYSDBA  0 0
BECKMANN0 0

Shouldn't SYSDBA show up with admin rights?
User BECKMANN were granted admin rights too
GSEC> modify BECKMANN -admin yes
but they won't show up either.

Now, I'd like to create a database (my server is running on 3051):

isql -user sysdba -password masterkey
CREATE DATABASE '127.0.0.1/3051:c:\temp\test.fdb' USER 'SYSDBA' PASSWORD
'masterkey';

But I get:
Statement failed, SQLSTATE = 28000
Your user name and password are not defined. Ask your database
administrator to set up a Firebird login.

Issuing
CREATE DATABASE 'c:\temp\test.fdb';
works fine.

Now, I try to connect to that database:
isql 127.0.0.1/3051:c:\temp\test.fdb -user sysdba -password masterkey
Does not work:
Statement failed, SQLSTATE = 28000
Your user name and password are not defined. Ask your database
administrator to set up a Firebird login.
Use CONNECT or CREATE DATABASE to specify a database

Using
isql 127.0.0.1/3051:c:\temp\test.fdb -user beckmann -password SomePwd
works fine - I understand, that my Windows-credentials have been used to
create the database.

Now:
gsec -database c:\temp\test.fdb
GSEC> display
Dynamic SQL Error
SQL error code = -204
Table unknown
PLG$SRP_VIEW
At line 1, column 129

After adding SYSDBA
GSEC>add SYSDBA -pw masterkey -admin yes
GSEC> display
GSEC>
SYSDBA will not show up, but the error is gone...

Issuing
gsec -database 127.0.0.1/3051:c:\temp\test.fdb -user beckmann -password
SomePwd
GSEC> display
crashes gsec (Windows exception), gsec shuts down, server is still up, while
gsec -database 127.0.0.1/3051:c:\temp\test.fdb -user sysdba -password
masterkey
works fine.

gsec -database c:\temp\test.fdb -user sysdba -password masterkey
GSEC> display
 user nameuid   gid admin full name

SYSDBA  0 0
GSEC>

Now, I do
gbak -b c:\temp\test.fdb c:\temp\test.fbk -user sysdba -password masterkey
gbak -r c:\temp\test.fbk c:\temp\test1.fdb -user sysdba -password masterkey

Than
gsec -database 127.0.0.1/3051:c:\temp\test1.fdb -user sysdba -password
masterkey
GSEC> display
crashes gsec, while
gsec -database c:\temp\test1.fdb -user sysdba -password masterkey
works fine.

Finally
gbak -b c:\temp\test.fdb c:\temp\test.fbk
gbak: ERROR:Unable to perform operation.  You must be either SYSDBA or
owner of the database
gbak:Exiting before completion due to errors
I still am the owner of the database (I hope ;-))
gbak -b c:\temp\test.fdb c:\temp\test.fbk -user beckmann -password SomePwd
returns the same error (this behavior is already in the tracker and
confirmed as beeing erroneous).

Hm... I'm getting quite confused...
Some of this behavior might be a bug, but some might be intended...

Thank you for some hints on this! Thomas
-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4132) gbak requires exclusive access

[Thomas Beckmann (JIRA)]

gbak requires exclusive access
--

 Key: CORE-4132
 URL: http://tracker.firebirdsql.org/browse/CORE-4132
 Project: Firebird Core
  Issue Type: Bug
  Components: GBAK
Affects Versions: 3.0 Initial
 Environment: Win7/64
gbak version WI-T3.0.0.30472 Firebird 3.0 Alpha 1
Reporter: Thomas Beckmann


Consider this testcase:

 isql -user testuser -password testpwd 
 create database c:\temp\test.fdb 
 exit;

Now:
 gbak -b c:\temp\test.fdb c:\temp\test.fbk 
 gbak -rep c:\temp\test.fbk c:\temp\test1.fdb
works fine

Open second console and run isql
 isql 127.0.0.1/3051:c:\temp\test.fdb -user testuser -password testpwd

Back to first console try
 isql 127.0.0.1/3051:c:\temp\test.fdb -user testuser -password testpwd
 exit;
works fine.

Try
 gbak -b c:\temp\test.fdb c:\temp\test.fbk
yields to
 gbak: ERROR:I/O error during "CreateFile (open)" operation for file 
"c:\temp\TEST.FDB" 
 gbak: ERROR:Error while trying to open file
 gbak: ERROR:Der Prozess kann nicht auf die Datei zugreifen, da sie von 
einem anderen Prozess verwendet wird.
 gbak:Exiting before completion due to errors
(meaning "file is in use by another process")

try
 gbak -b 127.0.0.1/3051:c:\temp\test.fdb c:\temp\test.fbk -user testuser 
-password testpwd
yields to
 gbak: ERROR:Unable to perform operation.  You must be either SYSDBA or owner 
of the database
 gbak:Exiting before completion due to errors

try
 gbak -b 127.0.0.1/3051:c:\temp\test.fdb c:\temp\test.fbk -user sysdba 
-password masterkey
yields to
 gbak: ERROR:Unable to perform operation.  You must be either SYSDBA or owner 
of the database 
 gbak:Exiting before completion due to errors

Am I missing something or is this a bug?

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Problem with CTE

[Thomas Beckmann]

> Feel free to add your case into the ticket, it could be useful when issue
> will be fixed and tested.

Thank you, Vlad, but I fear, that one is the most reduced testcase I can
offer (actually, Frank, who posted the issue, is a colleague of mine) -
the "real live"-examples are quite difficult to follow...

>> But: Did any one of you investigate about it? 
> Yes, a bit
> 
>> Do you have an idea what's going on here?
> So far i have no solution

Ok, have you been able to reproduce it, though?

Again: Thank you! Thomas
-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (04 51) 399 04 - 545 • Fax +49 (04 51) 399 04 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Problem with CTE

[Thomas Beckmann]

Again, I ran into the problem, that under certain conditions names can
not be resolved in (recursive) CTEs. I'm pretty sure it's the same
problem as described in http://tracker.firebirdsql.org/browse/CORE-4005
- thus I'm not going to create a new issue. But: Did any one of you
investigate about it? Do you have an idea what's going on here?

Thank you for hints! Thomas
-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (04 51) 399 04 - 545 • Fax +49 (04 51) 399 04 - 604
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4128) Default value can be of wrong type

[Thomas Beckmann (JIRA)]

Default value can be of wrong type
--

 Key: CORE-4128
 URL: http://tracker.firebirdsql.org/browse/CORE-4128
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0 Initial
 Environment: W7/64
ISQL Version: WI-T3.0.0.30435 Firebird 3.0 Unstable
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-T3.0.0.30435 Firebird 
3.0 Unstable"
Reporter: Thomas Beckmann


Consider following small example:

create domain D_TEST smallint default 'foo';

I would expect this to return an error. It does at run time, as soon as data is 
inserted and the default value is to be used. Type of default value is not 
checked in field and parameter definitions either.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4126) gbak -r fails in restoring all stored procedures/functions in packages

[Thomas Beckmann (JIRA)]

gbak -r fails in restoring all stored procedures/functions in packages
--

 Key: CORE-4126
 URL: http://tracker.firebirdsql.org/browse/CORE-4126
 Project: Firebird Core
  Issue Type: Bug
  Components: GBAK
Affects Versions: 3.0 Initial
 Environment: W7/64
ISQL Version: WI-T3.0.0.30435 Firebird 3.0 Unstable
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-T3.0.0.30435 Firebird 
3.0 Unstable"
Reporter: Thomas Beckmann


I'm sorry to have no neat testcase for this one, but I've an 8MB database where 
the problem is reproduceable.

As soon as a particular package is added, restore fails with "procedure id xxx 
is not defined" (xxx increasing every time I drop and recreate the package). 
Without he package, restore works. Commenting out the procedure in the package 
before backup just leads to another procedure failiing.

Using another package, I had a similar behavior, but there, a particular 
function would fail to restore and even crash the server, until I changed 
return type from user defined domain to smallint (which would work in this 
case).

If there's someone to investigate this bug, I'm glad to provide my testcase - 
it's just not suitable for this list...

Thank you, Thomas

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4124) Last "end" in package body may no langer be closed by "; "

[Thomas Beckmann (JIRA)]

Last "end" in package body may no langer be closed by ";"
-

 Key: CORE-4124
 URL: http://tracker.firebirdsql.org/browse/CORE-4124
 Project: Firebird Core
  Issue Type: Bug
  Components: ISQL
Affects Versions: 3.0 Initial
 Environment: W7/64
ISQL Version: WI-T3.0.0.30435 Firebird 3.0 Unstable
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-T3.0.0.30435 Firebird 
3.0 Unstable" 
    Reporter: Thomas Beckmann


Consider the following example:

set term ^ ;
create or alter package PKG_TEST
as
begin
  function F_TEST returns smallint;
end^

recreate package body PKG_TEST
as
begin
  function F_TEST returns smallint
  as
  begin
return 1;
  end;
end^
set term ; ^

This worked nicely until recently, but now, the ";" at the 3rd last line (the 
closing end for the function definition) leads to a "Token unknonw" error. If 
there are more functions, all but the last need the ";" at their end.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4122) Metadata export with isql (option -ex) does not functions properly

[Thomas Beckmann (JIRA)]

Metadata export with isql (option -ex) does not functions properly
--

 Key: CORE-4122
 URL: http://tracker.firebirdsql.org/browse/CORE-4122
 Project: Firebird Core
  Issue Type: Bug
  Components: ISQL
Affects Versions: 3.0 Initial
 Environment: W7/64 
ISQL Version: WI-T3.0.0.30435 Firebird 3.0 Unstable
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-T3.0.0.30435 Firebird 
3.0 Unstable"

Reporter: Thomas Beckmann


Summary says it all: 
Functions are exported as if they were UDFs. 
Functions belonging to packages are actually exported twice, properly with the 
package and incorrectly.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4114) similar to does not match x'##'-codes

[Thomas Beckmann]

Am 07.06.2013 17:55, schrieb Dimitry Sibiryakov:
> 07.06.2013 17:31, Leyne, Sean wrote:
>>  If an operator is comparing OCTETS against a string value, OCTETS 
>> value should be coerced into the charset of the other value.
> 
>In which way? How code x'a0' should be "coerced" into UTF-8? As russian 
> "a" or western "á"?
>A long time ago I suggested to convert OCTETS into hexadecimal values, but 
> it was rejected.

I have no idea, how the x'##' should be treated, but it sure is quite
irritating, reading in the docs that '[[:WHITESPACE:]]' would match some
characters named by their ASCII-numbers - and it does using
"ascii_char(##)" but doesn't using "x'##'" - we should have a hint
there, at least...

Moreover: The problem did arise in trying to find some text behind empty
lines in a blob - that is charset ISO8859_1 and the connection settings
are ISO8859_1 too.

select iif(BlobField similar to '[[:WHITESPACE:]]*SomeTextToFind', 'T',
'F') from SomeTable

would not return 'T', even though BlobField contains only CRLF in front
of SomeTextToFind.

If you need a more detailed example, I'll set one up.

Thanks for the discussion, Thomas

-- 
thomas.beckm...@thbeckmann.de

--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4114) similar to does not match x'##'-codes

[Thomas Beckmann (JIRA)]

similar to does not match x'##'-codes
-

 Key: CORE-4114
 URL: http://tracker.firebirdsql.org/browse/CORE-4114
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 2.5.2
 Environment: Win7/64
Reporter: Thomas Beckmann


As this example points out, x'##'-codes are not properly matched by similar to:

select
  iif(' ' similar to '[[:WHITESPACE:]]', 'T', 'F'),
  iif(x'20' similar to '[[:WHITESPACE:]]', 'T', 'F'),
  iif(x'20' similar to '%', 'T', 'F')
from RDB$DATABASE

returns 'T', 'F', 'F'

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
How ServiceNow helps IT people transform IT departments:
1. A cloud service to automate IT design, transition and operations
2. Dashboards that offer high-level views of enterprise services
3. A single system of record for all IT processes
http://p.sf.net/sfu/servicenow-d2d-j
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] "execute statement on external" between FB2.5 and FB3

[Thomas Beckmann]

> This makes plugins better than Legacy almost useless. Legacy auth 
> transfers passwords almost palin over the wire, making it too easy to be 
> captured by 3d party. And knowing first 8 bytes of password makes 
> finding the rest (provided password is longer than 8 bytes) much easier.

I agree, Alex, but this workaround should only be necessary *if* there
is anonther plugin in use for this user - in this case, the
administrator already made the decision of using a maybe vulnerable
architecture.

> > Second: Remember the the use case, that led to this question - we are
> > attaching a FB3.0-database by FB2.5 execute statement on external (or
> > vice versa), a use case, that might be valid for the next couple of
> > years...
> 
> Once again - legacy auth process and today security requirements are 
> incompatible.

Sure, but COBOL and todays software development paradicms are
incompatible to - but still, there's a lot of COBOL code out
there... ;-)

-- 
ASSFINET Dienstleistungs-GmbH

Wielandstraße 14c  *  23558 Lübeck
Tel +49 (04 51) 399 04 - 555 * Fax +49 (04 51) 399 04 -529
Mail thomas.beckm...@assfinet.de *  Web http://www.assfinet.de

Geschäftsführer: Marc Rindermann Registergericht Koblenz-HRB 23 331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese
Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser
Mail ist nicht gestattet.

--
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] "execute statement on external" between FB2.5 and FB3

[Thomas Beckmann]

Am Fri, 24 May 2013 16:06:39 +0400
schrieb Alex Peshkoff :

> On 05/24/13 15:51, Dimitry Sibiryakov wrote:
> > 24.05.2013 13:44, Alex Peshkoff wrote:
> >> It's possible to show all users. The problems are:
> >> 1. What to do when modify or delete someuser is issued, and someuser is
> >> present in >1 plugin?
> >> 2. What plugin to be called when adding new user?
> > 1a) Modify or delete all of them. Deleting user, DBA want to prevent him 
> > from being able
> > to log in. The only way to get that - delete all of them
> > 1b) Add syntax to indicate complete info: user@plugin for example. Of 
> > course, plugin name
> > should be shown in list.
> 
> Deleting all of them makes sense. Modifying is very bad - this may 
> compromise password in Srp, at least first 8 symbols of it. Supposing 
> that sooner or later Legacy plugin will be gone.

Well, first: Are all plugins available to the engine at all time and
one is just chosen bei the user? If so, can't the password be encoded
by every plugin as if it would be the one actually chosen by the user?

Second: Remember the the use case, that led to this question - we are
attaching a FB3.0-database by FB2.5 execute statement on external (or
vice versa), a use case, that might be valid for the next couple of
years...

Thomas
-- 
ASSFINET Dienstleistungs-GmbH

Wielandstraße 14c  *  23558 Lübeck
Tel +49 (04 51) 399 04 - 555 * Fax +49 (04 51) 399 04 -529
Mail thomas.beckm...@assfinet.de *  Web http://www.assfinet.de

Geschäftsführer: Marc Rindermann Registergericht Koblenz-HRB 23 331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese
Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser
Mail ist nicht gestattet.

--
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] "execute statement on external" between FB2.5 and FB3

[Thomas Beckmann]

> You may grant access to the particular user, which is used in execute 
> statement.

Ok, this works, even though the user is not visible in FB3.0?

-- 
ASSFINET Dienstleistungs-GmbH

Wielandstraße 14c  *  23558 Lübeck
Tel +49 (04 51) 399 04 - 555 * Fax +49 (04 51) 399 04 -529
Mail thomas.beckm...@assfinet.de *  Web http://www.assfinet.de

Geschäftsführer: Marc Rindermann Registergericht Koblenz-HRB 23 331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese
Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser
Mail ist nicht gestattet.

--
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] "execute statement on external" between FB2.5 and FB3

[Thomas Beckmann]

> I had to grant access to PUBLIC for all the tables I'd like to access
> this way, or is there any other way?

I went for particular roles, which works fine.

-- 
ASSFINET Dienstleistungs-GmbH

Wielandstraße 14c  *  23558 Lübeck
Tel +49 (04 51) 399 04 - 555 * Fax +49 (04 51) 399 04 -529
Mail thomas.beckm...@assfinet.de *  Web http://www.assfinet.de

Geschäftsführer: Marc Rindermann Registergericht Koblenz-HRB 23 331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese
Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser
Mail ist nicht gestattet.

--
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] "execute statement on external" between FB2.5 and FB3

[Thomas Beckmann]

Hi Alex,

sorry - I had no time to work on this problem again, before:

I got it to work.

Switching 
 AuthServer = Legacy_Auth
 AuthClient = Legacy_Auth
 UserManager = Legacy_UserManager
will show me a couple of older users in security database and I could
add my new user using gsec.

Switching only UserManager back to default and having
 AuthServer = Srp, Win_Sspi, Legacy_Auth
 AuthClient = Srp, Win_Sspi, Legacy_Auth
the user does not show up in gsec, but I'm able to connect.

I had to grant access to PUBLIC for all the tables I'd like to access
this way, or is there any other way?

Thanks alot, Thomas
 

> > as you proposed, I corrected
> >   UserManager = Legacy_UserManager
> > and was able to add a user, but still, using that account in accessing
> > the FB3.0-database from FB2.5, I get "your username and password is not
> > defined".
> 
> Is AuthServer parameter correct?
> AuthServer = Srp, Win_Sspi, Legacy_Auth
> 
> You may also try
> AuthServer = Legacy_Auth
> 
> in case you have problems.
> 
> > Can I check whether my new user is in old format (how?).
> 
> Best of all give him some First/Middle/Last Name and use list users 
> command with appropriate UserManager turned on. Reverting to default 
> user manager you should not see that user.



-- 
ASSFINET Dienstleistungs-GmbH

Wielandstraße 14c  *  23558 Lübeck
Tel +49 (04 51) 399 04 - 555 * Fax +49 (04 51) 399 04 -529
Mail thomas.beckm...@assfinet.de *  Web http://www.assfinet.de

Geschäftsführer: Marc Rindermann Registergericht Koblenz-HRB 23 331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese
Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser
Mail ist nicht gestattet.

--
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] "execute statement on external" between FB2.5 and FB3

[Thomas Beckmann]

Hi Alex,

as you proposed, I corrected
 UserManager = Legacy_UserManager
and was able to add a user, but still, using that account in accessing
the FB3.0-database from FB2.5, I get "your username and password is not
defined".

Can I check whether my new user is in old format (how?). I switched
UserManager back to default and restarted server before trying to
connect - or does the UserManager has to remain "legacy" as long as I
want to do my experiments from FB2.5?

Thank you, Thomas

Am 08.05.2013 17:27, schrieb Alex Peshkoff:
> On 05/08/13 19:16, Thomas Beckmann wrote:
>>> To make it possible to connect from pre-3 server/client to fb3-server
>>> you should configure fb3 server (unfortunately lowing it's security level).
>>> In firebird.conf set
>>> AuthServer = Srp, Win_Sspi, Legacy_Auth
>>> and
>>> WireCrypt = Enabled
>>>
>>> Last setting s ignored currently (i.e. may be missing) but will be
>>> required in release.
>>> Also make sure that security database contains an entry in old format
>>> for a user whose credentials you expect to use to connect. To do it
>>> temporary set
>>> UserManager = Legacy_Auth
>>> and use any tool to work with users list. Don't forget to restore
>>> default when you over with this task.
>> Thank you Alex, for your detailed information. Will there be a way to
>> connect without decrease of security level?
>>
> 
> The only way is to modify 2.5 to make it support 3.0 remote protocol: 
> the main problem is insecure transfer of short password over the wire.
> But affraid it's not realistic. Could we have providers architecture in 
> 2.5 it could be done easily (adding remote client provider from 3.0). 
> But providers arrived also just in 3.0.
> 
> 
> --
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and 
> their applications. This 200-page book is written by three acclaimed 
> leaders in the field. The early access version is available now. 
> Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
> 

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (04 51) 399 04 - 525 • Fax +49 (04 51) 399 04 - 559
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and 
their applications. This 200-page book is written by three acclaimed 
leaders in the field. The early access version is available now. 
Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] "execute statement on external" between FB2.5 and FB3

[Thomas Beckmann]

> To make it possible to connect from pre-3 server/client to fb3-server 
> you should configure fb3 server (unfortunately lowing it's security level).
> In firebird.conf set
> AuthServer = Srp, Win_Sspi, Legacy_Auth
> and
> WireCrypt = Enabled
> 
> Last setting s ignored currently (i.e. may be missing) but will be 
> required in release.
> Also make sure that security database contains an entry in old format 
> for a user whose credentials you expect to use to connect. To do it 
> temporary set
> UserManager = Legacy_Auth
> and use any tool to work with users list. Don't forget to restore 
> default when you over with this task.

Thank you Alex, for your detailed information. Will there be a way to
connect without decrease of security level?

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (04 51) 399 04 - 525 • Fax +49 (04 51) 399 04 - 559
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and 
their applications. This 200-page book is written by three acclaimed 
leaders in the field. The early access version is available now. 
Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] "execute statement on external" between FB2.5 and FB3

[Thomas Beckmann]

Is there a way to execute a statement on FB3.0-server from 2.5 by
"execute statement on external"? At least, I did not manage to
successfully connect...

Thank you for any hints! Thomas
-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (04 51) 399 04 - 525 • Fax +49 (04 51) 399 04 - 559
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and 
their applications. This 200-page book is written by three acclaimed 
leaders in the field. The early access version is available now. 
Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4084) Group by fails if subselect-column is involved

[Thomas Beckmann (JIRA)]

Group by fails if subselect-column is involved
--

 Key: CORE-4084
 URL: http://tracker.firebirdsql.org/browse/CORE-4084
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0 Alpha 1
 Environment: W7/64, WI-T3.0.0.30338 Firebird 3.0 Unstable 
Reporter: Thomas Beckmann
Priority: Critical


The following statement works as expected in FB2.5 but fails in 3.0, returning 
"SQL error code = -104. Invalid expression in the select list (not contained in 
either an aggregate function or the GROUP BY clause)." 

select
  iif(D is null, 10, 0) + SYS as SYS,
  count(*)
from (select
(select d.RDB$RELATION_ID from RDB$DATABASE d) as D,
coalesce(r.RDB$SYSTEM_FLAG, 0) as SYS
  from RDB$RELATIONS r)
group by 1

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4082) Wrong error message

[Thomas Beckmann (JIRA)]

Wrong error message
---

 Key: CORE-4082
 URL: http://tracker.firebirdsql.org/browse/CORE-4082
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0 Alpha 1
 Environment: W7/64, WI-T3.0.0.30338 Firebird 3.0 Unstable
Reporter: Thomas Beckmann
Priority: Minor


The following statement 

execute block returns (U varchar(14)) as begin U = gen_uuid(); suspend; end;

results in the error message:

"Arithmetic overflow or division by zero has occurred.
arithmetic exception, numeric overflow, or string truncation.
string right truncation.
expected length 16, actual 16."

The error is fine, of course, but the message should point out the expected 
length to be 14...

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4081) Buildin function no longer supported in "update or insert" value list

[Thomas Beckmann (JIRA)]

Buildin function no longer supported in "update or insert" value list
-

 Key: CORE-4081
 URL: http://tracker.firebirdsql.org/browse/CORE-4081
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0 Alpha 1
 Environment: W7/64, WI-T3.0.0.30317 Firebird 3.0 Unstable 
Reporter: Thomas Beckmann


Consider the following test case:

create table TEST (UID varchar(64));

update or insert into TEST (UID) values (uuid_to_char(gen_uuid())) matching 
(UID);

This leads to "column unknown" in FB3.0 while it works in FB2.5.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4075) Server crashes on exception in calculated index

[Thomas Beckmann (JIRA)]

Server crashes on exception in calculated index
---

 Key: CORE-4075
 URL: http://tracker.firebirdsql.org/browse/CORE-4075
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0 Alpha 1
 Environment: W7/63, WI-T3.0.0.30317 Firebird 3.0 Unstable
Reporter: Thomas Beckmann


Consider the following example:

create table TEST (BIT smallint);
create index IDX_TEST_BIT on TEST computed by (bin_shl(1, TEST.BIT-1));

insert into test values (0);

Of course, insertion should lead to an exception. Unfortunately, it crashes the 
server.


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire 
the most talented Cisco Certified professionals. Visit the 
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] RFC: non-expandable fields

[Thomas Beckmann]

Back to the question, Vlad asked (we are already discussing how it could
be done and whether one or the other approach would fit): Is this a
feature, Firebird should support?

I'm not familiar enough with the SQL-specification to answer whether
it's standard compliant or not, but if it isn't, I would not implement
it. As mentioned before, there are a lot of ways solving the original
problem (replication) without modifying the tables with "meta" fields
and furthermore, "select * " is - though allowed and sometimes useful -
nothing that has to take place in a sophisticated, database relying
application, particulary, if this is even replicated.

I really love to have a feature rich database engine, but I think, this
feature is of no significant use.

Thomas

Am 04.04.2013 23:39, schrieb Ann Harrison:
> 
> On Thu, Apr 4, 2013 at 3:29 PM, Sergey Mereutsa  <mailto:s...@dqteam.com>> wrote:
> 
> Hello Vlad and all,
> 
> IMHO, the easiest way to implement this is to make all fields with
> prefix "RDB$" (or whatever) hidden by default. Untill you do not
> address to those fields directly - they are ignored by the engine,
> when data is fetched.
> 
> 
> There's a perfectly good flag field in RDB$RELATION_FIELDS.  No
> reason to make dependencies on the field name.  I'm not going to
> opine on the value of the feature, just don't make it depend on a 
> naming artifact.
> 
> Cheers.
> 
> Ann
>  
> 
> 
> --
> Minimize network downtime and maximize team effectiveness.
> Reduce network management and security costs.Learn how to hire 
> the most talented Cisco Certified professionals. Visit the 
> Employer Resources Portal
> http://www.cisco.com/web/learning/employer_resources/index.html
> 
> 
> 
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
> 

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (04 51) 399 04 - 525 • Fax +49 (04 51) 399 04 - 559
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire 
the most talented Cisco Certified professionals. Visit the 
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] RFC: non-expandable fields

[Thomas Beckmann]

Hi Vlad,

I see two aspects:

- With "RDB$DB_KEY" there already is a hidden field (though this one is
not in 'RDB$RELATION_FIELDS'), so it might not be that surprising to
have this beeing a feature of FB.
- On the other hand, I would not like neither your statement a) nor b)
in our code, nor do I see the necessity of adding fields to a table for
replication purpose ;-) ...

I guess it's not to hard to implement, but I would expect it to be used
very rarely.

Thomas

Am 04.04.2013 15:27, schrieb Vlad Khorsun:
> Hi all,
> 
> i wrote this RFC by request of one local company which have (as many others)
> wrote own replicator and got some issues which could be resolved very easy 
> with a little support from the Firebird engine side. I think we could discuss 
> it and
> determine if requested feature could add some value to the engine for wider
> audience.
> 
>   Their software (replicator) add's some service field(s) to the customer 
> tables
> to track changes. In most cases it doesn't harm and customer software works
> as expected, i.e. ignores unknown for it new fields. But there are two cases
> when such service fields could change application's logic and even broke it. I
> mean queries where list of fields is not set explicitly by a programmer but
> expanded by the engine in run-time:
> a) select * from table
> b) insert into table values (...)
> 
>   So, the proposition is simple: add ability for engine to distinguish such 
> service
> fields and not include it into auto expanded list of fields for table or view 
> at the 
> queries above. I.e. service fields is fully accessible if present in query 
> text explicitly 
> and "hidden" otherwise.
> 
>   I prefer to discuss implementation details after (if) we agreed on 
> feasibility of 
> such feature.
> 
> Comments, ideas are welcome ;)
> Vlad
> 
> --
> Minimize network downtime and maximize team effectiveness.
> Reduce network management and security costs.Learn how to hire 
> the most talented Cisco Certified professionals. Visit the 
> Employer Resources Portal
> http://www.cisco.com/web/learning/employer_resources/index.html
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
> 

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (04 51) 399 04 - 525 • Fax +49 (04 51) 399 04 - 559
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire 
the most talented Cisco Certified professionals. Visit the 
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4073) Constant columns getting empty value with subselect from procedure in procedure or execute block

[Thomas Beckmann (JIRA)]

Constant columns getting empty value with subselect from procedure in procedure 
or execute block


 Key: CORE-4073
 URL: http://tracker.firebirdsql.org/browse/CORE-4073
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0 Alpha 1
 Environment: Win7/64, version "WI-T3.0.0.30317 Firebird 3.0 Unstable"
Reporter: Thomas Beckmann
Priority: Critical


Hard to describe, see this example:

set term ^ ;
create or alter procedure P_TEST returns (TEXT D_VC10) as
begin
  TEXT = '12345'; suspend;
end^
set term ; ^

select A, TEXT from (select 2 as A, TEXT from P_TEST);

returns

   A TEXT
 ==
   0 12345

and

select A, TEXT from (select '2' as A, TEXT from P_TEST);

returns 

A  TEXT
== ==
   12345


If the procedure is replaced like this

select A, TEXT from (select '2' as A, '12345' as TEXT from RDB$DATABASE);

everything works fine.

(Of course the above stuff is a simplified test case)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire 
the most talented Cisco Certified professionals. Visit the 
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4072) comment on function/procedure in package

[Thomas Beckmann (JIRA)]

comment on function/procedure in package


 Key: CORE-4072
 URL: http://tracker.firebirdsql.org/browse/CORE-4072
 Project: Firebird Core
  Issue Type: New Feature
  Components: Engine
Affects Versions: 3.0 Alpha 1
 Environment: Win7/64, WI-T3.0.0.30317 Firebird 3.0 Unstable
Reporter: Thomas Beckmann
Priority: Minor


Maybe, I just do not know how to write it, but I thought
"comment on function . is '';" 
would add a comment to the function in a package, but this leads to the error
"Token unknown: ." - complaining about the dot between package name and 
function name.

Is this a bug, a not jet implemented feature or did I just do the wrong thing?

Thank you, Thomas

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire 
the most talented Cisco Certified professionals. Visit the 
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] (Double) Metaphone?

[Thomas Beckmann]

> Can you point out to any existing UDF with this "double metaphone" inside? 
> Without this 
> "can be used right now" is just a lie.

No, sorry, I should have said "could be used right now" ;-) - but still
(please correct me, if I missunderstand this list): Aren't we talking
about building something into the firebird engine?
A UDF can be written by whom-so-ever, the architecture is there and does
not need to be developed by the firebird developer team...
-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (04 51) 399 04 - 525 • Fax +49 (04 51) 399 04 - 559
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire 
the most talented Cisco Certified professionals. Visit the 
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] (Double) Metaphone?

[Thomas Beckmann]

>>>>> Second: I'd like to have this like a plugin architecture,
>>>> The most simple requirement - just write UDF (or in FB3 external
>>>> function). No other plugins are needed.
>>> I think that Thomas meant was a phonetic matching function that can be
>>> configured in a way similar to collations, i.e. for this language, use
>>> these phonetic rules. No programming, just config.
>> Sorry - plugin means adding _code_, not just doing configuration.

"Plugin" does not express any means on what is plugged in, whether a
config file, particular code or a UDF.

We are talking about building something into the firebird engine, not a
UDF - because a UDF can be used right now, there is nothing to talk
about on this list.

If you integrate something into the engine, you can consider alternative
2. to 4. that Kjell pointed out.
What I think is, that trying approach 4 will be doomed to fail, and
approach 2 is - well I'd not say "useless", but probably not worth the
efford. Thus, we should try to find a way to make this extensible just
like collations.

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (04 51) 399 04 - 525 • Fax +49 (04 51) 399 04 - 559
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire 
the most talented Cisco Certified professionals. Visit the 
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] (Double) Metaphone?

[Thomas Beckmann]

Hi,

I followed the discussion silently, and let me just give my2c:

First: Even an english only algorithm is better than none; maybe,
writing your application, you'd have to find some workarounds.

Second: I'd like to have this like a plugin architecture, similar to the
well known dictionairies - sure, this needs some more thinking about -
but this would return the task to the people asking for language XYZ:
And I'm sure we'll find some volunteers helping us out there.

Thomas

Am 02.04.2013 22:42, schrieb Kjell Rilbe:
> 
> Den 2013-03-30 10:02 skrev m. Th. såhär:
>> Hi,
>>
>> More and more lately it feels the need to have an aproximate
>> (phonetic) search on character fields.
>> In fact it is a common feature nowadays (thanks, Google) and the users
>> want to see it also in their applications.
>> [snip]I would propose a Double Metaphone implementation in FB 3.0
>> For Double Metaphone see in the middle of the Wikipedia Metaphone page:
>> http://en.wikipedia.org/wiki/Metaphone
>>
>> Comments?
> 
> Well, I've been looking a few times for phonetic matching algorithms
> that would work for Swedish data. I did read about Metaphone as well as
> a few others.
> 
> The problem with a built-in phonetic matching engine in FB is that it
> would either be huge or useless. If it's supposed to support only
> English data, including names from other languages but pronounced in
> English, that would be fine, but for most applications quite useless. A
> lot of data exists out there that's not English at all.
> 
> Transliterating e.g. Cyrillic, Hebrew or other alphabets into some latin
> alphabet (a-z? a-ö like Swedish? What about ü, ï, Ç etc?) would not be
> enough. The fact is that the same latin-alphabet word can sound
> completely different in different languages.
> 
> Take my name as an example: kjell. In English it's almost
> "unpronouncable"(?) like "jelly" with a "K" in front and drop the
> trailing "Y". But it does in fact sound like an Englishman would
> pronounce "chell" (not "shell").
> 
> For this to work, the phonetic engine would have to know the
> pronunciation rules of hundreds of different languages. A huge task.
> 
> Otherwise, many many applications would be unable to use it.
> 
> In an ideal world I'd say "Yes, go for it!", because I would just love
> this feature. But in the real world I think the development time should
> be put to better use.
> 
> Regards,
> Kjell
> 
> -- 
> --
> Kjell Rilbe
> DataDIA AB
> E-post: kj...@datadia.se
> Telefon: 08-761 06 55
> Mobil: 0733-44 24 64
> 
> 
> 
> --
> Minimize network downtime and maximize team effectiveness.
> Reduce network management and security costs.Learn how to hire 
> the most talented Cisco Certified professionals. Visit the 
> Employer Resources Portal
> http://www.cisco.com/web/learning/employer_resources/index.html
> 
> 
> 
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
> 

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (04 51) 399 04 - 525 • Fax +49 (04 51) 399 04 - 559
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire 
the most talented Cisco Certified professionals. Visit the 
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4071) external function declaration with "returns parameter" crashes the server

[Thomas Beckmann (JIRA)]

external function declaration with "returns parameter" crashes the server
-

 Key: CORE-4071
 URL: http://tracker.firebirdsql.org/browse/CORE-4071
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0 Alpha 1
 Environment: Win7 64, Firebird/Windows/Intel/i386 (access method), 
version "WI-T3.0.0.30287 Firebird 3.0 Unstable"
on disk structure version 12.0
        Reporter: Thomas Beckmann
Priority: Critical


Declaration of external function that returns parameter fails with server crash:

eg.
declare external function B_LOADFROMFILE cstring(16383), blob returns parameter 
2 entry_point 'fn_b_load' module_name 'rfunc';

I tried it with a couple of declarations, those w/o "returns parameter" work 
fine, those with crash.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Own the Future-Intel® Level Up Game Demo Contest 2013
Rise to greatness in Intel's independent game demo contest.
Compete for recognition, cash, and the chance to get your game 
on Steam. $5K grand prize plus 10 genre and skill prizes. 
Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4070) NOT-NULL-column can be used as primary key and filled with NULL-values

[Thomas Beckmann (JIRA)]

NOT-NULL-column can be used as primary key and filled with NULL-values
--

 Key: CORE-4070
 URL: http://tracker.firebirdsql.org/browse/CORE-4070
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0 Alpha 1
 Environment: Windows 7 64, ISQL, Version: WI-T3.0.0.30287 Firebird 3.0 
Unstable
Reporter: Thomas Beckmann
Priority: Critical


I guess, this should not be possible:

SQL> show version;
ISQL Version: WI-T3.0.0.30287 Firebird 3.0 Unstable
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-T3.0.0.30287 Firebird 
3.0 Unstable"
on disk structure version 12.0
SQL> create table TEST$DATABASE (UID char(16) character set OCTETS collate 
OCTETS);
SQL> alter table TEST$DATABASE add primary key (UID);
SQL> commit;
SQL> insert into TEST$DATABASE (UID) values (null);
SQL> insert into TEST$DATABASE (UID) values (null);
SQL> commit;
SQL> show table TEST$DATABASE;
UID CHAR(16) CHARACTER SET OCTETS Nullable
CONSTRAINT INTEG_21:
  Primary key (UID)
SQL> select * from TEST$DATABASE;

UID




-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Own the Future-Intel® Level Up Game Demo Contest 2013
Rise to greatness in Intel's independent game demo contest.
Compete for recognition, cash, and the chance to get your game 
on Steam. $5K grand prize plus 10 genre and skill prizes. 
Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] FB3.0 Bug in nested join

[Thomas Beckmann]

Thanks alot, Dimitry, I didn't know about the new (SQL spec conforming)
restirction you mentioned in your prior post!

Thomas

> Sorry, I thought that your issue was caused by the i.RDB$RELATION_NAME = 
> rf.RDB$RELATION_NAME condition, but it's not. So there's only one error 
> and it's explained in my prior message. No bugs here, everything is as 
> designed. The query should be rewritten as:
> 
> select
>rf.RDB$RELATION_NAME,
>rf.RDB$FIELD_NAME,
>s.RDB$INDEX_NAME
> from RDB$RELATION_FIELDS rf
> left join (
>RDB$INDICES i
>join RDB$INDEX_SEGMENTS s
>  on i.RDB$INDEX_NAME = s.RDB$INDEX_NAME
>join RDB$RELATION_CONSTRAINTS rc
>  on rc.RDB$INDEX_NAME = s.RDB$INDEX_NAME
>and rc.RDB$CONSTRAINT_TYPE = 'FOREIGN KEY'
>) on i.RDB$RELATION_NAME = rf.RDB$RELATION_NAME
>  and s.RDB$FIELD_NAME = rf.RDB$FIELD_NAME
> where
>rf.RDB$FIELD_SOURCE starting with 'D_FK_'
> 
> 
> Dmitry
> 
> 
> --
> Own the Future-Intel® Level Up Game Demo Contest 2013
> Rise to greatness in Intel's independent game demo contest.
> Compete for recognition, cash, and the chance to get your game 
> on Steam. $5K grand prize plus 10 genre and skill prizes. 
> Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
> 

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (04 51) 399 04 - 525 • Fax +49 (04 51) 399 04 - 559
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
Own the Future-Intel® Level Up Game Demo Contest 2013
Rise to greatness in Intel's independent game demo contest.
Compete for recognition, cash, and the chance to get your game 
on Steam. $5K grand prize plus 10 genre and skill prizes. 
Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] FB3.0 Bug in nested join

[Thomas Beckmann]

It seems to me we have a bug in nested joins:

Consider the statement below. It's supposed to show foreign key fields
which it does nicely with FB2.5. With 3.0 you'll get the error "Column
unknown. RF.RDB$FIELD_NAME. At line 11, column 32." - this is the
postponed on clause (i.RDB$RELATION_NAME = rf.RDB$RELATION_NAME):

select
  rf.RDB$RELATION_NAME,
  rf.RDB$FIELD_NAME,
  s.RDB$INDEX_NAME
from RDB$RELATION_FIELDS rf
left join (RDB$INDICES i
  join RDB$INDEX_SEGMENTS s
on i.RDB$INDEX_NAME = s.RDB$INDEX_NAME and s.RDB$FIELD_NAME =
rf.RDB$FIELD_NAME
  join RDB$RELATION_CONSTRAINTS rc
on rc.RDB$INDEX_NAME = s.RDB$INDEX_NAME and rc.RDB$CONSTRAINT_TYPE =
'FOREIGN KEY')
  on i.RDB$RELATION_NAME = rf.RDB$RELATION_NAME
where
  rf.RDB$FIELD_SOURCE starting with 'D_FK_'

Did I miss something or does this turn out to be a bug?

Greetings, Thomas
-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (04 51) 399 04 - 525 • Fax +49 (04 51) 399 04 - 559
Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

--
Own the Future-Intel® Level Up Game Demo Contest 2013
Rise to greatness in Intel's independent game demo contest.
Compete for recognition, cash, and the chance to get your game 
on Steam. $5K grand prize plus 10 genre and skill prizes. 
Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4068) create package fails on creating header as soon as there is at least 1 procedure name

[Thomas Beckmann (JIRA)]

create package fails on creating header as soon as there is at least 1 
procedure name
-

 Key: CORE-4068
 URL: http://tracker.firebirdsql.org/browse/CORE-4068
 Project: Firebird Core
  Issue Type: Bug
Affects Versions: 3.0 Alpha 1
 Environment: Windows 7 64, Firebird "WI-T3.0.0.30281 Firebird 3.0 
Unstable"
Reporter: Thomas Beckmann
Priority: Critical


The code in the examples file fbout-header.sql fails:

SQL> create or alter package fb$out
CON> as
CON> begin
CON>   procedure enable;
CON> end!
Statement failed, SQLSTATE = XX001
corrupt system table
-Error while parsing procedure FB$OUT.ENABLE's BLR

If I leave out the procedure name, the package can be created. I did not manage 
to create any package containg a procedure. I did a backup/restore of the 
database, that has just been created.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel