~ubuntu-branches/ubuntu/saucy/drizzle/saucy-proposed

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near ')' at line 1

show count(*) errors;

@@session.error_count

show errors;

Level Code Message

Error 1064 You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near ')' at line 1

insert into t1 values (1);

insert into t1 values ("hej");

ERROR HY000: Incorrect integer value: 'hej' for column 'a' at row 1

insert into t1 values ("hej"),("d�");

ERROR HY000: Incorrect integer value: 'hej' for column 'a' at row 1

set SQL_WARNINGS=1;

insert into t1 values ("hej");

ERROR HY000: Incorrect integer value: 'hej' for column 'a' at row 1

insert into t1 values ("hej"),("d�");

ERROR HY000: Incorrect integer value: 'hej' for column 'a' at row 1

drop table t1;

set SQL_WARNINGS=0;

drop temporary table if exists not_exists;

Warnings:

Note 1051 Unknown table 'not_exists'

drop table if exists not_exists_table;

Warnings:

Note 1051 Unknown table 'not_exists_table'

show warnings limit 1;

Level Code Message

Note 1051 Unknown table 'not_exists_table'

drop database if exists not_exists_db;

Warnings:

Note 1008 Can't drop database './not_exists_db/'; database doesn't exist

show count(*) warnings;

@@session.warning_count

create table t1(id int);

create table if not exists t1(id int);

Warnings:

Note 1050 Table 't1' already exists

select @@warning_count;

@@warning_count

drop table t1;

create table t1(a int, b int not null, c date, d char(5));

load data infile '../std_data_ln/warnings_loaddata.dat' into table t1 fields terminated by ',';

ERROR 22004: Column set to default value; NULL supplied to NOT NULL column 'b' at row 2

select @@warning_count;

@@warning_count

drop table t1;

create table t1(a int NOT NULL, b int, c char(5));

insert into t1 values(-1,100,'mysql'),(10,-1,'mysql ab'),(500,256,'open source'),(20,NULL,'test');

ERROR 22001: Data too long for column 'c' at row 2

insert into t1 values(-1,100,'mysql'),(10,-1,'dri '),(500,256,'zzle'),(20,NULL,'test');

alter table t1 modify c char(4);

ERROR 01000: Data truncated for column 'c' at row 1

alter table t1 add d char(2);

update t1 set a=NULL where a=10;

ERROR 23000: Column 'a' cannot be null

update t1 set c='drizzle' where c='test';

ERROR 22001: Data too long for column 'c' at row 4

update t1 set d=c;

ERROR 22001: Data too long for column 'd' at row 1

create table t2(a int NOT NULL, b char(3));

insert into t2 select b,c from t1;

ERROR 22001: Data too long for column 'b' at row 1

insert into t2(b) values('mysqlab');

ERROR HY000: Field 'a' doesn't have a default value

insert into t2(a) values(1);

set sql_warnings=1;

insert into t2(a,b) values(1,'mysqlab');

ERROR 22001: Data too long for column 'b' at row 1

insert into t2(a,b) values(1,'mys');

set sql_warnings=0;

drop table t1, t2;

create table t1(a char(10));

alter table t1 add b char;

set max_error_count=10;

update t1 set b=a;

ERROR 22001: Data too long for column 'b' at row 1

alter table t1 modify b char(10);

update t1 set b=a;

select @@warning_count;

@@warning_count

100

set max_error_count=0;

101

show variables like 'max_error_count';

102

Variable_name Value

103

max_error_count 0

104

update t1 set b='hi';

105

select @@warning_count;

106

@@warning_count

107

108

show warnings;

109

Level Code Message

110

set max_error_count=65535;

111

show variables like 'max_error_count';

112

Variable_name Value

113

max_error_count 65535

114

set max_error_count=10;

115

show variables like 'max_error_count';

116

Variable_name Value

117

max_error_count 10

118

drop table t1;

119

create table t1 (a int);

120

insert into t1 (a) values (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);

121

update t1 set a='abc';

122

ERROR HY000: Incorrect integer value: 'abc' for column 'a' at row 1

123

show warnings limit 2, 1;

124

Level Code Message

125

show warnings limit 0, 10;

126

Level Code Message

127

Error 1366 Incorrect integer value: 'abc' for column 'a' at row 1

128

show warnings limit 9, 1;

129

Level Code Message

130

show warnings limit 10, 1;

131

Level Code Message

132

show warnings limit 9, 2;

133

Level Code Message

134

show warnings limit 0, 0;

135

Level Code Message

136

show warnings limit 1;

137

Level Code Message

138

Error 1366 Incorrect integer value: 'abc' for column 'a' at row 1

139

show warnings limit 0;

140

Level Code Message

141

show warnings limit 1, 0;

142

Level Code Message

143

select * from t1 limit 0;

144

145

select * from t1 limit 1, 0;

146

147

select * from t1 limit 0, 0;

148

149

drop table t1;

150

End of 4.1 tests

151

create table t1 (c_char char(255), c_varchar varchar(255), c_tinytext blob);

152

set @c = repeat(' ', 256);

153

set @q = repeat('q', 256);

154

insert into t1 values(@c, @c, @c);

155

Warnings:

156

Note 1265 Data truncated for column 'c_char' at row 1

157

Note 1265 Data truncated for column 'c_varchar' at row 1

158

show warnings;

159

Level Code Message

160

Note 1265 Data truncated for column 'c_char' at row 1

161

Note 1265 Data truncated for column 'c_varchar' at row 1

162

insert into t1 values(@q, NULL, NULL);

163

ERROR 22001: Data too long for column 'c_char' at row 1

164

insert into t1 values(NULL, @q, NULL);

165

ERROR 22001: Data too long for column 'c_varchar' at row 1

166

insert into t1 values(NULL, NULL, @q);

167

drop table t1;

168

End of Drizzle tests

Older »