<p dir="auto"><strong>Migrated issue, originally created by Michael Bayer (<a href="https://github.com/zzzeek">@zzzeek</a>)</strong></p>
<p dir="auto">will seek reporting this upstream as this likely breaks the SQL standard:</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="CREATE TABLE ck_cons_test (
    -&gt; b1 INT NULL, 
    -&gt; b2 INT NULL,
    -&gt; CHECK (b1 IN (0, 1)), 
    -&gt; CHECK (b2 IN (0, 1, NULL))
    -&gt; );
Query OK, 0 rows affected (0.03 sec)

MariaDB [test]&gt; INSERT INTO ck_cons_test (b1, b2) VALUES (1, 0);
Query OK, 1 row affected (0.01 sec)

MariaDB [test]&gt; 
MariaDB [test]&gt; INSERT INTO ck_cons_test (b1, b2) VALUES (1, NULL);
ERROR 4025 (23000): CONSTRAINT `CONSTRAINT_2` failed for `test`.`ck_cons_test`
MariaDB [test]&gt; 
MariaDB [test]&gt; INSERT INTO ck_cons_test (b1, b2) VALUES (NULL, 0);
ERROR 4025 (23000): CONSTRAINT `CONSTRAINT_1` failed for `test`.`ck_cons_test`
"><pre class="notranslate"><code class="notranslate">CREATE TABLE ck_cons_test (
    -&gt; b1 INT NULL, 
    -&gt; b2 INT NULL,
    -&gt; CHECK (b1 IN (0, 1)), 
    -&gt; CHECK (b2 IN (0, 1, NULL))
    -&gt; );
Query OK, 0 rows affected (0.03 sec)

MariaDB [test]&gt; INSERT INTO ck_cons_test (b1, b2) VALUES (1, 0);
Query OK, 1 row affected (0.01 sec)

MariaDB [test]&gt; 
MariaDB [test]&gt; INSERT INTO ck_cons_test (b1, b2) VALUES (1, NULL);
ERROR 4025 (23000): CONSTRAINT `CONSTRAINT_2` failed for `test`.`ck_cons_test`
MariaDB [test]&gt; 
MariaDB [test]&gt; INSERT INTO ck_cons_test (b1, b2) VALUES (NULL, 0);
ERROR 4025 (23000): CONSTRAINT `CONSTRAINT_1` failed for `test`.`ck_cons_test`

</code></pre></div>
<p dir="auto"><strong>Migrated issue, originally created by Michael Bayer (<a href="https://github.com/zzzeek">@zzzeek</a>)</strong></p>
<p dir="auto"><a href="https://mariadb.com/kb/en/library/mariadb-1029-changelog/" rel="nofollow">https://mariadb.com/kb/en/library/mariadb-1029-changelog/</a></p>
<p dir="auto">This fixes the CHECK constraint issue <a href="https://jira.mariadb.org/browse/MDEV-13596" rel="nofollow">https://jira.mariadb.org/browse/MDEV-13596</a> that ruins booleans for us, and additionally the DROP issue <a href="https://jira.mariadb.org/browse/MDEV-11114" rel="nofollow">https://jira.mariadb.org/browse/MDEV-11114</a> was fixed as of 10.2.8: <a href="https://mariadb.com/kb/en/library/mariadb-1028-changelog/" rel="nofollow">https://mariadb.com/kb/en/library/mariadb-1028-changelog/</a></p>
<p dir="auto">propose a brief warning if mariadb 10.2[&lt;9] is detected then go forward normally with CI support.  Will need to test if <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="384640259" data-permission-text="Title is private" data-url="https://github.com/sqlalchemy/sqlalchemy/issues/4096" data-hovercard-type="issue" data-hovercard-url="/sqlalchemy/sqlalchemy/issues/4096/hovercard" href="https://github.com/sqlalchemy/sqlalchemy/issues/4096">#4096</a> is still needed.</p>