2023
Details about the releases of Snowflake SnowConvert during 2023.
SQL Core 27.1.20 December 19th
SQL Server
Transformation for Top Level Statements outside routines
Irrelevant keyword TEXTIMAGE_ON commented out
Oracle
Fixes on calling built-in Tables and Views that require a schema name to run.
Teradata
Support DAYOFMONTH function
SQL Core 27.1.11 December 12th
SQL Server
Fix CREATE FUNCTION body not generated exception
Fix function ISDATE_UDF returning not expected value
Mark sp_addextendedproperty with the EWI MSCEWI4075
Fix spaces inconsistencies in the output code
Oracle
Support FIRST_VALUE and LAST_VALUE as an alias name
SQL Core 27.0.11 December 5th
Common
Fix performance issue with nested queries.
Modify UDF helpers to follow the standard name.
SQL Server
Fix create table calculated fields automatically generated as variant.
Fix quotes to PIVOT operation values.
Fix generated function QUOTENAME_UDF structure with Syntax error.
Fix mappping XML data type to VARIANT instead of TEXT.
Teradata
Fix exception thrown on for loops.
Oracle
Fix parsing error when using atomic as identifier.
SQL Core 26.0.4 November 28nd
Common
Fix parentheses not being added to converted non-parameterized built-in functions.
SQL Server
Support parsing of batches of statements separated by the GO command.
Support parsing of the DELAY keyword as an identifier.
Teradata
Fix parsing of the JSON_KEYS table operator.
Oracle
Support DEFAULT clause with string value converted to numeric value when the column data type is also numeric.
Fix critical exception when calling RAISE_APPLICATION_ERROR.
Fix MSCCP0004 not being added for dynamic queries inside an anonymous block.
SQL Core 23.0.6 November 22nd
Teradata
Fix CAST to date with the format specified first not converted correctly
Fix parsing errors related to data type attributes and range
Oracle
Support for anonymous blocks
SQL Core 22.5.27 November 15th
Common
Optimize the conversion time
SQL Server
Convert NCHAR data type to NCHAR data type instead of CHAR
Remove closing separator in column definition
Support ALTER PROCEDURE statement
Teradata
Fix the conversion of CAST inside TRIM and CAST AS TIMESTAMP ignoring the precision
Fix inconsistencies in the report's Issues Breakdown section
Oracle
Fix the critical error when it is converting the RAISE_APPLICATION_ERROR statement
SQL Core 22.5.10 November 8th
SQL Server
Fix the total number of parsing errors difference between Identified Objects and EWI1001
Teradata
Fix the Symbol table not solving correctly the types when casting
Fix MSCEWI1095 disappearance when the --renamingFile flag was being used in Linux
Fix UseCharactersConversionRate and UseLinesOfCodeConversionRate reporting always OFF
Fix CREATE TABLE with a duplicated UNIQUE INDEX clause
Fix Comparison Operator NE not migrated to <> Operator
Oracle
New Support for SQL%ROWCOUNT
Fix FORALL With UPDATE Statements in ambiguous column
Fix parsing of Period Definition
Fix the MSCEWI3118 was being removed from column alias
Fix parsing errors not being assigned to the CREATE TABLE node
Fix migration with arrange causing empty output directories
Fix Conversion rate not 100% with low-level EWIs in Tables
SQL Core 22.4.17 November 1st
Common
Add EWI to queries with missing dependent objects
Include Calling_Object_Type for query references
SQL Server
Fix parsing error in nested comments
Teradata
Fix default ordering direction in RANK() function conversion
Oracle
Support transformation of Raise_Application_Error
Support transformation of JSON_VALUE function
Support parsing of anonymous blocks
Support parsing of GENERATE AS IDENTITY column option
Fix multiple parsing errors in sample workloads
SQL Core 22.4.2 October 25th
Common
Optimize local symbols resolution for query scope
Improve friendly name for MSCEWI1050 and docx report
SQL Server
Parse NEXT VALUE FOR expression
Fix NLiteral Expressions wrong concatenation
Fix preprocessing bugs related to temporal table and merge into table with columns
Teradata
Fix wrong NAMED phrase conversion.
Oracle
Parse MOVE as an identifier
Optimize Common Table Expression transformation
SQL Core 22.3.4 October 18th
Teradata
Transformation for output parameters with dynamic result sets.
Fix CAST delimiting inside boolean operations.
Fix Parsing Error in CAST of FORMAT DATE.
Commenting the statement HELP STATISTICS.
Oracle
Fix error caused by Keyword enumeration being out of sync.
Fix table properties not showing up as an EWI.
Remove MSCINF0003 present in SqlIndexLocConversionRate.
Transformation for Flashback Query.
Add MSCEWI1050 to nested objects.
SQL Server
Fix parsing error when alias is NVARCHAR.
Exception caused when inserting in temporal table inside a function.
Fix JOIN not being added when converting DELETE statement.
Parse Alter DATABASE.
SQL Core 22.2.137 October 11th
Teradata
SnowConvert banker's rounding removed as PrPr in reports for Snowflake.
Fix count of data type attributes inside procedures.
Improve parsing of TPT's APPLY statement to avoid exceptions.
Oracle
Fix parsing causing stack overflow related to the UNION ALL operator.
SQL Core 22.2.116 October 4th
SQL Server
Parse CREATE USER for users based on logins in master syntax
Parse and comment ALTER LOGIN
Teradata
Support for WHERE conditions in IMPORT APPLY for MLOAD scripts
Oracle
When Triggers are not presented in the source code, the Assessment.docx reports “-” instead of “0%”
Fix file not generated when the procedure has a Cursor declaration with a pseudotype
Improve parsing error not being displayed inside functions that are part of packages
SQL Core 22.2.90 September 27th
Common
Fix complex pattern Issue showing for subqueries related to EXISTS/ NOT EXISTS, SOME
Fix complex pattern Issue