~drizzle-trunk/drizzle/development

Committer: Stewart Smith
Date: 2009-06-16 01:14:34 UTC
mto: This revision was merged to the branch mainline in revision 1071.
Revision ID: stewart@flamingspork.com-20090616011434-tgqlldw4nvcuyh5o

CSV as temporary only engine

files removed:
tests/r/csv.result

files modified:
plugin/csv/ha_tina.cc

tests/r/csv_alter_table.result

tests/r/csv_not_null.result

tests/t/csv_alter_table.test

tests/t/csv_not_null.test

removed removed

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

CREATE TABLE t1 (

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;

select * from t1;

Period Varor_period

select t1.* from t1;

Period Varor_period

CREATE TABLE t2 (

auto int 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,

fld6 char(4) DEFAULT '' NOT NULL

) ENGINE = CSV;

select t2.fld3 from t2 where companynr = 58 and fld3 like "%imaginable%";

select fld3 from t2 where fld3 like "%cultivation" ;

select t2.fld3,companynr from t2 where companynr = 57+1 order by fld3;

fld3 companynr

druggists 58

engrossing 58

exclaimers 58

ferociousness 58

hopelessness 58

imaginable 58

sentences 58

straggled 58

select fld3,companynr from t2 where companynr = 58 order by fld3;

fld3 companynr

druggists 58

engrossing 58

exclaimers 58

ferociousness 58

hopelessness 58

imaginable 58

sentences 58

straggled 58

select fld3 from t2 order by fld3 desc limit 10;

youthfulness

select fld3 from t2 order by fld3 desc limit 5;

youthfulness

select fld3 from t2 order by fld3 desc limit 5,5;

UPDATE t2 SET fld3="foo" WHERE fld3="b%";

select fld3 from t2;

bewilderingly

scatterbrain

misunderstander

intelligibility

rightfulness

featherweight

standardizes

irresponsibly

interdependent

Manhattanize

interrelationships

comprehensive

subdirectory

transistorizing

nonbiodegradable

monochromatic

postcondition

anesthetizing

combinations

inexperienced

competitions

observations

subdirectories

Franklinizations

uninterruptedly

surreptitious

counterpoise

metaphysically

contributorily

hopelessness

ferociousness

artificially

reminiscence

apprehensible

displacement

behaviorally

chronography

undiscovered

photosensitive

interactions

assassinated

bibliographies

superstitious

disappointing

definiteness

congresswoman

circumference

stratifications

disobedience

cartographer

Corinthianizes

simultaneous

accumulating

commercially

commencements

sportswriting

communicants

parametrized

registration

configurations

participated

certificates

effortlessly

overestimating

specification

decomposition

electroencephalography

similarities

serializations

taxonomically

hypothesizer

journalizing

precipitable

mournfulness

investigations

exponentials

evenhandedly

disobedience

miniaturizes

youthfulness

omnisciently

transcontinental

chamberlains

bibliography

bankruptcies

Asiaticizations

checksumming

Italianization

pharmaceutic

retransmitting

Peruvianizes

exterminated

translatable

presentation

photographers

solidification

inheritresses

extramarital

comfortingly

Italianization

nondecreasing

UPDATE t2 SET fld3="bar" WHERE fld3="s%";

select fld3 from t2;

bewilderingly

scatterbrain

misunderstander

intelligibility

rightfulness

featherweight

standardizes

irresponsibly

interdependent

Manhattanize

interrelationships

comprehensive

subdirectory

transistorizing

nonbiodegradable

monochromatic

postcondition

anesthetizing

combinations

inexperienced

competitions

observations

subdirectories

Franklinizations

uninterruptedly

surreptitious

counterpoise

metaphysically

contributorily

hopelessness

ferociousness

artificially

reminiscence

apprehensible

displacement

behaviorally

chronography

undiscovered

photosensitive

interactions

assassinated

bibliographies

superstitious

disappointing

definiteness

congresswoman

circumference

stratifications

disobedience

cartographer

Corinthianizes

simultaneous

accumulating

commercially

commencements

sportswriting

communicants

parametrized

registration

configurations

participated

certificates

effortlessly

overestimating

specification

decomposition

electroencephalography

similarities

serializations

taxonomically

hypothesizer

journalizing

precipitable

mournfulness

investigations

exponentials

evenhandedly

disobedience

miniaturizes

youthfulness

omnisciently

transcontinental

chamberlains

bibliography

bankruptcies

Asiaticizations

checksumming

Italianization

pharmaceutic

retransmitting

Peruvianizes

exterminated

translatable

presentation

photographers

solidification

inheritresses

extramarital

comfortingly

Italianization

nondecreasing

DELETE FROM t2 WHERE fld3="r%";

SELECT fld3 FROM t2;

bewilderingly

scatterbrain

misunderstander

intelligibility

rightfulness

featherweight

standardizes

irresponsibly

interdependent

Manhattanize

interrelationships

comprehensive

subdirectory

transistorizing

nonbiodegradable

monochromatic

postcondition

anesthetizing

combinations

inexperienced

competitions

observations

subdirectories

Franklinizations

uninterruptedly

surreptitious

counterpoise

metaphysically

contributorily

hopelessness

ferociousness

artificially

reminiscence

apprehensible

displacement

behaviorally

chronography

undiscovered

photosensitive

interactions

assassinated

bibliographies

superstitious

disappointing

definiteness

congresswoman

circumference

stratifications

disobedience

cartographer

Corinthianizes

simultaneous

accumulating

commercially

commencements

sportswriting

communicants

parametrized

registration

configurations

participated

certificates

effortlessly

overestimating

specification

decomposition

electroencephalography

similarities

serializations

taxonomically

hypothesizer

journalizing

precipitable

mournfulness

investigations

exponentials

evenhandedly

disobedience

miniaturizes

youthfulness

omnisciently

transcontinental

chamberlains

bibliography

bankruptcies

Asiaticizations

checksumming

Italianization

pharmaceutic

retransmitting

Peruvianizes

exterminated

translatable

presentation

photographers

solidification

inheritresses

extramarital

comfortingly

Italianization

nondecreasing

DELETE FROM t2 WHERE fld3="d%" ORDER BY RAND();

SELECT fld3 FROM t2;

bewilderingly

scatterbrain

misunderstander

intelligibility

rightfulness

featherweight

standardizes

irresponsibly

interdependent

Manhattanize

interrelationships

comprehensive

subdirectory

transistorizing

nonbiodegradable

monochromatic

postcondition

anesthetizing

combinations

inexperienced

competitions

observations

subdirectories

Franklinizations

uninterruptedly

surreptitious

counterpoise

metaphysically

contributorily

hopelessness

ferociousness

artificially

reminiscence

apprehensible

displacement

behaviorally

chronography

undiscovered

photosensitive

interactions

assassinated

bibliographies

superstitious

disappointing

definiteness

congresswoman

circumference

stratifications

disobedience

cartographer

Corinthianizes

simultaneous

accumulating

commercially

commencements

sportswriting

communicants

parametrized

registration

configurations

participated

certificates

effortlessly

overestimating

specification

decomposition

electroencephalography

similarities

serializations

taxonomically

hypothesizer

journalizing

precipitable

mournfulness

investigations

exponentials

evenhandedly

disobedience

miniaturizes

youthfulness

omnisciently

transcontinental

chamberlains

bibliography

bankruptcies

Asiaticizations

checksumming

Italianization

pharmaceutic

retransmitting

Peruvianizes

exterminated

translatable

presentation

photographers

solidification

inheritresses

extramarital

comfortingly

Italianization

nondecreasing

DROP TABLE t1;

ALTER TABLE t2 RENAME t1;

DROP TABLE t1;

CREATE TABLE t1 (

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;

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

Note 1051 Unknown table 't2'

Note 1051 Unknown table 't3'

Note 1051 Unknown table 't4'

DROP TABLE IF EXISTS bug13894;

CREATE TABLE bug13894 ( val integer not null ) ENGINE = CSV;

INSERT INTO bug13894 VALUES (5);

INSERT INTO bug13894 VALUES (10);

INSERT INTO bug13894 VALUES (11);

INSERT INTO bug13894 VALUES (10);

SELECT * FROM bug13894;

UPDATE bug13894 SET val=6 WHERE val=10;

SELECT * FROM bug13894;

DROP TABLE bug13894;

DROP TABLE IF EXISTS bug14672;

CREATE TABLE bug14672 (c1 integer not null) engine = CSV;

INSERT INTO bug14672 VALUES (1), (2), (3);

SELECT * FROM bug14672;

DELETE FROM bug14672 WHERE c1 = 2;

SELECT * FROM bug14672;

INSERT INTO bug14672 VALUES (4);

SELECT * FROM bug14672;

INSERT INTO bug14672 VALUES (5);

SELECT * FROM bug14672;

DROP TABLE bug14672;

CREATE TABLE test_repair_table ( val integer not null ) ENGINE = CSV;

CHECK TABLE test_repair_table;

Table Op Msg_type Msg_text

test.test_repair_table check status OK

REPAIR TABLE test_repair_table;

Table Op Msg_type Msg_text

test.test_repair_table repair status OK

DROP TABLE test_repair_table;

CREATE TABLE test_repair_table2 ( val integer not null ) ENGINE = CSV;

SELECT * from test_repair_table2;

Error 1194 Table 'test_repair_table2' is marked as crashed and should be repaired

SELECT * from test_repair_table2;

CHECK TABLE test_repair_table2;

Table Op Msg_type Msg_text

test.test_repair_table2 check status OK

DROP TABLE test_repair_table2;

CREATE TABLE test_repair_table3 ( val integer not null ) ENGINE = CSV;

CHECK TABLE test_repair_table3;

Table Op Msg_type Msg_text

test.test_repair_table3 check error Corrupt

REPAIR TABLE test_repair_table3;

Table Op Msg_type Msg_text

test.test_repair_table3 repair status OK

SELECT * FROM test_repair_table3;

DROP TABLE test_repair_table3;

CREATE TABLE test_repair_table4 (

num int not null,

magic_no int DEFAULT 0 NOT NULL,

company_name char(30) DEFAULT '' NOT NULL,

founded char(4) DEFAULT '' NOT NULL

) ENGINE = CSV;

SELECT * FROM test_repair_table4;

num magic_no company_name founded

Error 1194 Table 'test_repair_table4' is marked as crashed and should be repaired

SELECT * FROM test_repair_table4;

num magic_no company_name founded

CHECK TABLE test_repair_table4;

Table Op Msg_type Msg_text

test.test_repair_table4 check status OK

INSERT INTO test_repair_table4 VALUES (2,101,'SAP','1972');

INSERT INTO test_repair_table4 VALUES (1,101,'Microsoft','1978');

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

SELECT * FROM test_repair_table4;

num magic_no company_name founded

2 101 SAP 1972

1 101 Microsoft 1978

2 101 MySQL 1995

CHECK TABLE test_repair_table4;

Table Op Msg_type Msg_text

test.test_repair_table4 check status OK

REPAIR TABLE test_repair_table4;

Table Op Msg_type Msg_text

test.test_repair_table4 repair status OK

SELECT * FROM test_repair_table4;

num magic_no company_name founded

2 101 SAP 1972

1 101 Microsoft 1978

2 101 MySQL 1995

CHECK TABLE test_repair_table4;

Table Op Msg_type Msg_text

test.test_repair_table4 check status OK

REPAIR TABLE test_repair_table4;

Table Op Msg_type Msg_text

test.test_repair_table4 repair status OK

SELECT * FROM test_repair_table4;

num magic_no company_name founded

2 101 SAP 1972

1 101 Microsoft 1978

2 101 MySQL 1995

DROP TABLE test_repair_table4;

CREATE TABLE test_repair_table5 (

num int not null,

magic_no int DEFAULT 0 NOT NULL,

company_name char(30) DEFAULT '' NOT NULL,

founded char(4) DEFAULT '' NOT NULL

) ENGINE = CSV;

CHECK TABLE test_repair_table5;

Table Op Msg_type Msg_text

test.test_repair_table5 check error Corrupt

REPAIR TABLE test_repair_table5;

Table Op Msg_type Msg_text

test.test_repair_table5 repair status OK

SELECT * FROM test_repair_table5;

num magic_no company_name founded

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

SELECT * FROM test_repair_table5;

num magic_no company_name founded

1 102 CORRECT 1876

FLUSH TABLES;

CHECK TABLE test_repair_table5;

Table Op Msg_type Msg_text

test.test_repair_table5 check error Corrupt

REPAIR TABLE test_repair_table5;

Table Op Msg_type Msg_text

test.test_repair_table5 repair status OK

SELECT * FROM test_repair_table5;

num magic_no company_name founded

1 102 CORRECT 1876

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

SELECT * FROM test_repair_table5;

num magic_no company_name founded

1 102 CORRECT 1876

1 102 CORRECT2 1876

FLUSH TABLES;

CHECK TABLE test_repair_table5;

Table Op Msg_type Msg_text

test.test_repair_table5 check error Corrupt

REPAIR TABLE test_repair_table5;

Table Op Msg_type Msg_text

test.test_repair_table5 repair status OK

SELECT * FROM test_repair_table5;

num magic_no company_name founded

1 102 CORRECT 1876

1 102 CORRECT2 1876

DROP TABLE test_repair_table5;

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

insert t1 values (1);

delete from t1;

affected rows: 1

delete from t1;

affected rows: 0

insert t1 values (1),(2);

delete from t1;

affected rows: 2

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

flush tables;

delete from t1;

affected rows: 3

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

flush tables;

select count(*) from t1;

delete from t1;

affected rows: 4

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

truncate table t1;

affected rows: 5

drop table t1;

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

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

select * from t1;

alter table t1 change v v2 varchar(32);

select * from t1;

alter table t1 change v2 v varchar(64);

select * from t1;

update t1 set v = 'lmn' where v = 'hij';

select * from t1;

alter table t1 add i int auto_increment not null primary key first;

select * from t1;

update t1 set i=5 where i=3;

select * from t1;

alter table t1 change i i bigint;

select * from t1;

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

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

drop table t1;

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

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

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

insert into bug22080_1 values(1,'string');

insert into bug22080_1 values(2,'string');

insert into bug22080_1 values(3,'string');

check table bug22080_2;

Table Op Msg_type Msg_text

test.bug22080_2 check error Corrupt

check table bug22080_3;

Table Op Msg_type Msg_text

test.bug22080_3 check error Corrupt

drop tables bug22080_1,bug22080_2,bug22080_3;

create table float_test (id float not null,string varchar(64) not null) Engine=CSV;

insert into float_test values(1.0,'string');

insert into float_test values(2.23,'serg.g');

insert into float_test values(0.03,'string');

insert into float_test values(0.19,'string');

insert into float_test values(.67,'string');

insert into float_test values(9.67,'string');

select * from float_test;

drop table float_test;

CREATE TABLE `bug21328` (

`col1` int NOT NULL,

`col2` int NOT NULL,

`col3` int NOT NULL

) ENGINE=CSV;

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

alter table bug21328 engine=myisam;

drop table bug21328;

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

insert into t1 values('a', 1);

flush tables;

update t1 set b=2;

select * from t1;

drop table t1;

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

insert into t1 values(-1), (-123.34), (2), (-23);

select * from t1;

check table t1;

Table Op Msg_type Msg_text

test.t1 check status OK

drop table t1;

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

repair table t1;

Table Op Msg_type Msg_text

test.t1 repair Warning Data truncated for column 'a' at row 5

test.t1 repair status OK

check table t1;

Table Op Msg_type Msg_text

test.t1 check status OK

select * from t1;

check table t1;

Table Op Msg_type Msg_text

test.t1 check status OK

drop table t1;

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

insert into t1 values (0), (1), (2);

delete from t1 limit 2;

check table t1;

Table Op Msg_type Msg_text

test.t1 check status OK

select * from t1;

delete from t1;

check table t1;

Table Op Msg_type Msg_text

test.t1 check status OK

select * from t1;

drop table t1;

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

insert into t1 values();

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

select * from t1;

drop table t1;

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

insert into t1 values();

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

select * from t1;

drop table t1;

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

insert into t1 values();

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

select * from t1;

drop table t1;

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

insert into t1 values();

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

select * from t1;

drop table t1;

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

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

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

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

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

insert into t1 values();

select * from t1;

drop table t1;

CREATE TABLE t1(a INT) ENGINE=CSV;

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

SHOW WARNINGS;

Level Code Message

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

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

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

insert into t1 values("This");

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

affected rows: 1

info: Rows matched: 1 Changed: 1 Warnings: 0

select * from t1;

drop table t1;

drop table if exists t1;

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

select * from t1;

ERROR HY000: Can't find file: 't1' (errno: 2)

End of 5.1 tests

Older »