[jira] [Commented] (CLOUDSTACK-5534) MySQL exception raised when searching for users with keyword

["ASF subversion and git services (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-5534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13851195#comment-13851195 ] 

ASF subversion and git services commented on CLOUDSTACK-5534:
-------------------------------------------------------------

Commit d0abf3fcc2fde147038c75da2ea4d0c744a8127a in branch refs/heads/4.3 from [~minchen07]
[ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=d0abf3f ]

CLOUDSTACK-5534: MySQL exception raised when searching for users with
keyword.


> MySQL exception raised when searching for users with keyword
> ------------------------------------------------------------
>
>                 Key: CLOUDSTACK-5534
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-5534
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: API
>    Affects Versions: 4.2.0
>            Reporter: Min Chen
>            Assignee: Min Chen
>             Fix For: 4.3.0
>
>
> The following error dialog is shown when you attempt to search for users.
> Caught: com.mysql.jdbc.JDBC4PreparedStatement@541ee970: SELECT user_view.id, user_view.uuid, user_view.username, user_view.password, user_view.firstname, user_view.lastname, user_view.email, user_view.state, user_view.api_key, user_view.secret_key, user_view.created, user_view.removed, user_view.timezone, user_view.registration_token, user_view.is_registered, user_view.incorrect_login_attempts, user_view.account_id, user_view.account_uuid, user_view.account_name, user_view.account_type, user_view.domain_id, user_view.domain_uuid, user_view.domain_name, user_view.domain_path, user_view.job_id, user_view.job_uuid, user_view.job_status, user_view.default FROM user_view WHERE user_view.id != 1 AND user_view.domain_id = 1 AND user_view.account_name = _binary'admin' AND (user_view.username LIKE _binary'%test%' OR user_view.firstname LIKE _binary'%test%' OR user_view.lastname LIKE _binary'%test%' OR user_view.email LIKE _binary'%test%' OR user_view.state LIKE _binary'%test%' OR user_view.account_name LIKE _binary'%test%' OR OR ) AND user_view.removed IS NULL ORDER BY user_view.id ASC LIMIT 0, 20
> REPRO STEPS
> ====================
> 1. From CCP UI Home screen.
> 2. Click Accounts.
> 3. Click Admin.
> 4. Click View Users.
> 5. Type anything in search window and press ENTER.
> 6. Error dialog will appear.
> 7. Look closely, the query contains two consecutive OR's (e.g. "OR OR") and this is the reason it results in an error.
> 8. If you run the query manually after removing the 2 OR's, it will be successful.



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)