[MDEV-40834] [ERROR] Got error 131 when reading table './test/t' upon SELECT ... IN ... DuckDB table - Jira

XML

Word

Printable

Details

Type: Bug
Status: Confirmed (View Workflow)
Priority: Critical
Resolution: Unresolved
Affects Version/s: 11.4, 11.8, 12.3, 13.0, 13.1
Fix Version/s: 11.4, 11.8, 12.3
Component/s: Storage Engine - DuckDB
Labels:
- affects-tests
- subquery

Bug Category:
Can result in unexpected behaviour

Description

INSTALL SONAME 'ha_duckdb';

CREATE TABLE t (c INT KEY) ENGINE=DuckDB;

SELECT 'a' IN (SELECT * FROM t);

Leads to:

CS 13.1.0 da18481158c81ca94689702073c3e04aad85a6a3 (Debug, Clang 22.1.8-20260622) Build 18/08/2026
13.1.0-dbg>CREATE TABLE t (c INT KEY) ENGINE=DuckDB;
Query OK, 0 rows affected (0.038 sec)

13.1.0-dbg>SELECT 'a' IN (SELECT * FROM t);
ERROR 1031 (HY000): Storage engine DUCKDB of the table `test`.`t` doesn't have this option

However the error log shows:

CS 13.1.0 da18481158c81ca94689702073c3e04aad85a6a3 (Debug, Clang 22.1.8-20260622) Build 18/08/2026
[ERROR] Got error 131 when reading table './test/t'

Which is undescriptive and thus confusing for users. It however matches:

$ ./bin/perror 131

OS error code 131:  State not recoverable

MariaDB error code 131: Command not supported by the engine

And as such 'minor' prio.

Bug Detection Matrix
Rel o/d Build Commit UniqueID observed
CS 10.11 dbg 180826 8f00e6caca633c783140db86d3a48a96de67cf38 No bug found
CS 10.11 opt 180826 8f00e6caca633c783140db86d3a48a96de67cf38 No bug found
CS 11.4 dbg 180826 1a052f27e374fc9b4cb5b1fd098cf10f0e1381cc GOT_ERROR\|Got error 131\|when reading table X
CS 11.4 opt 180826 1a052f27e374fc9b4cb5b1fd098cf10f0e1381cc GOT_ERROR\|Got error 131\|when reading table X
CS 11.8 dbg 180826 d26f9ab217a7fcf9d4eccc62c01020ff275ff42e GOT_ERROR\|Got error 131\|when reading table X
CS 11.8 opt 180826 d26f9ab217a7fcf9d4eccc62c01020ff275ff42e GOT_ERROR\|Got error 131\|when reading table X
CS 12.3 dbg 180826 add63991988734383c5e942de2a19c6c45f511f7 GOT_ERROR\|Got error 131\|when reading table X
CS 12.3 opt 180826 add63991988734383c5e942de2a19c6c45f511f7 GOT_ERROR\|Got error 131\|when reading table X
CS 13.0 dbg 180826 a848493c6fe031f23606144420c1ca1e467cbd81 GOT_ERROR\|Got error 131\|when reading table X
CS 13.0 opt 180826 a848493c6fe031f23606144420c1ca1e467cbd81 GOT_ERROR\|Got error 131\|when reading table X
CS 13.1 dbg 180826 da18481158c81ca94689702073c3e04aad85a6a3 GOT_ERROR\|Got error 131\|when reading table X
CS 13.1 opt 180826 da18481158c81ca94689702073c3e04aad85a6a3 GOT_ERROR\|Got error 131\|when reading table X
ES 10.6 dbg 180826 fcecb2620f25965723d640decede7c018bcb1dcc No bug found
ES 10.6 opt 180826 fcecb2620f25965723d640decede7c018bcb1dcc No bug found
ES 11.4 dbg 180826 3b34189bfe675c18c4ced3ef531d016ea74c76f4 No bug found
ES 11.4 opt 180826 3b34189bfe675c18c4ced3ef531d016ea74c76f4 No bug found
ES 11.8 dbg 180826 4694e931d10fecf733c34f83ea2146d31b708eb3 No bug found
ES 11.8 opt 180826 4694e931d10fecf733c34f83ea2146d31b708eb3 No bug found
ES 12.3 dbg 180826 f513f503feacabfb219d4a6f965b5f72b86d4db0 No bug found
ES 12.3 opt 180826 f513f503feacabfb219d4a6f965b5f72b86d4db0 No bug found
MS 5.5 dbg 070123 bac287c315b1792e7ae33f91add6a60292f9bae8 No bug found
MS 5.5 opt 070123 bac287c315b1792e7ae33f91add6a60292f9bae8 No bug found
MS 5.6 dbg 070123 dab95781a1244104d6b87020ac2fc4d190ba2946 No bug found
MS 5.6 opt 070123 dab95781a1244104d6b87020ac2fc4d190ba2946 No bug found
MS 5.7 dbg 070525 f7680e98b6bbe3500399fbad465d08a6b75d7a5c No bug found
MS 5.7 opt 070525 f7680e98b6bbe3500399fbad465d08a6b75d7a5c No bug found
MS 8.0 dbg 060224 49ef33f7edadef3ae04665e73d1babd40179a4f1 No bug found
MS 8.0 opt 060224 49ef33f7edadef3ae04665e73d1babd40179a4f1 No bug found
MS 9.1 dbg 211024 61a3a1d8ef15512396b4c2af46e922a19bf2b174 No bug found
MS 9.1 opt 211024 61a3a1d8ef15512396b4c2af46e922a19bf2b174 No bug found

Attachments

Issue Links

blocks

MDEV-40015 Transition DuckDB engine to gamma

Open

relates to

MDEV-40846 default_storage_engine=DuckDB allows ENGINE=MyISAM/InnoDB table constructs to be honored whereas they should not be

In Progress

Activity

People

Assignee:: Roman

Reporter:: Roel Van de Paar

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2026-08-19 08:35

Updated:: 5 days ago 10:12

Time Tracking

Estimated:

Remaining:

Logged:

50m

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.