[MDEV-25116] Spider: IF(COUNT( trigger SQL Error (1054)_ Unknown column '' in field list - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.3.29, 10.4.17, 10.5.8, 10.6.3
Fix Version/s: 10.3.35, 10.4.25, 10.5.16, 10.6.8, 10.7.4, 10.8.3
Component/s: Storage Engine - Spider
Labels:
- not-10.2

Description

Hio,

works with 10.4.13, somewhere between 10.4.14 and 10.4.17 broken.

Testcase to reproduce

USE spider;

DROP TABLE if EXISTS `t1`;

DROP TABLE if EXISTS `t1remote`;

CREATE TABLE `t1` (

	id INT)

CREATE TABLE `t1remote` (

	id INT)

 ENGINE=SPIDER DEFAULT CHARSET=utf8 COMMENT='host "127.0.0.1",  database "spider" ,table "t1" ,user "spider", password "xxxxxxx", port "3307"';

SELECT IF(COUNT(a.`id` )>=0,'Y','N') FROM t1remote a;

Attachments

Issue Links

causes

MDEV-30391 Server crash in spider_set_direct_limit_offset upon 2nd execution of PS

Stalled

Activity

Ascending order - Click to sort in descending order

Richard Stracke created issue - 2021-03-11 10:51

Elena Stepanova made changes - 2021-03-22 00:14

Field	Original Value	New Value
Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Assignee		Kentoku Shiba [ kentoku ]

Elena Stepanova made changes - 2021-03-22 00:14

Status

Open [ 1 ]

Confirmed [ 10101 ]

Julien Fritsch made changes - 2021-07-01 06:06

Assignee

Kentoku Shiba [ kentoku ]

Nayuta Yanagisawa [ JIRAUSER47117 ]

Nayuta Yanagisawa (Inactive) made changes - 2021-08-03 10:54

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Nayuta Yanagisawa (Inactive) made changes - 2021-08-03 11:15

Affects Version/s

10.3.29 [ 25206 ]

Nayuta Yanagisawa (Inactive) made changes - 2021-08-03 11:15

Fix Version/s

10.3 [ 22126 ]

Nayuta Yanagisawa (Inactive) made changes - 2021-08-03 11:27

Labels

not-10.2

Nayuta Yanagisawa (Inactive) made changes - 2021-08-03 11:35

Affects Version/s

10.6.3 [ 25904 ]

Nayuta Yanagisawa (Inactive) made changes - 2021-08-03 11:35

Fix Version/s

10.6 [ 24028 ]

Nayuta Yanagisawa (Inactive) made changes - 2021-08-07 07:58

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Nayuta Yanagisawa (Inactive) made changes - 2021-08-23 08:59

Priority

Major [ 3 ]

Critical [ 2 ]

Sergei Golubchik made changes - 2021-08-23 09:36

Priority

Critical [ 2 ]

Major [ 3 ]

Julien Fritsch made changes - 2021-08-23 10:36

Priority

Major [ 3 ]

Critical [ 2 ]

Sergei Golubchik made changes - 2021-08-23 16:23

Priority

Critical [ 2 ]

Major [ 3 ]

Julien Fritsch made changes - 2021-11-02 17:40

Priority

Major [ 3 ]

Critical [ 2 ]

Sergei Golubchik made changes - 2021-12-06 21:35

Workflow

MariaDB v3 [ 120016 ]

MariaDB v4 [ 143682 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-15 14:37

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-16 03:28

Summary

spider: IF(COUNT( trigger SQL Error (1054)_ Unknown column '' in field list

Spider: IF(COUNT( trigger SQL Error (1054)_ Unknown column '' in field list

Nayuta Yanagisawa (Inactive) made changes - 2022-02-17 09:17

Assignee	Nayuta Yanagisawa [ JIRAUSER47117 ]	Alexey Botchkov [ holyfoot ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-17 09:28

Assignee

Alexey Botchkov [ holyfoot ]

Nayuta Yanagisawa [ JIRAUSER47117 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-17 09:28

Status

In Review [ 10002 ]

Stalled [ 10000 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-17 09:28

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-17 09:35

Assignee	Nayuta Yanagisawa [ JIRAUSER47117 ]	Alexey Botchkov [ holyfoot ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-19 15:14

Assignee

Alexey Botchkov [ holyfoot ]

Nayuta Yanagisawa [ JIRAUSER47117 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-19 15:14

Status

In Review [ 10002 ]

Stalled [ 10000 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-19 15:14

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-21 05:39

Status

In Progress [ 3 ]

In Review [ 10002 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-21 06:03

Status

In Review [ 10002 ]

Stalled [ 10000 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-21 06:03

Assignee	Nayuta Yanagisawa [ JIRAUSER47117 ]	Alexey Botchkov [ holyfoot ]
Status	Stalled [ 10000 ]	In Review [ 10002 ]

Alexey Botchkov made changes - 2022-04-07 10:31

Assignee	Alexey Botchkov [ holyfoot ]	Nayuta Yanagisawa [ JIRAUSER47117 ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-04-08 07:36

Fix Version/s		10.3.35 [ 27512 ]
Fix Version/s		10.4.25 [ 27510 ]
Fix Version/s		10.5.16 [ 27508 ]
Fix Version/s		10.6.8 [ 27506 ]
Fix Version/s		10.7.4 [ 27504 ]
Fix Version/s		10.8.3 [ 27502 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Yuchen Pei made changes - 2023-09-26 02:53

Link

This issue causes MDEV-30391 [ MDEV-30391 ]

Jira Automation (IT) made changes - 2024-07-04 02:24

Zendesk Related Tickets

194120

People

Assignee:: Nayuta Yanagisawa (Inactive)

Reporter:: Richard Stracke

Votes:: 0 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2021-03-11 10:51

Updated:: 2024-07-07 21:18

Resolved:: 2022-04-08 07:36

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration