Skip to Content.
Sympa Menu

freetds - RE: TODO

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Brian Bruns" <camber AT ais.org>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: RE: TODO
  • Date: Wed, 4 Sep 2002 12:15:39 -0400


Yep that's the one. tsql is dead simple in that it just converts blindly
to VARCHAR. I hadn't figured out whose fault it is (convert or tsql) yet,
but it strikes me as something that should work.

Brian

> 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')



  • TODO, ZIGLIO Frediano, 09/04/2002
    • <Possible follow-up(s)>
    • RE: TODO, Lowden, James K, 09/04/2002
    • Re: TODO, Brian Bruns, 09/04/2002
    • RE: TODO, Brian Bruns, 09/04/2002
    • RE: TODO, Thompson, Bill D (London), 09/04/2002
    • RE: TODO, Brian Bruns, 09/04/2002
    • RE: TODO, Thompson, Bill D (London), 09/04/2002
    • RE: TODO, Eric Deutsch, 09/04/2002
    • RE: TODO, Brian Bruns, 09/04/2002
    • RE: TODO, Thompson, Bill D (London), 09/04/2002
    • RE: TODO, Frediano Ziglio, 09/04/2002
    • RE: TODO, Lowden, James K, 09/04/2002
    • RE: TODO, Frediano Ziglio, 09/04/2002

Archive powered by MHonArc 2.6.24.

Top of Page