
Known Issues in Release 2.0
Reference Topic/Area Issue Description / Workaround
EXT-1107 Netezza Spatial
Package
A ST_DWithin function performed on two points does not return
TRUE when increasing the distance value past 18945535.
nzsql -u $NZ_USER -pw $NZ_PASSWORD -c "SELECT
ST_DWithin(ST_Point(0,0), ST_Point(0,1), 18945535,
'meter', 'wgs84');"
ST_DWITHIN
------------
t
(1 row)
nzsql -u $NZ_USER -pw $NZ_PASSWORD -c "SELECT
ST_DWithin(ST_Point(0,0), ST_Point(0,2), 18945536,
'meter', 'wgs84');"
ST_DWITHIN
------------
f
(1 row)
EXT-1223 Netezza Matrix
Engine
All matrices in a database are owned by INZAUSER. Also, any
"inza user" in the database runs the Matrix Engine commands as
INZAUSER. Therefore, if user A creates a matrix, then user B
can see the matrix. It is not possible to grant that permission (or
revoke it) to make matrices invisible to users.
This is in conflict with all other database objects in a Netezza
system. Objects have permissions granted on them (or revoked
on them) to users - otherwise the users cannot see them or oper-
ate on them.
Furthermore, any Netezza Analytics user in a database can drop
any other user's matrices. There is no protection.
EXT-1224 Netezza Matrix
Engine
(Related to EXT-1223)
Users who have not been given permissions to a particular data-
base on the Netezza System may still be able to list, view, print,
and delete matrices on that database, despite not being able to
affect tables. For example:
CALL nzm..list_matrices();
CALL nzm..print('ones5x5');
CALL nzm..delete_matrix('ones5x5');
EXT-1225 Netezza Matrix
Engine
If a user is granted Netezza Analytics permissions in a particular
database, then that user can use Netezza Analytics functions in
any other database where they have user permissions (except
nzMatrix functions).
Note that when you grant a user access to Netezza Analytics,
you are performing a global operation, not a per-database opera-
tion, with the exception of nzMatrix which is database-local.
While working as designed, improper use may cause issues.
EXT-1248 KNN, KMEANS DATE type is not supported by KNN and KMEANS algorithms
EXT-1249 MUTUALINFO The MUTUALINFO procedure may hang when run on a IBM
Netezza 1000-12.
EXT-1255 Netezza Analytics Moments, correlations, covariance, Bayesian networks, and
standardization/normalization stored procedures do not allow
NULL values. To use these stored procedures, all NULL values
must be removed from the data.
22
Comentários a estes Manuais