Bug 3400

Summary: Support Backticks in SQL queries and redundant size restrictions in DDL statements
Product: SQL Reporter: Hannes Muehleisen <hannes>
Component: allAssignee: SQL devs <bugs-sql>
Status: NEW ---    
Severity: enhancement    
Priority: Normal    
Version: -- development   
Hardware: All   
OS: All   

Description Hannes Muehleisen cwiconfidential 2013-11-26 10:40:43 CET
User-Agent:       Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/32.0.1700.19 Safari/537.36
Build Identifier: 

MySQL uses backticks (`) to escape DB identifiers such as table and column names. Since those are not used yet by MonetDB, it would be possible to also support those.

Also, MySQL supports restricting integer types with a length. These could be rewritten into DECIMAL or NUMERIC.

These changes would make it easier to migrate between MySQL and MonetDB. 

Reproducible: Always