[MDEV-33494] spider plugin init failure with no_zero_date sql_mode - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.5(EOL), 10.6, 11.4
Fix Version/s: 10.5.25, 10.6.18, 10.11.8, 11.0.6, 11.2.4, 11.1.5
Component/s: Storage Engine - Spider
Labels:
- affects-tests

Description

Splitted from a case from Roel's comment in ~~MDEV-33242~~[1], reproducible in 10.5 and 10.6 53c6c823dc7cafefffdc93c79661cfb146ff8641

set global sql_mode=(SELECT CONCAT (@@sql_mode,',no_zero_date'));

install soname 'ha_spider';

[1] https://jira.mariadb.org/browse/MDEV-33242?focusedCommentId=280426&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-280426

Attachments

Issue Links

relates to

MDEV-32753 Spider engine does not load in ORACLE mode

Closed

MDEV-33706 backport some spider fixes to 10.4 which was unlocked

Closed

split from

MDEV-33242 SPIDER plugin initialization failed at 'create table if not exists mysql.spider_tables ... with 'Specified key was too long; max key length is 1000 bytes', Warning: Memory not freed: 10720

Closed

split to

MDEV-33584 sql plugin init failure with traditional sql_mode

Closed

Activity

People

Assignee:: Yuchen Pei

Reporter:: Yuchen Pei

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2024-02-20 00:19

Updated:: 2024-03-27 00:35

Resolved:: 2024-03-04 01:15

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

4.95h

Git Integration

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