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

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

CR:484055

CR Number:   484055 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 06 Dec 2007 Fixed 15.0 23 Jan 2008 Fixed Description In rare circumstances, a complex query involving many derived tables and virtual columns could cause server failure in dfo::DFEMightBeNullHere().

CR:484204

CR Number:   484204 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 e04 11 Dec 2007 Fixed Description The DDL version for the ADO.NET 2.0 driver shipped with Sybase IQ 12.7 ESD #3 for Windows did not match the IQ build version. This issue has been resolved.

CR:484268

CR Number:   484268 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.7 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2009 Fixed 11 Sep 2009 Fixed 15.2 02 Feb 2010 Fixed Description Sqllog should log complete sql and not limit it to 32K The whole query text is now logged in the request log as compared to current limit of 32k. If the output of logging is directed to server log/console then only 32k size of query text will be logged. Stored procedure sa_get_request_times will truncate the request log record to 64k size.

CR:484702

CR Number:   484702 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) 29 Feb 2008 Fixed 12.7 e04 01 Feb 2008 Fixed 12.7 e04 29 Feb 2008 Fixed 12.7 e04 17 Mar 2008 Added to user documentation 15.0 14 Aug 2008 Fixed 15.2 08 Mar 2010 Added to user documentation Description The IQ server supports TDS password encryption when clients with this capability connect. However, clients shipped with Sybase IQ 12.7 do not support TDS password encryption. In order to use this feature, you must use Open Client 15.0 ESD #7 or later.

CR:484711

CR Number:   484711 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Solaris Original Version:   12.7 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Add functionality of IGNORE_DUP_KEY in IQ

CR:484934

CR Number:   484934 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to allow set option Temp_extract_NameN to have value larger than 127 characters.

CR:485021

CR Number:   485021 Product Name:   Sybase IQ ETL Product Component:   Installer Status:   Open OS:   Windows 2003 Original Version:   4.2.1 EBF #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Failed 16 May 2008 Presently Not Targeted For Any Future Release Of This Product Description Problem: The install and readme packaged with the product make reference to ETL Development 4.2.1 ESD#1. Workaround: Ignore the references to ESD#1 it should read ESD #2.

CR:485022

CR Number:   485022 Product Name:   Sybase IQ ETL Product Component:   Installer Status:   Closed OS:   Linux Red Hat Original Version:   4.2.1 EBF #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 May 2009 Fixed Description Problem: The uninstall script for Linux does not remove the products. Workaround: The user can delete the installation from the install directory manually.

CR:485316

CR Number:   485316 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e05 25 Apr 2008 Fixed Description When explicitly inserting values to the DEFAULT AUTOINCREMENT/IDENTITY column of a table is allowed, the "Tried to insert a duplicate value into a unique index" error will occur, if the user: 1. inserted N (an integer or an exact numeric type with scale 0) to the DEFAULT AUTOINCREMENT/IDENTITY column, and 2. inserted N-1 to the DEFAULT AUTOINCREMENT/IDENTITY column, and 3. tries to insert a value to another column of the table.

CR:485470

CR Number:   485470 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows 2000 Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 20 Feb 2008 Fixed Description When connecting to ASE or Microsoft SQL Server, the Remote Data Access layer was setting the QUOTED_IDENTIFIER option to ON at connect time, thus always quoting identifiers when querying data from ASE or SQL Server. Due to a restriction in the ASE server, always using quoted identifiers caused issues if the column name was 29 or 30 characters in length. Now, when connecting to ASE or SQL Server remote servers, the QUOTED_IDENTIFIER option on the remote server is set to match the local setting.

CR:485609

CR Number:   485609 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e05 11 May 2008 Fixed Description A query server may become unresponsive during multi-user tests and some multiplex verification tests. This has been fixed.

CR:485692

CR Number:   485692 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Solaris Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description customer request (Infoco N.V.)enhancement request for the AUDITING option to include userid / connection id information in the audit record created i.e. who is associated with the failed event being audited

CR:485694

CR Number:   485694 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request: Implement COUNT_BIG function for compatibility with MS Link Server

CR:485741

CR Number:   485741 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e05 07 May 2008 Fixed 15.0 15 Dec 2008 DEFER 20 Nov 2009 Fixed Description The current mechanism of generating query plans depends on a user connection to get the query text. Operations like event handling and triggers are connectionless, and with this fix, the query plan displays a more meaningful message "Statement text unavailable".

CR:485910

CR Number:   485910 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 Feature request: An error or warning when implicit conversion a numeric data into an integer.

CR:486216

CR Number:   486216 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.7 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 3 13 Apr 2008 Fixed 12.7 e05 3 04 Jun 2008 Fixed Description In the sql that follows, no rows are returned from "select * from #temp_t1". select * into #temp_t1 from sp_iqstatus(); select * from #temp_t1; This is incorrect and rows will be returned in 12.7 esd5.

CR:486261

CR Number:   486261 Product Name:   IQ Product Component:   Utility Status:   Closed OS:   Linux Red Hat Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jan 2013 Presently Not Targeted For Any Future Release Of This Product Description nogui dbisql does not display the notification message of login procedure.

CR:486491

CR Number:   486491 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.6 e10.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e05 19 May 2008 Fixed 12.6 e11 12 Aug 2008 Fixed Description A LOAD TABLE could possibly cause the server to stop processing, if the LOAD allocated more threads for processing than the number of indexes in the table. This problem rarely occurs. Workaround Description  Eng suggested to set fixed number of threads ( index count + 1) to prevent over allocated threads in loading. But this work-around cuased performance degradation bacause load peration goes single threads mode ( slow mode ). Due to it, customer doesn't accept to apply the suggested W/R.

CR:486663

CR Number:   486663 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Linux Red Hat Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 23 Jan 2008 Fixed Description Installing Linux 32-bit version of Sybase IQ on a Linux 64-bit system now selects the correct version of the SDK, when an ESD includes the SDK.

CR:487341

CR Number:   487341 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Solaris Original Version:   12.7 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e06 06 Nov 2008 Fixed 12.7 e04 12 Mar 2008 Fixed 12.7 e06 14 Nov 2008 Fixed Description On certain Sun Sparc machines, scjview fails to load libdbput9_r.so file, even though the file is available with proper permissions in lib directory. Workaround Description  rather than providing the db engine server name in the connection dialog, use host:port#.

CR:487417

CR Number:   487417 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 07 Jan 2008 Fixed Description A lock table attempt may give a different error from previous Sybase IQ versions. A simple sequence to illustrate the problem is user1: create table t1; lock table t1 in shared mode; user2: (who does not have select permission to user1.t1) lock table user1.t1 in exclusive mode; The lock table attempt by user2 used to report error "Permission denied: you do not have permission to alter t1.". In 12.7 ESD #4 and later, the lock attempt now returns error "User 'user1' has the row in 't1' locked."

CR:487710

CR Number:   487710 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Unknown Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to allow CONSTANT in the ORDER BY clause in the OLAP window.

CR:487746

CR Number:   487746 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   HP-UX Original Version:   12.6 e10 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When 'group by' is used by subquery in view, NULL attribute of column is reset.

CR:487747

CR Number:   487747 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   HP-UX Original Version:   12.6 e10 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When 'group by' is used by subquery in view, NULL attribute of column is reset.

CR:487748

CR Number:   487748 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   HP-UX Original Version:   12.6 e10 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When 'group by' is used by subquery in view, NULL attribute of column is reset.

CR:487749

CR Number:   487749 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   HP-UX Original Version:   12.6 e10 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When 'group by' is used by subquery in view, NULL attribute of column is reset.

CR:488335

CR Number:   488335 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   12.7 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 24 Jan 2008 Fixed 15.0 24 Jan 2008 Fixed Description A select with a scalar value subquery in the SELECT list causes server failure when a TOP qualifier or ROWCOUNT option is set with an ORDER BY clause, where the first entry is also an outer reference in the subquery. Workaround Description  Use dml_options2=8388608. There may be some modest performance impact.

CR:488546

CR Number:   488546 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e05 25 Jun 2008 Fixed Description IQ 12.7 server fails, when closing cursor.

CR:488964

CR Number:   488964 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e05 09 May 2008 Fixed Description Running the following commands using ISQL will cause tds protocol error: create table test_table (c1 int); go insert into test_table values (1); go alter table test_table add c2 bit not null default 0; go select * from test_table; go The error is: CT-LIBRARY error: ct_fetch(): protocol specific layer: external error: There is a tds protocol error. An illegal token was received. Workaround Description  Do not use isql for such alter commands. Use dbisql

CR:489037

CR Number:   489037 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2003 Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2008 Fixed Description IQ is downed without error message and stacktrace when a query including sum and group is executed. ===Fix by Engineering=== ( Imran ) IQ server crashed on "Group by" while costing was calculated as security_code_cookie check was inserted by MS VC for windows 64 bit platform. Care has been taken security cookie is not set any more for this function.

CR:489069

CR Number:   489069 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Windows XP Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2009 Fixed 12.7 e06 17 Nov 2008 Fixed Description BuildClient Name displaying internal build name on windows

CR:489234

CR Number:   489234 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Linux Red Hat Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e09 11 Oct 2009 Fixed Description Selecting from a view involving an outer join may cause an "An illegal token received" error. This has been fixed.

CR:489327

CR Number:   489327 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) 30 Jan 2008 Presently Not Targeted For Any Future Release Of This Product Description writer dbremote keeps sending messages to an excluded query server

CR:489624

CR Number:   489624 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 sp includes output parameter, execute immediate command fail. execute iimediate returns error of -946. Workaround Description  As a work around can you can use just any 'select statement' after the call to the procedure. eg. BEGIN DECLARE OUT1 VARCHAR(128); CALL sp_immediate(OUT1); SELECT 1234 from dummy; END Or there are other known obvious options like 1. doing select into <out_param> instead of assigning value to varable using SET 2. Using the result clause 3. Using cursors.

CR:489674

CR Number:   489674 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04.x 05 Jun 2008 Fixed 12.7 e05 19 Jun 2008 Fixed 15.0 14 Oct 2008 Fixed Description A server failure may result from memory corruption.

CR:490076

CR Number:   490076 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e06 31 Oct 2008 Fixed 12.7 e06 17 Feb 2009 Fixed Description A query involving a subquery may return incorrect results with a join index present. Workaround Description  Try to add additional column to join index and also see if the left and right tables can be interchanged.

CR:490477

CR Number:   490477 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description load table consistent messages when field that exceeded the limit of a column

CR:490478

CR Number:   490478 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description enhance "load table" for putting problematic data in one of the diagnostic files

CR:490480

CR Number:   490480 Product Name:   IQ Product Component:   Sybase Central Status:   Open OS:   Unknown Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description IQ 12.7 esd #3 , plugin 12.7.070907 gives error Invalid column index value 15 when using iAnywhere driver

CR:490797

CR Number:   490797 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e05 20 May 2008 Fixed 15.0 14 Oct 2008 Fixed Description Load was generating wrong identity values if extract column delimiter in the last row. Now identity values are generating correctly.

CR:490818

CR Number:   490818 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Unknown Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e06 07 Nov 2008 Fixed 12.7 e06 10 Nov 2008 Fixed Description If the constant 0.0 (one decimal separator and all digits zero) is used in the target list of a select INTO <permanent_table> statement, the statement fails with the "Syntax error near '0' on line 1". Workaround Description  1) use CAST() or CONVERT() function, for example: select dummy_col,CAST(0.00 as float(4)) as f_value into #S2 from iq_dummy; OR 2) Use expression instead of constant, for example select dummy_col, (0.00 * 1) as f_value into #S2 from iq_dummy;

CR:491041

CR Number:   491041 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows 2003 Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04.x 16 Apr 2008 Fixed Description Using a signed value for array indexing may lead to a negative index due to bad code optimization on Windows x64. This has been fixed.

CR:491070

CR Number:   491070 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows 2000 Original Version:   12.6 e10 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e11 19 Aug 2008 Fixed 12.7 e06 19 Nov 2008 Fixed 12.6 e11 05 Sep 2008 Fixed 15 Oct 2008 Fixed Description Derived table and proxy table give wrong correlation name.

CR:491377

CR Number:   491377 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) 14 Feb 2008 Duplicate Description document how to calculate resources needed for a split group by

CR:491480

CR Number:   491480 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04.x 05 Jun 2008 Duplicate 01 Feb 2010 Consult Complete Description The server may fail at s_buf.cxx:1534. This failure should not occur under normal circumstances. It has happened very rarely. In order to help determine the cause, in the event of a failure, diagnostics will be output to the iqmsg file.

CR:491483

CR Number:   491483 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Aug 2009 Presently Not Targeted For Any Future Release Of This Product 12.7 e10 18 Mar 2010 Added to user documentation Description The allowed value of the MAX_QUERY_PARALLELISM option is an integer less than, greater than or equal to number of CPUs. When MAX_QUERY_PARALLELISM is set, the number of parallel arms in a UNION GROUP BY can be greater than the number of CPUs.

CR:491609

CR Number:   491609 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) 12.7 e04.x 30 Apr 2008 Fixed 12.7 e04.x 07 Mar 2008 Fixed Description Queries of type select count(*) from ... where (((... is null) or (... in ...)) and ...) may cause the IQ server to crash. This is due to an attempt to write to a read-only bock map. In this case, a copy of the block map needs to be made and used. This has been fixed.

CR:491748

CR Number:   491748 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 e06 15 Jan 2009 Fixed Description Server fails at server.css:1192, signal 11 in hos_dfe_datetime_HOUR. This problem occurred while estimating cost of a correlated sub-query. The fix resolves cost estimation issue and query now runs without error.

CR:491779

CR Number:   491779 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Windows XP Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 12 Mar 2008 Fixed Description Silent install removes 12.4.3 install, but does not install 12.7 client

CR:491964

CR Number:   491964 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_iqcolumn does not include global temp table. sp_iqcolumn is made only for base table. Workaround Description  use sp_columns.

CR:491979

CR Number:   491979 Product Name:   IQ Product Component:   Utility Status:   Closed OS:   Windows XP Original Version:   12.7 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e04 17 Mar 2008 Fixed 12.7 e05 16 Jun 2008 Fixed 15.0 12 Jan 2009 Fixed Description On Windows 64-bit machines, running getiqinfo.bat gives the "asiqsrv12 is not running. Can not run stored procedures" error, and the subsequent 5 steps are missing. What's needed is the x64 version of Psapi.lib to build findproc.cxx. This has been fixed.

CR:492077

CR Number:   492077 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description SUBCASE NUMBER: 11409837-11 CUSTOMER NAME: RBC DOMINION SECURITIES ASIQ Version: IQ 12.7 esd #3 PLATFORM and OPERATING SYSTEM: Solaris BASIC INFORMATION: Customer will like to have some means that will show table names and blocks usage in TEMP space store (like ASE).

CR:492374

CR Number:   492374 Product Name:   IQ Product Component:   Utility Status:   Open OS:   Unknown Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description dbisql will not exit when connection is killed or onerror exit is used.

CR:492468

CR Number:   492468 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.6 e10 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e11 09 Jul 2010 Fixed 12.7 e05 29 Jun 2008 Fixed 12.6 e11 26 Aug 2008 Fixed 12.7 e05 10 Jul 2008 Fixed Description IQ shut down with a fatal error because a call to pthread_mutex_destroy returned EBUSY. As a part of fix we raised an exception string and report the value returned by the call to pthread_mutex_destroy , in this way, we are ignoring the EBUSY return .

CR:492507

CR Number:   492507 Product Name:   IQ Product Component:   Utility Status:   Closed OS:   Unknown Original Version:   12.7 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e06 15 Jul 2009 Fixed Description On Windows, the FINDIQVER utility returned 32bit for a 64bit installation.

CR:492996

CR Number:   492996 Product Name:   IQ Product Component:   Utility Status:   Closed OS:   Linux Red Hat Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2009 Not a Bug Description The IDLE option is not included in Admin Script which Sybase Central generated. The dbremote connection started from script will be disconnected in default timeout of IQ. But the dbremote connection started from Sybase Central is not disconnected by timeout. Please modify script, if timeout is prevented. "idle#0" is added to a SQLCONNECT variable. Workaround Description  "idle#0" is added to a SQLCONNECT variable.

CR:493414

CR Number:   493414 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Unknown Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e09 18 Sep 2009 Not a Bug Description The bitwise operators are defined for integer and bit array data types only. They are not defined for bit type. Because of this, the input operand of the bit negation operation is casted to integer first. After applying the bit negation, we try to cast the resulting integer value to bit again, which does not work.

CR:493441

CR Number:   493441 Product Name:   Sybase IQ ETL Product Component:   ETL Connectivity Status:   Closed OS:   Windows XP Original Version:   4.2.1 EBF #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2008 Fixed 23 Jun 2008 Fixed 10 Jun 2008 Fixed Description A new keyword has been introduced for the Default.ini file. The keyword is 'timeout' and it belongs in the Network area of the .ini file. The valid values for timeout are specified in seconds in a range from 1 second to 2,147,483 seconds. An extract of the Default.ini file contents shows the appropriate syntax. For more details on default.ini contents, refer to the User's Guide. ==Begin snippet of default.ini====== # The timeout setting must be in the # Network section. The beginning of the # Network section is defined by the line below. [Network] timeout=3600 =End snippet of default.ini=========== Please note this timeout affects only the ETL software acting as an ftp client. This timeout value will not affect any timeout setting that are defined on the ftp server or enforced by the network at the TCP layer.

CR:493563

CR Number:   493563 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e05 28 Apr 2008 Fixed 15.0 14 Oct 2008 Fixed Description SELECT COUNT (*) may return incorrect results in a UNION ALL view. Workaround Description  *** Monday, April 07, 2008 8:09:51 AM *** aldrich *** set option dml_options4=1024; or set as temporary option.

CR:493567

CR Number:   493567 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Windows XP Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 19 Jun 2008 Added to user documentation Description row_number () is not supported in the current IQ version when used in OLAP context

CR:494004

CR Number:   494004 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Feb 2010 Added to user documentation 25 Feb 2010 Added to user documentation Description Adjusting FS cache on RH4 and RH5 to reduce performance problems High FS cache on Red Hat 4 and Red Hat 5 impacts concurrent transactions on IQ 12.7. FS-Cache is a kernel facility by which a network filesystem or other service can cache data to improve performance. Because the current transaction version in IQ 12.7 is released only after the FS cache is totally flushed to disk, a high FS cache can impact concurrent transactions. Reducing the vm.dirty_background_ratio and vm.dirty_ratio parameters increases the number of flushes, but decreases the duration. Shorter flush times release the current IQ version more quickly and reduce performance problems. Note -- Red Hat 4 has no configuration parameter to limit FS cache size. In Red Hat 4, FS cache depends on machine memory. -- With Red Hat 5, this should be worked around by enabling direct I/O on the OS level to disable FS caching (not available in RH4).

CR:494230

CR Number:   494230 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Too Many UNION ALL requires time for creation of a query plan. Workaround Description  There is no workaround for the long time taken to gather the query plan. Once the query is established and working properly, don't request the query plan.

CR:494668

CR Number:   494668 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Linux Red Hat Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e06 09 Oct 2008 Fixed 15.0 09 Oct 2008 Fixed Description A query involving DISTINCT, GROUP BY, and ORDER BY that had a SQL error could return a confusing error. A correct error message is now returned. Workaround Description  The column set to be DISTINCT and ORDER BY is made the same.

CR:494972

CR Number:   494972 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   12.7 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e05 25 May 2008 Fixed Description The following SELECT executed against the asiqdemo database would cause the server to fail. select * from (select top 2 cust_id = rowid(t) from sales_order)t;

CR:495183

CR Number:   495183 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description IQ cannot execute the next SQL. It is ANSI. However, ASE can execute the same SQL. The customer expects that the T-SQL function of IQ nears ASE. 1. select distinct a from tab1 group by a,b order by a,b;2. select distinct a from tab1 order by a,b;

CR:497147

CR Number:   497147 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows XP Original Version:   12.7 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e06 12 Nov 2008 Not reproducible with latest version of the product available as of Resolution Date Description Windowing query with multiple columns in "partition by" clause was returning incorrect results. This issue is fixed now and correct results are returned regardless the number of columns in the "partition by" clause.

CR:497149

CR Number:   497149 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e06 03 Nov 2008 Fixed Other 24 Jul 2008 Fixed 12.7 e06 29 Jan 2009 Fixed Description Attempting to start a database with -iqro flag may fail to start with a Sybase IQ Abort error.

CR:497725

CR Number:   497725 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   SunOS Original Version:   12.7 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e05 30 May 2008 Fixed 15.0 09 Sep 2008 Fixed 12.7 e04.x 05 Jun 2008 Fixed Description Fetch from a hold cursor could return a wrong answer. As an example (in pseudo code): drop table xxx; create table xxx( c1 int ); open curs1 { select * from xxx }; insert into xxx values(1); open curs2 { select * from xxx }; insert into xxx values(2); open curs3 { select * from xxx }; insert into xxx values(3); open curs4 { select * from xxx }; commit; print 'cursor1 ======' loop { fetch curs1 relative 1 into c1 if SQLCODE = SQLE_NOTFOUND then { break loop } endif print 'c1 = ', c1 } endloop print 'cursor2 ======' loop { fetch curs2 relative 1 into c1 if SQLCODE = SQLE_NOTFOUND then { break loop } endif print 'c1 = ', c1 } endloop print 'cursor3 ======' loop { fetch curs3 relative 1 into c1 if SQLCODE = SQLE_NOTFOUND then { break loop } endif print 'c1 = ', c1 } endloop print 'cursor4 ======' loop { fetch curs4 relative 1 into c1 if SQLCODE = SQLE_NOTFOUND then { break loop } endif print 'c1 = ', c1 } endloop When running the script, the following results are produced cursor1 ====== cursor2 ====== c1 = 1 cursor3 ====== c1 = 1 cursor4 ====== c1 = 1 c1 = 2 c1 = 3 The results for cursors 1, 2, and 4 are correct. The results for cursor3 are incorrect. Cursor3 needs to see rows with values 1 and 2; not just 1.

CR:498713

CR Number:   498713 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e01 4 26 Aug 2009 Added to user documentation 17 Jun 2009 Fixed Description In earlier versions of Sybase IQ, running the stored procedure sp_iqdbspaceinfo on the entire database generated an error if any dbspace in that database was offline. In Sybase IQ 15.1 esd 1 and later, no error is reported if a dbspace is offline. The dbspace_online column was added to the output of the sp_iqdbspaceinfo stored procedure. A value of Y means that the dbspace is online and that the procedure returned data for that row. A value of N means that the dbspace is offline, meaning that the procedure was unable to return data for that row, and reports 0B (0 bytes) for those data values. The dbspace_id column was added to the output of the sp_iqdbspaceobjectinfo stored procedure. If you upgraded the server from a version earlier than 15.1 esd 1, you must run ALTER DATABASE UPGRADE on existing databases. If you do not upgrade the database, running the sp_iqdbspaceinfo stored procedure results in a Procedure no longer valid error.

CR:498862

CR Number:   498862 Product Name:   IQ Product Component:   other Status:   Closed OS:   HP-UX Original Version:   12.7 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e05 4 26 May 2008 Fixed Description Database names are limited to 40 bytes when the limit should be 250. This issue has been resolved.

CR:498912

CR Number:   498912 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Unknown Original Version:   12.7 future Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e07 17 Jun 2009 Fixed 15.1 e01 17 Jun 2009 Fixed 15.1 e01 24 Aug 2009 Fixed Description stop_iq and stop_asiq have a new parameter: -version. Use this parameter to find either 12.x IQ servers and agents, 15.x IQ servers and agents, or both. Default remains the same: stop_asiq finds 12.x servers by default, and stop_iq finds 15.x servers by default. 12.7 Usage: stop_asiq -version [12|15|all] 15.1 Usage: stop_iq -version [12|15|all]

CR:499172

CR Number:   499172 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows 2000 Original Version:   12.7 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When the multi-byte character which has '5c' in a remote table name is included, IQ cannot define correct remote_location. Workaround Description  Please create view with an English name. And please set view to be proxy table.

CR:499234

CR Number:   499234 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   SunOS Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 e01 16 Mar 2009 Fixed Description In SCJ:Information regarding Referential integrity constraints and Constraints will now be visible in the corresponding tabs.

CR:499572

CR Number:   499572 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 Utility to reset the DBA password in IQ catalog if the password is forgotten

CR:500305

CR Number:   500305 Product Name:   IQ Product Component:   Utility Status:   Open OS:   Solaris Original Version:   12.7 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description defncopy ( 5.0/P-EBF13575 ESD #4 ) from IQ 12.7 esd #4 exports stored procedure ddl incorrectly.

CR:523750

CR Number:   523750 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2009 Fixed Description IQ was getting an data type conversion error while trying to cast an empty string as double. The error was as follows - "Data exception - data type conversion is not possible". This error is fixed now.

CR:523752

CR Number:   523752 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description IQ 12.7 improve error message -1001006 ( Data exception - data type conversion)

CR:528319

CR Number:   528319 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 Oct 2008 Fixed 12.7 e06 25 Nov 2008 Fixed 12.7 e06 15 Jul 2009 Fixed 15.0 04 Mar 2009 Fixed Description The server may fail in st_cursor::GetCursorDetailUtilityInfo -> hos_strncpy() when multiple cursors are being opened and destroyed and information on cursors is being collected by sp_iqcontext.

CR:528569

CR Number:   528569 Product Name:   IQ Product Component:   Utility Status:   Closed OS:   Solaris Original Version:   12.7 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2009 Presently Not Targeted For Any Future Release Of This Product Description iq_bcp cannot copy data to a table with a lot of columns.

CR:529339

CR Number:   529339 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   12.7 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e05 20 May 2008 Added to user documentation Description Database names are limited to 40 bytes when the limit should be 250. This issue has been resolved.

CR:529798

CR Number:   529798 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Unknown Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 e01 06 Mar 2009 Fixed Description In SCJ: Create database wizard will not allow user to assign a server port, which is already in use.

CR:530012

CR Number:   530012 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.6 e11 12 Aug 2008 Fixed 12.7 e05 22 Jun 2008 Fixed 15.0 24 Sep 2008 Fixed 12.7 e04.x 05 Jun 2008 Fixed Description The platform-dependent limit on maximum virtual address space has been removed for 64 bit platforms Windows64, IBM Linux, and Linux64 AMD.

CR:530468

CR Number:   530468 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Windows XP Original Version:   12.7 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e06 20 Aug 2008 Fixed 12.7 e06 19 Dec 2008 Fixed 15.0 03 Mar 2009 Fixed Description Using Sybase Central, the Create Table statement produced by copying a Table definition with a primary key constraint could have incomplete SQL that would return a syntax error when executed. This has been corrected.

CR:530516

CR Number:   530516 Product Name:   IQ Product Component:   Utility Status:   Open OS:   Unknown Original Version:   12.7 future Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer (LEHMAN BROTHERS INC on 12.7 on solaris) would like a utility similar to the UDB db2ckbkp utility which will enable them to verify that a IQ backup is valid and restorable.

CR:531097

CR Number:   531097 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.7 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e05 3648 10 Jul 2008 Fixed 12.7 e05 3648 06 Jun 2008 Fixed 15 Apr 2009 Not reproducible with latest version of the product available as of Resolution Date Description If an Open Client or jConnect application executed a query that involved the use of host variables within a batch, then the server would have failed. This has been fixed so that the query now correctly fails with the error message "Host variables may not be used within a batch".

CR:531331

CR Number:   531331 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e05 03 Jul 2008 Fixed 15.0 03 Jul 2008 Fixed 12.7 e05 23 Jul 2008 Fixed 15.0 16 Oct 2008 Fixed 05 Jun 2013 EOL'd version. Not to be Fixed. Description Unable to backup a database built on raw partitions on Linux if raw partition's sector size is 4096.

CR:531717

CR Number:   531717 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 19 Mar 2010 Fixed 12.7 e07 15 Oct 2008 Fixed 12.6 e11 15 Oct 2008 Fixed Description The Sybase IQ Utility Guide documentation for the Backup utility (dbbackup) is incomplete. The option -xo should not be used in multiplex systems and the Sybase IQ servers must be stopped when -xo is used.

CR:531757

CR Number:   531757 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.7 e04.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Sep 2008 Insufficient priority to fix Description As a further enhancement to CR's 396843 and 499055 the customer would like to be able to use the new LOAD TABLE DEFAULTS ON option to do partial-width insertions in tables with an autoincrement without having to change the auoincrement column to allow nulls.

CR:531820

CR Number:   531820 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.7 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e06 05 Dec 2008 Fixed 12.7 e06 19 Dec 2008 Fixed Description In IQ versions 12.7esd4 and later, sp_password doesn't work correctly. Original sp_password syntax is 'sp_password caller password, new password, [userid]'. In case if 'SQL' is DBA's password, executing command as "sp_password 'DBA', 'abcd'", does not give the syntax error message and changes the DBA's password to new password without verifying the old one. Workaround Description  See sp_password source and check if password verification line is missing or not. It should have following line ... call dbo.sa_verify_password( isnull( @caller_pswd, '' ) ) In case of being missing above, re-create 'sp_password' procedure with right source from 'iqprocs.sql'.

CR:532151

CR Number:   532151 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e04 17 Jun 2008 Fixed 12.7 e05 09 Sep 2008 Fixed 12.6 e11 09 Sep 2008 Fixed Description On HP-UX, when a client application connect to IQ and aborts the connection while IQ is in the process of accepting the connection, IQ's listener thread aborts and no further connections can be made.

CR:532396

CR Number:   532396 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Unknown Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer has a process where they backup their dtabase and restore it with renames on a different location. There is currently no supplied way or utility to rename the .db catalog file. The way to do this is a simple OS rename of the file and change the IQ startup scripts to point to the new name. However the entry for the name of the .db file is still stored in the SYSFILE system table as the original file name so when you look at the dbspace info in SC you still see the old names. We need a utility or method of changing the name of the ctalog store cleanly and fully.

CR:532409

CR Number:   532409 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Original Version:   future Fixed Version Build Resolution Date Closure Code (If Appropriate) Description customer is after a feature request in IQ similar to Database Resource Manger in Oracle where they can set up user groups that have for example the ability to be guaranteed resources allocations. E.g. usergroup1 gets 80% of the CPU and usergroup2 only 20%.

CR:533250

CR Number:   533250 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   AIX Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2008 EOL'd version. Not to be Fixed. 12.7 e05 14 Jul 2008 Fixed 12.7 e05 18 Jul 2008 Fixed Description If a TCP/IP connection attempts to connect to IQ and the connection attempt terminates before IQ completes its accept processing, the IQ thread dies and cannot be used again by the server. Existing connections continue to work correctly.

CR:533545

CR Number:   533545 Product Name:   IQ Product Component:   other Status:   Closed OS:   Solaris Original Version:   2.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jun 2008 Duplicate 12.7 e06 09 Jan 2009 Fixed 15.0 26 Jan 2009 Fixed Description Debugging a stored procedure from SC caused the iqmsg file to fill rapidly with Txn-Cmt-PostCmt messages.

CR:533619

CR Number:   533619 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 e09 05 Jan 2010 Fixed Description Backup allocates an array of 2048 byte buffers to use for backup. The array is sized to the number of threads participating in the backup and each thread will work one of the buffers in the array. LINUX requires that the size of the transfer for read and write must be an integral multiple of the device's blocksize. For a disk, this is its sectorsize, which is normally 512 bytes. The other valid sectorsize values are 1024 and 2048. A blocksize of 4096 will not work. You may use any of these values: 512, 1024 or 2048. Then, provided raw partitions are correctly setup, IQ backup and restore are successful.

CR:533695

CR Number:   533695 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.x 18 Aug 2008 Fixed 12.7 e06 18 Aug 2008 Fixed 12.7 e05.x 15 Jul 2009 Fixed 12.7 e06 16 Dec 2008 Fixed 15.0 30 Jan 2009 Fixed Description If dbbackup is started and cannot complete its task, an orphan transaction will be left on the server and no further checkpoints will occur until the server is restarted.

CR:533736

CR Number:   533736 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jul 2008 Work as design 12.7 e10 16 Mar 2010 Fixed Description Upgrading databases may change system table definitions and certain features may be unavailable. Use ALTER DATABASE UPGRADE to upgrade databases, but for limitations, see SQL Anywhere 11.0.1 > SQL Anywhere Server - Database Administration > Administering Your Database > Database administration utilities > Upgrade utility (dbupgrad). Sybase IQ does not support the dbupgrad utility.

CR:533956

CR Number:   533956 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows XP Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 future 13 Jul 2009 Not reproducible with latest version of the product available as of Resolution Date Description The IQ plugin is now registered for dbisql as part of the install.

CR:534171

CR Number:   534171 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e09 13 Oct 2009 Fixed 15.1 e01 17 Apr 2009 Fixed Description Output of the Join Node of the query containing outer join and large nested CASE statements was blank. Now the output of the Join node contains the required entry.

CR:534316

CR Number:   534316 Product Name:   Sybase IQ ETL Product Component:   other Status:   Closed OS:   all Original Version:   4.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Sep 2008 Fixed Description Problem: The ETL Engine Monitor memory foot print grows over a period of time. Resolution: This was resolved by modifying our garbage collection, clearing unused objects and removing the saving of some unneeded diagnostic information in memory.