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

Replacing a view by a query on the view itself crashes the server. #7241

Closed
mvdvm opened this issue Feb 4, 2022 · 0 comments
Closed

Replacing a view by a query on the view itself crashes the server. #7241

mvdvm opened this issue Feb 4, 2022 · 0 comments
Labels
bug SQL
Milestone

Comments

@mvdvm
Copy link
Contributor

@mvdvm mvdvm commented Feb 4, 2022

Describe the bug
Replacing a view by a query on the view itself crashes the server.

To Reproduce
CREATE TABLE IF NOT EXISTS t7240 (val INTEGER);
INSERT INTO t7240(val) VALUES (1), (2), (3);
SELECT * FROM t7240;
CREATE OR REPLACE VIEW v7240 AS (SELECT * FROM t7240);
SELECT * FROM v7240;
-- replace the view now with a query on itself
CREATE OR REPLACE VIEW v7240 AS (SELECT * FROM v7240);
-- now the server is killed
SELECT * FROM v7240;

DROP VIEW v7240;
DROP TABLE t7240;

Expected behavior
No crash of the server.
Expected SQL parser Error msg instead (e.g. cannot replace view t7240 with a query including the view itself)

Software versions

  • MonetDB 5 server v11.43.5 (Jan2022)
  • OS and version: Compiled for amd64-pc-windows-msvc/32bit
  • self-installed
@mvdvm mvdvm added bug SQL labels Feb 4, 2022
@PedroTadim PedroTadim added this to the NEXTRELEASE milestone Feb 4, 2022
monetdb-team pushed a commit that referenced this issue Feb 6, 2022
…ug if we allow views with dependencies to be replaced
@sjoerdmullender sjoerdmullender removed this from the NEXTRELEASE milestone Feb 14, 2022
@sjoerdmullender sjoerdmullender added this to the Jan2022-SP1 milestone Feb 14, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug SQL
Projects
None yet
Development

No branches or pull requests

3 participants