List:Commits« Previous MessageNext Message »
From:Chuck Bell Date:December 9 2008 5:31pm
Subject:bzr commit into mysql-6.0 branch (cbell:2734)
View as plain text  
#At file:///D:/source/bzr/mysql-6.0-test-mime/

 2734 Chuck Bell	2008-12-09
      Testing purposes only. Do NOT use.
modified:
  mysql-test/suite/backup/t/backup.test

=== modified file 'mysql-test/suite/backup/t/backup.test'
--- a/mysql-test/suite/backup/t/backup.test	2008-12-08 10:30:21 +0000
+++ b/mysql-test/suite/backup/t/backup.test	2008-12-09 17:30:48 +0000
@@ -1,3 +1,69 @@
+
+CREATE DATABASE `Ñⁿ`;
+USE `Ñⁿ`;
+
+--echo Create table with all datatypes and load with data.
+
+CREATE TABLE `ºBIGINT,
+mint MEDIUMINT,
+name CHAR(100),
+city  VARCHAR(100),
+fl FLOAT(7,4),
+pers DECIMAL(8,2),
+sal DOUBLE,
+colours SET('red','blue','yellow'),
+continent ENUM('Asia', 'Europe','Africa','Antartica'),
+ts TIMESTAMP DEFAULT 0,
+dt DATETIME NOT NULL,
+dob DATE,
+time TIME,
+y YEAR
+);
+
+--echo creating table with blob and text columns
+
+CREATE TABLE `º╞2`(
+region TEXT,
+summary LONGTEXT,
+data BLOB,
+details MEDIUMBLOB,
+queries TINYTEXT,
+query2 TINYBLOB,
+extract LONGBLOB,
+);
+
+CREATE TABLE `º╢£`(b1 BINARY(3), b2 VARBINARY(2),bitvalue BIT(64));
+INSERT INTO `º╢£` VALUES(0x61,0x2130,b'1111111111111111111111111111111111111111111111111111111111111111'), (0x6120,0x4100,b'101010101010101'), (0x612020, 0x4120,b'000000001');
+SELECT HEX(b1), HEX(b2), HEX(bitvalue) FROM `º╢£`;
+
+INSERT INTO `ºden','678.299',200.23,829899.909,
+'red','Asia','2008-06-01 16:23:30','98/12/31 11*30*45','1984-09-08','7:05','1984');
+
+INSERT INTO `º╞2` VALUES
+('xxxxxxxx','Testofonline backup','aaaaaaaaaa','bbbbbbbbbbb','hhhhhhhhhhh',
+'kkkkkkkkkkkkk','mmmmmmmmmmmm','onlinebackup1');
+
+# Bug #37212  Restore crashes if table has longblob of size 1MB
+UPDATE `º╞2` SET extract=repeat('z',100);
+--query_vertical SELECT * FROM `º╞`;
+SELECT * FROM `º╞2`;
+
+DESCRIBE `º╞`;
+DESCRIBE `º╞2`;
+DESCRIBE `º╢£`;
+
+--echo ** Backup data **
+--echo
+--replace_column 1 #
+BACKUP DATABASE `Ñⁿ` to 'bup_datatype.bak';
+
+
+
 --source include/have_innodb.inc
 --source include/have_blackhole.inc
 --source include/not_embedded.inc

Thread
bzr commit into mysql-6.0 branch (cbell:2734) Chuck Bell9 Dec