In prod we went from 10.8>10.8.1 (After custom fixing that bug) > 10.9. We are now doing our test environment install but are trying to go straight to 10.9 and install fails to create the stats tables due to column length varchar(8192) as 8000 is the limit in MSSQL.
varchar(max) should be used which the hibernate dialect would map to 8000 and not 8192, I'm not sure what changed between 10.8 and 10.9?
One of the table creation failures:
Caused by: org.hibernate.HibernateException: Failed updating schema while executing query [create table xwikistatsreferer (XWR_ID numeric(19,0) not null, XWR_NUMBER int null, XWR_NAME varchar(255) not null, XWR_CLASSNAME varchar(255) null, XWR_REFERER varchar(8192) not null, XWR_PAGE_VIEWS int null, XWR_PERIOD int null, primary key (XWR_ID))]
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The size (8192) given to the column 'XWR_REFERER' exceeds the maximum allowed for any data type (8000).
Curious if a Oracle fresh install has similar issues as I believe it is 4000 there.