[MCOL-1476] Error with a complex view Created: 2018-06-15  Updated: 2021-02-20  Resolved: 2021-02-20

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.1.4
Fix Version/s: 5.5.1

Type: Bug Priority: Major
Reporter: Nicola Assignee: Roman
Resolution: Fixed Votes: 0
Labels: None
Environment:

vmware with two frontend modules and three performance modules with gluster fs.

Attachments: File export_c6msg_cstore.sql     File v_get_anomalia_msg_vlt_bot.sql    

 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

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-06-15 ]

Can you please provide some schemas for the underlying tables so we can test this and see what is going on?

Comment by Nicola [ 2018-06-18 ]

Hi,
I've upload the export schemas for reproducing the error.

export_c6msg_cstore.sql
Thanks,
Regards.
Nicola Battista

Comment by Nicola [ 2018-06-26 ]

Hi,
Are there news?

Thanks,
Regards.
Nicola Battista

Comment by Andrew Hutchings (Inactive) [ 2018-06-26 ]

I have reproduced this, it isn't related to it being inside a view. We are not sure why yet but I will try to find out during the 1.1.6 cycle.

Comment by Nicola [ 2018-07-25 ]

Hi,
Are there news?

Thanks,
Regards.
Nicola Battista

Generated at Thu Feb 08 02:29:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.