dbDelta() ignores changes to column nullability (NULL/NOT NULL)

[matt_fw]

dbDelta() ignores changes to the nullability of columns.

Test case:

<?php
$create = "CREATE TABLE dbdelta_bug_test  (
  id int(11) NOT NULL,
  value int(11) NOT NULL,
  PRIMARY KEY  (id)
);";
$update = "CREATE TABLE dbdelta_bug_test  (
  id int(11) NOT NULL,
  value int(11) NULL,
  PRIMARY KEY  (id)
);";

global $wpdb;
$wpdb->query("DROP TABLE dbdelta_bug_test");
$wpdb->query($create);

require_once ABSPATH . 'wp-admin/includes/upgrade.php';
dbDelta($update);

Expected result:
Column value is nullable.

Actual result:
dbDelta() doesn't detect any changes to the table.

[costdev]

Hi @matt_fw , thanks for opening this ticket.

I'm just going through tickets and making sure they have the right Version property. As Version refers to the WordPress version that introduced the issue, rather than the version that the site is using, can you confirm whether this issue only appeared in 6.0.2, or if it exists in earlier versions?

Thanks!

[matt_fw]

Replying to costdev:

Hi @matt_fw , thanks for opening this ticket.

I'm just going through tickets and making sure they have the right Version property. As Version refers to the WordPress version that introduced the issue, rather than the version that the site is using, can you confirm whether this issue only appeared in 6.0.2, or if it exists in earlier versions?

Thanks!

Indeed, I selected the WP version witch which I tested the code. My bad, sorry. I suspect the bug was always there. Which version should I select? I don't have an option to change it to 'unknown' or 'none'.