FreeTDS Development Group

["Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>]

Brian

Freetds latest snapshot;
sqsh 1.4  (db-library version);
Solaris 2.6

This is free software with ABSOLUTELY NO WARRANTY
For more information type '\warranty'
1> use master
2>
(0 rows affected)
1> select * from sysusers
2>
suid   uid    gid    name                           environ


------ ------ ------ ------------------------------
----------------------------------------------------------------------------
----
----------------------------------------------------------------------------
--------------------------------------------------------
-------------------------------------------
-16389 16389  16389  replication_role               NULL


-16388 16388  16388  navigator_role                 NULL


-16387 16387  16387  sybase_ts_role                 NULL


-16386 16386  16386  oper_role                      NULL


-16385 16385  16385  sso_role                       NULL

etc. etc.

(10 rows affected)
1> sp_help sysusers
2>
Name                           Owner                          Type
------------------------------ ------------------------------
----------------------
sysusers                       dbo                            system table

(1 row affected)
Data_located_on_segment        When_created
------------------------------ --------------------------
system                         Jan  1 1900 12:00:00:000AM

(1 row affected)
Column_name     Type            Length Prec Scale Nulls Default_name
Rule_name       Identity
--------------- --------------- ------ ---- ----- ----- ---------------
--------------- --------
suid            smallint        2      NULL NULL  0     NULL            NULL
0
uid             smallint        2      NULL NULL  0     NULL            NULL
0
gid             smallint        2      NULL NULL  0     NULL            NULL
0
name            sysname         30     NULL NULL  0     NULL            NULL
0
environ         varchar         255    NULL NULL  1     NULL            NULL
0

(5 rows affected)
index_name           index_description
index_keys

 
index_max_rows_per_page index_fillfactor index_reservepagegap
--------------------
--------------------------------------------------------
------------------------------------------------------
----------------------------------------------------------------------------
--------------------------------------------------------
---------------------------------------------------------------------
----------------------- ---------------- --------------------
sysusers             clustered, unique located on system
suid

                                                                      0
0                0
ncsysusers1          nonclustered, unique located on system
name

                                                                      0
0                0
ncsysusers2          nonclustered, unique located on system
uid

                                                                      0
0                0

(3 rows affected)

etc. etc.

looks OK to me.

BUT tsql on the other hand....

1> use master
2>
3> go
1> select * from sysusers
2> go
suid    uid     gid     name    environ
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
-16389  16389   16389   replication_role
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
-16388  16388   16388   navigator_role
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
-16387  16387   16387   sybase_ts_role
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
-16386  16386   16386   oper_role
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
-16385  16385   16385   sso_role
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
-16384  16384   16384   sa_role
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
-2      0       0       public
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
-1      2       0       guest
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
1       1       0       dbo
Msg 249, Level 16, State 1, Server OpenClient, Line 1682
Syntax error during explicit conversion of SYBVARCHAR value '' to a
SYBVARCHAR field.
150     3       0       gloss_sa

is that what you mean ?
> -----Original Message-----
> From: Brian Bruns [SMTP:camber AT ais.org]
> Sent: Wednesday, September 04, 2002 4:56 PM
> To:   TDS Development Group
> Subject:      [freetds] RE: TODO
> 
> Jim, also I think we need to pay special attention to some of the
> conversion errors, I got a bunch of spurious errors in tsql when selecting
> from sysusers (sybase 11.0.3), but haven't had time to look further. 
> Definately, 0.60 fodder if it's a bug.
> 
> Brian
> 
> > > From: ZIGLIO Frediano [mailto:Frediano.Ziglio AT vodafoneomnitel.it]
> > > Sent: September 4, 2002 11:28 AM
> > > 
> > > What does it mean the row in TODO:
> > > . move error message macro/prototype to tds.h.in; use in dblib.c. 
> > 
> > The definition of CONVERSION_ERROR and the prototype for
> > send_conversion_error_msg() are in tds/convert.c.  If they were moved to
> > tds.in.h, they could be used from dblib.c.  
> > 
> > Currently, dblib.c::dbconvert() writes to stderr instead of calling
> > CONVERSION_ERROR.  There are probably simlilar, um, oversights in ctlib
> and
> > odbc.  
> > 
> > See tds_convert() for example.  
> > 
> > Is clear?
> > 
> > --jkl
> 
> ---
> You are currently subscribed to freetds as: [thompbil AT exchange.uk.ml.com]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')