← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

Viewing changes to mysql-test/r/func_crypt.result

  • Committer: Bazaar Package Importer
  • Author(s): Norbert Tretkowski
  • Date: 2010-03-17 14:56:02 UTC
  • Revision ID: james.westby@ubuntu.com-20100317145602-x7e30l1b2sb5s6w6
Tags: upstream-5.1.45
Import upstream version 5.1.45

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/func_crypt.result
 
1
drop table if exists t1;
 
2
select length(encrypt('foo', 'ff')) <> 0;
 
3
length(encrypt('foo', 'ff')) <> 0
 
4
1
 
5
create table t1 (name varchar(50), pw varchar(64));
 
6
insert into t1 values ('tom', password('my_pass'));
 
7
set @pass='my_pass';
 
8
select name from t1 where name='tom' and pw=password(@pass);
 
9
name
 
10
tom
 
11
select name from t1 where name='tom' and pw=password(@undefined);
 
12
name
 
13
drop table t1;
 
14
select password('abc');
 
15
password('abc')
 
16
*0D3CED9BEC10A777AEC23CCC353A8C08A633045E
 
17
select password('');
 
18
password('')
 
19
 
 
20
select old_password('abc');
 
21
old_password('abc')
 
22
7cd2b5942be28759
 
23
select old_password('');
 
24
old_password('')
 
25
 
 
26
select password('gabbagabbahey');
 
27
password('gabbagabbahey')
 
28
*B0F99D2963660DD7E16B751EC9EE2F17B6A68FA6
 
29
select old_password('idkfa');
 
30
old_password('idkfa')
 
31
5c078dc54ca0fcca
 
32
select length(password('1'));
 
33
length(password('1'))
 
34
41
 
35
select length(encrypt('test'));
 
36
length(encrypt('test'))
 
37
13
 
38
select encrypt('test','aa');
 
39
encrypt('test','aa')
 
40
aaqPiZY5xR5l.
 
41
select old_password(NULL);
 
42
old_password(NULL)
 
43
NULL
 
44
select password(NULL);
 
45
password(NULL)
 
46
NULL
 
47
set global old_passwords=on;
 
48
select password('');
 
49
password('')
 
50
 
 
51
select old_password('');
 
52
old_password('')
 
53
 
 
54
select password('idkfa');
 
55
password('idkfa')
 
56
*B669C9DAC3AA6F2254B03CDEF8DFDD6B2D1054BA
 
57
select old_password('idkfa');
 
58
old_password('idkfa')
 
59
5c078dc54ca0fcca
 
60
set old_passwords=on;
 
61
select password('idkfa');
 
62
password('idkfa')
 
63
5c078dc54ca0fcca
 
64
select old_password('idkfa');
 
65
old_password('idkfa')
 
66
5c078dc54ca0fcca
 
67
set global old_passwords=off;
 
68
select password('idkfa');
 
69
password('idkfa')
 
70
5c078dc54ca0fcca
 
71
select old_password('idkfa');
 
72
old_password('idkfa')
 
73
5c078dc54ca0fcca
 
74
set old_passwords=off;
 
75
select password('idkfa ');
 
76
password('idkfa ')
 
77
*2DC31D90647B4C1ABC9231563D2236E96C9A2DB2
 
78
select password('idkfa');
 
79
password('idkfa')
 
80
*B669C9DAC3AA6F2254B03CDEF8DFDD6B2D1054BA
 
81
select password(' idkfa');
 
82
password(' idkfa')
 
83
*12B099E56BB7FE8D43C78FD834A9D1D11178D045
 
84
select old_password('idkfa');
 
85
old_password('idkfa')
 
86
5c078dc54ca0fcca
 
87
select old_password(' i          d k f a ');
 
88
old_password(' i         d k f a ')
 
89
5c078dc54ca0fcca
 
90
explain extended select password('idkfa '), old_password('idkfa');
 
91
id      select_type     table   type    possible_keys   key     key_len ref     rows    filtered        Extra
 
92
1       SIMPLE  NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    No tables used
 
93
Warnings:
 
94
Note    1003    select password('idkfa ') AS `password('idkfa ')`,old_password('idkfa') AS `old_password('idkfa')`
 
95
select encrypt('1234','_.');
 
96
encrypt('1234','_.')
 
97
#
 
98
#
 
99
# Bug #44767: invalid memory reads in password() and old_password() 
 
100
#             functions
 
101
#
 
102
CREATE TABLE t1(c1 MEDIUMBLOB);
 
103
INSERT INTO t1 VALUES (REPEAT('a', 1024));
 
104
SELECT OLD_PASSWORD(c1), PASSWORD(c1) FROM t1;
 
105
OLD_PASSWORD(c1)        PASSWORD(c1)
 
106
77023ffe214c04ff        *82E58A2C08AAFE72C8EB523069CD8ADB33F78F58
 
107
DROP TABLE t1;
 
108
End of 5.0 tests