Bug 6947 - Create index warnings
Summary: Create index warnings
Status: NEW
Alias: None
Product: SQL
Classification: Unclassified
Component: all (show other bugs)
Version: -- development
Hardware: Other Mac OS X
: Normal normal
Assignee: SQL devs
Depends on:
Reported: 2020-08-13 12:42 CEST by Martin Kersten
Modified: 2020-08-13 12:42 CEST (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Martin Kersten cwiconfidential 2020-08-13 12:42:40 CEST
User-Agent:       Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:78.0) Gecko/20100101 Firefox/78.0
Build Identifier: 

If the user types "CREATE INDEX my ON tbl(x)" nothing will happen, because this instruction is considered by the system as a no-op. A warning should be issued instead of staying silent.

Likewise, a warning should be given if you create an ordered index, because it will disappear upon update.

Reproducible: Always