PR#4595 - Added Keyboard shortcuts to query menu options: There is a menu next to the Run query button on projects and the ability to view keyboard shortcuts is a new option on it:
 |
PR#4646 - Rearrange the sidebar for projects: The left sidebar of the project workspace has been rearranged with a new link for Home on the top. The items in Documents (Project summary and Data dictionary) were moved up under Home, and the Documents header was removed.
Updates & fixes:
PR#5488 - Modified data.world SQL syntax to disallow joins without an ON or USING clause without the keyword NATURAL: The only SQL queries with a JOIN clause that can be written without specifying the column on which the tables are joined (JOIN ON or JOIN USING) are specified NATURAl joins. See the article on JOINS in our SQL tutorial for more information.
SELECT * FROM Table_1 NATURAL JOIN Table_2
PR#5620 - Changed rounding of SQL CAST AS INTEGER function for negative decimals : Up to now in dwSQL negative decimals were rounded towards negative infinity. No, in line with most programming languages, the decimal portion is dropped. Previously CAST(-1.2 AS INTEGER) would return -2. Now it returns -1. For more information on how to use the CAST function see the CAST article in our SQL tutorial.
PR#4616 - New success state for Save query to dataset/project: When saving a query to a dataset or project there is a new confirmation message with the name of the table and the name of the dataset or project it was saved to:
 |
Find out all about saving results from queries to a dataset or project in the article Why "Save to dataset or project" is important and how to use it.
-------------------------------------------------------------------------------------------------------------------------