| Subject | Re: [firebird-support] String right truncation Error |
|---|---|
| Author | Aldo Caruso |
| Post date | 2012-02-25T19:11:03Z |
Mark,
I really don't know why, in the Debian stable version, the Firebird
SS package isn't the final one but a Release Candidate.
On the other hand, your advice worked fine, although I don't figure
why.
In this context, an EXIST clause is more efficient than a IN
clause, but both should be equivalent.
Nevertheless, your advice worked.
Thanks
Aldo
El 25/02/12 14:55, Mark Rotteveel escribió:
I really don't know why, in the Debian stable version, the Firebird
SS package isn't the final one but a Release Candidate.
On the other hand, your advice worked fine, although I don't figure
why.
In this context, an EXIST clause is more efficient than a IN
clause, but both should be equivalent.
Nevertheless, your advice worked.
Thanks
Aldo
El 25/02/12 14:55, Mark Rotteveel escribió:
>[Non-text portions of this message have been removed]
> On 25-2-2012 18:48, Aldo Caruso wrote:
> > I'm running Firebird 2.5.0 on Linux Debian 64 bits
> > Sever version:
> > LI-V2.5.0.26054 Firebird 2.5 Release Candidate 3
>
> You are not even running 2.5.0 final, but RC3. You either need to
> upgrade to 2.5.1 or rewrite your view not to use IN (SELECT ....) but
> EXISTS (SELECT ... ) instead.
>
> Mark
>
> --
> Mark Rotteveel
>
>