cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Min Chen (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CLOUDSTACK-5534) MySQL exception raised when searching for users with keyword
Date Wed, 18 Dec 2013 00:35:07 GMT
Min Chen created CLOUDSTACK-5534:
------------------------------------

             Summary: 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)

Mime
View raw message