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

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

CR:443135

CR Number:   443135 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Solaris Original Version:   12.6 future Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Nov 2006 Duplicate Description DBD::ASAny is not included in IQ for UNIX. Please access the following URL, when you use DBD::ASAny with IQ. http://www.sybase.com/detail?id=1009063 Workaround Description  DBD::ASAny is downloaded from CPAN site.

CR:443138

CR Number:   443138 Product Name:   IQ Product Component:   other Status:   Closed OS:   Solaris Original Version:   12.6 future Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Nov 2009 Fixed Description perl interface(DBD::ASAny) is explained to New Features in Sybase IQ 12.6. But DBD::ASAny must install ASA. This driver cannot be used only by IQ.

CR:443179

CR Number:   443179 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.8 05 Dec 2006 Fixed 12.7 e02 16 Nov 2006 Fixed Description If the schema changed for one or more of the tables that participate in a join index, then subsequent operations involving tables in the join index could report an error from db_joinindex_id.cxx.

CR:443300

CR Number:   443300 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 ability to log in and reset an expired password like in ASE.

CR:443448

CR Number:   443448 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows 2000 Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Oct 2006 Duplicate Description Customer has a query with a convoluted set of nested AND clauses which include DATE comparison and conversion arguments. If there is an incorrect date format entered into the query it crashes the server instead of throwing an error message. This is a regression of behaviour that has come into the 12.6. ESD and 12.7 codeline (prior to 12.6 esd7 the ASA Error -157 with SQLSTATE = ' 53018' error message is thrown OK).

CR:443840

CR Number:   443840 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Unknown Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e02 17 Jan 2007 Fixed Description When using Sybase Central to connect to a IQ server running on Linux using an aliased IP address, the Multiplex folder did not open or could not be selected, preventing adding new query servers.

CR:443846

CR Number:   443846 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 20 Apr 2007 Fixed 15.0 1 24 May 2007 Fixed Description After upgrading from IQ Release 12.6, or earlier, to IQ Release 12.7 or later, sp_iqrelocate might report an -1006002 "IQ internal error" on any table that contains a column with NULL values, if that table has not been modified since the upgrade. Workaround Description  Date: Mon, 9 Apr 2007 10:57:21 -0400 (EDT) From: Kurt Deschler <kdeschle@sybase.com> To: Radha Srinivasan <radha@sybase.com> cc: Roland McKenney <rmckenne@sybase.com>, Tamilla I Talishinskaya <tamilla@sybase.com> Subject: Re: Reproduction of CR# 443846 This problem occurs when sp_iqrelocate opens an FP index readwrite for the very first time since the database has been started with 12.7. The problem is that opening the column readwrite instantiates a column nulls bitmap and leaves it in a state that sp_iqrelocate is not expecting. The workaround is to force all columns to be opened RW using empty update statements per the following example. This can be done safely for all tables in the database using the following SQL: ----- begin declare updstmt varchar(255); declare curs cursor for select 'update "'||sysusers.name||'"."'||table_name|| '" set "'||column_name||'"="'||column_name||'" where 0 = 1;' from systable,syscolumn,sysusers where systable.table_id = syscolumn.table_id and sysusers.uid=systable.creator and file_id = 16384; open curs with hold; lp: loop fetch curs into updstmt; if SQLCODE <> 0 then leave lp; end if; message updstmt to console; execute immediate updstmt; commit; end loop; close curs; end; ----- Once the existing (pre-12.7) tables have been updated, this problem should not re-occur. Regards, Kurt and Roland Kurt Deschler Sybase IQ DML Group kdeschle@SYBASE.COM (978)-287-1760

CR:443851

CR Number:   443851 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) 12.6 e08 12 Oct 2006 Fixed 11 Oct 2006 Fixed 12.7 e01 23 Oct 2006 Fixed Description Under certain circumstances, a DELETE statement involving a view or derived table in the FROM clause that used the same table alias as the delete table, may delete rows from the view or derived table with the duplicate alias. In order for the issue to occur, all of the following conditions must be true: 1)The DELETE statement has a FROM clause with multiple entries and one of those entries is a view or derived table; 2) An identical alias is used for both the delete table and a table in the view or derived table; 3) The delete table precedes the view or derived table in the FROM clause; 4) The view or derived table does not contain a DISTINCT clause, GROUP BY clause or any aggregates in its select list; and 5) The DELETE statement determines there are rows to be deleted based on the statement criteria. Workaround Description  Make sure you are not using the same alias in the delete that could have been used in the view (which is part of the delete sql)

