Sybase数据库技术,数据库恢复

• 首页
• 关于
• 订阅
• 归档
• 留言
• 标签
• 免费ASE测试环境
• 镜像站
• 恢复工具

CR:464327

CR Number:   464327 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e10 03 May 2007 Fixed 12.7 e03 06 Jun 2007 Fixed Description A server could fail with a Signal 11 if the Force_No_Scroll_Cursors option was set to the non-default value of 'ON' and a client-side cursor was closed and re-opened. The cursor operations could be called explicitly from a client library or as the result of a CIS decomposed query or OUTPUT TO statement.

CR:464331

CR Number:   464331 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows XP Original Version:   12.7 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e03 05 Jun 2007 Fixed 15.0 15 Oct 2008 Fixed Description A server failure might result during an INSERT...LOCATION of an ASE IMAGE column or IQ LONG BINARY column to an IQ BINARY or VARBINARY column.

CR:464420

CR Number:   464420 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e10 07 May 2007 Fixed Description In rare circumstances, the engine could fail when a stored procedure ran after DDL statements against the server caused a schema change involving a cached stored procedure.

CR:464869

CR Number:   464869 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e06.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 23 Jul 2008 Fixed Description Request feature that allows locking nonactive user account and indicates why the account is locked.

CR:465093

CR Number:   465093 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Unknown Original Version:   12.6 future Fixed Version Build Resolution Date Closure Code (If Appropriate) Description mechanism where IQ re-use the same astmp file or deletes with session end

CR:465663

CR Number:   465663 Product Name:   IQ Product Component:   Install Status:   Closed OS:   AIX Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e11 15 Sep 2008 Fixed 12.7 e03 26 Jun 2007 Fixed 15 Sep 2008 Presently Not Targeted For Any Future Release Of This Product Description On some UNIX systems (particularly AIX), files that the installer was trying to update could be held in memory and locked. This problem usually resolved itself in subsequent runs of the installer. However, if the locks continue to be held, run sybinstall with the new -unlock parameter. This parameter installs the files in a shadow directory, links to the correct location, then removes the shadow directory, thereby avoiding lock problems. Workaround Description  *** Tuesday, June 19, 2007 12:26:36 PM *** kthayer *** I have attached the Unix script "unlock_dir" (see attached) which will unlock a locked dir. checkout header for usage.

CR:465679

CR Number:   465679 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e03 19 Apr 2007 Fixed 12.6 e10 03 May 2007 Fixed Description Use of procedure references in the UPDATE statement could cause the server to fail under certain circumstances. The server now generates an appropriate error message.

CR:465686

CR Number:   465686 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Unknown Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e03 03 Aug 2007 Fixed 12.7 e03 10 Aug 2007 Fixed 15.0 15 Oct 2008 Fixed Description When IP aliasing is used, the plug-in might fail to connect to the agent. Successful connections by host name might fail when the IP Address is used.

CR:465697

CR Number:   465697 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   12.6 e06.x Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Create a feature similar to ASE's named cache in IQ

CR:465800

CR Number:   465800 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.7 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e03 26 Jun 2007 Fixed 15.0 07 Jan 2008 Fixed Description Under some circumstances, a query containing multiple nested levels of views or derived tables could encounter an internal error when either (1) the SELECT list of one of the higher level views or derived tables contained an expression that was not a constant, but which could be simplified into a constant value, or (2) some expression in the SELECT list of a higher level view was not used in the query using that view.

CR:465896

CR Number:   465896 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.6 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e10 15 May 2007 Fixed 12.7 e03 1 29 May 2007 Fixed Description An invalid double dot '..' expression in front of an aliased column name in a GROUP BY clause could cause the server to be unresponsive.

CR:466135

CR Number:   466135 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e03.x 02 Oct 2007 Fixed 12.7 e04 21 Jan 2008 Added to user documentation 15.0 17 Dec 2007 Fixed 12.7 e04 02 Dec 2007 Fixed Description Certain combinations of CURSOR FETCH, COMMIT, and CLOSE CURSOR could server failure. The following sequence will cause a failure: create table; insert table; commit; open cursor for select from table; commit; insert table; fetch cursor; commit; insert table; commit; close cursor; See the Release Bulletin for a description of related behavior changes.

CR:466246

CR Number:   466246 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   12.7 future Fixed Version Build Resolution Date Closure Code (If Appropriate) Description More diagnostic information during dbbackup

CR:466355

CR Number:   466355 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   12.6 future Fixed Version Build Resolution Date Closure Code (If Appropriate) Description feature request to include the cpu cost in the query detail.

CR:466410

CR Number:   466410 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2000 Original Version:   12.7 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e03 12 Jul 2007 Fixed Description Setting the option MAX_QUERY_PARALLELISM did not correctly control the degree of parallelism used for UNION query processing.

CR:466473

CR Number:   466473 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows XP Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 01 Feb 2008 Fixed 15.0 04 Mar 2009 Fixed Description ODBC applications may not process UPDATE and DELETE commands properly, whenever zero rows are updated or deleted. ODBC SQLROWCOUNT will be -1 instead of 0 for these two cases.

CR:466564

CR Number:   466564 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.6 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e10 10 May 2007 Fixed 12.7 e03 10 May 2007 Fixed Description Under certain circumstances, Sybase IQ could produce incorrect results when an HNG index was created on a column of CHAR type and the logical expression of a WHERE clause contained a comparison operator between that column and a string longer than the column width.

CR:466851

CR Number:   466851 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e10 15 May 2007 Fixed 12.7 27 Apr 2007 Duplicate 12.6 e10 08 May 2007 Added to user documentation Description A "Table not found" error is returned if a base table owner is not supplied within a stored procedure that issues a SELECT on the base table and is run by a user who does not own the procedure but has execute permission on the procedure and select permission on the base table.

CR:467394

CR Number:   467394 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.6 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e10 03 May 2007 Duplicate Description After a select into a local temporary table returned "ASA Error -1000106: Local temporary table, table1, must be committed in order to create an index", a select, update or drop on the local temporary table caused server failure. Another sequence that caused the same failure: DECLARE LOCAL TEMPORARY TABLE foo (c1 INT); CREATE foo (c1 INT);

CR:467665

CR Number:   467665 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 2 17 Jan 2008 Fixed Description The IQ server fails while trying to resolve a range predicate simplification of the form "a > x OR a > y" where x and y are equal. Workaround Description  The workaround is to disable the range predicate simplification: set temporary option DML_OPTIONS1='2097152';

CR:467981

CR Number:   467981 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e03 15 May 2007 Fixed 12.6 e10 13 May 2007 Fixed Description The IQGOVERN_PRIORITY database option value might not persist through a database stop and restart. If the IQGOVERN_PRIORITY and IQGOVERN_MAX_PRIORITY options were set to 1 for the PUBLIC group, the warning "Option IQgovern_priority has an invalid setting: 1." was reported on database restart.

CR:468278

CR Number:   468278 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e10 29 May 2007 Fixed 12.7 e03 29 May 2007 Fixed Description An IQ database may fail to start after restoring a backup that moves the catalog store.

CR:468370

CR Number:   468370 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Windows NT Original Version:   12.7 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e03 16 Aug 2007 Fixed Description Depending on the configuration of your Windows system, when running the "Raw Device Access" or "Sybase IQ Service Manager" server applications, the following error message might have been reported: "This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem."

CR:468458

CR Number:   468458 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   AIX Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e03 1 31 May 2007 Fixed Description If you used BCP IN to populate a table owned by a user other than the connected user, then BCP IN would fail with either a table not found error or the server would fail. In some cases, if the connected user also owned a table with the same name as the table being populated, then the server would attempt to add rows to the wrong table.

CR:468769

CR Number:   468769 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   12.6 e06.x Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Load table to should compare no. col specified in cmd is same as input file

CR:468975

CR Number:   468975 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Windows 2000 Original Version:   12.6 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When '0x5c' is contained in the 2nd byte of a multi-byte character, dbisql cannot output the character to a file correctly. And this issue is reproduced when the character exists in the head of a character sequence. Workaround Description  Please change ESCAPE CHARACTER. For example, please specify '!'.

CR:469023

CR Number:   469023 Product Name:   IQ Product Component:   other Status:   Closed OS:   Solaris Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 24 Jan 2008 Fixed Description Changing passwords using the sp_iqpassword procedure fails in ISQL if the VERIFY_PASSWORD_FUNCTION option is enabled.

CR:469093

CR Number:   469093 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.6 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e10 06 Jun 2007 Fixed 12.7 e03 06 Jun 2007 Fixed 12.6 e08 27 Jul 2007 Fixed Description In rare circumstances, a busy server executing DROP TABLE statements against local temporary tables could become unresponsive.

CR:469250

CR Number:   469250 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.6 e10 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e10 25 May 2007 Fixed 12.7 e03 23 Oct 2007 Not a Bug 12.6 e10 07 Jun 2007 Added to user documentation 12.7 e03 07 Jun 2007 Added to user documentation Description A database created with JAVA ON reported a different error on incorrect dotted references than a database created with JAVA OFF.

CR:469460

CR Number:   469460 Product Name:   IQ Product Component:   Utility Status:   Closed OS:   Solaris Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e11 24 Aug 2008 Fixed 12.7 e02 31 May 2007 Not reproducible with latest version of the product available as of Resolution Date Description Using the OUTPUT statement to output an indeterminate result set to a file causes dbisqlc to fail.

CR:469715

CR Number:   469715 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   12.6 e06.x Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Adding join to the view decreases performance , optimizer should choose push down instead of customer having to set join_preference = '-5' Workaround Description  set join_prerference = '-5'

CR:469926

CR Number:   469926 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e06 18 Nov 2008 Fixed 12.7 e06 10 Sep 2009 Fixed Description A query involving many UNIONs in combination with the SYS.DUMMY table may return "ASA Error-300" and cause a stack trace.

CR:469940

CR Number:   469940 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.6 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2010 Fixed 12.7 e07 02 Jun 2009 Fixed 03 Aug 2009 Not reproducible with latest version of the product available as of Resolution Date Description Query - Server failure was caused by incorrect logic for handling sort related data structures. Especially, this was a problem with "top n" kind of queries. The problem was not readily reproducible due to the fact that the problem was triggered by a busy temp cache.

CR:469966

CR Number:   469966 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Windows NT Original Version:   12.6 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Provide option to set AutoPreCommit in the ASA.NET driver

CR:469968

CR Number:   469968 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 15 Jun 2007 Not a Bug 12.6 e11 20 Aug 2008 Fixed 12.7 e03 05 Jul 2007 Fixed 15.0 28 Jan 2008 Fixed Description A datatype conversion error was reported when converting a zero length string to DATETIME.

CR:470046

CR Number:   470046 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e11 07 Oct 2008 Fixed 12.7 e03 1 19 Jun 2007 Fixed 15.0 15 Oct 2008 Fixed Description Using UNION ALL to put results from different proxy tables together used the data from the first proxy table to replace the expected data from the other proxy tables used in the query.

CR:470168

CR Number:   470168 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Unknown Original Version:   12.6 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e11 28 Aug 2008 Fixed 12.6 e11 28 Aug 2008 Fixed Description Running the stored procedure sa_get_server_messages() will probably cause the IQ temporary store to fill up.`

CR:470183

CR Number:   470183 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e03 24 Oct 2008 Fixed Description With certain types of queries, the IQ 12.7 query optimizer simplifies certain query conditions to avoid unnecessary joins and comparisons. In certain GROUP BY operations, a problem was found due to an incomplete elimination of a sort operation. Workaround Description  This is a constant equating problem. Use dml_options5=524288 dml_options3=8388608 Rather than the workaround below. **************************************************************************** join_preference = -1 If they don't want to set the option public due to performance reasons, use temporary option for a connection scope or use hint syntax for a query only scope: set temporary option join_preference=-1 ...query... set temporary option join_preference=0 so other connections will not be affected by the loss of performance. If they need to use the same connection, then modifying the failed query using the syntax: WHERE (a=b, 'J:-1') AND.... will allow them to avoid sort-merge join only for that query.

CR:470538

CR Number:   470538 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows NT Original Version:   12.6 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e11 01 Aug 2008 Fixed 12.7 e03 24 Aug 2007 Fixed Description "sp_iqindexinfo" returned the wrong value for DBSpPct. It now returns the correct percent of the dbspace used by the index.

CR:470596

CR Number:   470596 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.6 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e06 03 Nov 2008 Fixed 15.0 03 Nov 2008 Fixed 12.7 e06 23 Feb 2009 Fixed 15.0 03 Mar 2009 Fixed Description The IQ server may become unresponsive when the caches are heavily used, e.g., multiple connections are constantly loading to and deleting from tables.

CR:470997

CR Number:   470997 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   12.6 e06.x Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Provide an option to estimate space used by join columns between 2 tables

CR:471000

CR Number:   471000 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2000 Original Version:   12.6 e06 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e11 18 Aug 2008 Fixed Description A delete from a varchar column with a HG index defined could fail with the message "Key too large" or insert ... location ...could fail with "Page size selected is too small for this datatype".

CR:471003

CR Number:   471003 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   SunOS Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 28 Dec 2007 Fixed 15.0 21 Jul 2008 Fixed Description Executing a "DELETE ... WHERE ROWID(table) BETWEEN ... and ROWID(table) BETWEEN ..." statement could cause a server failure. Workaround Description  The problem can be averted by using set temporary option dml_options3 = 16777216;

CR:471004

CR Number:   471004 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e06.x Fixed Version Build Resolution Date Closure Code (If Appropriate) Other 16 Jul 2007 Not a Bug Description sp_iqcolumn truncates column name on the 51st column and after

CR:471075

CR Number:   471075 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.6 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2009 Duplicate 12.7 e07 29 Apr 2009 Fixed 12.7 e05.x 06 May 2009 Fixed 12.7 e06.x 20 May 2009 Fixed 15.1 e01 15 Jun 2009 Fixed 12.7 e07 21 May 2009 Fixed Description Attempting to return a result set from within a BEGIN ATOMIC block (this is not allowed) would not close the cursors that were created for the SELECT. This would cause the server to fail at st_txncb.cxx line 2822. Workaround Description  Not yet.

CR:471237

CR Number:   471237 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   12.6 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A lot of insert queries freezes IQ without an error. Workaround Description  Please increase the value of "-mc."

CR:471297

CR Number:   471297 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 3565+ 15 Jan 2008 Fixed 12.6 e11 05 Aug 2008 Fixed Description If you execute a query that involves many tables, then there is a chance the query will cause the server to fail. Such failures are more likely with databases that have a smaller page size. This problem has been fixed and the server now properly gives an error when a query with too many table nodes is executed. The error is "-890 Statement size or complexity exceeds server limits."

CR:471302

CR Number:   471302 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2000 Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 10 Dec 2007 Fixed Description Index Advisor recommends adding a CMP index on DOUBLE and FLOAT columns, when not all versions of Sybase IQ supports this behavior.

CR:471405

CR Number:   471405 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2000 Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 21 Apr 2008 Duplicate Description iq_bcp cannot blkin data correctly about the combination of a char type and a datetime type.

CR:472271

CR Number:   472271 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e01 13 Jul 2009 Fixed 15.2 27 Jul 2009 Fixed Description The sp_sproc_columns stored procedure does not return the parameter mode (IN, OUT, or INOUT). Instead, it returns 0 for all the modes. This has been fixed.

CR:472273

CR Number:   472273 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 05 Dec 2007 Fixed Description The procedure sp_iqprocparm() was returning the IN parameter mode for the INOUT parameter for all version of Sybase IQ. sp_iqprocparm() now returns INOUT mode for INOUT parameters.

CR:472435

CR Number:   472435 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e03 31 Jul 2007 Fixed 15.0 05 Feb 2008 Fixed Description A non-fatal error could occur when the number of rows was greater than 2 billion and there was a prefix match in the LIKE predicate through a WORD (WD) index.

CR:472803

CR Number:   472803 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e03 09 Jul 2007 Fixed Description Using the RANK statement returned data in the requested order, but if a WHERE clause was added, the data was sorted differently, ignoring the ordering requested.

CR:473089

CR Number:   473089 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 10 Dec 2007 Fixed Description The performance of the sp_iqindex stored procedure degrades as the number of tables increases in Sybase IQ.

CR:473547

CR Number:   473547 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 3480 25 Jan 2008 Fixed 15.0 05 Sep 2008 Fixed Description A query that involves more than one Remote Procedure Call in the FROM clause could cause server failure. For example: SELECT col1 from remote_procedure_1() where col2 = (select c1 from remote_procedure 2())

CR:473728

CR Number:   473728 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2000 Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e03 1 27 Jul 2007 Fixed Description Under certain circumstances, an IQ server could not start with a freshly created IQ database using a raw partition on Windows.

CR:474007

CR Number:   474007 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 21 Dec 2007 Fixed Description Execution of a SELECT statement with invalid syntax causes an IQ server failure when a period is present, instead of a comma, between two items in a SELECT list in which the second item is an aggregation function.

CR:474371

CR Number:   474371 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Windows 2000 Original Version:   12.6 e10 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2008 Not a Bug Description Sybase Central Java and Sybase IQ plugin cannot create dbspace to a windows network drive.

CR:474620

CR Number:   474620 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   12.6 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Allow a function similar to rowid() for views

CR:474893

CR Number:   474893 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e11 12 Aug 2008 Fixed 15 Jul 2009 Fixed 12.6 e11 01 Sep 2008 Fixed Description Server should return an error instead of hanging, if incorrect data is being passed to the variable in the set command

CR:475766

CR Number:   475766 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e07 08 Jun 2009 Fixed 12.7 e07 22 Jul 2009 Added to user documentation 15.0 e01 10 Jul 2009 Fixed 15.2 28 Sep 2009 Added to user documentation Description The NOEXEC database option has been enhanced to support INSERT...VALUE, INSERT...SELECT, INSERT...LOCATION, SELECT...INTO, LOAD TABLE, UPDATE, TRUNCATE, DELETE, SYNCHRONIZE JOIN INDEX, and updatable cursor operations.

CR:476329

CR Number:   476329 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Suse Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e06 07 Jul 2009 Fixed Description On a default SLES 10 install, Novell moved the rawctl file from /dev to /dev/raw, and IQ fails to find it until it is either copied into /dev or softlinked in /dev. Now IQ will look into both /dev and /dev/raw to find the rawctl file. Workaround Description  softlink /dev/raw/rawctl to /dev/rawctl this however would need to be done after every reboot, unless the ln - s is placed into /etc/rc.d/rc.local file. or: Change the line in /etc/udev/rules.d/50-udev-default.rules KERNEL=="rawctl*", NAME="raw/%k", GROUP="disk" to KERNEL=="rawctl*", NAME="%k", GROUP="disk"

CR:476496

CR Number:   476496 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   12.6 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Provide option to find total space used by a particular user

CR:476598

CR Number:   476598 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Windows 2003 Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e06 10 Nov 2008 Fixed Description User will be allowed to add columns to existing tables through Sybase Ceneral

CR:477073

CR Number:   477073 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.6 e09.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 31 Jan 2008 Fixed Description Subqueries with a simple predicate could show poor performance if the predicate contains a BETWEEN condition in the WHERE clause and not all of the predicate arguments are constants.

CR:477187

CR Number:   477187 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   12.7 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Aug 2007 Consult Complete Description Union All parallel query is serial in Subsequent Fetches phase

CR:477501

CR Number:   477501 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Provide option in Insert...Location to move empty string as empty string

CR:477504

CR Number:   477504 Product Name:   IQ Product Component:   other Status:   Closed OS:   Windows XP Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 10 Dec 2007 Fixed Description A query involving a table with a multicolumn primary key joined to another table could cause the following exception in IQ 12.7 ESD #2 on Solaris and Windows: SQLCode = -1006000. This exception occurs when one condition in the join compares a column from the multicolumn primary key with an expression, rather than with a base column from the other table.

CR:477609

CR Number:   477609 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2007 Fixed Description Display an error when truncating column name in dbisql -nogui mode

CR:477612

CR Number:   477612 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   12.6 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Allow user to be able to select view B without the need to grant select permission on the based table in the view A

CR:477741

CR Number:   477741 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2007 Not a Bug 12.7 e04 09 Oct 2007 Added to user documentation Description Operations such as INSERT...VALUES, LOAD, and SYNCHRONIZE are not affected by the NOEXEC option because they do not include a query.

CR:477881

CR Number:   477881 Product Name:   IQ Product Component:   Sybase Central Status:   Open OS:   Windows 2000 Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description If you are using IP aliasing and have started your IQ server with the MyIP tcpip setting set to the alias IP address... for example -x tcpip{MyIP=10.50.7.70;port=6999} ... then if you try and connect from SC to the IQ server using an ODBC data source file (.dsn file), the connection works but you are not able to open the multiplex folder. Workaround Description  The work arounds are to either not use a DSN file name to connect , or do not use the MyIP tcpip parameter, or if you have to use the MyIP parameter then also specify the base host IP address.

CR:478439

CR Number:   478439 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The customer is waiting for release of "Multiplex management without Sybase Central."

CR:478486

CR Number:   478486 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 12 Oct 2007 Fixed 15.0 12 Oct 2007 Fixed 12.6 e11 16 Oct 2007 Fixed Description Restore fails with "not enough threads" if many stripes are involved in the restore. Workaround Description  Set MAX_IQ_THREADS_PER_CONNECTION & MAX_IQ_THREADS_PER_TEAM to a higher value as temporary option prior to doing the restore.

CR:478886

CR Number:   478886 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e11 31 Jul 2008 Fixed 12.6 e11 06 Nov 2008 Fixed Description Subqueries with a simple predicate could show poor performance if the predicate contains a BETWEEN condition in the WHERE clause and not all of the predicate arguments are constants. This has been fixed.

CR:478904

CR Number:   478904 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows XP Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e06 10 Jul 2008 Fixed 12.7 e06 22 Oct 2008 Fixed 15.0 e01 02 Dec 2008 Added to user documentation 15.0 e01 02 Dec 2008 Added to user documentation Description The maximum length of the string that the SORTKEY function can handle is 254 bytes. The length limit of 254 bytes is now enforced and a new error message "Function not supported for the string > 254" is reported.

CR:479443

CR Number:   479443 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows XP Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e06 21 Apr 2009 Fixed 12.7 e06 14 Jan 2009 Fixed 12.7 e07 17 Mar 2009 Fixed Description When Insert.. Location command was executed between two servers running on different collation, an error was thrown while trying to insert multi-byte characters. This fix handles such issues and inserts multi-byte characters using Insert.. Location.

CR:480255

CR Number:   480255 Product Name:   IQ Product Component:   Utility Status:   Closed OS:   Windows XP Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Nov 2008 One-off Provided Description iq_bcp may be unable to insert the data of the length defined as charactor column. And the data of a succession column cannot be inserted correctly, either. For example, an issue is reproduced on a table with the column of char (50), char (210), and int.

CR:480259

CR Number:   480259 Product Name:   IQ Product Component:   Utility Status:   Closed OS:   Windows XP Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Nov 2008 Presently Not Targeted For Any Future Release Of This Product Description iq_bcp inserts wrong Japanese data. Moreover, it may cause a conversion error. This issue relates to CR#480255.

CR:480994

CR Number:   480994 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e03.x 25 Sep 2007 Duplicate Description IQ server crashed in s_bufhash while trying to do a insert into a temp table

CR:481251

CR Number:   481251 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.6 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2008 Consult Complete Description execution of cleaner dll provided by eng returns "Invalid expression near rowid"

CR:481616

CR Number:   481616 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 3523 25 Jan 2008 Fixed Description If you attempt to revoke connect permissions from a user who still has an externlogin mapped, the server returns a foreign key error. Logging in as the user being dropped then results in incorrect user permissions. The server now returns an error that externlogins are still mapped for the user, leaving the user permissions unchanged. Workaround Description  Use 'DROP EXTERNLOGIN', not 'REVOKE CONNECT'.

CR:481633

CR Number:   481633 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Suse Original Version:   12.7 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 3565 05 Dec 2007 Fixed 15.0 26 Dec 2007 Fixed Description The following SQL statement could result in a Non-Fatal Internal IQ Error: select id, fname into #ltt from customer where id = -99; commit; create index hg0 on #ltt(id); savepoint S4; create index hg2 on #ltt(fname); drop table #ltt; Workaround Description  *** Friday, September 28, 2007 8:20:26 AM *** aldrich *** Avoid trying to create indexes on columns that don't exist, or let the local temp table drop at disconnect rather than dropping it explicitly.

CR:481648

CR Number:   481648 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 05 Dec 2007 Fixed 12.7 e04 07 Jan 2008 Fixed 15.0 21 Jan 2008 Fixed 15.0 05 Feb 2008 Fixed Description A query with a condition containing thousands of OR-ed equalities in the WHERE clause, plus a FROM clause containing a view whose definition had a UNION with numerous arms, takes an excessive amount of time to get through the optimizer.

CR:481807

CR Number:   481807 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.6 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jun 2010 Fixed 12.7 e06 21 Jun 2010 Fixed 12.7 e06 02 Dec 2008 Fixed 16 Dec 2008 Fixed Description In certain circumstances, using user defined functions as a parameter to a procedure call, may cause a server failure. The following conditions must be true: - a cursor is opened on a procedure call that returns a result set - a parameter to the procedure is a user-defined function call - the UDF issues a COMMIT Workaround Description  Nothing yet.

CR:481820

CR Number:   481820 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e10 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e11 19 Aug 2008 Fixed 12.7 e04 07 Dec 2007 Fixed 12.6 e11 01 Sep 2008 Fixed Description If a SELECT statement contains proxy tables and a procedure call to a procedure for that server cannot inline the procedure's SELECT statement (the first statement in the procedure is not a SELECT), the server could fail. This issue could also occur if the SELECT is used as a subselect in a DML statement. This issue is resolved.

CR:481890

CR Number:   481890 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Oct 2007 Duplicate Description Server stacktrace when trying to release memory, it is stemming from DestroyCursor. This appears to be a dupe of cr 466135.

CR:482143

CR Number:   482143 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2007 Consult Complete Description Query causes non-fatal stacktrace in dfo_ranking.cxx

CR:482317

CR Number:   482317 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Windows 2003 Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e09 19 Nov 2009 Fixed Description The Sybase IQ Administration Guide states: "The JDBC-based server classes are the only classes that can be used with 64-bit UNIX IQ servers." An asejdbc class is also supported by Windows x64.

CR:482387

CR Number:   482387 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 3565 07 Jan 2008 Fixed 15.0 3565 19 Dec 2007 Fixed 12.6 e11 31 Mar 2009 Fixed Description The server could fail when running queries containing 2000 or more OR-ed equality conditions over a view that contains a many-arm UNION. This has been fixed.

CR:482604

CR Number:   482604 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows XP Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 10 Dec 2007 Fixed 15.0 08 Jan 2008 Fixed 12.6 e11 02 Sep 2008 Fixed Description Attempting to extract a VARBINARY column greater than 255 in length results in the error "Data exception. Data conversion is not possible."

CR:482705

CR Number:   482705 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Solaris Original Version:   12.7 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 27 Feb 2009 DEFER 15.1 28 Apr 2009 Fixed Description systypes view uses allowsnull column instead of allownull

CR:482989

CR Number:   482989 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Windows XP Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e06 03 Sep 2008 Fixed 12.7 e06 17 Dec 2008 Fixed Description Sybase central allows a DBA to create a users with a space in the name, but cannot drop them. This is corrected.

CR:482990

CR Number:   482990 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Solaris Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 07 Jan 2009 Fixed Description Sybase Central. User cannot uncheck checkkbox "No default or computed value" on "Column property -> Value panel" , after checking it.

CR:483271

CR Number:   483271 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e10 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e05 09 May 2008 Fixed 12.6 e11 27 Aug 2008 Fixed 12.6 e11 06 Oct 2008 Fixed Description sp_iqcheckdb may show leaked blocks for a database on multiplex if the write server is started in read-only mode using the "-r" or "-iqro 1" server startup option. If sp_iqcheckdb does not report leaked blocks if the server is not started for read-only, there are no leaked blocks.

CR:483384

CR Number:   483384 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e07 25 Jun 2009 Fixed 15.1 e01 15 17 Apr 2009 Fixed 03 Aug 2009 Presently Not Targeted For Any Future Release Of This Product Description In some situations, a query containing a CASE expression with a HAVING clause reported Internal error at dfo.cxx (Cannot evaluate expression).

CR:483417

CR Number:   483417 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e10 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 2 31 Jan 2008 Fixed 05 Dec 2007 Presently Not Targeted For Any Future Release Of This Product Description In certain circumstances, connections can appear unresponsive while the server returns large strings or binary large objects. This problem is more likely to be encountered when using TDS.

CR:483455

CR Number:   483455 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 20 Dec 2007 Not reproducible with latest version of the product available as of Resolution Date 12.6 e11 15 Sep 2008 Fixed Description Under a heavy load, and while another connection is executing DDL statements, calls to a user-defined function could result in a server failure. This issue has been resolved.

CR:483767

CR Number:   483767 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows XP Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 04 Jan 2008 Fixed 15.0 15 Jan 2008 Fixed 12.7 e04 10 Dec 2007 Added to user documentation 15.0 17 Jan 2008 Duplicate 12.6 e11 09 May 2008 Presently Not Targeted For Any Future Release Of This Product Description If character data is extracted to a file when the TEMP_EXTRACT_QUOTES option is ON, the data cannot be loaded successfully if the data contains quotes. For example, if a column contains a'b'c, the extract file contains 'a'b'c', which cannot be loaded by the LOAD statement with QUOTES ON.

CR:483824

CR Number:   483824 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 3565 22 Jan 2008 Fixed Description xp_cmdshell fails on IQ 12.7 when iqtc+iqmc is bigger than a certain value. The failure occurs if iqmc+iqtc is large enough for the server to start, but enough memory is not left over for a fork() to execute. This issue varies by the amount of memory on the system and is specific to Solaris.