|
1548.4.60
by Zimin
add rnd_pos test case and some fix in filesystem to make it work. |
1 |
#
|
2 |
# borrowed from embbedded innodb test suite |
|
3 |
#
|
|
4 |
||
5 |
--disable_warnings
|
|
6 |
DROP TABLE IF EXISTS t1; |
|
7 |
--enable_warnings
|
|
8 |
||
9 |
CREATE TABLE t1 ( |
|
10 |
aufnr VARCHAR(12) NOT NULL DEFAULT '', |
|
11 |
plnfl VARCHAR(6) NOT NULL DEFAULT '', |
|
12 |
vornr VARCHAR(4) NOT NULL DEFAULT '', |
|
13 |
xstatus_vor INT NOT NULL DEFAULT '0' |
|
|
1548.4.88
by Zimin
hacks to let the test case know of the files' location |
14 |
) ENGINE=FILESYSTEM,FILE="../filesystem_ln/rnd_pos.data"; |
|
1548.4.60
by Zimin
add rnd_pos test case and some fix in filesystem to make it work. |
15 |
|
16 |
DELETE FROM t1; |
|
17 |
||
18 |
INSERT INTO t1 VALUES ('40004712','000001','0010',9); |
|
19 |
INSERT INTO t1 VALUES ('40004712','000001','0020',0); |
|
20 |
||
21 |
UPDATE t1 SET t1.xstatus_vor = Greatest(t1.xstatus_vor,1) WHERE t1.aufnr = |
|
22 |
"40004712" AND t1.plnfl = "000001" AND t1.vornr > "0010" ORDER BY t1.vornr |
|
23 |
ASC LIMIT 1; |
|
24 |
||
25 |
SELECT * FROM t1; |
|
26 |
||
27 |
DELETE FROM t1; |
|
28 |
DROP TABLE t1; |