Some Flex2SQL Assumptions

This is common list of assumptions we have for all drivers:

1. Indexed columns are created as NOT NULL and should have a default value assigned to.

2. Tables are created with the table names with uppercase letters in Flex2SQL, ORAFlex and DB2Flex.

3. Partial Overlaps are created as a physical column if it is an indexed column only, otherwise it will be handled logically at run time.

4. Date formats:

• Flex2SQL for Oracle: 01/01/0001 is the default DATE value for the empty date fields.
• Flex2SQL for MS SQL Server: 01/01/1753 is the default DATE value for the empty date fields.
• Flex2SQL for MySQL: 01/01/0001 is the default DATE value for the empty date fields.
• Flex2SQL for PostgreSQL: 01/01/0001 is the default DATE value for the empty date fields.