Recreate cursors when switching between default and scaleout scenarios

- Achieve this by recreating cursors that don't have the appropriate prefix
#2061
New tests for cursor prefixes

#2061