← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/csv.test

  • Committer: lbieber
  • Date: 2009-06-10 16:47:25 UTC
  • mto: (1061.1.3 merge-all)
  • mto: This revision was merged to the branch mainline in revision 1062.
  • Revision ID: lbieber@lbieber-laptop-20090610164725-07ivii6d6jk3jesc
clean up unused targets in top level Makefile,  remove LOCK TABLES from csv.test

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/csv.test
1356
1356
# End of 4.1 tests
1357
1357
 
1358
1358
#
1359
 
# Test CONCURRENT INSERT (5.1)
1360
 
#
1361
 
 
1362
 
CREATE TABLE test_concurrent_insert ( val integer not null ) ENGINE = CSV;
1363
 
 
1364
 
connect (con1,localhost,root,,);
1365
 
connect (con2,localhost,root,,);
1366
 
 
1367
 
connection con1;
1368
 
# obtain TL_READ lock on the table
1369
 
LOCK TABLES test_concurrent_insert READ LOCAL;
1370
 
 
1371
 
connection con2;
1372
 
# should pass despite of the lock
1373
 
INSERT INTO test_concurrent_insert VALUES (1);
1374
 
SELECT * FROM test_concurrent_insert;
1375
 
 
1376
 
connection con1;
1377
 
# first connection should not notice the changes
1378
 
SELECT * FROM test_concurrent_insert;
1379
 
 
1380
 
UNLOCK TABLES;
1381
 
 
1382
 
# Now check that we see our own changes
1383
 
 
1384
 
LOCK TABLES test_concurrent_insert WRITE;
1385
 
INSERT INTO test_concurrent_insert VALUES (2);
1386
 
SELECT * FROM test_concurrent_insert;
1387
 
UNLOCK TABLES;
1388
 
 
1389
 
# cleanup
1390
 
DROP TABLE test_concurrent_insert;
1391
 
 
1392
 
#
1393
1359
# Test REPAIR/CHECK TABLE (5.1)
1394
1360
#
1395
1361