Bug 6947

Summary: Create index warnings
Product: SQL Reporter: Martin Kersten <mk>
Component: allAssignee: SQL devs <bugs-sql>
Status: NEW ---    
Severity: normal    
Priority: Normal    
Version: -- development   
Hardware: Other   
OS: Mac OS X   

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