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).

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

  • DanChadwick committed a0287ca on 7.x-4.x
    Issue #2457045 by david_garcia, DanChadwick: Index on submission data...
DanChadwick’s picture

Committed to 7.x-4.x.

Needs porting to 8.x

DanChadwick’s picture

Version: 7.x-4.x-dev » 8.x-4.x-dev
Status: Fixed » Patch (to be ported)
DanChadwick’s picture

Category: Bug report » Task

BTW -- 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.

fenstrat’s picture

Version: 8.x-4.x-dev » 7.x-4.x-dev
Status: Patch (to be ported) » Fixed

Committed and pushed to 8.x-4.x. Thanks!

  • fenstrat committed 22c16c0 on 8.x-4.x
    Issue #2457045 by david_garcia, DanChadwick: Index on submission data...

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.