John Kendall | 18 May 22:49 2016

TDS_INT8_MIN determined by shifting a negative value

Is there another way to determine TDS_INT8_MIN in convert.c (line 96)?

The new llvm compiler on OS X 10.11 is complaining about bit shifting a negative:

   warning: shifting a negative signed value is undefined [-Wshift-negative-value]

John
Frediano Ziglio | 18 May 22:41 2016
Picon

FreeTDS 1.0 Released!

Hi,
  finally ready. Changes (from NEWS file)

User visible (not in a particular order):
- Removed "8.0" from protocol version string accepted. Please
  update configuration files;
- Default protocol version is now auto. This could slow down
  connection but make user experience less painful;
- Sybase encrypted login. Set encryption to get it;
- Support protocol version 7.4;
- Add intent support to specify we don't want to change data;
- Allow to attach database file during the login (MS SQL Server);
- Support for Sybase time/date/bigdate/bigdatetime;
- Pool is working again;
- ODBC BCP (not complete);
- Improved dbconvert and dbconvert_ps (more compatible);
- Fixed dbspid;
- Improved ODBC type information;
- Better certificate verification;
- AppVeyor is used for every build;
- Try all IPs from DNS. This allows SQL Cluster connection
  to secondary servers.

Implementation:
- Removed Nmake support;
- Type conversions simplified;
- Better type handle code.

Frediano
(Continue reading)

Frediano Ziglio | 13 May 08:30 2016
Picon

Re: ctlib compute columns (was: "Fix affected rows after insert with prepared query" side effect)

It's always a good idea to open a new thread for a new topic!

2016-05-11 21:47 GMT+01:00 John Kendall <john <at> capps.com>:
>
> On May 11, 2016, at 1:23 PM, Frediano Ziglio <freddy77 <at> gmail.com> wrote:
>
>> 2016-05-11 6:07 GMT+01:00 John Kendall <john <at> capps.com>:
>>>
>>>> On May 10, 2016, at 3:34 PM, Frediano Ziglio <freddy77 <at> gmail.com> wrote:
>>>>
>>>> 2016-05-10 22:31 GMT+01:00 John Kendall <john <at> capps.com>:
>>>>> It appears the patch for this ("fix ct-library rows count") has broken compute in ctlib:
>>>>>
>>>>>
>>>>> select col=1 into #tbl insert #tbl values (2) select * from #tbl compute sum(col)
>>>>> (1 row affected)
>>>>> (1 row affected)
>>>>>  col
>>>>>  -----------
>>>>>            1
>>>>>            2
>>>>>            2
>>>>>
>>>>> (3 rows affected)
>>>>>
>>>>> dblib (and ctlib RC1) does the expected:
>>>>>
>>>>> select col=1 into #tbl insert #tbl values (2) select * from #tbl compute sum(col)
>>>>> (1 row affected)
>>>>> (1 row affected)
(Continue reading)

Frediano Ziglio | 11 May 22:10 2016
Picon

FreeTDS 1.0 Release Candidate 5 is out!

This release contains:
- new DB-library options:
  - DBSETLUTF16;
  - DBSETLNTLMV2;
  - per-DBPROCESS timeout using DBSETTIME;
- fix compute column in CT-library;
fix for native BCP using Sybase.

No portability issues this time. I'm confident to have the final
release in a week or so (I hope with no changes).

Frediano
John Kendall | 4 May 19:46 2016

freebcp in -n native switch not working with Sybase

On MS SQL Server this works:

   select col1="one", col2="2" into tempdb..tbl

   freebcp tempdb..tbl out tbl.bcp -n -Uusr -Ppw
   freebcp tempdb..tbl in  tbl.bcp -n -Uusr -Ppw

On Sybase the bcp in fails like so:

   Starting copy...

   Msg 20104, Level 3
   Unexpected EOF encountered in bcp datafile

   bcp copy in failed

Notes:
The bcp file created is identical for on both server flavors.
Using the character -c option works.

Anyone else able to reproduce this problem?

John
John Kendall | 4 May 18:07 2016

Re: "Fix affected rows after insert with prepared query" side effect


> On Apr 30, 2016, at 4:23 PM, Frediano Ziglio <freddy77 <at> gmail.com> wrote:
> 
> Now works much better. Please try last RC (4).
> 
> Frediano
> 

Looks good. 
Thank you!
John 

