Bug 3400 - Support Backticks in SQL queries and redundant size restrictions in DDL statements
Summary: Support Backticks in SQL queries and redundant size restrictions in DDL state...
Status: NEW
Alias: None
Product: SQL
Classification: Unclassified
Component: all (show other bugs)
Version: -- development
Hardware: All All
: Normal enhancement
Assignee: SQL devs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-11-26 10:40 CET by Hannes Muehleisen
Modified: 2016-04-11 11:45 CEST (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
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