Mantis Bugtracker

Viewing Issue Simple Details Jump to Notes ] View Advanced ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0000019 [sqliteman] SQL engine minor always 2007-09-09 17:25 2007-12-03 13:12
Reporter ArturAs View Status public  
Assigned To subzero
Priority normal Resolution fixed  
Status closed   Product Version
Summary 0000019: "delete from" fails
Description delete from zs_cds where quelle like "y%"

results in

Abfrage Fehler; unrecognized token: ":"

SQL statement not found. Pos: 32. Start: 0. End: 0.
Additional Information
Tags No tags attached.
Attached Files

- Relationships

-  Notes
(0000014)
subzero (administrator)
2007-09-10 14:35

What Sqliteman version are you using? If it's plain 1.0 then it looks like it's fixed in the SVN already.

Please try fresh SVN if you compile sqliteman yourself or wait for next bugfix release planned in 1-2 week(s).

Workaround: select your statement like for copy/pasting, then run it again.

Hint: SQL statements are terminated with semicolons ";". Maybe you are missing some.
(0000016)
ArturAs (reporter)
2007-09-10 14:48

Subzero, thank you for the quick answer.
I use compiled version 1.0.
I didn't understand what you mean with "select your statement like for copy/pasting, then run it again."
The statement
select * from zs_cds where quelle like "y%"
works, but not
delete from zs_cds where quelle like "y%"
It ist not the problem of a ";" - delete doesn't work with and without ";"
Artur
(0000018)
subzero (administrator)
2007-09-10 16:07

The problem is that I cannot reproduce this ugly behaviour. Where do you have text cursor exactly? Are there any more lines of text?

ad "select your statement..." - select your statement e.g. with mouse like when you want to copy the text.
(0000082)
subzero (administrator)
2007-11-30 16:24

all sql parser errors are resolved. SQliteman uses new SQL parser taken from TOra now.

- Issue History
Date Modified Username Field Change
2007-09-09 17:25 ArturAs New Issue
2007-09-10 14:35 subzero Note Added: 0000014
2007-09-10 14:48 ArturAs Note Added: 0000016
2007-09-10 16:07 subzero Note Added: 0000018
2007-11-30 16:24 subzero Status new => resolved
2007-11-30 16:24 subzero Fixed in Version => 1.1svn
2007-11-30 16:24 subzero Resolution open => fixed
2007-11-30 16:24 subzero Assigned To => subzero
2007-11-30 16:24 subzero Note Added: 0000082
2007-12-03 13:12 subzero Status resolved => closed


Mantis 1.1.7[^]
Copyright © 2000 - 2008 Mantis Group
Powered by Mantis Bugtracker