November 9, 2007 at 5:24 pm #4976
Yutaka Emura
Keymaster
Flint wrote:
I have the following text:ALTER TABLE asd ADD xxx TINYINT(1) DEFAULT ‘1’ NOT NULL;
UPDATE asd SET temp=0 WHERE id=-1;
INSERT INTO dsa (col1, col2) VALUES (‘test’, ‘0’);
INSERT INTO dsa (col1, col2) VALUES (‘test_with_something’, ‘0’);I select it all, then open the Replace dialog and set the following parameters:
Find: (.*);
Replace with: ‘1’,
[X] Use Regular Expressions
[X] In the Selection Only
Then I press Replace All. Only first two lines are replaced, the 3rd and the 4th remain unchanged.If I untick the In the Selection Only checkbox, all 4 lines are replaced.
This bug will be fixed on beta 33. Thanks!