Re: Arithmetic Overflow .. error 335544321 for ORDER BY

Article View: borland.public.interbase.sql

Article #879

Back to borland.public.interbase.sql Previous Next

#879

From: Wayne Niddery [TeamB]
Date: Sun, 17 Jun 2007 16:22

31 lines
2189 bytes

Adalberto Baldini wrote:
> With  IB 8.0.0.123 I get error 335544321 in following query.
>
> select
>  a.CSOC as CSOC, a.NRESERC as NRESERC, a.CODDOC as CODDOC,
>    a.CODGIO as CODGIO,
>  b.TIPDOC, b.DESDOC,
>  c.TIPGIO, c.DESGIO
>  from DOCGIO a
>  left join DOCTIP (a.CSOC, a.NRESERC) b on ( a.CODDOC = b.CODDOC )
>  left join GIOTIP (a.CSOC, a.NRESERC) c on (a.CODGIO = c.CODGIO)
>  where a.CSOC = :csoc and a.NRESERC =:nreserc and
>    Exists (select REC_UPD from FIDOCGIO d where d.CODDOC = b.TIPDOC
>            and d.CODGIO = c.TIPGIO)
>   ORDER BY
>   a.CODGIO, a.CODDOC
>
> If I omit Order By Clause it works.

Does it make any difference if you omit the redundant field aliases? I.e:

  a.CSOC, a.NRESERC, a.CODDOC, a.CODGIO,
  b.TIPDOC, b.DESDOC,
  c.TIPGIO, c.DESGIO

-- 
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"The legitimate powers of government extend to such acts only as are
injurious to others. But it does me no injury for my neighbor to say
there are twenty gods, or no God. It neither picks my pocket nor breaks
my leg." - Thomas Jefferson

Technical Details

Message-ID: <46755fda$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <46750340$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,b65ddf6ccabfce00
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
From: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
Newsgroups: borland.public.interbase.sql
References: <46750340$1@newsgroups.borland.com>
Subject: Re: Arithmetic Overflow ..  error  335544321  for ORDER BY
Date: Sun, 17 Jun 2007 12:22:51 -0400
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 69.17.170.228
Message-ID: <46755fda$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1182097370 69.17.170.228 (17 Jun 2007 09:22:50 -0700)
X-Authenticated-User: wniddery
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message