Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
chris__1
Helper III
Helper III

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:

chris__1_0-1690201015194.png

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!

2 ACCEPTED SOLUTIONS
GeethaT-MSFT
Community Support
Community Support

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

 

Regards

Geetha

View solution in original post

GeethaT-MSFT
Community Support
Community Support

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

 

Regards

Geetha

View solution in original post

4 REPLIES 4
chris__1
Helper III
Helper III

great, yes its fixed!

GeethaT-MSFT
Community Support
Community Support

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

 

Regards

Geetha

GeethaT-MSFT
Community Support
Community Support

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

 

Regards

Geetha

GeethaT-MSFT
Community Support
Community Support

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

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.