CR:443862

CR Number:   443862 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 e02 20 Dec 2006 Fixed 12.8 01 May 2007 Fixed Description If a query contains multiple aggregate functions (aggregate on different arguments) that contains NULL values, an error from dfe_MinMaxAggregate.cxx could be reported.

CR:443878

CR Number:   443878 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 1 27 Jul 2007 Fixed Description On Windows, the iqheader utility did not work on RAW partitions.

CR:444016

CR Number:   444016 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   future Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Nov 2006 Duplicate Description NFR:MINUS support like UNION[ALL], INTERSECT.

CR:444430

CR Number:   444430 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Linux Red Hat Original Version:   12.6 e06.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e08 21 Nov 2006 Fixed 12.7 e02 28 Nov 2006 Fixed 12.7 future 05 Dec 2006 Fixed Description Under rare circumstances, a query containing a SELECT TOP could return fewer rows than specified.

CR:444471

CR Number:   444471 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows NT Original Version:   12.6 e06.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e02 01 Feb 2007 Fixed Description Column is returned as nullable even if it was created as non-nullable.

CR:444887

CR Number:   444887 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   12.6 e06.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e08 02 Nov 2006 Fixed Description A server could fail with a signal 11 if the HG index was used to evaluate a range and the PBV algorithm was selected.

CR:445745

CR Number:   445745 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e09 04 Jan 2007 Fixed Description Inserting a string larger than the column size and having a SELECT in the INSERT caused a non-fatal stack trace in df_Heap.cxx. Workaround Description  Use INSERT INTO <tablename> values <columns> instead of using a SELECT in the INSERT.

CR:446054

CR Number:   446054 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows NT Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2009 Fixed Description ODBC API SQLGetTypeInfo returns wrong SQL data type value with ODBC 3.x.

CR:446660

CR Number:   446660 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e06 09 Jul 2010 Fixed 12.7 e06 22 Jan 2009 Fixed Description If a temporary store dbspace UFS file is accidentally overwritten by another file, then the server will detect the damage and not start. In this event, the server will report "Unexpected throw from IQ command" and a message will be logged into the iqmsg file: To repair this,start the server with the '-iqnotemp' switch and drop the affected temporary dbspace. Then shutdown and restart the server normally.

CR:446704

CR Number:   446704 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Solaris Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2008 Presently Not Targeted For Any Future Release Of This Product Description Incorrect tar file names in the readme provided with download for IQ 12.7 32 bit odbc driver kit

CR:446942

CR Number:   446942 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2007 Fixed Description Invalid query with missing group by clause and an invalid expression could result in a server failure

CR:446953

CR Number:   446953 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 e02 04 Dec 2006 Fixed 12.8 04 Dec 2006 Fixed Description A UNION all view with multiple NULL values doesn't return expected rows. Workaround Description  See CR description

CR:446964

CR Number:   446964 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e08 20 Nov 2006 Fixed Description DROP VIEW from a query server resulted in a misleading error message.

CR:446967

CR Number:   446967 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.6 e06.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2007 Not a Bug Description option TEMP_EXTRACT_NAME1 allow user to output the file to local to client

CR:446968

CR Number:   446968 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.6 e06.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.8 12 Dec 2006 Fixed 12.7 e02 06 Dec 2006 Fixed 12.7 e02 19 Dec 2006 Fixed 12.7 e02 20 Mar 2007 Fixed Description Column headings in isql and dbisql were inconsistent when calling the same procedure.

CR:447061

CR Number:   447061 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 e02 16 Jan 2007 Fixed Description The start_asiq utility referred to "hard-coded" logfiles directory.

CR:447069

CR Number:   447069 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   SunOS Original Version:   12.6 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e08 20 Nov 2006 Fixed 01 Dec 2006 Fixed Description Propagating ALTER TABLE RENAME to query servers caused running query servers to abort if the table_id of the table being renamed was greater than 65535. The workaround for this problem is to manually stop and synchronize all query servers after performing an ALTER TABLE RENAME on a table with table_id greater than 65535.

CR:447374

CR Number:   447374 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Solaris Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 09 Nov 2006 Not a Bug Description Add documentation for dblic in IQ docs

CR:447454

CR Number:   447454 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Unknown Original Version:   12.6 e06.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e08 17 Nov 2006 Fixed Description Tape diagnostic messages should only be reported to the console.

CR:447914

CR Number:   447914 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) 12.7 e02 09 Jan 2007 Fixed 12.6 e09 09 Jan 2007 Fixed Description Select statement without a FROM clause in UNION ALL returned error intcode: -121 "Permission denied: you do not have permission to select from view01".

CR:447918

CR Number:   447918 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 e02 06 Dec 2006 Fixed 12.8 08 Dec 2006 Fixed 12.8 16 Feb 2007 Fixed Description A query involving a view that was a UNION ALL of two SELECTs in the FROM clause and a date comparison in conjunction with an OR operator could cause server failure.

CR:447992

CR Number:   447992 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Linux Red Hat Original Version:   12.6 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) future 16 Nov 2006 Presently Not Targeted For Any Future Release Of This Product Description Quick Reference manual of Sybase IQ does not exist.

CR:448072

CR Number:   448072 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.7 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e02 02 Feb 2007 Fixed 12.8 06 Feb 2007 Fixed Description If a SQL code contains accented characters, the SQL running through ODBC may produce a stack trace in function dfo_cOrderBy.cxx 311 Workaround Description  ODBC can not be used for such SQL.

CR:448140

CR Number:   448140 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Linux Red Hat Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 05 Mar 2009 Insufficient priority to fix Description IQ cannot debug procedure by multiple users. As for debugging work, only single user is allowed.

CR:448232

CR Number:   448232 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Windows 2000 Original Version:   12.7 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2006 Presently Not Targeted For Any Future Release Of This Product Description ddl generated using IQ plugin for a dbspace does not contain file size

CR:448244

CR Number:   448244 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   AIX Original Version:   12.6 e06.x Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Support encrypted password feature with ASEJDBC remote class

CR:448641

CR Number:   448641 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) Description The JRE patch level has been updated to resolve a situation where the implementation of RSA signature verification in SSL/TLS or other application scenarios may incorrectly verify forged signatures leading to security vulnerability.

CR:448642

CR Number:   448642 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 e08 14 Dec 2006 Fixed Description The JRE patch level has been updated to resolve a situation where the implementation of RSA signature verification in SSL/TLS or other application scenarios may incorrectly verify forged signatures leading to security vulnerability.

CR:448736

CR Number:   448736 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Solaris Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 04 Dec 2006 Presently Not Targeted For Any Future Release Of This Product Description Include complete patch list in addition to RPK

CR:448737

CR Number:   448737 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Solaris Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e02 14 Jan 2007 Fixed 12.8 17 Jan 2007 Fixed Description The sybinstall utility failed to recognize existence of LD_LIBRARY_PATH and LD_LIBRARY_PATH_64 variables.

CR:448901

CR Number:   448901 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 e02 06 Dec 2006 Fixed 12.8 06 Dec 2006 Fixed Description sp_iqindexadvice may cause server failure if the option Index_Advisor_Max_Rows is set to a value larger than 30 and the server accumulates at least 30 distinct advice messages.

CR:449116

CR Number:   449116 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 e09 19 Dec 2006 Fixed Description A query on a column with a two-byte FP index and 65536 distinct values might incorrectly return no rows. Workaround Description  The work around in this case is to convert the 2 Byte FP Index on the column to a Flat FP. There is no direct way of doing this. We suggest the following: 1) Customer adds one new row with a dummy distinct value in the actual_end_time column. They will need to add just one more distinct value as there are already 65536 distinct values. 2) Verify that they have a flat style FP on the actual_end_time column. 3) Remove the row that was added with a dummy value.

CR:449393

CR Number:   449393 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e09 20 Dec 2006 Fixed Description The following combination of conditions could result in a IQ server failure with stack trace: - a stored procedure references a user-defined function in the search-condition of an IF statement - the function calls a procedure with OUTPUT or INOUT parameters - the function then calls another procedure

CR:449501

CR Number:   449501 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) 12.6 e09 07 Jan 2007 Fixed Description Updating a column with a LF index in an upgraded database experienced slow performance. The performance penalty depended on the number of distinct values in the LF and the number of rows to be updated. Workaround Description  *** Monday, December 04, 2006 3:16:39 PM *** vbhaskar *** As suggested in customer case 11202426, replacing LF index with HG index works fine.

CR:449513

CR Number:   449513 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.8 17 Jan 2007 Fixed 12.7 e02 17 Jan 2007 Fixed 12.7 e02 22 Jan 2007 Fixed Description Under certain circumstances, a query containing a correlated subquery could report a non-fatal error "cannot evaluate expression" depending on the cardinality of the data.

CR:449521

CR Number:   449521 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Unknown Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e09 20 Dec 2006 Fixed 12.7 e02 13 Dec 2006 Fixed Description Insert into a local table with a select from a derived table where the derived table involves both local and remote tables may cause server failure.

CR:449573

CR Number:   449573 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jan 2007 Presently Not Targeted For Any Future Release Of This Product Description Ability to load space & zero-length columns at the same time

CR:449578

CR Number:   449578 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e10 27 Mar 2007 Fixed 12.7 e02 07 Mar 2007 Fixed Description If the ROWID function was used on an alias to a view, then server failure occurred instead of reporting the error that ROWID over a view is not supported.

CR:449707

CR Number:   449707 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Unknown Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e09 12 Jan 2007 Fixed 12.7 e02 13 Dec 2006 Fixed Description When executing a .NET application that executes a stored procedure, the second time the application was executed, a "cursor not open" error was reported.

CR:449762

CR Number:   449762 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 e09 14 Jan 2007 Fixed 12.7 e02 14 Jan 2007 Fixed 12.6 e09 18 Jan 2007 Fixed 12.7 e02 26 Feb 2007 Fixed Description IQ server failure or an unresponsive server on shutdown could randomly occur when the thread memory size allocated on server startup exceeded 4GB. The thread memory size is the product of the -iqmt value multiplied by the -iqtss value. Workaround Description  Workaround described in description is to use -iqtss and -iqmt settings that keep total Thread Memory Size below 4Gb

CR:449963

CR Number:   449963 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) 23 Jan 2007 Not a Bug Description Ability to make a backup based on creator of objects.

CR:451346

CR Number:   451346 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   12.7 future Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Using dbisqlc in IQ 12.6 or 12.7, if we use following method to connect to the server from remote machine, dbisqlc -c 'dsn=shashi_demo', and then after get connected if we issue command, "connect database asiqdemo user DBA identified by SQL' then the connection is failed and any commands issued after this will not work, until this command is issued every thing works fine. Using dbisqlc for IQ 12.5 ad using IQ 12.5 same thing works without any problem. On IQ 12.6 and 12.7 it fails. So it seems to be problem intoduced in IQ 12.6 and up. Problem is not observed when connected to the IQ server from same host machine on which IQ is residing. Workaround Description  Do not use "Connect database .........." command if connect to the database using dbisqlc -c 'dsn=engine_name' Method.

CR:451471

CR Number:   451471 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2000 Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e02 01 Mar 2007 Fixed 12.8 16 Mar 2007 Fixed Description If a query contains a join with multiple primary join conditions, where one of the join keys is equated to a constant value expression in another condition and where the optimizer selected either the SMJ or the SMPDJ algorithm for the join, then that query could under some circumstances be rejected with a non-fatal internal error stating that the input to a join operator was "not ordered as required". Workaround Description  The best work around is to disable the optimization which is causing the problem by: set temporary option dml_options5 = 524288; This option can, if necessary, be set public.

CR:451556

CR Number:   451556 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e09 10 Jan 2007 Fixed Description Under certain circumstances a query containing case expression, that may return different data types, may return incorrect values or result in a server failure. The result is dependant on various conditions including the case expressions involving computations, data volume and available indexes.

CR:451777

CR Number:   451777 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e10 30 Apr 2007 Fixed Description Under certain circumstances, a grouped "union all view" type query where each arm is grouped may return extra rows. Workaround Description  WA: 1) set option parallel_gbh_enable = 'off'; 2) create a lf index on the prd.FR_COMISSION.COMIS_ORIGIN_SYS column Number 2 is obviously a better choice because it improves the performance as well.

CR:451844

CR Number:   451844 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   AIX Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description We have had a number of AIX customers have issues where the IQ process is killed by the OS when the OS detects it is running low on free paging-space blocks and starts hitting virtual memory running low condition. In AIX if this condition is detected the OS sends out a SIGDANGER(33) to active processes. If the condition persists it will chooses processes to kill to alleviate the condition, usually the biggest consuming process. Can IQ be improved to see if there may be a way to better handle this condition so that IQ is not killed abruptly and cause recovery issues / problems. Could IQ issue a warning, or would there be a way to tell the OS not to select it, or even if IQ tries to dynamically reduces its requirements to alleviate the problem. Obviously this would be dependant on what the OS does, i.e. its not clear yet if the OS issues the SIGDANGER(33) then immediately start killing processes, and if so what signals does it send. We are already aware that the underlying condition can be avoided by configuring more memory / paging space ... etc. etc. However in reality its not always possible or desirable for a customer site to provide excessively large amounts of these resources, so some degree of tuning is done based on 'normal' requirements, hence from time to time customers can and do hit this issue. Can we make it a little less painfull for them?

CR:451899

CR Number:   451899 Product Name:   IQ Product Component:   Utility Status:   Closed OS:   Windows 2003 Original Version:   12.7 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e02 09 Jan 2007 Fixed 12.6 e09 09 Jan 2007 Fixed Description On Windows 64-bit, the Sybase IQ Service Manager incorrectly used a 32-bit file path when entering the service. Workaround Description  Please change registry key. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\your_service_name\ImagePath "C:\Program Files\Sybase\ASIQ-12_7\win32\asiqsrv12.exe" "....." to ... "C:\Program Files\Sybase\ASIQ-12_7\x64\asiqsrv12.exe" "....."

CR:452026

CR Number:   452026 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.7 e02 02 Mar 2007 Fixed 12.8 14 Mar 2007 Fixed Description A query with many productions (expression evaluations) could take a long time to execute. Workaround Description  No workaround

CR:452526

CR Number:   452526 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e09 18 Jan 2007 Fixed Description When attempting to display a result set that contained numeric data that could not be displayed, dbisql java could return the message "There was an error reading the results of the SQL statement. The displayed results may be incorrect or incomplete." This error message has been replaced with the the textual representation of the value that is returned by the server.

CR:453050

CR Number:   453050 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.6 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e09 19 Jan 2007 Fixed 12.7 e02 19 Jan 2007 Fixed 12.8 25 Jan 2007 Fixed Description Under certain conditions, an IQ server could fail at s_blockmap.cxx:2198 while executing operations that update HG indexes or LOB columns after adding a dbspace that was assigned block numbers larger than 4 billion.

CR:453588

CR Number:   453588 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 08 May 2007 Fixed Description sp_iqcheckdb on a read-only database caused the server to fail.

CR:454166

CR Number:   454166 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Windows XP Original Version:   12.6 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e10 26 Jun 2007 Fixed 12.7 e03 1 12 Jun 2007 Fixed Description Under certain circumstances, Starting Sybase IQ Service Manager from Start/Programs/Sybase/Adaptive Server 12.6/Sybase IQ Service Manager might fail with the error "This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem."

CR:454490

CR Number:   454490 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) 12.6 e10 27 Apr 2007 Fixed 12.7 e03 27 Apr 2007 Fixed Description DBISQL could display LONG VARCHAR, BINARY, LONG BINARY or VARBINARY values as empty, if the "Show multiple result sets" option was ON and the truncation length was set to zero.

