Seagate ST43401N/ND Technické informace stáhnout pdf (Strana 58)

5-4 Implement: Making Required Application Changes

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

Adaptive Server now defaults to the numeric datatype rather than

ﬂoat. For example, this constant:

5.1

is treated as numeric. If you want to use ﬂoat, represent the constant

5.1e0

In addition, the optimizer has trouble with clauses where ﬂoat

columns are joined to numeric arguments. Table 5-2 shows some

examples of different representations of constants as a result of this

change:

➤

Note

Pre-release 10.x Client-Library applications running against 10.0 or higher

SQL Servers map

numeric

ﬂoat

The mathematical functions that return a value of type numeric rather

than ﬂoat are:

• abs

• ceiling

• degrees

• ﬂoor

• power

• radians

• round

• sign

Table 5-2: Different results with numeric rather than ﬂoat datatype

Statement 4.9.2 10.0 and later

select 2147483648 integer overﬂow 2147483648

select 2 * 1.2345678 2.246914 2.24691356

select 2.8 * 5 14.000000 14.0

1 2 ... 53 54 55 56 57 58 59 60 61 62 63 ... 171 172

Žádné komentáře

Seagate ST43401N/ND Technické informace Strana 58