[logback-dev] [JIRA] Created: (LBCLASSIC-266) mssql.sql file has invalid schema
Sumit Khanna (JIRA)
noreply-jira at qos.ch
Thu May 12 15:07:51 CEST 2011
mssql.sql file has invalid schema
Issue Type: Bug
Affects Versions: 0.9.28
Environment: Java 1.6 / Apache Tomcat 6 / SuSE Enterprise / Microsoft SQL Server 2005 - 9.00.4035.00 (x64 Enterprise Edition)
Reporter: Sumit Khanna
Assignee: Logback dev list
In the file logback-0.9.28\logback-classic\src\main\java\ch\qos\logback\classic\db\dialect\mssql.sql, the type of DECIMAL(40) is invalid in SQL Server 2005. I had to change it to 38 to create the table.
I apologize if this is a duplicate. I did a search and couldn't find any relevant bugs, but noticed in the source file the following commnet:
-- The event_id column type was recently changed from INT to DECIMAL(40)
-- without testing.
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://jira.qos.ch/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the logback-dev