Arithmetic Overflow .. error 335544321 for ORDER BY

Article View: borland.public.interbase.sql

Article #876

Back to borland.public.interbase.sql Previous Next

#876

From: Adalberto Baldini
Date: Sun, 17 Jun 2007 09:47

26 lines
1736 bytes

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.

I tried option :
  Order By  3,4
  Order By  CODGIO, CODDOC
  Order By  DOCGIO.CODGIO, DOCGIO.CODDOC
with same error.

Thanks for help.
Adalberto Baldini

Technical Details

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

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,b65ddf6ccabfce00,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Sun, 17 Jun 2007 11:47:47 +0200
From: Adalberto Baldini <finman@swissonline.ch>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Arithmetic Overflow ..  error  335544321  for ORDER BY
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 84.74.35.221
Message-ID: <46750340$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1182073664 84.74.35.221 (17 Jun 2007 02:47:44 -0700)
Lines: 26
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail