远程Sybase数据库技术支持,联系手机:13811580958,QQ:289965371!

 

随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息。
在SAP Support Portal网站或者google上搜索Targeted CR List for ASE,可以看到针对不同版本的CR(CR表示Change Request)简单描述信息列表。
需要注意的是:Targeted CR List for ASE列出的CR虽然绝大多数是BUG,但有一些是更改需求。
以下提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息!

如有问题,请联系我!

QQ :289965371 点击这里给我发消息
Email:
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

CR:629367
CR Number:   629367
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   AIX
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 21 May 2010 Added to user documentation
Description
Catalog DB and IQ store of IQ do not support NAS.



CR:629497
CR Number:   629497
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e01 15 Jul 2010 Fixed
Description
A SELECT query with a two table join intermittently produced

an incorrect result. The result depended on the method the query

optimizer chose to process the pushed down predicate of a hash

pushed down join.



CR:629523
CR Number:   629523
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.3 21 Mar 2011 Added to user documentation
Description
With the imsl timeseries functions an error number is reported but no error text.



Please document that a list of errors can be found in the files imslerr.dat and imsls_e.dat



CR:629542
CR Number:   629542
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Aug 2011 Presently Not Targeted For Any Future Release Of This Product
Description
When there is a problem with calling time series within the

imsl library functions then only errornumber and no errortext

is put into the logfile or send to the client



CR:629701
CR Number:   629701
Product Name:   IQ
Product Component:   other
Status:   Closed
OS:   Linux
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2013 Duplicate
Description
multiplex system running a stored procedure which alters some ddl gets st_server.cxx:1376 crash. On HP the stack does not have the sq symbols printed so you see this for example....

/opt/sybase/IQ-15_1/IQ-15_1/lib64/libiqserv15_r.so [0x400011f52d8]

/opt/sybase/IQ-15_1/IQ-15_1/lib64/libiqserv15_r.so [0x400011f5534]

/opt/sybase/IQ-15_1/IQ-15_1/lib64/libiqserv15_r.so [0x400011d6b88]



There is a seperate CR 633385 raised to resolve this stack print error on IBM platforms.



The real stack can be obtained from running s gbd on the core, failure is at _ZN15df_MemGovRegion14DoCanAllocPageEv



CR:629819
CR Number:   629819
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2010 Fixed
Description
IQ catches signal11 and stops in df_Heap::GenerateDF.



CR:629840
CR Number:   629840
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2011 Presently Not Targeted For Any Future Release Of This Product
Description
Customer uses Replication Server DSI to connect and replicated data into IQ. Under certain rare conditions the DSI TDS connection into IQ hits the following error...



I. 05/18 09:29:13. TDS 178: login: user 'DLNPSPSW04_IQ_maint', database '', application 'RepServer', host 'lns66d-8110a', host_pid '21988', charset 'iso_1'

I. 05/18 09:29:13. Login procedure 'DBA.sp_iq_process_login' caused SQLSTATE '22003'

I. 05/18 09:29:13. Value 2117418877184 out of range for destination



The login is not rejected however and the connection to IQ is allowed (this must surely also be a bug?). Another side affect of the error is that the call to sp_login_environment() is not made meaning that the sp_tsql_environment procedure is not called so database options specific to TDS connections are not set.



The source of the "Value 2117418877184 out of range for destination" error is an incorrect declaration of the column that represents LockName in the stored procedure sp_iq_process_login...



'create procedure DBA.sp_iq_process_login()\x0Abegin

declare @admin_on char(1);

declare @has_perm char(1);

declare @login_locked char(1);

declare @number_connects integer;

declare @number_connects_admin integer;

declare @number_db_connects integer;

declare @password_days integer;

declare @password_days_admin integer;

declare @password_created timestamp;

declare @times_connected integer;

declare c1 integer;

declare c2 varchar(255);

declare c3 varchar(255);

declare c4 integer;

declare c5 varchar(255);

declare c6 varchar(255);

declare c7 integer;

declare c8 varchar(255);

declare c9 varchar(255);

declare c10 varchar(255);

declare c11 integer;

declare c12 integer;

declare c13 integer;

declare c14 unsigned integer;

declare c15 integer;

declare @counter integer;

declare end_of_cursor exception for sqlstate value ''02000'';

declare saconn dynamic scroll cursor for call sa_conn_info();

......





the declare for c14 (which is the LockName) should be unsigned bigint and NOT unsigned integer.



Here is the corresponding declares in sa_conn_info where the connection infromation is obtained from...



'create procedure dbo.sa_conn_info(in connidparm integer default null)

result(Number integer,Name varchar(255),Userid varchar(255),DBNumber integer,LastReqTime varchar(255),ProcessTime varchar(255),Port integer,ReqType varchar(255),CommLink varchar(255),NodeAddr varchar(255),LastIdle integer,CurrTaskSw integer,BlockedOn integer,LockName unsigned bigint,UncmtOps integer)

begin

declare connid integer;

declare local temporary table t_conn_info(

Number integer null,

Name varchar(255) null,

Userid varchar(255) null,

DBNumber integer null,

LastReqTime varchar(255) null,

ProcessTime varchar(255) null,

Port integer null,

ReqType varchar(255) null,

CommLink varchar(255) null,

NodeAddr varchar(255) null,

LastIdle integer null,

CurrTaskSw integer null,

BlockedOn integer null,

LockName unsigned bigint null,

UncmtOps integer null,

)

in SYSTEM not transactional;if(connidparm is not null) then

....



Not an issue for IQ 15 and higher as this use dbo.sp_login_environment instead of DBA.sp_iq_process_login
Workaround Description
 Alter procedure sp_iq_process_login and change

declare c14 unsigned integer;

to

declare c14 unsigned bigint;



suggest to minimize problems caused by users loging in while changing the proc restart the server with -gm 1 and tcpip connections disabled before dropping and recreating the login proc.



CR:629950
CR Number:   629950
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   AIX
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jun 2010 Fixed
29 Jun 2010 Fixed
Description
IQ cannot be started on an AIX machine with 252 or more CPU threads. IQ will output and abort the "Memory allocation size too large" message.



CR:629952
CR Number:   629952
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   AIX
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The request of the feature which restores the backup file of readonly dbspace to Updating dbspace.



CR:630020
CR Number:   630020
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2010 One-off Provided
Description
Referenced view or derived table that contained a select list item which was not a table column caused a crash in IQ at df_GenrateDF.cxx:192. This has been rectified



CR:630516
CR Number:   630516
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   15.1 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for sp_iqdatatype to return for a user-defined datatype/domain, the underlying IQ system data type.



CR:630523
CR Number:   630523
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows XP
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e01 13 Aug 2010 Fixed
Description
Could not insert, update, delete, or transfer data to Sybase IQ,

when using MS-SQL SSIS. Could not insert, update, or delete,

when using MS-SQL 2008 Link Server to Sybase IQ. The error

"[ADO NET Destination [16]] Error: Length cannot be less than

zero." was returned. ADO.NET drivers were not properly registered

with the system registry for Microsoft Visual Studio 2008.



CR:631239
CR Number:   631239
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
NFR: provide a way for IQ to return XOpen/SQL99 form



CR:631262
CR Number:   631262
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows XP
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e01 24 Jun 2010 Fixed
15.2 e01 14 Jun 2010 Fixed
15.3 16 Jun 2010 Fixed
15.2 e01 24 Jun 2010 Fixed
03 Dec 2010 Consult Complete
Description
Updatable Cursor could not handle more rows than specified by

the cursor_window_rows option and caused the server to become

unresponsive.



CR:631447
CR Number:   631447
Product Name:   IQ
Product Component:   Sybase Central
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jul 2010 Presently Not Targeted For Any Future Release Of This Product
15.2 04 Jun 2010 Added to user documentation
Description
The trigger creation wizard of Sybase Central cannot list a user table.
Workaround Description
 Please use DBISQL.



CR:631478
CR Number:   631478
Product Name:   IQ
Product Component:   Documentation
Status:   Open
OS:   Linux Red Hat
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
clarify open cursors to the db are not closed when an auto-commit occurs



CR:631595
CR Number:   631595
Product Name:   IQ
Product Component:   Sybase Central
Status:   Open
OS:   Solaris
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A new user's comment set to be a user creation wizard is not shown on the user property dialog of Sybase Central.



CR:631775
CR Number:   631775
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2010 Fixed
03 Aug 2010 Fixed
Description
Creating WD indices in parallel gives them the default delimiters instead of the one specified.



CR:631863
CR Number:   631863
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   HP-UX
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Support for UTC timestamp format when using load table.



CR:632115
CR Number:   632115
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jun 2010 Consult Complete
Description
IQ should locate all object data to a partition by range specification. IQ cannot split metadata and index(non FP index) data.



CR:632178
CR Number:   632178
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows 2008
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e01 09 Jun 2011 Fixed
Description
When attempting to replicate data from MS-SQL to Sybase IQ,

no data was sent to Sybase IQ and the connection was dropped

abruptly. The schema definitions that provide input to the

OLEDB driver have been updated to return correct database

metadata for Sybase IQ.



CR:632261
CR Number:   632261
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e02 13 Jul 2010 Fixed
15.3 26 Aug 2010 Fixed
Description
The ISDATE function returned an incorrect result.



CR:632266
CR Number:   632266
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.3 17 Sep 2010 Fixed
10 Dec 2010 Fixed
15.1 e03.x
Description
Only in case of parallel left outer hash join, when under resource constraints, parallel probing was not possible and it tries to do a serial probing and while doing so the server fails. This has been fixed.



CR:632475
CR Number:   632475
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Windows 2008
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e01 13 Aug 2010 Fixed
Description
OLEDB not working for linked server for some SQL syntaxes. This has now been fixed.



CR:632548
CR Number:   632548
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   15.1 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Improve performance for select * from wide tables (900+ columns)



CR:632876
CR Number:   632876
Product Name:   IQ
Product Component:   Utility
Status:   Closed
OS:   Solaris
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2013 Presently Not Targeted For Any Future Release Of This Product
Description
iqunload -n generate incorrect syntax for IQ table with foreign key. An error "Not NULL foreign key not supported" was raised when executing a reload schema in reload.sql.This issue does not apply to iqunload -au.
Workaround Description
 The workaround for this issue is to do a search and replace in the generated reload.sql (iqunload -n) file as follows:



ADD NOT NULL FOREIGN KEY

with

ADD FOREIGN KEY



CR:633040
CR Number:   633040
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e01 25 Jun 2010 Fixed
03 Aug 2010 Presently Not Targeted For Any Future Release Of This Product
18 Aug 2010 Presently Not Targeted For Any Future Release Of This Product
Description
Calling a stored procedure that operates on a table column

could cause a server failure, if the specified column did not

exist. A server failure could also occur, when calling stored

procedures that operate on literal names, when quotes were

omitted. For example, sp_helptext dbo.sp_iqstatus

caused a server failure, because without quotes,

dbo.sp_iqstatus was interpreted as a table/column name pair.
Workaround Description
 use single/double quotes around owner.table.idxname

sp_iqindexsize 'mytext.tidx' ;



sp_iqindexsize "mytext.tidx" ;



CR:633062
CR Number:   633062
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
For example, when DB Collation of IQ is UTF8 and Client Chaeset is EUC_JIS.

The client for which Japanese included in the result of SQL is using which character set is also converted correct.



CR:633066
CR Number:   633066
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
IQ does not support a trigger. However, a trigger can be created using DBISQL. However, the created trigger does not work.



CR:633143
CR Number:   633143
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows XP
Original Version:   15.2 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e01 29 Jun 2010 Fixed
15.2 e01 28 Jun 2010 Added to user documentation
15 Nov 2010 Added to user documentation
Description
Sybase IQ and the installer require .NET v2 and .NET v3.5 for support of the ADO.NET drivers.



CR:633354
CR Number:   633354
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e01 02 Jul 2010 Fixed
15.3 01 Jul 2010 Fixed
16.0 01 Jul 2010 Fixed
15.4 01 Jul 2010 Fixed
Description
xp_cmdshell did not execute the command on UNIX platforms.
Workaround Description
 revert back to esd 1 or 2.1



CR:633385
CR Number:   633385
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2011 Fixed
08 Mar 2011 DEFER
15.3 08 Mar 2011 Fixed
15.3 10 Mar 2011 Fixed
Description
On linux the stack is not resolving all symbols so you see something like this....

: ===== Thread Number 1305012544 (IQ connID: 0000514253) =====

/sybase/IQ-15_3/bin64/../lib64/libiq15.so(_Z9pcstkwalkP9stk_traceiP6db_logP6hos_fd+0x31) [0x2aaabf3a4ad1]

&/sybase/IQ-15_3/bin64/../lib64/libiq15.so [0x2aaabf3a3a42]

&/sybase/IQ-15_3/bin64/../lib64/libiq15.so(_Z14DumpAllThreadsPKcji+0xff) [0x2aaabf3a37bf]

&/sybase/IQ-15_3/bin64/../lib64/libiq15.so(_Z9hos_ABORTPKcjS0_PcS1_+0x19a) [0x2aaabf15729a]

&/sybase/IQ-15_3/bin64/../lib64/libiq15.so(SigHndlr+0x4e) [0x2aaabfc6366e]

&/lib64/libpthread.so.0 [0x367520eb10]

&/sybase/IQ-15_3/lib64/libiqserv15_r.so [0x2ad89f7f21e7]

&/sybase/IQ-15_3/lib64/libiqserv15_r.so [0x2ad89f5f9e00]

&/sybase/IQ-15_3/lib64/libiqserv15_r.so [0x2ad89f5fad8f]

&/sybase/IQ-15_3/lib64/libiqserv15_r.so [0x2ad89f8eb42f]

&/sybase/IQ-15_3/lib64/libiqserv15_r.so [0x2ad89f8c314f]

&/sybase/IQ-15_3/lib64/libiqserv15_r.so [0x2ad89f8c3313]

&/sybase/IQ-15_3/lib64/libiqserv15_r.so [0x2ad89f8c490d]

&/sybase/IQ-15_3/lib64/libiqserv15_r.so [0x2ad89f8c4e3c]

..................





The environment has to have a pstack command defined as a symbolic link to the gstack command for Linux. If this is set up then a second print of the stack is done with all the symbols resolved.



Please note the top part of the stack will still show the first thread for the ABORT with the unresolved symbolic names. However if you search on ABORT further down in the stack trace you should see the thread printed again (with the thread number in HEX) this time with the symbolic names resolved.
Workaround Description
 The environment has to have a pstack command defined as a symbolic link to the gstack command for Linux. If this is set up then a second print of the stack is done with all the symbols resolved.



Please note the top part of the stack will still show the first thread for the ABORT with the unresolved symbolic names. However if you search on ABORT further down in the stack trace you should see the thread printed again (with the thread number in HEX) this time with the symbolic names resolved.



CR:633466
CR Number:   633466
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux
Original Version:   15.2 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 15 Mar 2013 Fixed
Description
A simple join between an IQ table and a remote table returned an internal error if the local IQ table did not return any rows.



CR:633606
CR Number:   633606
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   15.1 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e02.x 10 Jan 2011 Fixed
18 Feb 2011 Presently Not Targeted For Any Future Release Of This Product
15.2 e03 Fixed
15.4 e02 14 Nov 2012 Fixed
13 Dec 2012 Fixed
15.4 e03 10 Dec 2012 Fixed
Description
Sybase IQ server failed from s_blockmap.cxx with message "TEMPORARY blockmap still owns dirty pages -- should have been destroyed".



CR:633825
CR Number:   633825
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   12.7 e06.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jul 2010 Consult Complete
14 Jul 2010 Not reproducible with latest version of the product available as of Resolution Date
12.7 e11 05 Oct 2010 Fixed
Description
When sp_addtype was executed on local store, it created

'Create domain ...' entry into local TLV store with Owner

of the domain 'dbo'. If sync followed, sync failed to replay

the domain command due to 'dbo' owner.
Workaround Description
 Nothing Yet.



CR:633919
CR Number:   633919
Product Name:   IQ
Product Component:   Utility
Status:   Open
OS:   Windows 2003
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer has a requirement to be able to create windows services for starting IQ servers via a command line utility similar to windows sc.exe so that this operation can be done via a silent install script with no user interaction or intervention needed. Can SybaseIQservice15.exe be enhanced to be able to run it as a command line tool?



CR:633949
CR Number:   633949
Product Name:   IQ
Product Component:   Utility
Status:   Closed
OS:   Solaris
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2011 Fixed
Description
dbisql fails to decrypt command file encrypted with dbfhide utility on solaris



CR:634176
CR Number:   634176
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2013 Consult Complete
Description
We need an official document that states whether there is backward compatibility

of the IQ 15.2 connectivity drivers with the previous versions of IQ server.



CR:634314
CR Number:   634314
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Sep 2010 Fixed
Description
On running "select * from sp_iqmpxincheartbeatinfo()", error

Cannot convert '00:00:0000:00:00:00' to a timestamp

SQLCODE=-157, ODBC 3 State="07006"

maybe thrown.



CR:634333
CR Number:   634333
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e10 16 Jul 2010 Added to user documentation
15.2 e02 09 Nov 2010 Fixed
15.3 09 Nov 2010 Added to user documentation
Description
In Performance and Tuning Guide > Using OLAP >Analytical Functions > Windowing >

Window framing > ROWS, the description of calculation for averages contains five

bullet points. The last two bullet points should be changed to: Row [4] = (120 + 500 + NULL)/2 and Row [5] = (500 + NULL + NULL)/1



CR:634385
CR Number:   634385
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e02 19 Jul 2010 Fixed
15.3 19 Jul 2010 Fixed
Description
Queries containing a CASE statement with a NOT NULL

clause returned incorrect results.
Workaround Description
 W/R is to set dml_options5=1073741824 in order to disable case simplification.



CR:634674
CR Number:   634674
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e11 27 Aug 2010 Fixed
Description
Under exceptionally rare conditions, the server failed when

expanding a very large view definition that contained a

UNION, INTERSECT, or EXPEPT query node and there was

insufficient cache space available.



CR:634959
CR Number:   634959
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e01 21 Jul 2010 Fixed
Description
A query that included both an IQ table and a proxy table

returned the error "Msg 2706, Level 11, State 0:

SQL Anywhere Error -141: Table '<proxy_table_name>' not

found," when the proxy table was qualified by owner and

the user executing the query was not the owner of the

table.



CR:635046
CR Number:   635046
Product Name:   IQ
Product Component:   Utility
Status:   Closed
OS:   HP-UX
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e02 30 Jul 2010 Fixed
Description
When performing IQUNLOAD -au on a database with

quoted_identifier='off', IQUNLOAD failed on reload

with the syntax error "SQL error: Syntax error

near 'old_IQ_MPX_INFO' on line 1"



CR:635108
CR Number:   635108
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   12.7 e09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e11 17 Dec 2010 Fixed
Description
If an application executed a remote statement that required

the server to execute the statement in either partial or no

passthru mode, there was a chance the server would fail, if

the statement was overly complex or if the server cache was

exhausted. In addition, if an application executed a remote

query that required partial or no passthru processing and

the query made heavy use of aliases, then the server

could incorrectly return error "-890 statement size or

complexity exceeds server limits." Now the -890 error is

returned only if the statement size or complexity really do

exceed server limits.



CR:635244
CR Number:   635244
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   AIX
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When a bit data type is added using a SUM function, IQ may return the wrong result. An index exists in the corresponding table, and it may be reproduced when the column is set to be order by.
Workaround Description
 The cast of the bit data type is carried out to a tinyint data type.



CR:635782
CR Number:   635782
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   12.7 e09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e11 05 Oct 2010 Fixed
Description
During local TLV replay, if comment on procedure statement

encountered a procedure not found error (SQLSTATE:52W09),

then local TLV performed an emergency shutdown.



CR:635832
CR Number:   635832
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Nov 2010 Fixed
Description
The option ANSI_SUBSTRING was introduced in the IQ 15.0 time frame but was never honored in IQ's implementation of substr. This option controls whether or not the substr function conforms to the ANSI standards. In particular, it disallows the third argument from being a negative number. The default value for this option is being changed for IQ databases to be 'OFF'. This will maintain the current default behavior of allowing a negative number as the third argument.



CR:635840
CR Number:   635840
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Windows 2003
Original Version:   15.2 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e02 16 Aug 2010 Fixed
Description
ADO.NET Data Provider: The Available objects list was empty

when creating SSIS data source view.



CR:636042
CR Number:   636042
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2010 Consult Complete
05 Jan 2011 Added to user documentation
Description
The value of the VersionID column of sp_iqtransaction is always set to 0. However, in non-MPX, the same value as TxnID is set to VersionID.



CR:636175
CR Number:   636175
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e01 30 Jul 2010 Fixed
15.2 e03 20 Sep 2010 Fixed
20 Sep 2010 Fixed
Description
LOAD TABLE QUOTES ON could not load quoted strings with

columns delimited by TAB, and returned the error "Could

not execute statement. Expected 'column' delimited column

type on input, but encountered a row delimiter instead.

Probable cause is a mismatch between the specified

column delimiter and the column delimiter used in the

input file."
Target Version
 15.2 e01



CR:636192
CR Number:   636192
Product Name:   IQ
Product Component:   other
Status:   Closed
OS:   Unknown
Original Version:   15.2 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e01 01 Sep 2010 Added to user documentation
15.2 e02 03 Sep 2010 Added to user documentation
15.3 31 Mar 2011 Added to user documentation
Description
The mapping of the columns of a proxy table to a Microsoft

SQL Server table changed as of Sybase IQ 15.2 ESD #1. A LONG

BINARY column now maps to a Microsoft SQL Server VARBINARY(max)

column. In Sybase IQ 15.2 GA, a VARBINARY column was mapped to

a Microsoft SQL Server VARBINARY(max) column.



CR:636476
CR Number:   636476
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   12.7 e08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e11 31 Aug 2010 Fixed
15.2 e02 31 Aug 2010 Fixed
15.3 31 Aug 2010 Fixed
Description
The IQ server appeared to be unresponsive, when an

ESQL program that opened many no-scroll cursors

disconnected.



CR:636632
CR Number:   636632
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.2 e00.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e02 19 Aug 2010 Fixed
15.2 e01 19 Aug 2010 Fixed
15.3 21 Feb 2011 Fixed
Description
The IQ server failed when the query was using a sort

merge pushdown join on a heavily loaded server.
Workaround Description
 If removed "A.call_code = B.call_code" in where condition,

the query run well.



CR:636953
CR Number:   636953
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.2 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e01 05 Aug 2010 Fixed
15.2 e02 05 Aug 2010 Fixed
15.3 05 Aug 2010 Fixed
Description
The Sybase IQ server failed while creating an index,

when the database option MAX_IQ_THREADS_PER_TEAM = 1.



CR:637544
CR Number:   637544
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jan 2011 Fixed
Description
Customer using '-onerror continue' option for dbisql.

However Batch SQL was finished when certain error occurred.



CR:637612
CR Number:   637612
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e01 18 Aug 2010 Fixed
Description
Loading into auto-increment/default columns can fail for a specific scenario. This has been fixed.



CR:637839
CR Number:   637839
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.2 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Oct 2010 Fixed
Description
When CONTAINS() was used in a CASE expression for empty

string data, a WD index on a VARCHAR column returned an

incorrect result.



CR:637840
CR Number:   637840
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Windows XP
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e02 16 Aug 2010 Fixed
15.2 e01.x 17 Sep 2010 Fixed
Description
ADO.NET driver: SAConnection.State was still open after

the connection was dropped.



CR:637935
CR Number:   637935
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   AIX
Original Version:   15.2 e00.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e02 18 Oct 2010 Fixed
15.3 28 Oct 2010 Fixed
Description
A query returned "Non-Fatal IQ Internal Error Detected

at dfo.cxx:9685 on thread 2828 (TID 25) Internal error

at node: #08 Can not evaluate expression:

MIN(MIN(TEST_MIN.col1)) Error detected at DFO #08 Group

By Single"
Workaround Description
 set temporary option aggregation_preference=(1/2/3/-2)



CR:637953
CR Number:   637953
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e03 31 Mar 2011 Fixed
28 Dec 2010 Fixed
15.3 10 Feb 2011 Fixed
Description
A SELECT query involving an outer join and scalar correlated

subquery sometimes failed with a dfo.cxx:9562 exception.
Workaround Description
 set temporary option 'subquery_flattening_preference'='-2'



CR:638356
CR Number:   638356
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2010 Fixed
Description
There was an issue in the memory handling in the driver code. This has been fixed.



CR:638546
CR Number:   638546
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   12.7 e10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e11 28 Oct 2010 Fixed
15.2 e03 28 Oct 2010 Fixed
Description
Secondary nodes shut down after executing a few alter table

statements separated by colon ":" on the coordinator/writer

node.



CR:638734
CR Number:   638734
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Nov 2010 Consult Complete
15.3 11 May 2011 Fixed
Description
In an MPX environment,backup first RW dbspaces then RO dbspaces.

Inadvertantly, if you restore read only dbspaces (resp. RW dbspaces) from the RW (resp. RO) archive, the restored catalog could be invalid.



CR:639150
CR Number:   639150
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   future
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request for Replication Agent IQ.



CR:639229
CR Number:   639229
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   HP-UX
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
need ACCENT_RESPECT collation for 1250LATIN2 charset



CR:639243
CR Number:   639243
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.2 e00.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e02 06 Oct 2010 Fixed
Description
Multiplex: An update on a table returned a main bufman

error, when executed in the same session after converting

a Reader node to a Writer node without rebooting the

server.



CR:639334
CR Number:   639334
Product Name:   IQ
Product Component:   Install
Status:   Closed
OS:   Windows 2003
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2010 Work as design
Description
The Redistributable package of VC++2005 and VC++2008 is required for IQ.

The installer of IQ installs these packages in a system.

However, in the system in which VC++ of one of versions was installed, IQ installer cannot install insufficient VC++Redistrabutable.
Workaround Description
 Please install manually VC++Redistributable which is not installed.



CR:639368
CR Number:   639368
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2013 Not reproducible with latest version of the product available as of Resolution Date
Description
15.2 IQUNLOAD -au would faile if the database being upgraded has a java class installed with the command: INSTALL JAVA FROM @variable
Workaround Description
 Remove this Java class before migrating



CR:639512
CR Number:   639512
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
add a parameter to sp_iqemptyfile to allow specifying which r/w dbfile to relocate data to



CR:639513
CR Number:   639513
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
allow specification of any r/w dbfile in ANY dbspace rather than just current one



CR:639730
CR Number:   639730
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 future 07 Mar 2011 Fixed
Description
The unnecessary link is included in description of "-cl" starting option in IQ Utility Guide.It does not need to be explained for description of '-cl' after 'For more information'.



CR:639767
CR Number:   639767
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.3 15 Mar 2011 Fixed
Description
It is included in description of 'ALTER TABLE' about EBM. However, the document written about EBM does not exist.

EBM is the short title of Existence Bit Map. EBM : a basic datastructure used for storing metadata information that table/Indexes



CR:639824
CR Number:   639824
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08 04 Dec 2013 Fixed
Description
A complex query with subqueries that contain no FROM clause may result in an IQ Internal Error along with a stacktrace in the iqmsg file.



CR:640129
CR Number:   640129
Product Name:   Sybase IQ ETL
Product Component:   pEngine
Status:   Closed
OS:   all
Original Version:   Denali
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2012 Fixed
10 Oct 2010 Added to user documentation
23 May 2011 Fixed
Description
When a product requires multiple licenses and the license server has insufficient licenses available to satisfy it's needs, the failure message reported by the product does not show the correct amount that were available (that the product could obtain). E.g. "Replication Server requires 4 REP_SERVER licenses but only 4 could be obtained."
Workaround Description
 Run the following command to determine how many licenses are available:

sysam status -a



CR:640192
CR Number:   640192
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Dec 2010 Fixed
15.2 e03 11 Jan 2011 Fixed
11 Jan 2011 Fixed
14 Jan 2011 Fixed
Description
There was a problem in an HG index load algorithm, when the

underlying index contained some deleted keys. "Non-Fatal IQ

Internal Error Detected" was returned.



CR:640331
CR Number:   640331
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
load table (filename-vaiable) fails with an Exception



CR:640333
CR Number:   640333
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhance TDS support for 'load table using client file' using iqisql/jConnect



CR:640419
CR Number:   640419
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Oct 2010 Duplicate
Description
A query involving OLAP and views using extended GROUP BY

syntax was not rejected with a syntax error, when the query

ran as a SQL Anywhere managed and non-passthrough query

(using cis_option=8).



CR:640433
CR Number:   640433
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2010 Fixed
23 Jan 2011 Fixed
Description
When the 'substr' function was used with 'SELECT....CASE

WHEN' and the value -ve was passed as length to the

function, Sybase IQ returned an invalid parameter error

(SQLCODE -1090), only if the 'substr' function executed

at runtime.



CR:640731
CR Number:   640731
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows 2008
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2012 Fixed
Description
In IQ15, the updating transaction which used cursor requires many time rather than IQ12.7.



CR:640890
CR Number:   640890
Product Name:   IQ
Product Component:   Utility
Status:   Closed
OS:   Solaris
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Sep 2010 Fixed
Description
When creating a database using an iqinit utility, IQ temp reserve size cannot be set.



CR:640913
CR Number:   640913
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Unknown
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
add ability to tds layer so that user can log in via ctlib isql if user was created with 'force password change on'



CR:641090
CR Number:   641090
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.2 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.1 e03.x 22 Dec 2010 Fixed
15.3 22 Dec 2010 Fixed
15.2 e02 22 Dec 2010 Fixed
Description
Cleanup for sort object during forceful termination of query has been corrected.



CR:641229
CR Number:   641229
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.1 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e02 08 Oct 2010 Fixed
15.2 e01.x 03 Nov 2010 Fixed
Description
In very rare cases, the Sybase IQ server could stop

processing, if an external environment call was made at

the same time the server began to perform some maintenance

on the database.



CR:641943
CR Number:   641943
Product Name:   IQ
Product Component:   other
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e01 21 Sep 2010 Not a Bug
Description
IQ 15.1 checks out one IQ_CORE license more than there are actual cores on the machine if floating licenses are in use.



CR:642111
CR Number:   642111
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
15.2 ALTER TABLE hangs until full BACKUP finishes



CR:642368
CR Number:   642368
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2010 Fixed
Description
v3 Scalar UDF example my_toupper produced wrong results due to a character pointer offset by 1. This has been fixed.



CR:642371
CR Number:   642371
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Dec 2010 Fixed
Description
The CREATE PROCEDURE for the v3 Scalar UDF example my_toupper example was not present while creating a new IQ database. This has been fixed.



CR:642507
CR Number:   642507
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   15.2 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
distinct query with inner joins takes much longer than MySQL



CR:642511
CR Number:   642511
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.3 05 Apr 2011 Added to user documentation
Description
Customer requested fruther documentation on the transaction states reproted in sp_iqtransaction. In particular to help understand when a transaction is placed in an APPLIED state and what it means to versions and locks the transaction was holding.



CR:643258
CR Number:   643258
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   AIX
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
IQ(SQL Anywhere) JDBC driver cannot handle the DBCS SJIS character including 0x7B correct as an object name.



CR:643282
CR Number:   643282
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux
Original Version:   15.2 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e02 11 Oct 2010 Fixed
15.3 11 Oct 2010 Fixed
Description
The Sybase IQ server failed on the parallel execution of

vertical predicates (a SELECT with subqueries).
Workaround Description
 Disable "parallelism into vpp_dfp execution of FP complex predicates path" with

set temporary option dml_options6 = 512;



CR:643926
CR Number:   643926
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Solaris
Original Version:   15.1 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Feb 2011 Fixed
Description
IQ 15.1 cannot reach ASE 15 through remote server class ASEODBC 64 bits



CR:644031
CR Number:   644031
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.2 e01.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e01.x 05 Nov 2010 Fixed
15.3 05 Nov 2010 Fixed
15.2 e02.x 31 Jan 2011 Fixed
15.2 e03 01 Apr 2011 Fixed
Description
The Sybase IQ server sometimes failed when executing a query

involving the sort merge push-down algorithm.
Workaround Description
 If removed "A.call_code = B.call_code" in where condition,

the query run well.



CR:644073
CR Number:   644073
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux
Original Version:   15.2 e00.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2011 Consult Complete
Description
We need explanations about temp cache management



CR:644410
CR Number:   644410
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Windows 2003
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e02 09 Dec 2010 Added to user documentation
Description
Please be sure to install VC++ 2005,2008 Redistributed Package before executing the installer of Sybase IQ 15.x for Windows.

Some programs could not be started when only VC++ 2005 currently written to the installation guide is installed.
Workaround Description
 Please install insufficient VC++ 2005,2008 Redistributed Package from CD or the downloaded installation package. And Sybase IQ Agent is manually registered to Windows Service.



CR:644979
CR Number:   644979
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   HP-UX
Original Version:   12.7 e09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Version: 12.7.0/100114/P/ESD 9/ITANIUM/HP-UXi 11.23/64bit

Would like help determining if a poorly performing query is the result of bad optimizer choices , or if working as expected and explaination as to why and whats happening...



Customer has a query that is being executed in 12 seconds, the format for the query is



SELECT ...

FROM ...

WHERE ... AND B.TIMESTAMP_S4B > '2010-08-04 11:00:00.000000'



If customer adds a simple condition in the where for a column that already had a condition

then the query plan changes and the query takes 55 minutes. This is the format

for the new query



SELECT ...

FROM ...

WHERE ... AND B.TIMESTAMP_S4B > '2010-08-04 11:00:00.000000' and

B.TIMESTAMP_S4B < '2010-07-06 11:00:00.000000'



looking at the query plans good and bad that can be found at \\ecss\ts-cases\11629000s\11629275, we can see the performance increase is stemming from the rows returned from leaf node #3 into the join.



In the bad query a table scan is done and the entire 684 million rows from table HOP_OPPERACIONES_6_MESES_EVR is passed to the JOIN and a sort merge join is done on it.



In the good query a condition of

ROW(A.ID_4B, A.CODIGO_OPERACION) = ROW(BV(2, CAST(SUBSTR ((D.REFERENCIA_DOCUMENTAL,2,23) AS NUMERIC(126,38))), BV(1, CAST(D.NUMERO_EXPEDIENTE AS NUMERIC(126,38))))

is pushed out of the join and into Leaf node #03 resulting in only 553 rows passed into the join and a Nested Loop push down is done.



In both queries the B.TIMESTAMP_S4B condition is resolved and an invariant in Leaf #5. For the bad query the extra condition is merged into a single BETWEEN condition.



If the customer uses join_preference -1 or 3 to avoid the sort merge then the query runs quickly again. So why is the optimizer choosing the slower sort merge ?



CR:645066
CR Number:   645066
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Windows 2003
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A user name is not set to analaysis result when request log is analyzed using sa_get_request_profile() or sa_get_request_times().



CR:645127
CR Number:   645127
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.1 e03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 2010 Fixed
31 Oct 2010 Fixed
15.1 e03 11 Feb 2011 Fixed
Description
The problem may occur if a crash occurs after insert/load transaction commits and before checkpoint.

The fix takes care of reflecting most up-to-date identity value into catalog before the objects are closed at the end of insert/load operation.
Target Version
 15.1 e03.x





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具:ReadASADB。
此工具支持ASA v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0等版本。
恢复Sybase SQL Anywhere的工具在国内应该算首创。

ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具

  1. 适用于所有的SQL Anywhere版本    包括:5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集  包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

ReadASADB适用场景

各种误操作:

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

本工具的应用场景:

1.因为物理磁盘故障、操作系统、系统软件方面或者掉电等等原因导致的Sybase SQL Anywhere数据库无法打开的情况;
2.误操作,包括truncate table,drop table,不正确的where条件导致的误删除等;
Sybase SQL Anywhere无法打开时,比较常见的错误是:Assertion failed。
如:
1、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Checkpoint log: invalid bitmap page -- transaction rolled back
2、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Page number on page does not match page requested -- transaction rolled back
3、Internal database error *** ERROR *** Assertion failed:200502 (9.0.2.2451) Checksum failure on page 23 -- transaction rolled back
4、File is shorter than expected
5、Internal database error *** ERROR *** Assertion failed: 201116 Invalid free list index page found while processing checkpoint log -- transaction rolled back
6、*** ERROR *** Assertion failed: 51901 Page for requested record not a table page or record not present on page等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------