[MDEV-28551] Full text query returning NULL generated columns - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Duplicate
Affects Version/s: 10.3.32, 10.6.7
Fix Version/s: 10.3.38, 10.4.28, 10.5.19, 10.6.12, 10.7.8, 10.8.7, 10.9.5, 10.10.3, 10.11.2
Component/s: Full-text Search, Virtual Columns
Labels:
None

Description

When querying a table that has virtual generated columns using full text search, these columns are not generated and are always NULL in the results.

It can be seen here: https://dbfiddle.uk/?rdbms=mariadb_10.6&rdbms2=mysql_8.0&fiddle=524b4b7e77d159f0ce8740b639aaa9fd

Attachments

Issue Links

duplicates

MDEV-29169 Using MATCH returns NULL for Virtual Column

Closed

Activity

People

Assignee:: Nikita Malyavin

Reporter:: Wilson Medeiros dos Santos Neto

Votes:: 1 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2022-05-12 16:18

Updated:: 2022-11-23 16:55

Resolved:: 2022-11-23 16:54

Git Integration

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