Ignore whitespace not working in 5.7.6.6321 and later

• 
  I appear to be experiencing the same issue. On the same version of SSC and am seeing just 3 objects affected: db_datareader, db_owner and db_securityadmin. SSC detects the change immediately after committing and there is no identifiable difference between the text output in the bottom windows.
  
  Update: Upgraded to version 5.8.3.6733 but still seeing the issue.

  Don_W August 22, 2017 15:33

  - 0 +
• 
  So sorry for the delayed response!
  
  I haven't been able to reproduce this with a simple test, unfortunately.
  
  @caliq Can I just check if this is still occurring for you as well in the latest frequent release, v5.8.3.6733?
  
  @Don_W And just to clarify if this is the same issue with white space and casing-- do the db_datareader, db_owner and db_securityadmin objects have actual white space and casing differences (that SQL Source Control should be ignoring but isn't) or are they completely identical (yet SQL Source Control says they are different)?
  
  Do the problems go away if you reinstall version 5.7.4.6241?

  Jessica R August 22, 2017 22:54

  - 0 +
• 
  Found a workaround.
  
  I couldn't find any differences in whitespace or casing. Checksums were identical. Reinstalled with the version you recommended but no luck.
  
  Finally tried undoing changes which seemed to resolve the issue.

  Don_W August 23, 2017 15:32

  - 0 +
• 
  Thanks for those details @Don_W!
  
  I'm glad to hear you've found a workaround but that is a really odd issue you were seeing. If this comes up again, can you please let us know? It may be helpful to get a copy of your working and transient folders as well as a snapshot of the database.

  Jessica R August 23, 2017 20:31

  - 0 +
• 
  I will certainly do that thanks.

  Don_W August 24, 2017 13:20

  - 0 +
• 
  I have a ticket open. It has been reproduced with my sample files. See below

  ---

  Hi Richard,
  
  I have now logged a bug report for this issue (ref n. SC-9595).
  
  I will keep this on hold and will update when there are meaningful updates or this is fixed.
  
  Thank you,
  Sergio
  

  caliq August 24, 2017 13:47

  - 0 +
• 
  Ah I see, thank you for pointing that out @caliq!
  
  From taking a look at that ticket, it looks like the bug that is causing issues with "Ignore whitespace" is also causing some identical objects to show up as different, so @Don_W appears to be running into SC-9595 as well.
  
  We'll let you both know once we have an update on this!

  Jessica R August 24, 2017 15:52

  - 0 +
• 
  Hi all, it looks SC-9595 should actually be resolved as of version 6.0.1.6892. Can you please update if you haven't already and let us know if any issues persist?
  
  Thank you!

  Jessica R October 31, 2017 18:49

  - 0 +

Add comment

Please sign in to leave a comment.