Wildcard join and sqldf inconsistent

[d.ma...@ya.ru]

Hi

I am running following code and it does not work as it does on Data Base.
In short it matches only first string in the list. So my join produces about 2 % of required rows only.

http://rextester.com/WSU51736


Vs.



join2 <- sqldf("
select Logs.Column2, Instances.DeviceNumber, Instances.slotlist2
from Logs
inner join Instances ON Logs.Column1 = Instances.DeviceNumber
and (', ' + RTRIM(Instances.slotlist2) + ',') LIKE '%, '+ Logs.Column2 +',%' ")


Any idea what can casue the trouble ?

[Gabor Grothendieck]

Please provide the code needed to generate the R data frames used so 

it can just be copied and pasted into R.