Date: 2014-04-04 17:41:26 +0200
From: Martin van Dinther <<martin.van.dinther>>
To: SQL devs <>
Version: -- development

Last updated: 2017-07-17 16:07:20 +0200

Comment 19730

Date: 2014-04-04 17:41:26 +0200
From: Martin van Dinther <<martin.van.dinther>>

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

An ORDER BY clause in the creation of a VIEW is currently not supported.
It is very desirable to have this supported, as it allows you to predefine the ordering per view. This allows it to be used for meaningful (ordered) reporting.

Reproducible: Always

Steps to Reproduce:

CREATE VIEW user_tables AS
SELECT * FROM sys.tables WHERE NOT system AND query IS NULL
ORDER BY name;

Actual Results:

Error: CREATE VIEW: ORDER BY not supported
SQLState: 42000

Expected Results:

The view to be created and the ordering applied during querying.

Comment 25079

Date: 2017-03-02 15:00:55 +0100
From: MonetDB Mercurial Repository <>

Changeset 2bac5d524bcb made by Martin van Dinther martin.van.dinther@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=2bac5d524bcb

Changeset description:

Remove the restriction to use an ORDER BY clause in a CREATE VIEW statement.
Added tests to prove this works correctly.
This implements request: bug #3465