# The default max_cursor_count and max_statement_count settings of 50 are too
# low to run this test.
+#
+# Setting them to zero is preferred.
my $dbd_sqlanywhere_dsn = $ENV{DBICTEST_SYBASE_ASA_DSN} || '';
my $dbd_sqlanywhere_user = $ENV{DBICTEST_SYBASE_ASA_USER} || '';
my $tester = dbixcsl_common_tests->new(
vendor => 'SQLAnywhere',
auto_inc_pk => 'INTEGER IDENTITY NOT NULL PRIMARY KEY',
- default_function => 'current timestamp',
connect_info => [ ($dbd_sqlanywhere_dsn ? {
dsn => $dbd_sqlanywhere_dsn,
user => $dbd_sqlanywhere_user,
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' },
- '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: