Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

adding a view to a merge table gives unexpected behaviour #6685

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

adding a view to a merge table gives unexpected behaviour #6685

monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
bug Something isn't working normal SQL

Comments

@monetdb-team
Copy link

Date: 2019-02-22 10:00:07 +0100
From: @aris-koning
To: SQL devs <>
Version: 11.31.13 (Aug2018-SP2)
CC: @PedroTadim

Last updated: 2019-04-30 12:36:00 +0200

Comment 26902

Date: 2019-02-22 10:00:07 +0100
From: @aris-koning

User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:65.0) Gecko/20100101 Firefox/65.0
Build Identifier:

There is no clear specification that allows or disallows views to be added to a merge table. This can lead to weird behaviour. See the reproduction steps.

Reproducible: Always

Steps to Reproduce:

1.create table foo (val int);
2.insert into foo values (1), (2), (3);
3.create view foo_view as select * from foo;
4.create merge table foo_merge_table (val int);
5.alter table foo_merge_table add table foo_view;
6.select * from foo_merge_table;

Actual Results:

operation successful
3 affected rows
operation successful
operation successful
operation successful
+-----+
| val |
+=====+
+-----+
0 tuples

Expected Results:

Either everything finishes succesfully and the final query returns all results in the view
or
an error message after submitting the alter table statement.

I am not sure what other merge table implementations handle alter table add view attempts.

Comment 26907

Date: 2019-02-27 11:28:21 +0100
From: MonetDB Mercurial Repository <>

Changeset ab619c893147 made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=ab619c893147

Changeset description:

Cannot add a view into a merge/remote/replica table. This fixes bug #6685.

Comment 26908

Date: 2019-02-27 11:30:02 +0100
From: @PedroTadim

We don't allow views to be added into merge/remote/replica tables.

Comment 26909

Date: 2019-02-27 11:53:01 +0100
From: @aris-koning

Changeset looks good to me.

@monetdb-team monetdb-team added bug Something isn't working normal SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Feb 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working normal SQL
Projects
None yet
Development

No branches or pull requests

2 participants