Bug with "create or alter procedure"

classic Classic list List threaded Threaded
15 messages Options
Reply | Threaded
Open this post in threaded view
|

Bug with "create or alter procedure"

Si Carter
Ive added the listing here
(http://sourceforge.net/tracker/index.php?func=detail&aid=1303307&group_id=1
24340&atid=699234), thought I'd mention it here as well as the only way to
return the list to normal is to disconnect/reconnect.

Rgds

Si Carter
http://www.tectsoft.net/
http://www.fbtalk.net/




-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server.
Download it for free - -and be entered to win a 42" plasma tv or your very
own Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel
Reply | Threaded
Open this post in threaded view
|

Re: Bug with "create or alter procedure"

Milan Babuskov-5
Simon Carter wrote:
> Ive added the listing here
> (http://sourceforge.net/tracker/index.php?func=detail&aid=1303307&group_id=1
> 24340&atid=699234), thought I'd mention it here as well as the only way to
> return the list to normal is to disconnect/reconnect.

Can anyone reproduce this with CVS version? I can't. If nobody can, I
guess the bug was fixed while migration to wxString.

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org



-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel
Reply | Threaded
Open this post in threaded view
|

RE: Bug with "create or alter procedure"

Si Carter
> -----Original Message-----
> Can anyone reproduce this with CVS version? I can't. If
> nobody can, I guess the bug was fixed while migration to wxString.

If anyone wants to make an interim build available, I will gladly test it
:-)

Rgds

Si Carter
http://www.tectsoft.net/
http://www.fbtalk.net/



-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel
Reply | Threaded
Open this post in threaded view
|

Re: Bug with "create or alter procedure"

Milan Babuskov-2
Simon Carter wrote:
>>-----Original Message-----
>>Can anyone reproduce this with CVS version? I can't. If
>>nobody can, I guess the bug was fixed while migration to wxString.
>
>
> If anyone wants to make an interim build available, I will gladly test it
> :-)

Please find it here:
http://www.flamerobin.org/test/04oct2005.zip

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org



-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel
Reply | Threaded
Open this post in threaded view
|

Re: Bug with "create or alter procedure"

Milan Babuskov-2
In reply to this post by Si Carter
Hi all,

I haven't received this e-mail, so I'm resending it. Sorry if you
already got it.

Simon Carter wrote:
>>-----Original Message-----
>>Can anyone reproduce this with CVS version? I can't. If
>>nobody can, I guess the bug was fixed while migration to wxString.
>
>
> If anyone wants to make an interim build available, I will gladly test it
> :-)

Please find it here:
http://www.flamerobin.org/test/04oct2005.zip

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org




-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel
Reply | Threaded
Open this post in threaded view
|

RE: Bug with "create or alter procedure"

Si Carter
> -----Original Message-----
> >>Can anyone reproduce this with CVS version? I can't. If
> nobody can, I
> >>guess the bug was fixed while migration to wxString.
> >

I have just tested the original bug (1303307) with this build (4 Oct 2005)
and it still occurs.

Rgds

Si Carter
http://www.tectsoft.net/
http://www.fbtalk.net/



-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel
Reply | Threaded
Open this post in threaded view
|

Re: Bug with "create or alter procedure"

Milan Babuskov-2
Simon Carter wrote:
> I have just tested the original bug (1303307) with this build (4 Oct 2005)
> and it still occurs.

Nando, Michael, could you please test?

Thanx,

--
Milan Babuskov
http://www.flamerobin.org



-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel
Reply | Threaded
Open this post in threaded view
|

Re: Bug with "create or alter procedure"

Nando Dessena
Milan,

M> Simon Carter wrote:
>> I have just tested the original bug (1303307) with this build (4 Oct 2005)
>> and it still occurs.

M> Nando, Michael, could you please test?

