1
drop table if exists t1,t2,t3,t4;
2
CREATE TEMPORARY TABLE t1 (
3
Period int DEFAULT 0 NOT NULL,
4
Varor_period int DEFAULT 0 NOT NULL
6
INSERT INTO t1 VALUES (9410,9412);
16
CREATE TEMPORARY TABLE t2 (
18
fld1 int DEFAULT 0 NOT NULL,
19
companynr int DEFAULT 0 NOT NULL,
20
fld3 char(30) DEFAULT '' NOT NULL,
21
fld4 char(35) DEFAULT '' NOT NULL,
22
fld5 char(35) DEFAULT '' NOT NULL,
23
fld6 char(4) DEFAULT '' NOT NULL
25
select t2.fld3 from t2 where companynr = 58 and fld3 like "%imaginable%";
28
select fld3 from t2 where fld3 like "%cultivation" ;
31
select t2.fld3,companynr from t2 where companynr = 57+1 order by fld3;
56
select fld3,companynr from t2 where companynr = 58 order by fld3;
81
select fld3 from t2 order by fld3 desc limit 10;
93
select fld3 from t2 order by fld3 desc limit 5;
100
select fld3 from t2 order by fld3 desc limit 5,5;
107
UPDATE t2 SET fld3="foo" WHERE fld3="b%";
871
electroencephalography
1309
UPDATE t2 SET fld3="bar" WHERE fld3="s%";
1310
select fld3 from t2;
2073
electroencephalography
2511
DELETE FROM t2 WHERE fld3="r%";
2512
SELECT fld3 FROM t2;
3275
electroencephalography
3713
DELETE FROM t2 WHERE fld3="d%" ORDER BY RAND();
3714
SELECT fld3 FROM t2;
4477
electroencephalography
4916
ALTER TABLE t2 RENAME t1;
4918
CREATE TEMPORARY TABLE t1 (
4919
Period int DEFAULT 0 NOT NULL,
4920
Varor_period int DEFAULT 0 NOT NULL
4922
INSERT INTO t1 VALUES (9410,9412);
4923
select period from t1;
4926
drop table if exists t1,t2,t3,t4;
4928
Note 1051 Unknown table 't2'
4929
Note 1051 Unknown table 't3'
4930
Note 1051 Unknown table 't4'
4931
DROP TABLE IF EXISTS bug13894;
4932
CREATE TEMPORARY TABLE bug13894 ( val integer not null ) ENGINE = CSV;
4933
INSERT INTO bug13894 VALUES (5);
4934
INSERT INTO bug13894 VALUES (10);
4935
INSERT INTO bug13894 VALUES (11);
4936
INSERT INTO bug13894 VALUES (10);
4937
SELECT * FROM bug13894;
4943
UPDATE bug13894 SET val=6 WHERE val=10;
4944
SELECT * FROM bug13894;
4950
DROP TABLE bug13894;
4951
DROP TABLE IF EXISTS bug14672;
4952
CREATE TEMPORARY TABLE bug14672 (c1 integer not null) engine = CSV;
4953
INSERT INTO bug14672 VALUES (1), (2), (3);
4954
SELECT * FROM bug14672;
4959
DELETE FROM bug14672 WHERE c1 = 2;
4960
SELECT * FROM bug14672;
4964
INSERT INTO bug14672 VALUES (4);
4965
SELECT * FROM bug14672;
4970
INSERT INTO bug14672 VALUES (5);
4971
SELECT * FROM bug14672;
4977
DROP TABLE bug14672;
4978
create temporary table t1 (a int not null) engine=csv;
4979
insert t1 values (1);
4984
insert t1 values (1),(2);
4987
insert t1 values (1),(2),(3);
4991
insert t1 values (1),(2),(3),(4);
4993
select count(*) from t1;
4998
insert t1 values (1),(2),(3),(4),(5);
5002
create temporary table float_test (id float not null,string varchar(64) not null) Engine=CSV;
5003
insert into float_test values(1.0,'string');
5004
insert into float_test values(2.23,'serg.g');
5005
insert into float_test values(0.03,'string');
5006
insert into float_test values(0.19,'string');
5007
insert into float_test values(.67,'string');
5008
insert into float_test values(9.67,'string');
5009
select * from float_test;
5017
drop table float_test;
5018
CREATE TEMPORARY TABLE `bug21328` (
5019
`col1` int NOT NULL,
5020
`col2` int NOT NULL,
5023
insert into bug21328 values (1,0,0);
5024
alter table bug21328 engine=myisam;
5025
drop table bug21328;
5026
create temporary table t1(a blob not null, b int not null) engine=csv;
5027
insert into t1 values('a', 1);
5034
create temporary table t1(a int not null) engine=csv;
5035
insert into t1 values(-1), (-123.34), (2), (-23);
5043
Table Op Msg_type Msg_text
5044
test.t1 check status OK
5046
create temporary table t1(a int not null) engine=csv;
5047
insert into t1 values (0), (1), (2);
5048
delete from t1 limit 2;
5050
Table Op Msg_type Msg_text
5051
test.t1 check status OK
5057
Table Op Msg_type Msg_text
5058
test.t1 check status OK
5062
create temporary table t1(a datetime not null) engine=csv;
5063
insert into t1 values();
5064
ERROR HY000: Field 'a' doesn't have a default value
5068
create temporary table t1(a varchar(32) not null) engine=csv;
5069
insert into t1 values();
5070
ERROR HY000: Field 'a' doesn't have a default value
5074
create temporary table t1(a int not null) engine=csv;
5075
insert into t1 values();
5076
ERROR HY000: Field 'a' doesn't have a default value
5080
create temporary table t1(a blob not null) engine=csv;
5081
insert into t1 values();
5082
ERROR HY000: Field 'a' doesn't have a default value
5086
create temporary table t1(a enum('foo','bar') default null) engine=csv;
5087
ERROR 42000: The storage engine for the table doesn't support nullable columns
5088
create temporary table t1(a enum('foo','bar') default 'foo') engine=csv;
5089
ERROR 42000: The storage engine for the table doesn't support nullable columns
5090
create temporary table t1(a enum('foo','bar') default 'foo' not null) engine=csv;
5091
insert into t1 values();
5096
CREATE TEMPORARY TABLE t1(a INT) ENGINE=CSV;
5097
ERROR 42000: The storage engine for the table doesn't support nullable columns
5100
Error 1178 The storage engine for the table doesn't support nullable columns
5101
Error 1005 Can't create table 'test.#t1' (errno: 138)
5102
create temporary table t1 (c1 blob not null) engine=csv;
5103
insert into t1 values("This");
5104
update t1 set c1="That" where c1="This";
5106
info: Rows matched: 1 Changed: 1 Warnings: 0
5111
drop table if exists t1;
added
removed
plugin/csv/tests/r/basic.result
