blob: 1b826b3166ddfe32fd6db80662035d6eb92f6394 [file] [log] [blame]
>>obey TEST_5_3_2(tests);
>>
>>------------------------------------------------------------------
>>-- TEST CASE
>>------------------------------------------------------------------
>>
>>UPDATE tab1A SET b = b+10 WHERE a<3;
--- 2 row(s) updated.
>>
>>SELECT * FROM tab1A;
A B C D
----------- ----------- ----------- -----------
1 12 3 4
2 13 4 5
3 4 5 6
--- 3 row(s) selected.
>> -- check result
>>
>>SELECT * FROM tab1B;
A B
----------- -----------
1 2
2 3
10 10
--- 3 row(s) selected.
>> -- check result
>>
>>SELECT * FROM cat2.schm.tab2A;
A B
----------- -----------
1 2
2 3
--- 2 row(s) selected.
>> -- check result
>>
>>------------------------------------------------------------------
>>-- END
>>------------------------------------------------------------------
>>LOG;