Early Bird Registration for DrupalCon Portland 2024 is open! Register by 23:59 PST on 31 March 2024, to get $100 off your ticket.
webform_update_7419() introduced an index on the webform_submission table's data column in order to speed up unique validation. The data column is of type 'text'. MS SQL both can't create a length-limited index and can't index a text column.
The solution is simply to not create this index for MS SQL Server. This patch both bypasses adding the index int he update function and defers creation of the index from hook_schema to hook_install (where the database driver can be checked).
Comment | File | Size | Author |
---|---|---|---|
#2 | webform-index_ms_sql-2457045-1.patch | 1.4 KB | DanChadwick |
Comments
Comment #2
DanChadwick CreditAttribution: DanChadwick commentedCommitted to 7.x-4.x.
Needs porting to 8.x
Comment #3
DanChadwick CreditAttribution: DanChadwick commentedComment #4
DanChadwick CreditAttribution: DanChadwick commentedBTW -- the only part that needs porting is deferring the creation of the index until installation time, after the schema has been built. The portion in the hook_update_7419 does not apply to D8, of course.
Comment #5
fenstratCommitted and pushed to 8.x-4.x. Thanks!