fix(cursor): close underlying query cursor when calling destroy()

fix(cursor): close underlying query cursor when calling destroy() #1946