Please retry with DBI 1.201 and send diffs for that ASAP. Thanks! Tim.
On Tue, Jan 22, 2002 at 08:33:15PM +0100, schoen wrote: > Hi, > > Three datatypes are defined in ODBC 3.X but not defined > or known (as far as I can tell) in DBI and DBD::ODBC. > > The SQL data types are: > > SQL_TYPE_DATE (91) > SQL_TYPE_TIME (92) > SQL_TYPE_TIMESTAMP (93) > > I use Red Hat 7.2, SAP DB 7.3.0.18, DBI 1.20 and DBD::ODBC 0.31. > When running DBD::ODBC make test TEST_VERBOSE=1 I get this output: > " > ... > t/02simple..........1..16 > .... > Test 3: create test table > Using fields: A SMALLINT, B VARCHAR(4000), C LONG, D DATE > ok 3 > .... > Test 9: test ColAttributes > Column count is: 4 > 1: A = 5 > 2: B = 12 > 3: C = -1 > 4: D = 91 > not ok 9 > .... > " > > SAP DB ODBC returns SQL_TYPE_DATE (91) for the D (DATE) column > and the test fails. > > Can the maintainers of DBI and DBD::ODBC please add the > SQL_TYPE_DATE, SQL_TYPE_TIME and SQL_TYPE_TIMESTAMP > ODBC 3.X SQL data type constants to DBI and handle > SQL_TYPE_DATE in the DBD::ODBC test script; or is there a good > reason for not implementing them? > > Does anybody want me to add them to DBI and DBD::ODBC and supply > the diff files? > > # schoen > >
