SQL query messed up
|Reported by:||dnedelchev||Owned by:||Ryan J Ollos|
If you write the following in a wiki page:
see #1 and #2 and #3, probably #4; maybe #5- and #6 #7:eventually ticket:8, ticket:9 and [ticket:10] ?
then only tickets 2 and 10 would be detected by the macro. The reason is the quiery is only for tickets referred in the following form:
'#3 '(i.e. a trailing space is mandatory!)
'[ticket:3]'(i.e. a trailing space is mandatory!)
If the trailing space as well as enveloping brackets are just removed, all tickets except ticket 1 are detected. But then references like these:
will also be detected while they obviously shouldn't be.
(I didn't investigated yet why ticket 1 is handled different - in some cases it's missed when other tickets referenced in the same form are detected normally)
In short: I think the SQL query have to be rewritten from the beginning since I think it should be made much more clean.
I'll try to un-ravel it a bit more if I have time but I'm not too much in that matter and I'm sure someone else can do it much better than me.
(see also #7299)
Change History (5)
comment:2 Changed 4 years ago by
|Owner:||changed from David Francos Cuartero to Ryan J Ollos|
|Status:||new → assigned|