NuoDB Migrator Mappings for DEFAULT Values

The NuoDB Migrator does DEFAULT value translations (where DEFAULT is part of the syntax for, e.g. CREATE TABLE table (column [DEFAULT default_expr], …​)).

MySQL DEFAULT Value Translations

Date translator

MySQL NuoDB

CURRENT_TIMESTAMP, CURRENT_TIMESTAMP(), NOW(), LOCALTIME, LOCALTIME(), LOCALTIMESTAMP, LOCALTIMESTAMP()

NOW

Bit field literal translator http://dev.mysql.com/doc/refman/5.0/en/bit-field-literals.html

MySQL NuoDB

b'1'

TRUE

b'0'

FALSE

MSSQL DEFAULT Value Translations

Date translator

MSSQL NuoDB

GETDATE(), CURRENT_TIMESTAMP, NOW()

NOW

Unicode constant translator http://msdn.microsoft.com/en-us/library/ms179899.aspx Paragraph Unicode strings

MSSQL NuoDB

N'(constant)'

constant

PostgreSQL DEFAULT Value Translations

Date translator

PostgreSQL NuoDB

CURRENT_TIMESTAMP, NOW()

NOW

Casted expressions as default value http://www.postgresql.org/docs/9.2/static/sql-expressions.html #4.29

PostgreSQL NuoDB

expression::[.var]type

expression

Oracle DEFAULT Value Translations

Date translator

Oracle NuoDB

CURRENT_DATE, SYSDATE

NOW

IBM DB2 DEFAULT Value Translations

Date translator

IBM DB2 NuoDB

CURRENT DATE, CURRENT TIME, CURRENT TIMESTAMP

NOW