Error running script containing quotes and semicolons

[expired user #4938]'s profile image [expired user #4938] posted 14 years ago in Running SQL scripts Permalink
Let's have simple table here:
CREATE TABLE `temp_test` (
`id` INT(10) NOT NULL DEFAULT '0',
`text` TEXT NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM
ROW_FORMAT=DEFAULT


When I'm trying to change the 'text' column using Query window in HeidiSQL it fails. (F9 command)

UPDATE `temp_test` SET `text`='<span style="text-decoration: underline;">' WHERE `id`=1;


The same command succeeded when I'm changing values in data grid in HeidiSQL.

Please see screenshot here:
[/url]

In log window you can see the correct statement when I used data grid for changing value (line 30) and the error when I tried to use Query window (line 31)

The same command has worked fine in MySQL Command Line Client:
[url=
http://picasaweb.google.com/107916404888365403566/HeidiSQL#5475961157226095234]

Please help.
A.

ansgar's profile image ansgar posted 14 years ago Permalink
That's a bug in the SQL splitter - your query end is detected at the semicolon. Damn, should have been fixed by r3346 but obviously is not working 100%.
Code modification/commit from ansgar.becker, 14 years ago, revision 5.1.0.3351
Closing string encloser must be same as opening one. Fixes issue reported in forum: http://www.heidisql.com/forum.php?t=5856
ansgar's profile image ansgar posted 14 years ago Permalink
Fixed in r3351
[expired user #4938]'s profile image [expired user #4938] posted 14 years ago Permalink
Yes, it's working now.
Thank you

Please login to leave a reply, or register at first.