Seagate ST43401N/ND Información técnica descargar pdf (Pagina 65)

Migrating to Sybase Adaptive Server Enterprise 11.5 5-11

Adaptive Server Enterprise 11.5 If Your Current Version is 4.x

select title

from titles t1

where t1.advance > all

(select advance

from publishers p, titles t2

where

p.pub_name=”No Such Publisher”

and t2.pub_id = p.pub_id)

Correlated Subqueries

Release 4.x erroneously suppressed duplicates if all columns in the

outer query also were used in the subquery.

If you rewrite release 4.x subqueries for release 11.5, they will return

correct results. As a result of the new behavior:

• The client has additional rows to process.

• The application has to be able to handle the duplicates.

This example uses tables from pubs2 to compare results returned by

different releases:

select pub_id,

(select count(*) from publishers

where publishers.pub_id = titles.pub_id

Release 4.x

Results

Release 10.x and 11.x

Results

NULL all rows in the titles table

1 2 ... 60 61 62 63 64 65 66 67 68 69 70 ... 171 172

Sin comentarios

Seagate ST43401N/ND Información técnica Pagina 65