← Back to branch summary

~ubuntu-branches/ubuntu/hardy/mysql-dfsg-5.0/hardy-proposed

« back to all changes in this revision

Viewing changes to mysql-test/suite/funcs_1/r/charset_collation.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-23 11:21:11 UTC
  • mfrom: (1.1.16) (38.1.4 hardy-security)
  • Revision ID: package-import@ubuntu.com-20120223112111-rn9ruzg86juli2ec
Tags: 5.0.95-0ubuntu1
https://launchpad.net/bugs/937869
* SECURITY UPDATE: Update to 5.0.95 to fix multiple security issues
  (LP: #937869)
  - http://www.oracle.com/technetwork/topics/security/cpujan2012-366304.html
  - CVE-2012-0075
  - CVE-2012-0087
  - CVE-2012-0101
  - CVE-2012-0102
  - CVE-2012-0114
  - CVE-2012-0484
  - CVE-2012-0490
* Dropped patches unnecessary with 5.0.95:
  - debian/patches/91_SECURITY_CVE-2007-5925.dpatch
  - debian/patches/95_SECURITY_CVE-2008-3963.dpatch
  - debian/patches/96_SECURITY_CVE-2008-4098.dpatch
  - debian/patches/97_CVE-2008-4456.dpatch
  - debian/patches/97_CVE-2009-2446.dpatch
  - debian/patches/97_CVE-2009-4019.dpatch
  - debian/patches/97_CVE-2009-4030.dpatch
  - debian/patches/98_CVE-2009-4484.dpatch
  - debian/patches/99_ssl_test_certs.dpatch
  - debian/patches/100_CVE-2010-1850.dpatch
  - debian/patches/101_CVE-2010-1849.dpatch
  - debian/patches/102_CVE-2010-1848.dpatch
  - debian/patches/103_CVE-2010-1626.dpatch
  - debian/patches/98_CVE-2010-3677.dpatch
  - debian/patches/98_CVE-2010-3680.dpatch
  - debian/patches/98_CVE-2010-3681.dpatch
  - debian/patches/98_CVE-2010-3682.dpatch
  - debian/patches/98_CVE-2010-3833.dpatch
  - debian/patches/98_CVE-2010-3834.dpatch
  - debian/patches/98_CVE-2010-3835.dpatch
  - debian/patches/98_CVE-2010-3836.dpatch
  - debian/patches/98_CVE-2010-3837.dpatch
  - debian/patches/98_CVE-2010-3838.dpatch
  - debian/patches/98_CVE-2010-3840.dpatch
  - debian/patches/45_warn-CLI-passwords.dpatch
  - debian/patches/50_fix_mysqldump.dpatch
  - debian/patches/51_incorrect-order.dpatch
  - debian/patches/52_ndb-gcc-4.2.dpatch
  - debian/patches/53_integer-gcc-4.2.dpatch
  - debian/patches/54_ssl-client-support.dpatch
  - debian/patches/55_testsuite-2008.dpatch
  - debian/patches/58-disable-ndb-backup-print.dpatch
  - debian/patches/59-fix-mysql-replication-logs.dpatch
  - debian/patches/86_PATH_MAX.dpatch
  - debian/patches/90_upstreamdebiandir.dpatch
  - debian/patches/92_fix_order_by32202.dpatch
  - debian/patches/93_fix_user_setup_on_localhost.dpatch
  - debian/patches/94_fix_mysqldump_with_old_versions.dpatch
  - debian/patches/56-mysqlhotcopy-invalid-dbtable.dpatch
  - debian/patches/57-fix-mysqlslowdump-config.dpatch
* debian/mysql-client-5.0.docs, debian/mysql-server-5.0.docs: removed
  EXCEPTIONS-CLIENT file
* debian/libmysqlclient15-dev.docs, debian/libmysqlclient15off.docs:
  removed, no longer necessary.
* debian/patches/25_mysys__default.c.dpatch: updated for 5.0.95.
* debian/mysql-server-5.0.files: change ndb_mgmd and ndbd manpage
  locations. Removed mysqlmanagerc.1 and mysqlmanager-pwgen.1

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/funcs_1/r/charset_collation.result
 
1
DROP USER dbdict_test@localhost;
 
2
CREATE USER dbdict_test@localhost;
 
3
# Establish connection con (user=dbdict_test)
 
4
 
 
5
SELECT *
 
6
FROM information_schema.character_sets
 
7
WHERE character_set_name IN ('utf8','latin1','binary')
 
8
ORDER BY character_set_name;
 
9
CHARACTER_SET_NAME      DEFAULT_COLLATE_NAME    DESCRIPTION     MAXLEN
 
10
binary  binary  Binary pseudo charset   1
 
11
latin1  latin1_swedish_ci       cp1252 West European    1
 
12
utf8    utf8_general_ci UTF-8 Unicode   3
 
13
 
 
14
SELECT *
 
15
FROM information_schema.collations
 
16
WHERE character_set_name IN ('utf8','latin1','binary')
 
17
AND (collation_name LIKE CONCAT(character_set_name,'_general_ci')
 
18
OR
 
19
collation_name LIKE CONCAT(character_set_name,'_bin'))
 
20
ORDER BY collation_name;
 
21
COLLATION_NAME  CHARACTER_SET_NAME      ID      IS_DEFAULT      IS_COMPILED     SORTLEN
 
22
latin1_bin      latin1  47              Yes     1
 
23
latin1_general_ci       latin1  48              Yes     1
 
24
utf8_bin        utf8    83              Yes     1
 
25
utf8_general_ci utf8    33      Yes     Yes     1
 
26
 
 
27
SELECT *
 
28
FROM information_schema.collation_character_set_applicability
 
29
WHERE character_set_name IN ('utf8','latin1','binary')
 
30
AND (collation_name LIKE CONCAT(character_set_name,'_general_ci')
 
31
OR
 
32
collation_name LIKE CONCAT(character_set_name,'_bin'))
 
33
ORDER BY collation_name, character_set_name;
 
34
COLLATION_NAME  CHARACTER_SET_NAME
 
35
latin1_bin      latin1
 
36
latin1_general_ci       latin1
 
37
utf8_bin        utf8
 
38
utf8_general_ci utf8
 
39
# Switch to connection default + disconnect con
 
40
DROP USER dbdict_test@localhost;