Description:
Executing a skript with some characters in a former comment causes it to fail.
The error message shows, that some characters of the sql-line have been deleted.
Experiments show, that sometimes the error occurs with german diaeresis (is that the word? We say "Umlaute": "a, "o, etc :-) but sometimes these characters do not harm. Sometimes even a blank line causes the error to show up.
I tried several comment-prefixes '/*', '#', '--' with no other effect.
How to repeat:
Try this (german-comment) skript in a skript-tab:
snip--------------------------------
-- use wongi_test;
-- Import der Daten aus der Datenbank wongi_import.
-- Es kommt beim Import auf die Reihenfolge an, damit FOREIGN-KEY-Beziehungen
-- nicht verletzt werden.
-- 1. Alle Daten aus allen Tabellen löschen.
-- 2. Beitragsklassen importieren
-- 3.
--
-- Erstmal alles löschen
delete from SollBeitraege;
delete from Kontoauszuege;
delete from Buchungen;
delete from TKD_Info;
delete from Mitglieder;
delete from Beitragklassen;
delete from Konten;
--
-- Beitragsklassen importieren
--
insert into Beitragklassen (
select klasse_id, bezeichnung, beitrag
from wongi_import.imp_beitragsklassen
);
snip--------------------------------
It doesn't matter that the tables do not exist, because this skript causes an sql-syntax-error. The log shows the command 'elete from SollBeitraege' which is little bit short :-)
Suggested fix:
Don't know.
