Bug #13260 On Linux UPDATE STATISTICS doesn't work with colum names
Submitted: 16 Sep 2005 11:33 Modified: 11 Oct 2005 14:20
Reporter: Robert Klemme Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MaxDB Severity:S3 (Non-critical)
Version:7.5.0.30 OS:Linux (Linux 2.4.21-27.EL)
Assigned to: CPU Architecture:Any

[16 Sep 2005 11:33] Robert Klemme 
Description:
OS: RedHat Enterprise Linux 3

UPDATE STATISTICS on this Linux version doesn't accept tablename.columname although DBA.SYSUPDSTATWANTED contains combinations with a non NULL column name. This works ok with Windows version 7.5.0.18.

How to repeat:
Execute

SELECT tablename, columnname FROM DBA.SYSUPDSTATWANTED

Then chose any of the results that has a non NULL columnname.

Try to execute

UPDATE STATISTICS <table>.<column> ESTIMATE SAMPLE 20 PERCENT

For example

UPDATE STATISTICS S_DATADICTIONARYDETAIL.INDEXID ESTIMATE SAMPLE 20 PERCENT

You'll see

---- Error -------------------------------
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
Base table not found;-4004 POS(1) Unknown table name.
UPDATE STATISTICS S_DATADICTIONARYDETAIL.INDEXID ESTIMATE SAMPLE 20 PERCENT

Using double quotes around table and column name shows no effect.
[16 Sep 2005 11:36] Robert Klemme 
This happens also with user tables.  It's a coincidence that I used a system table as example.
[11 Oct 2005 14:20] Robert Klemme 
When using this SQL statement it works:

UPDATE STATISTICS COLUMN S_DATADICTIONARYDETAIL.INDEXID ESTIMATE SAMPLE 20 PERCENT

So it's seems rather a bug of the older version that accepted this statement without "COLUMN" although documentation said "COLUMN" had to be there.