~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/csv.result

Committer: Brian Aker
Date: 2008-12-24 19:41:08 UTC
mfrom: (722.2.32 devel)
Revision ID: brian@tangent.org-20081224194108-4140ku9dgjkyk97m

Merge from Monty.

files added:
tests/r/csv_alter_table.result

files removed:
tests/include/not_windows.inc

tests/suite/broken/r/crash_commit_before.result

tests/suite/broken/r/ctype_ldml.result

tests/suite/broken/r/ctype_mb.result

tests/suite/mordred/t/crash_commit_before.test

tests/suite/mordred/t/ctype_ldml.test

tests/suite/mordred/t/ctype_mb.test

files renamed:
tests/suite/broken/r/connect.result => tests/r/connect.result

tests/suite/broken/r/create.result => tests/r/create.result

tests/suite/broken/r/create_not_windows.result => tests/r/create_not_windows.result

tests/suite/broken/r/csv.result => tests/r/csv.result

tests/suite/broken/r/csv_not_null.result => tests/r/csv_not_null.result

tests/suite/broken/r/default.result => tests/r/default.result

tests/suite/broken/r/derived.result => tests/r/derived.result

tests/suite/broken/r/error_simulation.result => tests/r/small_tmp_table.result

tests/suite/mordred/t/concurrent_innodb.test => tests/suite/broken/t/concurrent_innodb.test

tests/suite/mordred/t/connect.test => tests/t/connect.test

tests/suite/mordred/t/create.test => tests/t/create.test

tests/suite/mordred/t/create_not_windows.test => tests/t/create_not_windows.test

tests/suite/mordred/t/csv.test => tests/t/csv.test

tests/suite/mordred/t/csv_alter_table.test => tests/t/csv_alter_table.test

tests/suite/mordred/t/csv_not_null.test => tests/t/csv_not_null.test

tests/suite/mordred/t/default.test => tests/t/default.test

tests/suite/mordred/t/derived.test => tests/t/derived.test

tests/suite/mordred/t/error_simulation.test => tests/t/small_tmp_table.test

files modified:
drizzled/drizzled.cc

drizzled/function/master_pos_wait.cc

drizzled/function/master_pos_wait.h

drizzled/protocol.cc

libdrizzle/client.c

libdrizzle/drizzle.h

tests/r/create_select_tmp.result

tests/t/create_select_tmp.test

Show diffs side-by-side

added added

removed removed

tests/r/csv.result

drop table if exists t1,t2,t3,t4;

CREATE TABLE t1 (

Period smallint(4) unsigned zerofill DEFAULT '0000' NOT NULL,

Varor_period smallint(4) unsigned DEFAULT '0' NOT NULL

Period int DEFAULT 0 NOT NULL,

Varor_period int DEFAULT 0 NOT NULL

) ENGINE = CSV;

INSERT INTO t1 VALUES (9410,9412);

select period from t1;

9410 9412

