Interesting

[Jack Parker]

A newbie-ish fellow here just wrote me to say that on 11.5:

alter table <table>
add
{
col4 char(10)
};

Says "Table altered", but did not add his column.

Since curly brackets are comments - of course it didn't, but I'm surprised that he got a success message. When I try it on my (11.7) machine I get:

8200: User (informix) does not have DBSECADM authority.

Which is also a surprise.

j.

[FRANK]

In our IDS11.50 FC8, it shows,

 

alter table abc_test add { kk int};
#                               ^
# 8200: User (informix) does not have DBSECADM authority.
#

 

Frank

_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

[Jack Parker]

Not sure if Fernando's note went to the group or just to me.

In the case of a system which was upgraded to 11.50 (as opposed to a fresh install) we might expect to see the behaviour I indicated previously.

Good of you to point out that a fresh install of 11.50 behaves as does 11.70

IMHO both behaviors are incorrect.

j.

[Fernando Nunes]

I don't understand exactly why sometimes the "reply" works and others I need to "reply all". It is probably related to the original email headers.
Anyway...

I agree that both behaviors is wrong, although there is a strange "path" in the manual syntax diagram. But from my understanding if it has the "add" it must have something else. So I'd say a bug...

Regarding the error and the fresh install vs an upgrade, the point is that DBSECADM was introduced in version 11.50. On a newly installed instance no user will have the DBSECADM. On an upgraded instance, in order not to break compatibility with existing code, user informix will be granted the DBSECADM. This part is correct and documented, but the base question is the other and I think a 201 - Syntax error should be raised.

Regards.

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...