[DERBY-6221] Can't select from SYS.SYSUSERS if you use a WHERE clause in the query

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.11.1.1
• Fix Version/s: 10.9.2.2, 10.10.2.0, 10.11.1.1
• Component/s: SQL
• Labels: derby_backport_reject_10_8
• Urgency: Normal
• Issue & fix info: Repro attached
• Bug behavior facts: Seen in production
• Assignee: Richard N. Hillegas
• Reporter: Richard N. Hillegas
• Created: 09/May/13 19:25
• Updated: 16/Apr/14 02:40
• Resolved: 27/Jun/13 22:30

Description

The following query runs fine:

SELECT username, lastmodified FROM sys.sysusers;

...but the following query raises an exception:

SELECT username, lastmodified FROM sys.sysusers WHERE USERNAME = 'FRED';

...which is

ERROR 4251E: No one can view the 'SYSUSERS'.'PASSWORD' column.

Issue Links

• relates to: DERBY-866 Derby User Management Enhancements