Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

REWRITE bug?

3 posts in General Discussion (old) Last posting was on 2008-10-09 17:47:27.0Z
Markus KARG Posted on 2008-10-09 14:49:22.0Z
From: "Markus KARG" <karg@quipsy.de>
Newsgroups: sybase.public.sqlanywhere
Subject: REWRITE bug?
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48ee19f2@forums-1-dub>
Date: 9 Oct 2008 07:49:22 -0700
X-Trace: forums-1-dub 1223563762 10.22.241.152 (9 Oct 2008 07:49:22 -0700)
X-Original-Trace: 9 Oct 2008 07:49:22 -0700, vip152.sybase.com
X-Authenticated-User: panorama
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:188
Article PK: 866632

I have executed the following SQL. The result is "11":

SELECT SUM(AX) FROM A WHERE AID IN(SELECT AID FROM A LEFT JOIN B LEFT JOIN C
WHERE C.CX IS NULL OR CX IN (7,8))

Then I did SELECT REWRITE on that SQL, and executed it's result in turn. The
result is "17".

Is that normal that REWRITE is not an exact rewrite but only "something near
to exact"?

Thanks
Markus


Ani Nica Posted on 2008-10-09 15:24:56.0Z
From: "Ani Nica" <anica@sybase.com>
Newsgroups: sybase.public.sqlanywhere
References: <48ee19f2@forums-1-dub>
Subject: Re: REWRITE bug?
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48ee2248$1@forums-1-dub>
Date: 9 Oct 2008 08:24:56 -0700
X-Trace: forums-1-dub 1223565896 10.22.241.152 (9 Oct 2008 08:24:56 -0700)
X-Original-Trace: 9 Oct 2008 08:24:56 -0700, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:190
Article PK: 866635

What version of SA are you using?

Thanks!
--
Ani Nica
Research & Development, Query Processing
iAnywhere Solutions Engineering

"Markus KARG" <karg@quipsy.de> wrote in message
news:48ee19f2@forums-1-dub...
>I have executed the following SQL. The result is "11":
>
> SELECT SUM(AX) FROM A WHERE AID IN(SELECT AID FROM A LEFT JOIN B LEFT JOIN
> C WHERE C.CX IS NULL OR CX IN (7,8))
>
> Then I did SELECT REWRITE on that SQL, and executed it's result in turn.
> The result is "17".
>
> Is that normal that REWRITE is not an exact rewrite but only "something
> near to exact"?
>
> Thanks
> Markus
>


Markus KARG Posted on 2008-10-09 17:47:27.0Z
From: "Markus KARG" <karg@quipsy.de>
Newsgroups: sybase.public.sqlanywhere
References: <48ee19f2@forums-1-dub> <48ee2248$1@forums-1-dub>
Subject: Re: REWRITE bug?
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48ee43af$1@forums-1-dub>
Date: 9 Oct 2008 10:47:27 -0700
X-Trace: forums-1-dub 1223574447 10.22.241.152 (9 Oct 2008 10:47:27 -0700)
X-Original-Trace: 9 Oct 2008 10:47:27 -0700, vip152.sybase.com
X-Authenticated-User: panorama
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:194
Article PK: 866639

SQL Anywhere 11

"Ani Nica" <anica@sybase.com> schrieb im Newsbeitrag
news:48ee2248$1@forums-1-dub...

> What version of SA are you using?
>
> Thanks!
> --
> Ani Nica
> Research & Development, Query Processing
> iAnywhere Solutions Engineering
>
> "Markus KARG" <karg@quipsy.de> wrote in message
> news:48ee19f2@forums-1-dub...
>>I have executed the following SQL. The result is "11":
>>
>> SELECT SUM(AX) FROM A WHERE AID IN(SELECT AID FROM A LEFT JOIN B LEFT
>> JOIN C WHERE C.CX IS NULL OR CX IN (7,8))
>>
>> Then I did SELECT REWRITE on that SQL, and executed it's result in turn.
>> The result is "17".
>>
>> Is that normal that REWRITE is not an exact rewrite but only "something
>> near to exact"?
>>
>> Thanks
>> Markus
>>
>
>