SQLB-2492: SQLBase 12.0 Custom Column on SysUserAuth Causes Load Fail

[Clifford Bass]

Hi,

In my never-ending quest for really odd stuff.... 8) ... here are two more.

A custom column is added to the SysUserAuth table. A view is then created referencing that new column. The database is unloaded and then an attempt to load it is done.

Problem 1. Because the statements to modify system tables come after the view-creation statements in an unload file the load fails when it gets to the view-creation statement. To fix the problem I had to move the statements that modify system tables to a location before the view-creation statements.

Problem 2. The statements to update the custom column fail because the final conditions incorrectly is "...AND EXTUSER = " (note the lack of an actual constant value). Removal of that invalid condition (or correction of it) fixes that problem.

There is a script file attached to demonstrate the problems.

Clifford Bass

[RainerE]

In my opinion modifying system tables should not be possible.
I would create a new table Ext_SysUserAuth containing the additional column.

Regards,
Rainer

[Clifford Bass]

Hi Rainer,

I have done something similar. But since Gupta/Unify/Centura/Gupta has long allowed for that option there is really no reason to complicate things. In my rash opinion, if an option is provided, it ought to work.

Using other tables I have found can result in orphan records if you are not diligent to clean things up. If I get rid of a role and I am using a custom field in the system table to add descriptive information the custom information vanishes nicely without any added effort. Yeah, I know it would be minor.

Clifford

[Mike Vandine]

Hi Cliff,

>>In my rash opinion, if an option is provided, it ought to work.<<

Gads! You sure are picky!

I will get this reported.

Best regards,

[Clifford Bass]

Hi Cliff,

>>In my rash opinion, if an option is provided, it ought to work.<<

Gads! You sure are picky!

I will get this reported.

Best regards,

I sure am!

As always, thanks a lot Mike!

Cliff