1
--source include/have_maria.inc
4
# "Maria: table is not empty but DELETE and SELECT find no rows"
8
kind ENUM('po', 'pp', 'rr', 'dr', 'rd', 'ts', 'cl') NOT NULL DEFAULT 'po',
10
) transactional=0 row_format=page engine=maria;
12
let $query= INSERT INTO t1 (name, kind, line) VALUES
13
("Aadaouane", "pp", GeomFromText("POINT(32.816667 35.983333)")),
14
("Aadassiye", "pp", GeomFromText("POINT(35.816667 36.216667)")),
15
("Aadbel", "pp", GeomFromText("POINT(34.533333 36.100000)")),
16
("Aadchit", "pp", GeomFromText("POINT(33.347222 35.423611)")),
17
("Aadchite", "pp", GeomFromText("POINT(33.347222 35.423611)")),
18
("Aadchit el Qoussair", "pp", GeomFromText("POINT(33.283333 35.483333)")),
19
("Aaddaye", "pp", GeomFromText("POINT(36.716667 40.833333)")),
20
("'Aadeissa", "pp", GeomFromText("POINT(32.823889 35.698889)")),
21
("Aaderup", "pp", GeomFromText("POINT(55.216667 11.766667)")),
22
("Qalaat Aades", "pp", GeomFromText("POINT(33.503333 35.377500)")),
23
("A ad'ino", "pp", GeomFromText("POINT(54.812222 38.209167)")),
24
("Aadi Noia", "pp", GeomFromText("POINT(13.800000 39.833333)")),
25
("Aad La Macta", "pp", GeomFromText("POINT(35.779444 -0.129167)")),
26
("Aadland", "pp", GeomFromText("POINT(60.366667 5.483333)")),
27
("Aadliye", "pp", GeomFromText("POINT(33.366667 36.333333)")),
28
("Aadloun", "pp", GeomFromText("POINT(33.403889 35.273889)")),
29
("Aadma", "pp", GeomFromText("POINT(58.798333 22.663889)")),
30
("Aadma Asundus", "pp", GeomFromText("POINT(58.798333 22.663889)")),
31
("Aadmoun", "pp", GeomFromText("POINT(34.150000 35.650000)")),
32
("Aadneram", "pp", GeomFromText("POINT(59.016667 6.933333)")),
33
("Aadneskaar", "pp", GeomFromText("POINT(58.083333 6.983333)")),
34
("Aadorf", "pp", GeomFromText("POINT(47.483333 8.900000)")),
35
("Aadorp", "pp", GeomFromText("POINT(52.366667 6.633333)")),
36
("Aadouane", "pp", GeomFromText("POINT(32.816667 35.983333)")),
37
("Aadoui", "pp", GeomFromText("POINT(34.450000 35.983333)")),
38
("Aadouiye", "pp", GeomFromText("POINT(34.583333 36.183333)")),
39
("Aadouss", "pp", GeomFromText("POINT(33.512500 35.601389)")),
40
("Aadra", "pp", GeomFromText("POINT(33.616667 36.500000)")),
41
("Aadzi", "pp", GeomFromText("POINT(38.100000 64.850000)"));
53
delete from t1 limit 1;
54
delete from t1 limit 10;
55
delete from t1 limit 7;
56
delete from t1 limit 2;
61
select count(*) from t1;
62
delete from t1 limit 1000;
63
select count(*) from t1;
65
check table t1 extended;