Unshaped nodes errors in Time Series Analysis in SQL Server

[ismayc]

After re-running all of the SOLUTION code in https://campus-no-cache.datacamp.com/courses/20239/63394?ex=1, I've found the following exercises to have errors about unshaped nodes. I've also linked to the AST viewer for each exercise:

Chapter 2

• Ch2Ex4 - Build dates and times with offsets from parts: AST viewer
• Ch2Ex8 - Parse strings to dates: AST viewer
• Ch2Ex14 - Try out type-safe date functions (Step 1): AST viewer
• Ch2Ex14 - Try out type-safe date functions (Step 2): AST viewer
• Ch2Ex14 - Try out type-safe date functions (Step 3): AST viewer
• Ch2Ex15 - Convert imported data to dates with time zones: AST viewer
• Ch2Ex16 - Test type-safe conversion function performance (Step 1): AST viewer
• Ch2Ex16 - Test type-safe conversion function performance (Step 2): AST viewer
• Ch2Ex16 - Test type-safe conversion function performance (Step 3): AST viewer

Chapter 3

• Ch3Ex7 - Calculating median in SQL Server: AST viewer
• Ch3Ex13 - Generate a summary with ROLLUP: AST viewer
• Ch3Ex14 - View all aggregations with CUBE: AST viewer
• Ch3Ex15 - Generate custom groupings with GROUPING SETS: AST viewer
• Ch3Ex16 - Combine multiple aggregations in one query: AST viewer

Chapter 4

• Ch4Ex9 - Seeing prior and future periods: AST viewer
• Ch4Ex10 - Seeing the prior three periods: AST viewer
• Ch4Ex11 - Calculating days elapsed between incidents: AST viewer

[hermansje]

A recent antlr-tsql update addressed these.

[ismayc]

@hermansje I'm still getting unshaped nodes errors when I try to run the examples above through either of the branches on campus at https://www.datacamp.com/teach/repositories/5004/branches/master. Can you confirm that these are working for you there?

[hermansje]

The AST viewer didn't have the update yet. @BogdanFloris will deploy it.

[ismayc]

@BogdanFloris: Can you please deploy this? We had planned to launch the course this week and this is one of the last things left for the course.

[BogdanFloris]

It is now deployed!