summaryrefslogtreecommitdiff
path: root/mysql-test/suite/csv/csv.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/csv/csv.result')
-rw-r--r--mysql-test/suite/csv/csv.result12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/suite/csv/csv.result b/mysql-test/suite/csv/csv.result
index 5f1b380f96b..833cd688be5 100644
--- a/mysql-test/suite/csv/csv.result
+++ b/mysql-test/suite/csv/csv.result
@@ -4978,11 +4978,16 @@ c1
5
DROP TABLE bug14672;
CREATE TABLE test_concurrent_insert ( val integer not null ) ENGINE = CSV;
+connect con1,localhost,root,,;
+connect con2,localhost,root,,;
+connection con1;
LOCK TABLES test_concurrent_insert READ LOCAL;
+connection con2;
INSERT INTO test_concurrent_insert VALUES (1);
SELECT * FROM test_concurrent_insert;
val
1
+connection con1;
SELECT * FROM test_concurrent_insert;
val
UNLOCK TABLES;
@@ -4994,6 +4999,9 @@ val
2
UNLOCK TABLES;
DROP TABLE test_concurrent_insert;
+connection default;
+disconnect con1;
+disconnect con2;
CREATE TABLE test_repair_table ( val integer not null ) ENGINE = CSV;
CHECK TABLE test_repair_table;
Table Op Msg_type Msg_text
@@ -5391,8 +5399,12 @@ That
drop table t1;
create table t1 (a int not null) engine=csv;
lock tables t1 read;
+connect con1,localhost,root,,;
+connection con1;
select * from t1;
ERROR HY000: File 'MYSQLD_DATADIR/test/t1.CSV' not found (Errcode: 2 "No such file or directory")
+disconnect con1;
+connection default;
unlock tables;
drop table t1;
CREATE TABLE t1 (e enum('foo','bar') NOT NULL) ENGINE = CSV;