[MDEV-9516] type error when setting session variable - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.1.9, 10.1(EOL)
Fix Version/s: 10.1.13
Component/s: Admin statements
Labels:
- regression
Environment:
XAMPP bundle on Windows 8.1

Sprint:
10.1.13

Description

The following query fails:

SET SESSION wait_timeout = GREATEST(28000, @@wait_timeout)

Error:
#1232 - Incorrect argument type to variable 'wait_timeout`

There should be no type conversion issue as those queries work:

SET SESSION wait_timeout = 28000;
SET SESSION wait_timeout = @@wait_timeout;
SELECT GREATEST(28000, @@wait_timeout);

please see this SO question for detail:
http://stackoverflow.com/questions/35187378/mariadb-type-error-when-setting-session-variable

Attachments

Activity

People

Assignee:: Alexander Barkov

Reporter:: Moritz Vondano

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2016-02-03 23:36

Updated:: 2016-03-28 21:28

Resolved:: 2016-03-21 20:10

Git Integration

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