blob: 3ec3c1ed2515f3f8e602347eecb729013b03c26e [file] [log] [blame]
>>obey TEST_6_2_1_3(tests);
>>
>>------------------------------------------------------------------
>>-- TEST CASE
>>------------------------------------------------------------------
>>
>>DELETE FROM T1 WHERE a>9;
--- 1 row(s) deleted.
>>
>>SELECT * FROM T1 ORDER BY a;
A B
----------- -----------
2 2
--- 1 row(s) selected.
>> -- check result
>>
>>SELECT * FROM T2 ORDER BY a,b;
A B
----------- -----------
1 2
1 3
--- 2 row(s) selected.
>> -- check result
>>
>>SELECT * FROM T3 ORDER BY a;
A B
----------- -----------
1 2
--- 1 row(s) selected.
>> -- check result
>>
>>SELECT * FROM T4 ORDER BY a;
A
-----------
100
--- 1 row(s) selected.
>> -- check result
>>
>>------------------------------------------------------------------
>>-- END
>>------------------------------------------------------------------
>>LOG;