> 
> 2016-04-24 16:55 GMT+01:00 John Kendall <john <at> capps.com>:
>> Sorry, my last post had the wrong link to sybase infocenter.
>> 
>> 2016-04-23 13:04 GMT+01:00 Frediano Ziglio <freddy77 at gmail.com>:
>> 
>>> 2016-04-22 1:03 GMT+01:00 John Kendall <john at capps.com>:
>>> 
>>>> Thu, 21 Apr 2016 11:04:54 +0100 Frediano Ziglio <freddy77 at gmail.com>
>>>> 
>>>>> 2016-04-21 8:00 GMT+01:00 John Kendall <john at capps.com>:
>>>>>> On Oct 19, 2015 this patch was applied to ct.c:
>>>>>> 
>>>>>> "Fix affected rows after insert with prepared query"
>>>>>> 
>>>>>> This patch has the side-effect of a 'rows affected' being displayed for every
>>>>>> select statement within a ASE stored procedure. For example, sp_help returns
>>>>>> 136 extra 'rows affected' lines. See below. Backing out this patch stops this from
(Continue reading)

Velichko Yuriy | 3 May 11:34 2016
Picon

ntlmv2 default value

Hello, what is default value for ntlmv2 option?
If ''no", can you add method, like DBSETUTF16, to avoid using .conf file to
setup this option?

Thanks!
Frediano Ziglio | 2 May 22:00 2016
Picon

Re: Setting `login->use_utf16` With DBLIB Using Sybdb.h

Added the DBSETUTF8 option! Not really hard :-)

Frediano

2016-05-02 12:18 GMT+01:00 Ken Collins <ken <at> actionmoniker.com>:
> The option to set the long would make sense to me. I love the default, but
> would love to allow someone to set this in my client without going to a conf
> file. Hope that helps.
>
>  - Ken
>
>
> On April 25, 2016 at 8:20:08 AM, Frediano Ziglio (freddy77 <at> gmail.com) wrote:
>
> 2016-04-24 20:58 GMT+01:00 Ken Collins <ken <at> metaskills.net>:
>> So I saw the news about `use utf-16 = true` via the conf file for 0.95 and
>> how this is the default in 1.0 release candidate. However, I was wondering
>> if there is a way I can set this long in bit using either an environment
>> variable or some other means when compiling against sybdb.h?
>>
>> - Thanks in advance,
>> Ken Collins
>
> An environment variable looks to much.
> An option to set using setlshort/setllong would make sense to me.
> Does it sound reasonable? I don't understand how you want to use this
> option.
>
> Frediano
> _______________________________________________
(Continue reading)

Frediano Ziglio | 1 May 01:22 2016
Picon

FreeTDS 1.0 Release Candidate 4 is out!

This release contains:
- fix some compile issues with Mac OS X;
- fix CT-Library rows counts;
- fix minor compatibility issues with some unit tests;
- other minor issues.

Frediano
Frediano Ziglio | 29 Apr 19:50 2016
Picon

Re: 'compute' deprecated (Re: rc3 looks good on OpenVMS)

2016-04-29 14:41 GMT+01:00 Craig A. Berry <craigberry <at> mac.com>:
>
>> On May 28, 2015, at 5:16 PM, Frediano Ziglio <freddy77 <at> gmail.com> wrote:
>>
>> Il 28/Mag/2015 09:58, "Craig A. Berry" <craigberry <at> mac.com> ha scritto:
>>>  With SQL 2012 this test below fails, but I
>>> think it's just because "compute" has been removed in SQL 2012:
>
>> Yes, that test check how compute queries reply so cannot work but is not a
>> Freetds issue
>
> I’m reviving this year-old thread because this is still a problem and getting to be a bigger one, and
while it isn’t FreeTDS’s fault, it is FreeTDS’s problem if its test suite can’t even run to
completion on 3 of the 4 currently-supported versions of Microsoft’s server (SQL 2005 went out of
support a week or two ago, so SQL 2008 is the only one that can run the test suite).
>

I though AppVeyor was running check against mssql 2012 !!

> The following tests are the ones affected:
>
> src/ctlib/unittests/t0009
> src/dblib/unittests/t0023
> src/dblib/unittests/dbmorecmds
>
> I tried (unsuccessfully) to come up with a way to skip the tests when running on SQL 2012 or greater.  The
following check tells you what you’ve got, but only at run time, which is too late.  The ‘compute’
keyword will still be seen at parse time so the script will already fail before this check runs.  Plus it uses
Microsoft-specific functions that will probably not parse on Sybase.
>
(Continue reading)

Frediano Ziglio | 29 Apr 19:27 2016
Picon

Re: [PATCH] Test tds_strl* routines on all platforms

Applied

Thanks,
  Frediano

2016-04-29 13:48 GMT+01:00 Craig A. Berry <craigberry <at> mac.com>:
> The src/replacements/unittests/strings.c failed to build for me on OS X.  The test is explicitly using
the routines with the tds_ prefix, which don’t exist when we aren’t using replacements.  So this
change makes them exist for test purposes only in the case where we wouldn’t normally get them.
>
>
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS <at> lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
_______________________________________________
FreeTDS mailing list
FreeTDS <at> lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

Gmane