← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/drizzledump.result

  • Committer: Andrew Hutchings
  • Date: 2010-10-26 23:46:28 UTC
  • mto: (1883.1.1 build)
  • mto: This revision was merged to the branch mainline in revision 1884.
  • Revision ID: andrew@linuxjedi.co.uk-20101026234628-ofhbcl1b2kl981og
https://launchpad.net/bugs/667053
Add quoting to the end of the table definition
Fix spelling error

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/drizzledump.result
13
13
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
14
14
CREATE TABLE `t1` (
15
15
  `a` DECIMAL(64,20) DEFAULT NULL
16
 
) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
16
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
17
17
 
18
18
INSERT INTO `t1` VALUES ('1234567890123456789012345678901234567890.00000000000000000000'),('987654321098765432109876543210987654321.00000000000000000000');
19
19
 
29
29
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
30
30
CREATE TABLE ```a` (
31
31
  `i` INT DEFAULT NULL
32
 
) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
32
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
33
33
 
34
34
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
35
35
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
76
76
DROP TABLE IF EXISTS `t2`;
77
77
CREATE TABLE `t2` (
78
78
  `a` INT DEFAULT NULL
79
 
) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
79
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
80
80
 
81
81
ALTER TABLE `t2` DISABLE KEYS;
82
82
INSERT INTO `t2` VALUES (4),(5),(6);
97
97
DROP TABLE IF EXISTS `t1`;
98
98
CREATE TABLE `t1` (
99
99
  `b` BLOB DEFAULT NULL
100
 
) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
100
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
101
101
 
102
102
ALTER TABLE `t1` DISABLE KEYS;
103
103
INSERT INTO `t1` VALUES (0x602010000280100005E71A);
118
118
DROP TABLE IF EXISTS `t1`;
119
119
CREATE TABLE `t1` (
120
120
  `a` INT DEFAULT NULL
121
 
) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
121
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
122
122
 
123
123
ALTER TABLE `t1` DISABLE KEYS;
124
124
INSERT IGNORE INTO `t1` VALUES (1),(2),(3),(4),(5),(6);
798
798
  `F_cd00692c3bfe59267d5ecfac5310286c` INT DEFAULT NULL,
799
799
  `F_6faa8040da20ef399b63a72d0e4ab575` INT DEFAULT NULL,
800
800
  `F_fe73f687e5bc5280214e0486b273a5f9` INT DEFAULT NULL
801
 
) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
801
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
802
802
 
803
803
ALTER TABLE `t1` DISABLE KEYS;
804
804
INSERT INTO `t1` VALUES (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
823
823
DROP TABLE IF EXISTS `t1`;
824
824
CREATE TABLE `t1` (
825
825
  `a` INT DEFAULT NULL
826
 
) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
826
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
827
827
 
828
828
ALTER TABLE `t1` DISABLE KEYS;
829
829
INSERT INTO `t1` VALUES (1),(2),(3);
847
847
DROP TABLE IF EXISTS `t1`;
848
848
CREATE TABLE `t1` (
849
849
  `a` INT DEFAULT NULL
850
 
) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
850
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
851
851
 
852
852
DROP TABLE IF EXISTS `t2`;
853
853
CREATE TABLE `t2` (
854
854
  `a` INT DEFAULT NULL
855
 
) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
855
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
856
856
 
857
857
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
858
858
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
862
862
DROP TABLE IF EXISTS `t1`;
863
863
CREATE TABLE `t1` (
864
864
  `a` INT DEFAULT NULL
865
 
) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
865
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
866
866
 
867
867
DROP TABLE IF EXISTS `t2`;
868
868
CREATE TABLE `t2` (
869
869
  `a` INT DEFAULT NULL
870
 
) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
870
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
871
871
 
872
872
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
873
873
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
896
896
  `a` VARCHAR(30) NOT NULL COLLATE utf8_general_ci,
897
897
  `b` INT NOT NULL,
898
898
  PRIMARY KEY (`a`)
899
 
) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
899
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
900
900
 
901
901
Error executing query: Table 'mysqldump_test_db.t\1' doesn't exist
902
902
Error: Could not get data for table t\1
907
907
  `a` VARCHAR(30) NOT NULL COLLATE utf8_general_ci,
908
908
  `b` INT NOT NULL,
909
909
  PRIMARY KEY (`a`)
910
 
) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
910
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
911
911
 
912
912
Error executing query: Table 'mysqldump_test_db.t\1' doesn't exist
913
913
Error: Could not get data for table t\1
977
977
DROP TABLE IF EXISTS `t3`;
978
978
CREATE TABLE `t3` (
979
979
  `a` INT DEFAULT NULL
980
 
) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
980
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
981
981
 
982
982
DROP TABLE IF EXISTS `t1`;
983
983
CREATE TABLE `t1` (
984
984
  `a` INT DEFAULT NULL
985
 
) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
985
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
986
986
 
987
987
DROP TABLE IF EXISTS `t2`;
988
988
CREATE TABLE `t2` (
989
989
  `a` INT DEFAULT NULL
990
 
) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
990
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
991
991
 
992
992
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
993
993
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
1054
1054
CREATE TABLE `t1` (
1055
1055
  `a` INT DEFAULT NULL,
1056
1056
  `b` INT DEFAULT NULL
1057
 
) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
1057
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
1058
1058
 
1059
1059
ALTER TABLE `t1` DISABLE KEYS;
1060
1060
REPLACE INTO `t1` VALUES (1,1),(2,3),(3,4),(4,5);
1074
1074
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
1075
1075
CREATE TABLE `test` (
1076
1076
  `a` INT DEFAULT NULL
1077
 
) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
1077
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
1078
1078
 
1079
1079
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
1080
1080
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;