Bug in MONEY rule replacement

Answers

• MichelD Posts: 8 Bronze 1

  January 22, 2019 4:02PM edited January 23, 2019 8:47AM

  Same with :
  

  DECLARE @Batch_ID SMALLINT,

           @TotalBalance MONEY
  
  Becomes:
  

    DECLARE @Batch_ID SMALLDECIMAL(19, 4)

           @TotalBalance MONEY
  
  SQL Prompt 9.4.7.7595

  1 · Share on Twitter
• tgburgin Posts: 8 New member

  January 22, 2019 4:13PM

  Ah ha, it's just doing the replace on the line above.
  If you test:
  

  DECLARE @Batch_ID SMALLINT, @Test BIGINT,

          @TotalBalance MONEY
  
  It goes to:
  

  DECLARE @Batch_ID SMALDECIMAL(19, 4) @Test BIGINT,

          @TotalBalance MONEY
  
  Replacing the characters directly above the MONEY declaration.

  0 · Share on Twitter
• Alex B Redgate › Posts: 1,157 Diamond 4

  January 23, 2019 2:22PM

  Hi @tgburgin and @MichelD,
  
  This issue originally appeared as SP-7377 where it broke for
  

  DECLARE @m MONEY;<br>--into<br><span>DECDECIMAL(19, 4)@m MONEY;</span>

  That has been corrected but it has either caused this issue or this issue went unnoticed and uncorrected.  I have reopened SP-7377 and referenced the information here and will update you when I have more info!
  
  Kind regards,
  Alex

  Product Support Engineer | Redgate Software
  
  Have you visited our Help Center?

  1 · Share on Twitter
• Alex B Redgate › Posts: 1,157 Diamond 4

  January 24, 2019 11:56AM

  Hi all,
  
  Just an update, the team have let me know they've fixed it for the other cases and it should be available in the next release, I'll post here again when that is available!
  
  Kind regards,
  Alex

  Product Support Engineer | Redgate Software
  
  Have you visited our Help Center?

  1 · Share on Twitter
• tgburgin Posts: 8 New member

  January 24, 2019 12:27PM

  Great news, thanks @Alex B
  

  0 · Share on Twitter
• tgburgin Posts: 8 New member

  January 25, 2019 9:32AM

  @Alex B confirmed as fixed in 9.4.9, thank you!
  

  0 · Share on Twitter