[MDEV-28658] ER_UNKNOWN_ERROR reported due to LIMIT ROWS EXAMINED Created: 2022-05-24  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Information Schema
Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9
Fix Version/s: 10.4, 10.5, 10.6

Type: Bug Priority: Major
Reporter: Marko Mäkelä Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-28613 Query from I_S.INNODB_SYS_INDEXES exc... Closed

 Description   

This is forked from MDEV-28613:

--source include/have_innodb.inc
--error 0,ER_UNKNOWN_ERROR
SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES LIMIT ROWS EXAMINED 5;

The cause of this is two functions in sql/sql_show.cc. It could affect also other information_schema table plugins which return nonzero when schema_table_store_record() returns nonzero. Either that function or get_schema_tables_result() or all functions in between will need to be fixed somehow, for example, the bool error code needs to be changed to int.


Generated at Thu Feb 08 10:02:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.