Skip to content

Allow dot in username#2062

Merged
Alkarex merged 2 commits intoFreshRSS:devfrom
Alkarex:dot_username
Oct 24, 2018
Merged

Allow dot in username#2062
Alkarex merged 2 commits intoFreshRSS:devfrom
Alkarex:dot_username

Conversation

@Alkarex
Copy link
Copy Markdown
Member

@Alkarex Alkarex commented Oct 21, 2018

* '_' is a reserved internal username.
*/
const USERNAME_PATTERN = '[0-9a-zA-Z_]{2,38}|[0-9a-zA-Z]';
const USERNAME_PATTERN = '[0-9a-zA-Z_][0-9a-zA-Z_.]{1,38}|[0-9a-zA-Z]';
Copy link
Copy Markdown
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

In MySQL I note that this means all identifiers should be quoted since only these are permitted in unquoted:

https://dev.mysql.com/doc/refman/8.0/en/identifiers.html

I'm not sure if hat could cause any issues at this point in time?

ASCII: [0-9,a-z,A-Z$_] (basic Latin letters, digits 0-9, dollar, underscore)

Copy link
Copy Markdown
Member Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

We do quote identifiers for MySQL / SQLite / PostgreSQL so that should be fine (require quick testing)

@Alkarex Alkarex merged commit 6a686da into FreshRSS:dev Oct 24, 2018
@Alkarex Alkarex deleted the dot_username branch October 24, 2018 11:07
Alkarex added a commit that referenced this pull request Oct 25, 2018
mdemoss pushed a commit to mdemoss/FreshRSS that referenced this pull request Mar 25, 2021
* Allow dot in username

FreshRSS#2061

* Missing quotes for special chars in PostgreSQL
mdemoss pushed a commit to mdemoss/FreshRSS that referenced this pull request Mar 25, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants