TYPO3 Core

When creating a table a few steps are involved to parse the MySQL table creation definition and rewrite it to be compatible with another DBMS.

First step after parsing gives back an array [parsed_columns.png].

The value ['DEFAULT']['value']⁰ may contain a numeric value. The method compileFieldCfg() returns a definition as

I8 default '0' NOQUOTE

meaning this should be created as a integer with default value '0' (the single quote comes from ['DEFAULT']['value']¹)

and it should be unquoted later on.

When having a string, if the default value is empty, then following definition is returned for instance:

C 255 default "''" NOQUOTE

You have to read it {double-quote}{single-quote}{single-quote}{double-quote}

The default value will get unquoted which result in '' (2x single quote) which is OK.

However when there is a default value which is non-numeric the following definition is returned:

C 255 default 'wwwhomepage' NOQUOTE

which is then unquoted and the actual code sent to the database is something like that:

CREATE TABLE "tx_euldap_server" (
...
"www" VARCHAR DEFAULT wwwhomepage,
...
)

which does not work as anybody may understand. For instance the SQL part of what is shown on [parsed_columns.png] is

CREATE TABLE "tx_euldap_server" (
...
"country" VARCHAR DEFAULT countrycode,
"www" VARCHAR DEFAULT wwwhomepage,
"user" VARCHAR DEFAULT '',
...
)

It is clear that the only valid definition is the last one with an empty default value. My patch removes the NOQUOTE

attribute when default value is not numeric and it results to a valid SQL:

CREATE TABLE "tx_euldap_server" (
...
"country" VARCHAR DEFAULT 'countrycode',
"www" VARCHAR DEFAULT 'wwwhomepage',
"user" VARCHAR DEFAULT '',
...
)

(issue imported from #M11142)