[MDEV-26543] Spider: [ERROR] Got error 12701 when reading table './test/t' on SELECT - Jira

XML

Word

Printable

Details

Type: Bug
Status: Stalled (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL)
Fix Version/s: 10.5, 10.6
Component/s: Partitioning, Storage Engine - Spider
Labels:
- affects-tests
- regression

Description

INSTALL PLUGIN spider SONAME 'ha_spider.so';

CREATE TABLE t (c INT KEY,c2 INT,KEY(c2)) ENGINE=SPIDER PARTITION BY LIST COLUMNS (c) (PARTITION p DEFAULT ENGINE=SPIDER);

ALTER TABLE t ADD c2 BINARY FIRST;

SELECT * FROM t WHERE c2='' AND c2='' AND c='' ORDER BY c2 DESC;

Leads to an ERROR visible in the error log only:

10.7.0 1bc82aaf0a7746c0921a94034aff2d51f0d75cd0 (Debug)
2021-09-06 11:19:39 4 [ERROR] Got error 12701 when reading table './test/t'

Furthermore, error 12701 is undefined:

$ ./bin/perror 12701

Illegal error code: 12701

Bug confirmed present in:
MariaDB: 10.4.22 (dbg), 10.4.22 (opt), 10.5.13 (dbg), 10.5.13 (opt), 10.6.5 (dbg), 10.6.5 (opt), 10.7.0 (dbg), 10.7.0 (opt)

Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.2.41 (dbg), 10.2.41 (opt), 10.3.32 (dbg), 10.3.32 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.35 (dbg), 5.7.35 (opt), 8.0.26 (dbg), 8.0.26 (opt)

Attachments

Issue Links

relates to

MDEV-30576 Include spider error codes in extra/perror, especially 12719, 12701

Open

MDEV-29455 mysql_ha_read attempts table read after 'Access denied' for server created by CREATE SERVER | Got error 12701 when reading table

Open

Activity

People

Assignee:: Yuchen Pei

Reporter:: Roel Van de Paar

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2021-09-06 01:24

Updated:: 2024-09-10 14:57

Git Integration

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