CR:454784

CR Number:   454784 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 e03 09 Jul 2007 Fixed Description Starting a multiplex query server with a local store with the -iqro 1 startup option failed.

CR:454965

CR Number:   454965 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 e02 15 Feb 2007 Fixed 12.8 15 Feb 2007 Fixed Description A non-fatal exception error in dfp.cxx could be reported on a query which involved a view which contained a UNION ALL of 2 SELECTS in the FROM clause and a WHERE clause with a BETWEEN condition on 2 dates and an OR condition.

CR:455667

CR Number:   455667 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   AIX Original Version:   12.6 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e02 08 Mar 2007 Fixed 12.6 e10 11 Apr 2007 Fixed Description In rare circumstances, the server might fail if multiple connections ran the same procedure concurrently and the procedure contained a control statement (for example, IF) with a condition that used a subselect.

CR:455702

CR Number:   455702 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 23 Mar 2007 Duplicate Description IQ is unable to resolve index names of same name table and temp table.

CR:455820

CR Number:   455820 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) 15.0 16 Nov 2009 Not a Bug Description The issue does not exist in IQ 15.0 or later, since from IQ 15.0 on, query servers do not have local stores anymore, eliminating this kind of name collisions causing emergency shutdown of the query server.

CR:456013

CR Number:   456013 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 e02 02 Mar 2007 Fixed 12.8 16 Mar 2007 Fixed Description A UNION of a numeric data type column to the NULL value reported an "Incompatible data types in UNION" error.

CR:456280

CR Number:   456280 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows XP Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e03 01 Aug 2007 Fixed Description The ADO.NET driver of IQ 12.7 registered the wrong file to Visual Studio 2005.

CR:456316

CR Number:   456316 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   12.7 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Support of NULLS FIRST|NULLS LAST in ORDER BY Clause

CR:456456

CR Number:   456456 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   SunOS Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e10 11 May 2007 Fixed 15.0 02 Jan 2008 Fixed 12.6 e10 11 May 2007 Fixed 12.7 e03 11 May 2007 Fixed 15.0 21 May 2007 Fixed Description The IQ server failed in attempting to set the option IDENTITY_INSERT on a global temporary table, if the SET OPTION command was the first operation after connecting and was the first access of the global temporary table.

CR:456533

CR Number:   456533 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) 12.6 e10 03 May 2007 Fixed 12.7 e03 25 Apr 2007 Fixed Description A complex join involving more than 38 tables in the join took a long time to be optimized.

CR:456591

CR Number:   456591 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 e02 01 Mar 2007 Fixed 12.8 16 Mar 2007 Fixed Description A query could return a non-fatal error from s_bm.cxx if it referenced a column containing null values that was created in 12.6 or earlier and that column had not yet been modified in 12.7.

CR:456647

CR Number:   456647 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 e03 25 Jun 2007 Fixed Other 08 May 2007 Presently Not Targeted For Any Future Release Of This Product Description When creating a proxy table, if Japanese was contained in the Oracle table name, creation of the proxy table failed.

CR:456808

CR Number:   456808 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 e02 05 Mar 2007 Fixed 12.8 16 Mar 2007 Fixed Description A query with search condition "<=ALL" or ">=ALL" may fail to return data. For example, select col1, col2 from table1 where col1>=ALL( select col1 from table2 where col1=1 ) order by col1, col2;

CR:460713

CR Number:   460713 Product Name:   IQ Product Component:   Utility Status:   Closed OS:   Solaris Original Version:   12.6 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2007 Not a Bug Description temp table not found when created part of the batch & when executed from dbisql

CR:461029

CR Number:   461029 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   SunOS Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e10 26 Apr 2007 Fixed 12.6 e10 18 Apr 2007 Fixed 12.7 e03 26 Apr 2007 Fixed 15.0 02 Jan 2008 Fixed 15.0 18 Apr 2007 Fixed 12.7 e03 18 Apr 2007 Fixed Description If the 'literal' supplied for the NULL column-spec was wider than 3956 bytes, columns might not be recognized as NULL, even if the data matched the literal specified for the NULL column-spec.

