* Merge from debian experimental (and 5.0 from main), remaining changes: - debian/mysql-server-5.1.config: + ask for MySQL root password at priority high instead of medium so that the password prompt is seen on a default install. (LP: #319843) + don't ask for root password when upgrading from a 5.0 install. - debian/control: + Make libmysqlclient16-dev a transitional package depending on libmysqlclient-dev. + Make libmysqlclient-dev conflict with libmysqlclient15-dev. + Don't build mysql-server, mysql-client, mysql-common and libmysqlclient15-dev binary packages since they're still provided by mysql-dfsg-5.0. + Make mysql-{client,server}-5.1 packages conflict and replace mysql-{client,server}-5.0, but not provide mysql-{client,server}. + Depend on a specific version of mysql-common rather than the src version of mysql-dfsg-5.1 since mysql-common is currently part of mysql-dfsg-5.0. + Lower mailx from a Recommends to a Suggests to avoid pulling in a full MTA on all installs of mysql-server. (LP: #259477) - debian/rules: + added -fno-strict-aliasing to CFLAGS to get around mysql testsuite build failures. + install mysql-test and sql-bench to /usr/share/mysql/ rather than /usr/. - debian/additions/debian-start.inc.sh: support ANSI mode (LP: #310211) - Add AppArmor profile: - debian/apparmor-profile: apparmor profile. - debian/rules, debian/mysql-server-5.0.files: install apparmor profile. - debian/mysql-server-5.0.dirs: add etc/apparmor.d/force-complain - debian/mysql-server-5.0.postrm: remove symlink in force-complain/ on purge. - debian/mysql-server-5.1.README.Debian: add apparmor documentation. - debian/additions/my.cnf: Add warning about apparmor. (LP: #201799) - debian/mysql-server-5.1.postinst: reload apparmor profiles. - debian/additions/my.cnf: remove language option. Error message files are located in a different directory in MySQL 5.0. Setting the language option to use /usr/share/mysql/english breaks 5.0. Both 5.0 and 5.1 use a default value that works. (LP: #316974) - debian/mysql-server-5.1.mysql.init: + Clearly indicate that we do not support running multiple instances of mysqld by duplicating the init script. (closes: #314785, #324834, #435165, #444216) + Properly parameterize all existing references to the mysql config file (/etc/mysql/my.cnf). - debian/mysql-server-5.0.postinst: Clear out the second password when setting up mysql. (LP: #344816) - mysql-server-core-5.1 package for files needed by Akonadi: + debian/control: create mysql-server-core-5.1 package. + debian/mysql-server-core-5.1.files, debian/mysql-server-5.1.files: move core mysqld files to mysql-server-core-5.1 package. - Don't package sql-bench and mysql-test file. * Dropped changes: - debian/patches/92_ssl_test_cert.dpatch: certificate expiration in test suite (LP: #323755). Included upstream. * Dropped from 5.0: - apparmor profile: - debian/control: Recommends apparmor >= 2.1+1075-0ubuntu6. All version of apparmor-profile (>hardy) are higher than this version. - debian/mysql-server-5.0.preinst: create symlink for force-complain/ on pre-feisty upgrades, upgrades where apparmor-profiles profile is unchanged (ie non-enforcing) and upgrades where the profile doesn't exist. Support for pre-hardy upgrades is no longer needed. * debian/mysql-server-5.1.postinst: fix debian-sys-maint user creation.
Function sql_mode Create Function character_set_client collation_connection Database Collation
4342
4342
create procedure bug13012()
4343
4343
BEGIN
4344
4344
REPAIR TABLE t1;
4345
BACKUP TABLE t1 to '../tmp';
4345
BACKUP TABLE t1 to '../../tmp';
4346
4346
DROP TABLE t1;
4347
RESTORE TABLE t1 FROM '../tmp';
4347
RESTORE TABLE t1 FROM '../../tmp';
4348
4348
END|
4349
4349
call bug13012()|
4350
4350
Table Op Msg_type Msg_text
4351
4351
test.t1 repair status OK
4352
4352
Table Op Msg_type Msg_text
4353
test.t1 backup Warning The syntax 'BACKUP TABLE' is deprecated and will be removed in MySQL 5.2. Please use MySQL Administrator (mysqldump, mysql) instead
4353
test.t1 backup Warning The syntax 'BACKUP TABLE' is deprecated and will be removed in MySQL 6.0. Please use MySQL Administrator (mysqldump, mysql) instead
4354
4354
test.t1 backup status OK
4355
4355
Table Op Msg_type Msg_text
4356
test.t1 restore Warning The syntax 'RESTORE TABLE' is deprecated and will be removed in MySQL 5.2. Please use MySQL Administrator (mysqldump, mysql) instead
4356
test.t1 restore Warning The syntax 'RESTORE TABLE' is deprecated and will be removed in MySQL 6.0. Please use MySQL Administrator (mysqldump, mysql) instead
4357
4357
test.t1 restore status OK
4358
4358
drop procedure bug13012|
4359
4359
create view v1 as select * from t1|
6018
6018
INSERT INTO t3 VALUES (1, 3.4), (1, 2), (1, 0.9), (2, 8), (2, 7)|
6019
6019
SELECT SUM(f2), bug25373(f1) FROM t3 GROUP BY bug25373(f1) WITH ROLLUP|