Stored Procedure SELECT statement

[random1]

I have the following stored procedure in my db:

 

DELIMITER //
CREATE DEFINER=`root`@`localhost` PROCEDURE `procedure_update_user`(IN `user_username` VARCHAR(25))
    COMMENT 'Updates the ''user'' table'
BEGIN
UPDATE `user`
SET `user_datetime_utc_last_login` = UTC_TIMESTAMP()
WHERE `user_username` = user_username;
SELECT `user_username`, `user_datetime_utc_last_login`
FROM `user`
WHERE `user_username` = user_username;
END//
DELIMITER ;

 

But when I run:

 

CALL procedure_update_user('user1');

 

It's supposed to return one row but it returns all user rows. Do I have to use "DISTINCT" for the SELECT statement?

[fenway]

Why do you have duplicate usernames?

[random1]

That's just it I don't have duplicate usernames.

 

The result set I get without "DISTINCT" returns the duplicate row for the number of users in the table.

 

e.g.

 

username  DATE

username  DATE

username  DATE

...

...

...

 

103 times.

 

Any ideas?

[fenway]

Well, you'd have to log the actual query you're running to verify this strange fact -- though you can cheat and output UIDs and see if it's true.