Forum Discussion

chris__1's avatar
chris__1
Icon for Advocate II rankAdvocate II
3 years ago
Solved

Data Warehouse: Bug in ALTER Stored Procedure

Can someone please confirm this behavior:

1.In Fabric create a data warehouse and create a stored procedure that includes at least one table or field name that has the string 'create' in its name. In my case the field name affected by this is 'adf_create_date'.

2. Select to ALTER the stored proc by using the three-dots menu "more options" within the data warehouse:

3. In the Script returned it seems like Fabric did simply do a search and replace in the script for the string 'create' . This does not only change the first word in the proc from 'create' to 'alter' but it also changes all other 'create' strings to 'alter' - completly messing up the script!

 

Thanks!

  • Anonymous's avatar
    Anonymous
    3 years ago

    chris__1 I have created a Bug internally to fix this issue.

     

    Regards

    Geetha

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi @chris__1 This issue is now fixed can you please check and confirm?

     

    Regards

    Geetha

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi chris__1 Thanks for posting your question in Microsoft Fabric Community

    Currently, I am reproducing this issue and will get back to you with more details.

    Regards

    Geetha

  • Anonymous's avatar
    Anonymous
    Not applicable

    chris__1 I have created a Bug internally to fix this issue.

     

    Regards

    Geetha

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi @chris__1 This issue is now fixed can you please check and confirm?

     

    Regards

    Geetha