CR:461174

CR Number:   461174 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.7 e03 08 May 2007 Fixed 15.0 02 Jan 2008 Fixed Description Under certain circumstances, a non-fatal error "cannot evaluate expression" might occur, if dml_options5=1073741824 was set. Workaround Description  do not set any value for dml_option5

CR:461369

CR Number:   461369 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.6 e10 18 May 2007 Fixed 12.7 e03 19 Apr 2007 Fixed Description When a query had a single inline view which contained many UNION ALL branches and the first UNION ALL branch had a misspelled function, for example "UBSTR()", a server failure could occur.

CR:461593

CR Number:   461593 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e09.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.8 24 Apr 2007 Fixed 12.7 e03 24 Apr 2007 Fixed 15.0 24 Apr 2007 Fixed 12.7 e03 24 Apr 2007 Fixed Description Sybase IQ ignored the declared precision/scale of a variable and promoted the variable to a larger precision that is not supported by Open Client isql, resulting in the CT-LIBRARY error "An invalid numeric precision was received." Workaround Description  A workaround for the issue when using isql is to cast the value, for example: select cast(@numvar as numeric(15,0)) from iq_dummy.

CR:461665

CR Number:   461665 Product Name:   IQ Product Component:   other Status:   Closed OS:   Linux Red Hat Original Version:   12.6 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e03 11 Jul 2007 Fixed 15.0 2 10 Sep 2008 Fixed 12.7 e03 15 Aug 2007 Fixed 15.1 23 Jun 2009 Fixed Description stop_asiq on Linux 64-bit failed to find servers to shutdown when username was longer than 8 characters. See the Release Bulletin for information on the new optional stop_asiq parameter -user.

CR:461762

CR Number:   461762 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.6 e10 30 May 2007 Fixed 12.7 e03 29 Jun 2007 Fixed Description The following conditions in a query could return unexpected results: 1) UNION ALL, 2) DISTINCT on UNION arms, 3) Left outer joins in the union arms, 4) Columns with multi-column HG indexes in the SELECT list of UNION arms. Workaround Description  Workaround: There is workaround to disable the use of multi-column HG index for the query by setting DML_Options3 to 8192. But the above option looks partially works. it doesn't make customer's query return correct data.

CR:461876

CR Number:   461876 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) 15 Mar 2007 Not a Bug Description Incorrect syntax goes into inefficient way of processing, rather than erroring. This causes the connection to hang , if left alone for a long period and sometimes not being able to drop the connection. Only way out is to recycle the reader node.

CR:462158

CR Number:   462158 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 IQ server crashes if it runs out of main buffer cache instead of giving error

CR:462333

CR Number:   462333 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) 23 Apr 2007 Presently Not Targeted For Any Future Release Of This Product 12.7 e03 04 May 2007 Fixed 15.0 04 May 2007 Fixed Description Under certain circumstances, a query server could shutdown when a user canceled commands in transactions waiting on Table Level Versioning (TLV) versions.

CR:462334

CR Number:   462334 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 28 Mar 2007 Fixed Description Sybase IQ shut down with a fatal error because a call to pthread_mutex_destroy returned EBUSY.

CR:462390

CR Number:   462390 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.6 e10 16 May 2007 Fixed 15 May 2007 Workaround Description A query returns an internal node error when a derived column is based on a RANK function on a derived column. Workaround Description  Available W/R may be using temp table for derived table in query,instead of origin query.

CR:462733

CR Number:   462733 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 e02 22 Mar 2007 Fixed 12.8 28 Mar 2007 Fixed 12.6 e10 16 May 2007 Fixed Description When the option INFER_SUBQUERY_PREDICATES is ON, a query involving a join and a NOT IN subquery where the subquery could infer the predicate from a join condition could return unexpected results, since the "NOT" condition was dropped. In order to infer the predicate from the join condition, the data types of the join column and subquery column must be identical. Workaround Description  set IN_Subquery_Preference = '-2' (avoid vertical IN subquery)

