password => $odbc_password,
} : ()),
],
+ loader_options => { preserve_case => 1 },
data_types => {
# http://infocenter.sybase.com/help/topic/com.sybase.help.sqlanywhere.11.0.1/dbreference_en11/rf-datatypes.html
#
'int' => { data_type => 'integer' },
'integer' => { data_type => 'integer' },
'bigint' => { data_type => 'bigint' },
- 'float' => { data_type => 'float' },
- 'real' => { data_type => 'float' },
+ 'float' => { data_type => 'real' },
+ 'real' => { data_type => 'real' },
'double' => { data_type => 'double precision' },
'double precision' =>
{ data_type => 'double precision' },
- 'float(2)' => { data_type => 'float' },
- 'float(24)' => { data_type => 'float' },
+ 'float(2)' => { data_type => 'real' },
+ 'float(24)' => { data_type => 'real' },
'float(25)' => { data_type => 'double precision' },
'float(53)' => { data_type => 'double precision' },
'smalldatetime'
=> { data_type => 'smalldatetime' },
'timestamp' => { data_type => 'timestamp' },
- # rewrite 'current timestamp' as 'CURRENT_TIMESTAMP'
- 'timestamp DEFAULT current timestamp'
- => { data_type => 'timestamp', default_value => \"CURRENT_TIMESTAMP" },
+ # rewrite 'current timestamp' as 'current_timestamp'
+ 'timestamp default current timestamp'
+ => { data_type => 'timestamp', default_value => \'current_timestamp',
+ original => { default_value => \'current timestamp' } },
'time' => { data_type => 'time' },
# String Types
else {
$tester->run_tests();
}
+# vim:et sts=4 sw=4 tw=0: