These are the queries:
with t1(EML) as
-- Bad comment '' (with unbalanced quote)
( values 'a@b.c', 'd@e.f', 'f@h.i', 'j@k.l') select * from t1 where EML like '%@h.i';
with t1(EML) as
-- Bad comment ' (with unbalanced quote)
( values 'a@b.c', 'd@e.f', 'f@h.i', 'j@k.l') select * from t1 where EML like '%@h.i';
__
The only difference is the additional single quote in the comment
Using Toad for DB2, connected to any server, and executing these queries one by one in the Editor window, one may see that the first query, the one with the pair of quote-marks, returns one row, and, the second query, the one with only one single quote-mark in the comment area, returns no rows.
So, when there are unpaired quote-marks in a comment within the query, the result set is empty / incorrect.
Tiene que estar conectado y contar con un contrato de mantenimiento vigente para ver los artículos de conocimiento premium.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center