Support for SQL Azure Version and escaped tables

Created on 21 March 2024, 8 months ago
Updated 27 March 2024, 8 months ago

Problem/Motivation

Installation of sqlsrv fails due to the minimum version requirement of 13 for SQL Azure support not being met.

Steps to reproduce

NA

Proposed resolution

The issue is that 'Azure SQL' has it's own separate versioning from 'SQL Server'.
Azure SQL v12 is equivalent to SQL Server v19. Azure SQL is always up to date anyway, it's automatically upgraded.
As such I propose the version check is expanded to include both version number and edition. If the Edition is 'SQL Azure' then the code should continue if the edition isn't 'SQL Azure' then do the version check.

There is a provision to support escapedTables which is currently not used. So enabled it. reference below.

$databases['default']['default'] = [
...
  'prefix' => 'prefixname_',
  'escapedTables' => [
    '[table1]' => '[table1]',
    '[table2]' => '[table2]',
  ]
...
]

Remaining tasks

User interface changes

API changes

Data model changes

🐛 Bug report
Status

Needs work

Version

4.4

Component

Code

Created by

🇮🇳India D2ev

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Merge Requests

Comments & Activities

Production build 0.71.5 2024