I see that Michael has already added a comment to the tracker issue
that explains the behaviour. I can only say that I cannot confirm the
exact steps in the bug description: the first time you run the
supplied script you get just one procedure FOO in the tree; if you
re-run it you get an additional FOO entry each time.

I think it's a critical bug.

Ciao
--
Nando Dessena
http://www.flamerobin.org



-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel
Reply | Threaded
Open this post in threaded view
|

Re: Bug with "create or alter procedure"

Milan Babuskov-2
Nando Dessena wrote:
> M> Nando, Michael, could you please test?
>
> I see that Michael has already added a comment to the tracker issue
> that explains the behaviour.

I've seen it too, but haven't been able to reproduce with or without spaces.

> I can only say that I cannot confirm the
> exact steps in the bug description

Me neither.

>: the first time you run the
> supplied script you get just one procedure FOO in the tree; if you
> re-run it you get an additional FOO entry each time.

I'll check that out.

> I think it's a critical bug.

It sure is. I wanted to fix it, but was unable to reproduce using the
supplied example...

--
Milan Babuskov
http://www.flamerobin.org



-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel
Reply | Threaded
Open this post in threaded view
|

RE: Bug with "create or alter procedure"

Si Carter

> -----Original Message-----
> It sure is. I wanted to fix it, but was unable to reproduce
> using the supplied example...


A bit bonkers, ive just tried the sample given in the bug report, i.e.
(everything between dotted lines)

------------------------------------------------
set term ## ;
create or alter procedure foo(inparam INTEGER)
returns (outparam integer)
as
BEGIN
end ##

set term ; ##

commit;
-----------------------------------------------------------

And it still reproduces in 0.4.0

Rgds

Si



-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel
Reply | Threaded
Open this post in threaded view
|

Re: Bug with "create or alter procedure"

Nando Dessena
Simon,

S> A bit bonkers, ive just tried the sample given in the bug report, i.e.
S> (everything between dotted lines)

S> ------------------------------------------------
S> set term ## ;
S> create or alter procedure foo(inparam INTEGER)
S> returns (outparam integer)
S> as
S> BEGIN
S> end ##

S> set term ; ##

S> commit;
S> -----------------------------------------------------------

S> And it still reproduces in 0.4.0

running it only one time and on a database that doesn't have a FOO
procedure already?

Ciao
--
Nando Dessena
http://www.flamerobin.org



-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel
Reply | Threaded
Open this post in threaded view
|

Re: Bug with "create or alter procedure"

Milan Babuskov-2
In reply to this post by Nando Dessena
Nando Dessena wrote:

> M> Simon Carter wrote:
>
>>>I have just tested the original bug (1303307) with this build (4 Oct 2005)
>>>and it still occurs.
>
> the first time you run the
> supplied script you get just one procedure FOO in the tree; if you
> re-run it you get an additional FOO entry each time.
>
> I think it's a critical bug.

Fixed in CVS.

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org



-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel
Reply | Threaded
Open this post in threaded view
|

RE: Bug with "create or alter procedure"

Si Carter
In reply to this post by Nando Dessena
 

> -----Original Message-----
> running it only one time and on a database that doesn't have
> a FOO procedure already?

Running it more than once, with or without an existing foo

Rgds

Si Carter
http://www.tectsoft.net/
http://www.fbtalk.net/



-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel
Reply | Threaded
Open this post in threaded view
|

Re: Bug with "create or alter procedure"

Nando Dessena
Simon,

S> Running it more than once

OK; *that* was the piece missing from the bug report. :-)

Ciao
--
Nando Dessena
http://www.flamerobin.org



-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel
Reply | Threaded
Open this post in threaded view
|

RE: Bug with "create or alter procedure"

Si Carter

> -----Original Message-----
> OK; *that* was the piece missing from the bug report. :-)

:-(, missed that sorry, it was late! Not that that's an excuse.  I take it
its fixed now as its closed.

Rgds

Si Carter
http://www.tectsoft.net/
http://www.fbtalk.net/

 



-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel