dbDelta allow spaces between column names and between lines

[soulseekah]

SQL is hard :( make it accept nicer schema definitions with arbitrary space alignments, blank lines, etc.

[soulseekah]

• 44767-ignore_change_with_space_between_column_and_type.diff

Allows the schema to be written with spaces and tabs between the column name and the type.

`id`   INT,
`name` TEXT,

• 44767-test_ignore_empty_lines_completely.diff

Allows the inclusion of empty lines in the SQL:

`id` INT,
`name` TEXT,

PRIMARY KEY (`id`)

[soulseekah]

Let me know if I should merge them into one.

[netweb]

Related: #36924 dbDelta(): Support more than one whitespace between field name and its type definition

[SergeyBiryukov]

Replying to soulseekah:

Let me know if I should merge them into one.

Yes, please, the patch and the tests should generally be in the same file.

[soulseekah]

2-in-1

[soulseekah]

@SergeyBiryukov these are two different patches one dealing with whitespace, the other newlines, each with tests inside them. They can be applied separately but I attatched both as one changeset.

[desrosj]

This ticket has not received any attention during the 5.2 cycle. With beta 1 tomorrow, going to punt this to 5.3.

[davidbaumwald]

This ticket needs reviewing. With version 5.3 Beta 1 landing in a few hours, I'm moving this to Future Release.