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.

Not all rows inserted then selecting from Proxy Tables

2 posts in General Discussion Last posting was on 2009-05-13 11:14:04.0Z
Evaldas Posted on 2009-05-13 07:24:58.0Z
Sender: 4138.4a0a73dc.1804289383@sybase.com
From: Evaldas
Newsgroups: ianywhere.public.general
Subject: Not all rows inserted then selecting from Proxy Tables
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a0a75ca.416b.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 May 2009 00:24:58 -0700
X-Trace: forums-1-dub 1242199498 10.22.241.41 (13 May 2009 00:24:58 -0700)
X-Original-Trace: 13 May 2009 00:24:58 -0700, 10.22.241.41
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7552
Article PK: 5960

Hello,
I'm running SQL from several joined Proxy Tables, which
referes to another ASA 9 database server. And it returns not
all rows.

My SQL example:

select Column1, Column2 into MyDestinationTable
from ProxyTable1 inner join ProxyTable2 on (id1=id2)
--
If i run SQL with count:
select count(*)
from
(
select Column1, Column2 into MyDestinationTable
from ProxyTable1 inner join ProxyTable2 on (id1=id2)
) as SubQuery

I've got for example 100 (100 rows), but then I
select count(*) from MyDestinationTable
I've got just 80rows


Glenn Paulley [Sybase iAnywhere] Posted on 2009-05-13 11:14:04.0Z
From: "Glenn Paulley [Sybase iAnywhere]" <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Not all rows inserted then selecting from Proxy Tables
References: <4a0a75ca.416b.1681692777@sybase.com>
In-Reply-To: <4a0a75ca.416b.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a0aab7c$1@forums-1-dub>
Date: 13 May 2009 04:14:04 -0700
X-Trace: forums-1-dub 1242213244 10.22.241.152 (13 May 2009 04:14:04 -0700)
X-Original-Trace: 13 May 2009 04:14:04 -0700, vip152.sybase.com
Lines: 46
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7554
Article PK: 5959

Please don't cross-post. I've responded to your thread on
sybase.public.sqlanywhere.general newsgroup.

Glenn

Evaldas wrote:
> Hello,
> I'm running SQL from several joined Proxy Tables, which
> referes to another ASA 9 database server. And it returns not
> all rows.
>
> My SQL example:
>
> select Column1, Column2 into MyDestinationTable
> from ProxyTable1 inner join ProxyTable2 on (id1=id2)
> --
> If i run SQL with count:
> select count(*)
> from
> (
> select Column1, Column2 into MyDestinationTable
> from ProxyTable1 inner join ProxyTable2 on (id1=id2)
> ) as SubQuery
>
> I've got for example 100 (100 rows), but then I
> select count(*) from MyDestinationTable
> I've got just 80rows

--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport