Seagate ST43401N/ND Technical Information PDF herunterladen (Seite 62)

5-8 Implement: Making Required Application Changes

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

arithignore arith_overﬂow

The command:

set arithignore arith_overflow

speciﬁes whether error messages are sent upon numeric overﬂow

The command options are:

ON: Doesn’t advise application of overﬂow or divide-by-zero errors

OFF (Default): Advises application of overﬂow or divide-by-zero

errors

Subquery Processing Changes

This section describes changes in subquery processing. The

examples used are from the pubs2 sample database supplied with

your software. For more information about pubs2 and its tables, see

the Reference Supplement. Changes to query processing include:

• in and any 5-8

• not in 5-9

• or...exists/in/any 5-10

• >all and <all 5-10

• Correlated Subqueries 5-11

• Aggregates with exists 5-12

• select distinct 5-13

in and any

Subqueries with

in and any no longer return duplicate rows. In

version 4.x, SQL Server processed the query in the example below as

a join and returned one row from the outer table for each matching

row from the inner table.

However, the semantics of ANSI existence tests prevent rows from

the outer query being returned more than once. If your application

requires duplicate rows, it will break.

This example, taken from the pubs2 sample database, shows how

result sets changed between 4.x and 10.0:

select pub_name from publishers

where pub_id in

(select pub_id from titles)

1 2 ... 57 58 59 60 61 62 63 64 65 66 67 ... 171 172

Keine Kommentare

Seagate ST43401N/ND Technical Information Seite 62