CREATE TABLE t2 (

auto int not null,

fld1 int(6) unsigned zerofill DEFAULT '000000' NOT NULL,

companynr tinyint(2) unsigned zerofill DEFAULT '00' NOT NULL,

fld1 int DEFAULT 0 NOT NULL,

companynr int DEFAULT 0 NOT NULL,

fld3 char(30) DEFAULT '' NOT NULL,

fld4 char(35) DEFAULT '' NOT NULL,

fld5 char(35) DEFAULT '' NOT NULL,

4916

ALTER TABLE t2 RENAME t1;

4917

DROP TABLE t1;

4918

CREATE TABLE t1 (

4919

Period smallint(4) unsigned zerofill DEFAULT '0000' NOT NULL,

4920

Varor_period smallint(4) unsigned DEFAULT '0' NOT NULL

4919

Period int DEFAULT 0 NOT NULL,

4920

Varor_period int DEFAULT 0 NOT NULL

4921

) ENGINE = CSV;

4922

INSERT INTO t1 VALUES (9410,9412);

4923

select period from t1;

5025

DROP TABLE test_repair_table3;

5026

CREATE TABLE test_repair_table4 (

5027

num int not null,

5028

magic_no int(4) unsigned zerofill DEFAULT '0000' NOT NULL,

5028

magic_no int DEFAULT 0 NOT NULL,

5029

company_name char(30) DEFAULT '' NOT NULL,

5030

founded char(4) DEFAULT '' NOT NULL

5031

) ENGINE = CSV;

5043

INSERT INTO test_repair_table4 VALUES (2,101,'MySQL','1995');

5044

SELECT * FROM test_repair_table4;

5045

num magic_no company_name founded

5046

2 0101 SAP 1972

5047

1 0101 Microsoft 1978

5048

2 0101 MySQL 1995

5049

CHECK TABLE test_repair_table4;

5050

Table Op Msg_type Msg_text

5051

test.test_repair_table4 check status OK

5052

REPAIR TABLE test_repair_table4;

5053

Table Op Msg_type Msg_text

5054

test.test_repair_table4 repair status OK

5055

SELECT * FROM test_repair_table4;

5056

num magic_no company_name founded

5057

2 0101 SAP 1972

5058

1 0101 Microsoft 1978

5059

2 0101 MySQL 1995

5060

CHECK TABLE test_repair_table4;

5061

Table Op Msg_type Msg_text

5062

test.test_repair_table4 check status OK

5063

REPAIR TABLE test_repair_table4;

5064

Table Op Msg_type Msg_text

5065

test.test_repair_table4 repair status OK

5066

SELECT * FROM test_repair_table4;

5067

num magic_no company_name founded

5068

2 0101 SAP 1972

5069

1 0101 Microsoft 1978

5070

2 0101 MySQL 1995

5046

2 101 SAP 1972

5047

1 101 Microsoft 1978

5048

2 101 MySQL 1995

5049

CHECK TABLE test_repair_table4;

5050

Table Op Msg_type Msg_text

5051

test.test_repair_table4 check status OK

5052

REPAIR TABLE test_repair_table4;

5053

Table Op Msg_type Msg_text

5054

test.test_repair_table4 repair status OK

5055

SELECT * FROM test_repair_table4;

5056

num magic_no company_name founded

5057

2 101 SAP 1972

5058

1 101 Microsoft 1978

5059

2 101 MySQL 1995

5060

CHECK TABLE test_repair_table4;

5061

Table Op Msg_type Msg_text

5062

test.test_repair_table4 check status OK

5063

REPAIR TABLE test_repair_table4;

5064

Table Op Msg_type Msg_text

5065

test.test_repair_table4 repair status OK

5066

SELECT * FROM test_repair_table4;

5067

num magic_no company_name founded

5068

2 101 SAP 1972

5069

1 101 Microsoft 1978

5070

2 101 MySQL 1995

5071

DROP TABLE test_repair_table4;

5072

CREATE TABLE test_repair_table5 (

5073

num int not null,

5074

magic_no int(4) unsigned zerofill DEFAULT '0000' NOT NULL,

5074

magic_no int DEFAULT 0 NOT NULL,

5075

company_name char(30) DEFAULT '' NOT NULL,

5076

founded char(4) DEFAULT '' NOT NULL

5077

) ENGINE = CSV;

5086

INSERT INTO test_repair_table5 VALUES (1, 102, "CORRECT", 1876);

5087

SELECT * FROM test_repair_table5;

5088

num magic_no company_name founded

5089

1 0102 CORRECT 1876

5089

1 102 CORRECT 1876

5090

FLUSH TABLES;

5091

CHECK TABLE test_repair_table5;

5092

Table Op Msg_type Msg_text

5096

test.test_repair_table5 repair status OK

5097

SELECT * FROM test_repair_table5;

5098

num magic_no company_name founded

5099

1 0102 CORRECT 1876

5099

1 102 CORRECT 1876

5100

INSERT INTO test_repair_table5 VALUES (1, 102, "CORRECT2", 1876);

5101

SELECT * FROM test_repair_table5;

5102

num magic_no company_name founded

5103

1 0102 CORRECT 1876

5104

1 0102 CORRECT2 1876

5103

1 102 CORRECT 1876

5104

1 102 CORRECT2 1876

5105

FLUSH TABLES;

5106

CHECK TABLE test_repair_table5;

5107

Table Op Msg_type Msg_text

5111

test.test_repair_table5 repair status OK

5112

SELECT * FROM test_repair_table5;

5113

num magic_no company_name founded

5114

1 0102 CORRECT 1876

5115

1 0102 CORRECT2 1876

5114

1 102 CORRECT 1876

5115

1 102 CORRECT2 1876

5116

DROP TABLE test_repair_table5;

5117

create table t1 (a int not null) engine=csv;

5118

insert t1 values (1);

5136

affected rows: 4

5137

insert t1 values (1),(2),(3),(4),(5);

5138

truncate table t1;

5139

affected rows: 0

5139

affected rows: 5

5140

drop table t1;

5141

create table t1 (v varchar(32) not null);

5142

insert into t1 values ('def'),('abc'),('hij'),('3r4f');

5179

i v

5180

1 def

5181

2 abc

5182

4 3r4f

5182

5183

5 lmn

5183

4 3r4f

5184

alter table t1 change i i bigint;

5185

select * from t1;

5186

i v

5187

1 def

5188

2 abc

5189

4 3r4f

5189

5190

5 lmn

5190

4 3r4f

5191

alter table t1 add unique key (i, v);

5192

select * from t1 where i between 2 and 4 and v in ('def','3r4f','lmn');

5193

i v

5194

4 3r4f

5195

drop table t1;

5196

create table bug15205 (val int(11) not null) engine=csv;

5197

create table bug15205_2 (val int(11) not null) engine=csv;

5198

select * from bug15205;

5199

ERROR HY000: Can't get stat of './test/bug15205.CSV' (Errcode: 2)

5200

select * from bug15205_2;

5201

val

5202

select * from bug15205;

5203

val

5204

drop table bug15205;

5205

drop table bug15205_2;

5206

set names latin1;

5207

create table t1 (

5208

c varchar(1) not null,

5209

name varchar(64) not null

5210

) character set latin1 engine=csv;

5211

insert into t1 values (0xC0,'LATIN CAPITAL LETTER A WITH GRAVE');

5212

insert into t1 values (0xE0,'LATIN SMALL LETTER A WITH GRAVE');

5213

insert into t1 values (0xEE,'LATIN SMALL LETTER I WITH CIRCUMFLEX');

5214

insert into t1 values (0xFE,'LATIN SMALL LETTER THORN');

5215

insert into t1 values (0xF7,'DIVISION SIGN');

5216

insert into t1 values (0xFF,'LATIN SMALL LETTER Y WITH DIAERESIS');

5217

select hex(c), c, name from t1 order by 1;

5218

hex(c) c name

5219

C0 � LATIN CAPITAL LETTER A WITH GRAVE

5220

E0 � LATIN SMALL LETTER A WITH GRAVE

5221

EE � LATIN SMALL LETTER I WITH CIRCUMFLEX

5222

F7 � DIVISION SIGN

5223

FE � LATIN SMALL LETTER THORN

5224

FF � LATIN SMALL LETTER Y WITH DIAERESIS

5225

drop table t1;

5226

End of 5.0 tests

5227

5196

create table bug22080_1 (id int not null,string varchar(64) not null) Engine=CSV;

5228

5197

create table bug22080_2 (id int not null,string varchar(64) not null) Engine=CSV;

5229

5198

create table bug22080_3 (id int not null,string varchar(64) not null) Engine=CSV;

5254

5223

9.67 string

5255

5224

drop table float_test;

5256

5225

CREATE TABLE `bug21328` (

5257

`col1` int(11) NOT NULL,

5258

`col2` int(11) NOT NULL,

5259

`col3` int(11) NOT NULL

5226

`col1` int NOT NULL,

5227

`col2` int NOT NULL,

5228

`col3` int NOT NULL

5260

5229

) ENGINE=CSV;

5261

5230

insert into bug21328 values (1,0,0);

5262

5231

alter table bug21328 engine=myisam;

5317

5286

drop table t1;

5318

5287

create table t1(a datetime not null) engine=csv;

5319

5288

insert into t1 values();

5320

Warnings:

5321

Warning 1364 Field 'a' doesn't have a default value

5322

select * from t1;

5323

5324

0000-00-00 00:00:00

5325

drop table t1;

5326

create table t1(a set('foo','bar') not null) engine=csv;

5327

insert into t1 values();

5328

Warnings:

5329

Warning 1364 Field 'a' doesn't have a default value

5330

select * from t1;

5331

5332

5289

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

5290

select * from t1;

5291

5333

5292

drop table t1;

5334

5293

create table t1(a varchar(32) not null) engine=csv;

5335

5294

insert into t1 values();

5336

Warnings:

5337

Warning 1364 Field 'a' doesn't have a default value

5295

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

5338

5296

select * from t1;

5339

5297

5340

5341

5298

drop table t1;

5342

5299

create table t1(a int not null) engine=csv;

5343

5300

insert into t1 values();

5344

Warnings:

5345

Warning 1364 Field 'a' doesn't have a default value

5301

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

5346

5302

select * from t1;

5347

5303

5348

5349

5304

drop table t1;

5350

5305

create table t1(a blob not null) engine=csv;

5351

5306

insert into t1 values();

5352

Warnings:

5353

Warning 1364 Field 'a' doesn't have a default value

5307

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

5354

5308

select * from t1;

5355

5309

5356

5357

drop table t1;

5358

create table t1(a bit(1) not null) engine=csv;

5359

insert into t1 values();

5360

Warnings:

5361

Warning 1364 Field 'a' doesn't have a default value

5362

select BIN(a) from t1;

5363

BIN(a)

5364

5365

5310

drop table t1;

5366

5311

create table t1(a enum('foo','bar') default null) engine=csv;

5367

5312

ERROR 42000: The storage engine for the table doesn't support nullable columns

5379

5324

Level Code Message

5380

5325

Error 1178 The storage engine for the table doesn't support nullable columns

5381

5326

Error 1005 Can't create table 'test.t1' (errno: 138)

5382

create table t1 (c1 tinyblob not null) engine=csv;

5327

create table t1 (c1 blob not null) engine=csv;

5383

5328

insert into t1 values("This");

5384

5329

update t1 set c1="That" where c1="This";

5385

5330

affected rows: 1

Older »