[MDEV-9447] view queries are not executed and block Maria DB - Jira

XML

Word

Printable

Details

Type: Bug
Status: Confirmed (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.1.10, 5.5, 10.0, 10.1, 10.2.6, 10.3
Fix Version/s: 10.4
Component/s: Optimizer
Labels:
- optimizer
- upstream-fixed
Environment:
Windows 7, Windows Server, Ubuntu 14.04

Sprint:
10.1.12

Description

I have some views, but the queries defined in those views are not executed and the server is blocked. The queries are not optimized yet, but I have tried out with mysql 5.5 and does not work, so that I decided to try out with mysql 5.6 and 5.7 and the queries work normally.

The views defined are:

view_rip_medicamento
vista_rip_consulta

I suppose the another queries have the same problem.

I leave the script with all necessary tables and views

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

db.sql
3.87 MB
2016-01-22 05:57

Activity

People

Assignee:: Unassigned

Reporter:: Alexander Ceballos

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2016-01-22 06:05

Updated:: 2023-04-27 14:26

Git Integration

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