[MCOL-1476] Error with a complex view - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 1.1.4
Fix Version/s: 5.5.1
Component/s: MariaDB Server
Labels:
None
Environment:
vmware with two frontend modules and three performance modules with gluster fs.

Description

Hi,
I try execute this view:
select * from v_get_anomalia_msg_vlt_bot;
/* Errore SQL (1815): Internal error: IDB-1000: 'v_get_anomalia_msg_vlt_bot' and 'p' are not joined. */
Why this error?
p is a derived table inside a sql view.
I've upload the query of the view.

Thanks
Best regards
Nicola Battista

Attachments

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

export_c6msg_cstore.sql
10 kB
2018-06-18 06:12
v_get_anomalia_msg_vlt_bot.sql
3 kB
2018-06-15 08:24

Activity

People

Assignee:: Roman

Reporter:: Nicola

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2018-06-15 08:25

Updated:: 2021-02-20 20:23

Resolved:: 2021-02-20 20:23

Git Integration

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