Author: jzucker Date: Mon Oct 11 12:57:07 2004 New Revision: 485 Modified: dbi/trunk/t/50dbm.t Log: Test to detect bad SQL parsing of spaces
Modified: dbi/trunk/t/50dbm.t ============================================================================== --- dbi/trunk/t/50dbm.t (original) +++ dbi/trunk/t/50dbm.t Mon Oct 11 12:57:07 2004 @@ -140,9 +140,9 @@ INSERT INTO fruit VALUES (1,'oranges' ); INSERT INTO fruit VALUES (2,'to_change' ); INSERT INTO fruit VALUES (3, NULL ); -INSERT INTO fruit VALUES (4,'to_delete' ); +INSERT INTO fruit VALUES (4,'to delete' ); UPDATE fruit SET dVal='apples' WHERE dKey=2; -DELETE FROM fruit WHERE dKey=4; +DELETE FROM fruit WHERE dVal='to delete'; SELECT * FROM fruit; DROP TABLE fruit;
