1460
1460
select * from t1;
1464
# Bug #39616 Missing quotes from .CSV crashes server
1466
# Editing the .CSV file and leaving out quotes from around an integer field
1467
# crashes the server.
1471
# Test for the integers and strings enclosed in quotes, not enclosed in quotes,
1474
create table bug39616_1(id int NOT NULL, d varchar(50) NOT NULL) ENGINE=csv;
1476
--remove_file $MYSQLTEST_VARDIR/master-data/test/bug39616_1.CSV
1477
--write_file $MYSQLTEST_VARDIR/master-data/test/bug39616_1.CSV
1478
1,"integer sans quotes"
1479
1,string sans quotes
1480
1,string end quotes"
1481
1,quotes"in between" strings
1482
"1",Integer with quote and string with no quote
1483
1,"escape sequence \n \" \\ \r \a within quotes"
1486
select * from bug39616_1;
1488
drop table bug39616_1;
1491
# Test for he case when a field begins with a quote, but does not end in a
1493
# Note: This results in an empty set.
1495
create table bug39616_1(id int NOT NULL, d varchar(50) NOT NULL) ENGINE=csv;
1497
--remove_file $MYSQLTEST_VARDIR/master-data/test/bug39616_1.CSV
1498
--write_file $MYSQLTEST_VARDIR/master-data/test/bug39616_1.CSV
1499
1,"string only at the beginning quotes
1502
select * from bug39616_1;
1504
drop table bug39616_1;
1463
1506
--echo End of 5.0 tests