CR:462762

CR Number:   462762 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) 12.7 e02 20 Mar 2007 Fixed 12.6 e10 30 Apr 2007 Fixed Description A query with a MIN or MAX aggregate could return an empty result instead of the expected NULL value under the following conditions: 1) There were no GROUP BY items associated with the MIN/MAX. 2) The argument of the MIN/MAX could be simplified into a constant. (For example: SELECT MAX(a) FROM t WHERE a=6) 3) No result rows satisfied the query predicate. Workaround Description  The workaround is to turn on dml_options5 = 524288

CR:462766

CR Number:   462766 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 Option to log more info when IQ shuts down

CR:462773

CR Number:   462773 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 option to limit rows returned from a particular object for a user

CR:462788

CR Number:   462788 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 Allow load/extract table to use file from/to remote file system

CR:463015

CR Number:   463015 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows 2000 Original Version:   12.6 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e10 30 Apr 2007 Fixed Description An ADO.NET provider 9.0.1.1530 Exception Type "System.ArgumentOutOfRangeException" could occur when connection pooling is enabled and many users are concurently connected.

CR:463160

CR Number:   463160 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 18 May 2007 Fixed 12.7 e05 12 May 2008 Fixed Description The server might fail while running the sp_iqrowdensity stored procedure, reporting a stack trace at st_server.cxx: function. Workaround Description  restart the IQ

CR:463195

CR Number:   463195 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 e03 13 Apr 2007 Fixed 12.6 e10 18 Apr 2007 Fixed Description In a SQL batch, a cursor opened WITH HOLD could keep Temporary IQ block usages increasing, until the cursor was closed and the connection was disconnected. The workaround is not to use the cursor WITH HOLD option. Workaround Description  Avoid using cursor "with hold" option

CR:463558

CR Number:   463558 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 29 May 2007 Fixed 12.7 e03 skamat 21 Aug 2007 Fixed Description If a multiplex database was created with IQ PAGE SIZE 512KB (524288) and the write server was started with startup option "-iqnotemp 1", then the server failed, producing a stack trace.

CR:463754

CR Number:   463754 Product Name:   IQ Product Component:   other Status:   Closed OS:   Solaris Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e02 09 Apr 2007 Fixed 15.0 28 Jan 2008 Fixed Description Under certain circumstances, queries involving CLOB or BLOB columns and a subquery could unexpectedly return the error "Feature, DISTINCT or GROUP BY against long binary/varchar data, is not supported."

CR:463774

CR Number:   463774 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 e02.x 12 Apr 2007 Fixed 12.7 e03 18 Apr 2007 Fixed Description Under certain circumstances, a query that referenced a BINARY or VARBINARY UNION ALL view column as a distinct or grouping column could return a non-fatal internal error.

CR:463784

CR Number:   463784 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   12.7 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e09 16 Mar 2010 Fixed Description ECC protocol restriction for ESD #3 clients Sybase IQ 12.7 ESD #3 clients and servers have been updated to use Certicom v5 libraries for Transport Layer Security (TLS) encryption, HTTPS encryption, and aes_fips database encryption on the following platforms: AIX64, Linux AMD64, Sun64, and Windows 32-bit. This update changes product behavior in a single instance. To connect a version 12.7 ESD #3 Network Client to a 12.6 Sybase IQ server encrypted, you must use the RSA protocol. Attempts to connect encrypted to unpatched or 12.6servers using the Elliptic Curve Cryptography (ECC) protocol return error code -829: TLS handshake failed.

CR:463881

CR Number:   463881 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows 2000 Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e02 27 Mar 2007 Fixed Description An attempt to create a Proxy Table using server class 'aseodbc' when the remote table name contained an underscore would fail with the error "The remote table <table name> could not be found." (Duplicate CR 454785) Workaround Description  create a view in ASE for the table that does not use underscores.

CR:463892

CR Number:   463892 Product Name:   IQ Product Component:   Utility Status:   Closed OS:   Solaris Original Version:   12.6 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jul 2008 Deferred Description provide option to add multiple lines in dbisql -nogui mode