Description:
The function password() does not seem to return the same code on multiple runs with the same input.
I'm using:
mysql Ver 13.5 Distrib 4.1.0-alpha, for pc-linux (i686)
from the binary (non-rpm) distribution on a Mandrake 9.1 system.
How to repeat:
mysql> select password('foo') = password( 'foo' );
+-------------------------------------+
| password('foo') = password( 'foo' ) |
+-------------------------------------+
| 0 |
+-------------------------------------+
1 row in set (0.00 sec)
mysql> select password( 'foo' ), now();
+-----------------------------------------------+---------------------+
| password( 'foo' ) | now() |
+-----------------------------------------------+---------------------+
| *6a14c5b4a62c2d635175a59b08f5069d25e7f767d98c | 2003-06-12 00:47:53 |
+-----------------------------------------------+---------------------+
1 row in set (0.00 sec)
mysql> select password( 'foo' ), now();
+-----------------------------------------------+---------------------+
| password( 'foo' ) | now() |
+-----------------------------------------------+---------------------+
| *f04a7b3789e414ca99390011a99538a805b6812055f2 | 2003-06-12 00:47:55 |
+-----------------------------------------------+---------------------+
Description: The function password() does not seem to return the same code on multiple runs with the same input. I'm using: mysql Ver 13.5 Distrib 4.1.0-alpha, for pc-linux (i686) from the binary (non-rpm) distribution on a Mandrake 9.1 system. How to repeat: mysql> select password('foo') = password( 'foo' ); +-------------------------------------+ | password('foo') = password( 'foo' ) | +-------------------------------------+ | 0 | +-------------------------------------+ 1 row in set (0.00 sec) mysql> select password( 'foo' ), now(); +-----------------------------------------------+---------------------+ | password( 'foo' ) | now() | +-----------------------------------------------+---------------------+ | *6a14c5b4a62c2d635175a59b08f5069d25e7f767d98c | 2003-06-12 00:47:53 | +-----------------------------------------------+---------------------+ 1 row in set (0.00 sec) mysql> select password( 'foo' ), now(); +-----------------------------------------------+---------------------+ | password( 'foo' ) | now() | +-----------------------------------------------+---------------------+ | *f04a7b3789e414ca99390011a99538a805b6812055f2 | 2003-06-12 00:47:55 | +-----------------------------------------------+---------------------+