Issue Details (XML | Word | Printable)

Key: CORE-4464
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Alexander Peshkov
Reporter: Robert
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Duplicate tags for CREATE/ALTER USER not handled correctly

Created: 18/Jun/14 12:11 PM   Updated: 23/Sep/15 11:26 AM
Component/s: Security
Affects Version/s: 3.0 Alpha 2
Fix Version/s: 3.0 Beta 1

Environment: Windows 7

QA Status: Done successfully


 Description  « Hide
WI-T3.0.0.30809 Firebird 3.0 Alpha 2

With CREATE/ALTER USER, if I specify two tags with the same name, both will be added in SEC$USER_ATTRIBUTES.

Example:
CREATE USER Test1 PASSWORD 'masterkey' TAGS (a = '1', a = '2')

NAME VALUE
================ ==============================
A 1
A 2

It would be better to produce a syntax error or to insert only the last value (a='2').

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Robert made changes - 18/Jun/14 12:12 PM
Field Original Value New Value
Description WI-T3.0.0.30809 Firebird 3.0 Alpha 2

With CREATE/ALTER USER, if I specify two tags with the same name, both will be added in SEC$USER_ATTRIBUTES.

Example:
CREATE USER Test1 PASSWORD 'masterkey' TAGS (a = '1', a = '2')

NAME VALUE
================ ==============================
A 1
A 2

It would be better to produce a syntax error or to insert only the last value to (a='2').
WI-T3.0.0.30809 Firebird 3.0 Alpha 2

With CREATE/ALTER USER, if I specify two tags with the same name, both will be added in SEC$USER_ATTRIBUTES.

Example:
CREATE USER Test1 PASSWORD 'masterkey' TAGS (a = '1', a = '2')

NAME VALUE
================ ==============================
A 1
A 2

It would be better to produce a syntax error or to insert only the last value (a='2').
Alexander Peshkov made changes - 18/Jun/14 12:25 PM
Assignee Alexander Peshkov [ alexpeshkoff ]
Alexander Peshkov made changes - 24/Jun/14 07:19 AM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 3.0 Beta 1 [ 10332 ]
Resolution Fixed [ 1 ]
Pavel Zotov made changes - 28/May/15 03:06 PM
Status Resolved [ 5 ] Resolved [ 5 ]
QA Status Done successfully
Pavel Cisar made changes - 23/Sep/15 11:26 AM
Status Resolved [ 5 ] Closed [ 6 ]