#82202Database Analyzer does not work on MSSQL
Description
The Database Analyzer does not work on MSSQL because of various errors. It fails adding fields and in comparing state.
Extract:
Database update failed Error: SQLSTATE [42000, 4901]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied the table must be empty to allow addition of this column. Column 'actiontype' cannot be added to non-empty table 'sys_history' because it does not satisfy these conditions. Database update failed Error: SQLSTATE [42000, 1752]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Column 'actiontype' in table 'sys_history' is invalid for creating a default constraint. SQLSTATE [42000, 1750]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Could not create constraint or index. See previous errors. Database update failed Error: SQLSTATE [42000, 4901]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied the table must be empty to allow addition of this column. Column 'usertype' cannot be added to non-empty table 'sys_history' because it does not satisfy these conditions. Database update failed Error: SQLSTATE [42000, 1752]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Column 'usertype' in table 'sys_history' is invalid for creating a default constraint. SQLSTATE [42000, 1750]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Could not create constraint or index. See previous errors. Database update failed Error: SQLSTATE [42000, 4901]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied the table must be empty to allow addition of this column. Column 'filelink_sorting_direction' cannot be added to non-empty table 'tt_content' because it does not satisfy these conditions. Database update failed Error: SQLSTATE [42000, 1752]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Column 'filelink_sorting_direction' in table 'tt_content' is invalid for creating a default constraint. SQLSTATE [42000, 1750]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Could not create constraint or index. See previous errors.
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.