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

Report SqlBase bugs and possible workarounds.
CliffordBass

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

Post by CliffordBass » 06 Apr 2016, 20:14

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
You do not have the required permissions to view the files attached to this post.

Rainer Ebert

SQLBase 12.0 Custom Column on SysUserAuth Causes Load Fail

Post by Rainer Ebert » 08 Apr 2016, 15:06

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

Regards,
Rainer

CliffordBass

SQLBase 12.0 Custom Column on SysUserAuth Causes Load Fail

Post by CliffordBass » 08 Apr 2016, 17:29

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

SQLBase 12.0 Custom Column on SysUserAuth Causes Load Fail

Post by Mike Vandine » 27 Apr 2016, 09:33

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,

CliffordBass

SQLBase 12.0 Custom Column on SysUserAuth Causes Load Fail

Post by CliffordBass » 27 Apr 2016, 17:06

mvandine wrote: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! :lol: :lol:

As always, thanks a lot Mike!

Cliff

Return to “Bug Reports”

Who is online

Users browsing this forum: [Ccbot] and 0 guests