Re: [Dbi-interbase-devel] 40alltests.t needs to set dialect 3

[Daniel R. <dan...@gm...>]

this is not a problem in t/40alltypes.t. the dialect is set correct to 3.
the problem is that employee.gdb is a dialect 1 database. 
ib 6 documentation says (GetStart.pdf):

------------------------------------------------------------------------------------------------
FEATURES AVAILABLE ONLY IN DIALECT 3 DATABASES:
The following features are available only in dialect 3 clients AND DATABASES because they
conflict with dialect 1 usage.

** Delimited identifiers
Identifiers can now be keywords, contain spaces, be case sensitive, and contain
non-ASCII characters. Such identifiers must be delimited by double quotes. String
constants must be delimited by single quotes.

** INT64 data storage
In dialect 3 databases, data stored in DECIMAL and NUMERIC columns is stored as INT64
when the precision is greater than 9. This is true only for columns that are created in
dialect 3. These same datatypes are stored as DOUBLE PRECISION in dialect 1 and in all
older InterBase versions. This change in storage also requires different arithmetic
algorithms.

** DATE and TIME datatypes
In dialect 3, the DATE datatype holds only date information. This is a change from earlier
InterBase versions in which it stored the whole timestamp.
Dialect 3 allows the use of the TIME datatype, which hold only the time portion of the
timestamp.
-----------------------------------------------------------------------------------------------

but 40alltypes.t has to test the new types, so it needs a dialect 3 database!

rgds
-daniel

----- Original Message ----- 
From: "Mark D. Anderson" <md...@di...>
To: <dbi...@li...>
Sent: Wednesday, August 01, 2001 6:13 PM
Subject: [Dbi-interbase-devel] 40alltests.t needs to set dialect 3


> running make test of DBD-InterBase-0.28.4 i got a failure in t/40alltypes.t
> this was using a test database of  /opt/interbase/examples/v5/employee.gdb
> i don't recall right now the interaction between the dialect setting on a gdb,
> and the dialect setting at connect time, but it seems like something should be
> done. btw, seems like that test db should maybe be the default answer in
> Makefile.PL?
> 
> t/30insertfetch.....ok
> t/40alltypes........DBD::InterBase::db do failed: Invalid token
> -Dynamic SQL Error
> -SQL error code = -104
> -Database SQL dialect 1 does not support reference to TIME datatype
> DBD::InterBase::db prepare failed: Undefined name
> -Dynamic SQL Error
> -SQL error code = -204
> -Table unknown
> -BUILTIN
> Can't call method "execute" on an undefined value at t/40alltypes.t line 131.
> 
> 
> t/40alltypes........ok 1/25
> 
> t/40alltypes........NOK 2
> 
> t/40alltypes........NOK 3
> 
> t/40alltypes........dubious
>         Test returned status 22 (wstat 5632, 0x1600)
> DIED. FAILED tests 2-25
>         Failed 24/25 tests, 4.00% okay
> 
> 
> 
> _______________________________________________
> Dbi-interbase-devel mailing list
> Dbi...@li...
> http://lists.sourceforge.net/lists/listinfo/dbi-interbase-devel
>