1
vote
2answers
44 views
How to download a file from internet using sql anywhere behind a squid proxy ?
I try to use this function on SQLA 10.0.1.3976 as a test.
alter FUNCTION "DBA"."UNBlacklist"()
returns long varchar
url 'http://www.un.org/sc/committees/1267/consolidatedlist.x …
1
vote
2answers
49 views
Is ‘-12345678901234566.00’ the correct result of str(-12345678901234567.0001,40,2)
When i execute the following command I'm a little bit surprised of the result.
select -12345678901234.0001 as TestVal, str( TestVal, 40, 2) as stringVal
union all
select -123456 …
0
votes
2answers
61 views
BUG In SA 11 .NET Driver
I think I found a bug in ADO.NET driver for SA 11.
if I try to execute this code:
DbCommand command = connection.CreateCommand();
command.CommandText = "select 'my ' + 'strin …
3
votes
2answers
61 views
Intent lock bug?
We have recently upgraded our database from SQL Anywhere 5.5 to SQL Anywhere 11. Our users use applications written in Delphi to access the data in the database through ODBC. Needl …
1
vote
3answers
80 views
BUG In SA 11 .NET Driver (2)
As suggested me Breck, I'm starting this thread for this question.
That's my code:
using System;
using System.Data.Common;
namespace SA11BUG
{
class Program
{
st …
1
vote
2answers
66 views
How to crash a SA11 engine with a simple SQL statement
While testing High Availability I want to simulate a failing primary server. Killing the process via task manager would work, but I just wanted a more elegant solution using plain …