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

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

CR:384154

CR Number:   384154 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 17 Mar 2006 Fixed Description Request to print the index usage for a query.

CR:384245

CR Number:   384245 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 e04 20 Apr 2005 Fixed Description For a UNION ALL view, if one (or more than one) arm of the union was a complete empty table, Sybase IQ returned the following stack trace: Non-Fatal IQ Internal Error Detected at dfe_BaseColumn.cxx:886 on thread 34 (dfe_BaseColumn::GetMaxValue(void)) The view met the following criteria: 1) A UNION ALL view over ungrouped base tables 2) Each of the view's select list items mapped to a set of identically typed base columns 3) One (or more) of the arms of the UNION referred to an empty base table 4) The query block referring to that view performed a GROUP BY or a join on a column from that view, such that the optimizer requested the distinct count of that column from the view 5) That view column had an unscaled integer data type 6) All of the base columns mapped to by that view column had HG indexes defined 7) The sum of the distinct counts for all the base columns mapped to by that view column exceeded ~1.5 million Target Version  12.6 e03

CR:384407

CR Number:   384407 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e04 16 Apr 2005 Fixed Description The @@proc_id global variable worked only on Windows systems. On UNIX, it returned '0' instead of the procid of the executing procedure.

CR:384590

CR Number:   384590 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows 2000 Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e04 15 Apr 2005 Fixed Description When connected to an IQ server, the ODBC driver's SQLGetInfo function would return "Adaptive Server Anywhere" instead of "Adaptive Server IQ" for the SQL_DBMS_NAME.

CR:384743

CR Number:   384743 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e04 11 Apr 2005 Fixed Description Within an INSERT statement into a temporary table, a negated disjunction containing a subquery could return an internal error from opt_QueryTree.cxx:3616.

CR:385230

CR Number:   385230 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) 07 Apr 2005 Presently Not Targeted For Any Future Release Of This Product Description Request to implement Integrated Logon functionality from CT-Lib ISQL to IQ/ASA over named pipes.

CR:385404

CR Number:   385404 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e04 08 May 2005 Fixed Description When more than 700 GRANT statements were issued, Sybase IQ returned the error "Assertion failed: 101506 (9.0.1.1753) Allocation size too large when re-allocating memory." Workaround Description  1. create a new IQ database and specify a PAGE SIZE of 8192 2. bakup the existing database doing a FULL backup. 3. restore the new database from the backup. 4. run a dblog -t to change the log file name to the new db. ie. I restored asiqcopy.db from asiqdemo.db, so I specified dblog -t asiqcopy.log asiqcopy.db. 5. start database and run grants.3.txt.

CR:385684

CR Number:   385684 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.6 e04 03 May 2005 Fixed Description Corrected an issue whereby certain queries involving GROUP BY or SELECT DISTINCT on expressions could be rejected with an "Internal error" that stated "Can not evaluate expression".

CR:385719

CR Number:   385719 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 e11 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e16 22 Apr 2005 Fixed Description A timing-dependent multiplex issue could cause a query server failure with an Abort at st_server.cxx:1056 during normal use, or an Exception Thrown from db_catx.cxx:416 when trying to restart a query server without synchronizing if the server had not cleanly shut down.

CR:385759

CR Number:   385759 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 e12 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e04 16 May 2005 Fixed Description Queries with IS NOT NULL and IS NULL predicates on large tables are sometimes less efficient than they could be, causing queries to use more temp space and execute more slowly than necessary. The following cases were improved for queries where <col1> contains NULL values: select ... where <col1> IS NOT NULL, select ... where <predicate> AND <col1> IS NOT NULL, select ... where <predicate> OR <col1> IS NOT NULL, and select ... where <predicate> AND <col1> IS NULL

CR:385837

CR Number:   385837 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e04 26 Apr 2005 Fixed Description Starting a named transaction incremented @@trancount by two.

CR:385851

CR Number:   385851 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 23 Jan 2006 Fixed 12.6 e05 20 Oct 2005 Fixed Description A delete operation on a table with significant number of rows and DTTM, DATE, HNG, LF, and TIME indexes would take a long time to complete before noticing that the user had interrupted the operation.

CR:385915

CR Number:   385915 Product Name:   IQ Product Component:   other Status:   Closed OS:   Solaris Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e04 22 Apr 2005 Fixed Description The IQ server failed when a NULL value was inserted via an ODBC parameterized variable. Workaround Description  No known workaround ==> If a user simply wants to insert null value into table through ODBC interface, the workaround could be simply execute the insert statement withough binding parameters, like below: sprintf((char*)sqlStr, "INSERT INTO c11124625 (C1) VALUES (NULL)"); ret_code = SQLPrepare(iq_stmt, sqlStr, SQL_NTS); ret_code = SQLSetStmtAttr(iq_stmt, SQL_ATTR_PARAMSET_SIZE,(SQLPOINTER) rowCount, 0); ret_code = SQLExecute(iq_stmt); or he could create the target table in system, and run the insert with parameter binding through ODBC. After that, he can copy the data back into an IQ table.

CR:386566

CR Number:   386566 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e17 04 May 2005 Fixed 12.6 e04 05 May 2005 Fixed Description Virtual memory used by a write server, as reported via sp_iqstatus, continuously grew when executing a multiplex usage scenario that had a query server performing only queries and the write server performing a repeated pattern of insert/load commit into one or more tables, always modifying the tables in the exact same order.

CR:386583

CR Number:   386583 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   HP-UX Original Version:   12.5 e12 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e16 19 Apr 2005 Fixed Description A problem with the improper handling of interrupted jConnect connections when the server is returning results that could result in unexpected server termination has been resolved.

CR:386813

CR Number:   386813 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 e15 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e16 22 Apr 2005 Fixed 12.5 e16 18 Apr 2005 Fixed Description Attempting to restart a multiplex write server could encounter a fatal error if dbremote connected to the database before a user transaction completed. Workaround Description  If the multiplex writer does not restart correctly, perform the following steps: Restart the multiplex from the command line. Connect to the database and issue any IQ command such as sp_iqstatus; Disconnect. Start dbremote.

CR:386867

CR Number:   386867 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 07 Oct 2005 Fixed Description Simultaneous internal errors could cause stack trace information to be incomplete.

CR:387043

CR Number:   387043 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e04 06 May 2005 Fixed 12.6 e04 12 Oct 2005 Fixed Description A memory inconsistency was detected and an exception thrown from db_Identity.cxx when SET TEMPORARY OPTION identity_insert was attempted twice for same session. Before you can reset the IDENTITY_INSERT option, you must first unset it. For example: SET TEMPORARY OPTION identity_insert = ''; (This problem was fixed but undocumented in ESD 4.)

CR:387337

CR Number:   387337 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows XP Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e04 17 May 2005 Fixed Description The server might fail after raising error 9216 (Feature, non-constant expression in IN list not supported).

CR:387343

CR Number:   387343 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e04 29 Apr 2005 Fixed Description LOAD TABLE processing used the wrong data conversion behavior. Workaround Description  aletr precision and scale

CR:387972

CR Number:   387972 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Unknown Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2005 Presently Not Targeted For Any Future Release Of This Product Description New Future:Password encryption for jConnect connections

CR:388110

CR Number:   388110 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 e04 02 May 2005 Fixed Description When querying a database with Japanese collation, Sybase IQ returned the wrong value for a CLOB value greater than 254 bytes and less than 32768 bytes. Workaround Description  none

CR:388129

CR Number:   388129 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) future 25 May 2005 Deferred Description Changing a database from one collation to another is missing in System Administration Guide.

CR:388153

CR Number:   388153 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.5 e11 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e04 28 Apr 2005 Fixed Description The stored procedure sp_iqprintconstraints might give incorrect results depending upon the setting of the ANSINULL option. Workaround Description  set temporary option ansinull = 'on'

CR:388219

CR Number:   388219 Product Name:   IQ Product Component:   other Status:   Closed OS:   Solaris Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 21 Nov 2005 Fixed Description Using the IQ/ASA ODBC Driver, the ODBC API call SQLGetTypeInfo could return the wrong size for decimal columns. This has been fixed.

CR:388509

CR Number:   388509 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e04 05 May 2005 Fixed 16 Nov 2005 Deferred Description Currently, IQ does not support the PERCENTILE_CONT or PERCENTILE_DISC function with GROUP BY CUBE operations. Sybase IQ now returns an error instead of a server failure.

CR:388731

CR Number:   388731 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e04 03 May 2005 Fixed Description The migration stored procedure sp_iqdropconstraints dynamically creates ALTER DROP statements that drop unenforced 12.5 constraints. To handle special cases of owners, tablenames and columnnames, the script delimits the identifiers with quotation marks in these statements. With the default setting for QUOTED_IDENTIFIER = 'OFF' for isql connections, the script failed when run from an isql session. It ran fine from dbisqlc and dbisql. The stored procedure has been corrected to run correctly with isql, dbisqlc and dbisql.

CR:389049

CR Number:   389049 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e04 21 May 2005 Fixed Description When an undefined column was selected inside a derived table or a view, the IQ server might fail. The failure only occurred when the derived table or the view contained UNION operators.

CR:389295

CR Number:   389295 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Windows XP Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 05 May 2005 Duplicate Description Request to start the server with the largest page size using the -gp 32768 switch when using the Utility Database via Sybase Central to create an IQ Database to accomodate page sizes of the Catalog store greater than 4KB.

CR:389355

CR Number:   389355 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e04 11 May 2005 Fixed Description Sybase IQ now returns an error indicating that INSERT VALUES does not support subqueries instead of a server failure.

CR:390125

CR Number:   390125 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Unknown Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 18 Jul 2005 Fixed Description Internal IQ datatypes should not be listed in the dropdown list provided when creating a new table in Sybase Central.

CR:390440

CR Number:   390440 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2000 Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 22 Jul 2005 Fixed Description A query using the intersect keyword (which is not supported by IQ at this time) could cause a non-fatal stack trace instead of generating an error message.

CR:390895

CR Number:   390895 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2000 Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e04 18 May 2005 Duplicate Description You must only set IDENTITY_INSERT as a temporary option. If you do not, the server may fail with Exception Thrown from db_Identity.cxx:362, and dump all thread stacks at st_server.cxx:504. Workaround Description  only set IDENTITY_INSERT as a temporary option

CR:390916

CR Number:   390916 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 e15 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 28 Jul 2005 Fixed Description When a user renames a table that a stored procedure selects from and then creates a view with the old table name on the renamed table, Sybase IQ must be restarted to avoid server failure on procedure execution.

CR:390969

CR Number:   390969 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 e16 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2005 Not a Bug Description Temp space is not released if we get an error from dbisql when executing a sp. The temporary block used up is more in 12.5x release as compared to 12.6x release.

CR:391018

CR Number:   391018 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 e05 27 Jul 2005 Fixed Description String functions such as locate(), charindex(), ascii(), repeat(), patIndex(), and concatenate slowed down when processing a large number of rows.

CR:391118

CR Number:   391118 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 07 Jul 2005 Fixed 12.5 e17 07 Jul 2005 Fixed Description Numerous customers have reported Sybase IQ server fails when starting the IQ monitor with the '-summary' option. For example: iq utilities main into DBA.dummy start monitor '-interval 10 -summary'

CR:391185

CR Number:   391185 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 02 Aug 2005 Fixed Description If an expression contained a reference to a proxy table, the engine failed if that expression was used as an expression in a message or PRINT statement, an expression in a RETURN statement of a function or procedure, a time/delay expression in a WAITFOR statement, or an offset expression of a FETCH statement. Workaround Description  Change the original user function to return single value: =============================================================== set temporary option on_error = 'continue'; drop table DATE_CONTROL; Create table DATE_CONTROL ( VALUE_IN char(20), VALUE_OUT date ); insert into DATE_CONTROL values('ALL SPACES ','0001-01-01'); insert into DATE_CONTROL values('NULL ','0001-01-01'); insert into DATE_CONTROL values('INVALID DATE ','0001-01-02'); insert into DATE_CONTROL values('LOW VALUES ','0001-01-01'); insert into DATE_CONTROL values('HIGH VALUES ','9999-12-31'); commit; drop function MVS_DATE_CONVERT; create function MVS_DATE_CONVERT(inValue varchar(50)) RETURNS DATE BEGIN RETURN ( CASE WHEN invalue is null then ('0001-01-01') WHEN invalue = ' ' then ('0001-01-01') WHEN invalue = '00000000' then ('0001-01-01') WHEN invalue < '0' then ('0001-01-01') WHEN ((SUBSTR(invalue,1,4) = '0000') OR (SUBSTR(invalue,5,2) > '12') OR (SUBSTR(invalue,5,2) = '00') OR (SUBSTR(invalue,7,2) > '31') OR (SUBSTR(invalue,7,2) = '00') OR (SUBSTR(invalue,5,2) IN ('04','06','09','11') AND SUBSTR(invalue,7,2) > '30') OR (SUBSTR(invalue,5,2) = '02' AND SUBSTR(invalue,7,2) > '29') OR (SUBSTR(invalue,5,2) = '02' AND SUBSTR(invalue,7,2) = '29' AND ((MOD(cast(SUBSTR(invalue,1,4) as integer),4) > 0) OR ((SUBSTR(invalue,3,2) = '00') AND ( MOD(cast(SUBSTR(invalue,1,2) as integer),4)> 0))))) THEN ('0001-01-02') ELSE CAST(SUBSTR(invalue,1,4)||'-'||(SUBSTR(invalue,5,2))||'-'||(SUBSTR(invalue,7,2)) AS DATE) END) END; SELECT MVS_DATE_CONVERT('2004-05-05'); ================================================================ Or use procedure to return result set like below: ============================================================== set temporary option on_error = 'continue'; drop table DATE_CONTROL; Create table DATE_CONTROL ( VALUE_IN char(20), VALUE_OUT date ); insert into DATE_CONTROL values('ALL SPACES ','0001-01-01'); insert into DATE_CONTROL values('NULL ','0001-01-01'); insert into DATE_CONTROL values('INVALID DATE ','0001-01-02'); insert into DATE_CONTROL values('LOW VALUES ','0001-01-01'); insert into DATE_CONTROL values('HIGH VALUES ','9999-12-31'); commit; drop procedure MVS_DATE_CONVERT; create procedure MVS_DATE_CONVERT(inValue varchar(50)) RESULT(MVS_DATE DATE) BEGIN CASE WHEN invalue is null then (SELECT VALUE_OUT FROM DATE_CONTROL WHERE VALUE_IN = 'NULL') WHEN invalue = ' ' then (SELECT VALUE_OUT FROM DATE_CONTROL WHERE VALUE_IN = 'ALL SPACES') WHEN invalue = '00000000' then (SELECT VALUE_OUT FROM DATE_CONTROL WHERE VALUE_IN = 'LOW VALUES') WHEN invalue < '0' then (SELECT VALUE_OUT FROM DATE_CONTROL WHERE VALUE_IN = 'LOW VALUES') WHEN ((SUBSTR(invalue,1,4) = '0000') OR (SUBSTR(invalue,5,2) > '12') OR (SUBSTR(invalue,5,2) = '00') OR (SUBSTR(invalue,7,2) > '31') OR (SUBSTR(invalue,7,2) = '00') OR (SUBSTR(invalue,5,2) IN ('04','06','09','11') AND SUBSTR(invalue,7,2) > '30') OR (SUBSTR(invalue,5,2) = '02' AND SUBSTR(invalue,7,2) > '29') OR (SUBSTR(invalue,5,2) = '02' AND SUBSTR(invalue,7,2) = '29' AND ((MOD(cast(SUBSTR(invalue,1,4) as integer),4) > 0) OR ((SUBSTR(invalue,3,2) = '00') AND ( MOD(cast(SUBSTR(invalue,1,2) as integer),4)> 0))))) then (SELECT VALUE_OUT FROM DATE_CONTROL WHERE VALUE_IN = 'INVALID DATE') ELSE (SELECT CAST(SUBSTR(invalue,1,4)||'-'||(SUBSTR(invalue,5,2))||'-'||(SUBSTR(invalue,7,2)) AS DATE)) END CASE; END; CALL MVS_DATE_CONVERT('2004-05-05'); ============================================================

CR:391376

CR Number:   391376 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 03 Nov 2005 Fixed Description Long varchar update performance involving short strings can be improved.

CR:392322

CR Number:   392322 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Linux Original Version:   12.6 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e03 08 Jun 2005 Fixed 12.6 e04 08 Jun 2005 Fixed Description On Linux and all UNIX platforms, attempts to start IQ after uninstalling Open Client and the language modules returned the error "Could not load the store DLL libiq.so." The error occurred when the default uninstall option was selected during an uninstall of Open Server and the SDK on a system where Sybase IQ was installed.

CR:392616

CR Number:   392616 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 e15 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 31 Jul 2005 Fixed Description Thread memory size (the product of the values of -iqmt and -iqtss) no longer has a limit of 2097151KB on 64-bit systems.

CR:392931

CR Number:   392931 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 e16 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 04 Nov 2005 Fixed Description Under rare circumstances, a query server became unresponsive during a rollback operation, then suddenly restarted.

CR:393067

CR Number:   393067 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 29 Jul 2005 Fixed Description Processing of Table Level Versioning Replay could fail to complete if there were insufficient threads to run the replay of a connection that holds locks causing these locks to be retained.

CR:393196

CR Number:   393196 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 e11 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 27 Jun 2005 Fixed 12.6 e05 12 Jul 2005 Fixed Description Sybase IQ misinterpreted a white space after a series of digits as the end of input in loads, inserts, updates, and queries. For example, it treated "666 7" as "666".

CR:393311

CR Number:   393311 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.6 e04 13 Jun 2005 Fixed Description INSERT into a view fails.

CR:393409

CR Number:   393409 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 e16 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2005 Presently Not Targeted For Any Future Release Of This Product Description Option to mark connection dead when the connection cannot be dropped

CR:393747

CR Number:   393747 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.5 e16 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jun 2005 Fixed Description Derived table in in-list will generate stack trace as ASA level Workaround Description  Upgrade to IQ 12.6 or rewrite the query

CR:393797

CR Number:   393797 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.6 e05 26 Jul 2005 Fixed Description If a procedure or function call a java method and the java code uses the current connection to run SQL statement that calls a procedure or function that also call a java method, the engine fails if the two procedures/functions have a return statement.

CR:393819

CR Number:   393819 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows XP Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 15 Jul 2008 Presently Not Targeted For Any Future Release Of This Product Description Request for SA to add functionality to distinguish between BINARY and VARBINARY

CR:393823

CR Number:   393823 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Windows 2000 Original Version:   12.5 e17 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e17 26 Jul 2005 Fixed Description In Sybase IQ 12.5, if "select *" is used in a view and the base table(s) used in that view are changed, then you must drop and recreate the view. There is a related IQ 12.6 CR 362288.

CR:393984

CR Number:   393984 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows XP Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 07 Nov 2005 Fixed Description sp_iqpassword does not validate the old password before changing to the new password.

CR:394070

CR Number:   394070 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2005 Presently Not Targeted For Any Future Release Of This Product Description Have a procedure containing a variable in a select run in full pass thru mode

CR:394506

CR Number:   394506 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 31 Aug 2005 Fixed 12.6 e05 12 Oct 2005 Fixed Description A database experiencing a high rate of commits could starve checkpoints.

CR:394696

CR Number:   394696 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   future Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e03 13 Aug 2008 Fixed Description Request feature that provides monitoring feature similar to ASE MDA tables.

CR:394739

CR Number:   394739 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 28 Apr 2006 Fixed Description A "between" predicate is of the form "A between B and C" In 12.6.0 and prior versions, A, B, and C all had to be constants, host variables, or columns. In 12.6.1 either "B" or "C" or both "B" and "C" can now be subqueries. "A", the left hand argument, must still be a constant, a column, or a host variable in 12.6.1.

CR:394848

CR Number:   394848 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Solaris Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 08 Aug 2005 Fixed Description Reference Manual error: Table name should be "SYSIQINFO" instead of "SYSINFO".

CR:395407

CR Number:   395407 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2000 Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 02 Aug 2005 Fixed Description To improve performance of queries on a view with UNION ALL, Sybase IQ no longer pushes a predicate through UNION to the base table.

CR:395428

CR Number:   395428 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 26 Sep 2005 Not a Bug Description Under certain circumstances, a'Cursor Not Open' error could occur when inserting into a global or local temp table

CR:396568

CR Number:   396568 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Unknown Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 14 Nov 2005 Fixed Description Queries containing the FOR XML [RAW|AUTO} clause would get an 'Invalid Expression near forxml' error.

CR:396836

CR Number:   396836 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 e05 29 Jul 2005 Fixed Description Following a partial width insert, a non-fatal internal error (s_ohcIter.cxx; 789) could be reported performing an UPDATE operation on a HG index.

CR:397343

CR Number:   397343 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows XP Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 16 Aug 2005 Fixed Description ct-describe via CTLIB returns max byte storage when varchar/varbinary > 255

CR:397657

CR Number:   397657 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 14 Feb 2006 Fixed Description Remove reference to the SYBASE_JRE environment variable from ASIQ-12_6.sh. Workaround Description  We never overwrite the Envrionment files once GA is installed (as users can make changes). ESDs only modify them IF NECESSARY. End user can simply manually remove SYBASE_JRE from the file.

CR:397929

CR Number:   397929 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.6 e05 01 Sep 2005 Fixed Description In IQ 12.6, the stored procedure "sp_iqdbspace()" returns different column names depending on how the procedure is called form isql. When called as "call sp_iqdbspace()" it returns one set of column names, when called as "select * from sp_iqdbspace()" it returns a different set of names.

CR:398740

CR Number:   398740 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 03 Oct 2005 Fixed Description Under rare circumstances, a delete operatino on a multiplex cause server failure reported at s_blockmap.cxx; 974. Workaround Description  set option Bitmap_Options1 = 1

CR:398906

CR Number:   398906 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 2 13 Jun 2008 Fixed 15.0 12 May 2009 Added to user documentation Description Provide some global variable that will provide number of current user connections and the max number user connections configured

CR:399062

CR Number:   399062 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows XP Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 02 Nov 2005 Fixed Description Modifying system time does not reflect in sql log (from -zo output).

CR:399149

CR Number:   399149 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Feb 2006 Fixed Description Results from the Inttohex() function for bigint and numeric types were formatted inconsistently. The following are the results for bigint, integer and numeric values: '00000001' '00000001' '00000001' 'ffffffffffffffff' 'ffffffff' 'ffffffffffffffff' '00000002' '00000002' '00000002' 'fffffffffffffffe' 'fffffffe' 'fffffffffffffffe' '7fffffff' '7fffffff' '7fffffff' 'ffffffff80000001' '80000001' 'ffffffff80000001' 'ffffffff80000000' '80000000' 'ffffffff80000000' '80000000' '00008000' '80000000' '7fffffffffffffff' '00007fff' '7fffffffffffffff' '8000000000000001' 'ffff8000' '8000000000000001' '8000000000000000' 'ffff7fff' '8000000000000000' This problem has been fixed. The following shows typical results now returned for bigint, integer and numeric values: '0000000000000001' '00000001' '0000000000000001' 'ffffffffffffffff' 'ffffffff' 'ffffffffffffffff' '0000000000000002' '00000002' '0000000000000002' 'fffffffffffffffe' 'fffffffe' 'fffffffffffffffe' As well, with 9.0.2, passing a negative value to inttohex() would have resulted result in a "value out of range" error. This to has been corrected

CR:399275

CR Number:   399275 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 22 Sep 2005 Fixed Description Multiplex -- During multiplex propagation of stored procedures, views, or functions that contain special characters enclosed in single quotation marks, the query server may fail with SQLSTATE: 42WO4. For example, this may occur in the case of a stored procedure containing a load statement with '\n'.

CR:399761

CR Number:   399761 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows 2000 Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 10 Aug 2005 Fixed Description Under rare circumstances, during automatic database recovery, the server could become unresponsive when deleting an entry from an invalid index instead of reporting Assertion 200901.

CR:399768

CR Number:   399768 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 24 Oct 2005 Fixed Description Options changed during ALTER DATABASE UPGRADE process are documented in the Release Bulletin. Use sp_iqcheckoptions to display settings before and after upgrade.

CR:399881

CR Number:   399881 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Windows 2000 Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 10 Oct 2005 Fixed Description Using Sybase Central Java edition for IQ 12.6, if you uncheck the 'allowed to connect' box in the properties of a user object, it appears to set the password to Null. The user can then still log on to IQ using dbisqlc if you enter a Null password for the user you have just tried to lock out. Dbisql java works fine and prevents access as expected. Also, once you have unchecked the 'allowed to connect' property box and applied it, if you close the properties window then reopen it, the box reappears as checked again.

CR:399882

CR Number:   399882 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 14 Sep 2005 Fixed Description Under certain circumstances when running sp_iqdbspace a logic error could report Non-Fatal s_bm.cxx error "Bitmap result bitcount not in legal range" and may cause the server to be unresponsive.

CR:400095

CR Number:   400095 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Windows 2000 Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 17 Nov 2005 Fixed Description The installer has been updated so that shared java components are not removed on uninstall if there is any possiblity that they are being used by another product. ESD #5 must be installed for this change to be included in the uninstall.

CR:400302

CR Number:   400302 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 e05 23 Sep 2005 Fixed Description Under rare circumstances, a query using nested subqueries might result in server failure.

CR:400486

CR Number:   400486 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 30 Sep 2005 Fixed Description Running the sp_iqmpxdumptlvlog procedure could cause write or query server failure if the write server is concurrently writing new rows to the Transaction Level Versioning (TLV) log.

CR:400807

CR Number:   400807 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2000 Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 05 Oct 2005 Fixed Description Query server might do an emergency shutdown during synchronize when the write server contained Java related domains.

CR:400914

CR Number:   400914 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2000 Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 06 Apr 2006 Fixed Description Cannot automatically start IQ Agent on Windows 2003.

CR:401034

CR Number:   401034 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 22 Aug 2005 Fixed Description A write server occasionally failed to start even when it was previously stopped normally.

CR:401051

CR Number:   401051 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2005 Fixed Description Allow new connections while versions are being dropped

CR:401168

CR Number:   401168 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows 9x Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 18 Oct 2005 Fixed Description When connecting DBISQL java using iAnywhere JDBC driver to Sybase IQ, neither the GUI nor a SET OPTION statement allow you to save options in "Tools" -> "Options" permanently.

CR:401194

CR Number:   401194 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 30 Nov 2005 Fixed Description A fatal server error occurred when dynamic memory was exceeded.

CR:401247

CR Number:   401247 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 22 Sep 2005 Fixed Description Creating an IQ local store on a multiplex query server in some situations may cause the query server to stop with an emergency shutdown message.

CR:401344

CR Number:   401344 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Unknown Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Nov 2005 Not a Bug Description provide a new dbisql option to specify a delimiter for column headings and data

CR:401519

CR Number:   401519 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 e05 21 Sep 2005 Fixed Description Creating an IQ local store on a multiplex query server in some situations may cause the query server to stop with an emergency shutdown message.

CR:401883

CR Number:   401883 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 11 Nov 2005 Fixed Description Stored procedure performance during database versions release was improved.

CR:401892

CR Number:   401892 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 04 Nov 2005 Fixed Description If the system clock was advanced and then moved backward to the current time, major timestamp increases could occur. Moving the time ahead a minute or two (or a day or two), could cause change of perhaps 5 days, or no advance, but when time was moved backwards to the current time, advances in the "-zr" logfile of 23-25 days could result.

CR:401966

CR Number:   401966 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Windows NT Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 05 Oct 2005 Fixed Description When the password in a profile was blank and the profile was set to connect on startup, Sybase IQ returned the error ASA -103: Invalid user ID or password. Workaround Description  Manually delete the contents of the password field.

CR:402043

CR Number:   402043 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.6 e05 02 Oct 2005 Fixed Description If a user was granted permissions on a view but not on one of the underlying IQ or remote tables, then using the view in a subquery failed with a permission denied error.

CR:402152

CR Number:   402152 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 23 Sep 2005 Fixed Description The IQ server returns a stack trace with a signal 11 if user_id or user_name is used in a query like the following: SELECT user_id() FROM DBA.IQ_DUMMY.

CR:402196

CR Number:   402196 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 28 Jan 2008 Fixed 15.1 07 Apr 2009 Added to user documentation Description Customer is requesting the same functionality as exists with the LOAD TABLE command where it allows you to control load behavior when integrity constraints are violated and to selectively log information about the violations.

CR:402205

CR Number:   402205 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 15 Feb 2006 Fixed Description Include table owner to the index advisor advice when outputting <table.column>.

CR:402551

CR Number:   402551 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 17 Oct 2005 Fixed Description Duplicate create index statements occurred in jcatalog.sql.

CR:402580

CR Number:   402580 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 07 Sep 2005 Fixed Description Using 12.6 ESD4.3 only, write server recovery could incorrectly restore the state of the transaction manager after a server failure. This could lead to allocation problems.

CR:402901

CR Number:   402901 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 09 Sep 2005 Fixed Description Checkpoint might deadlock if the IQ temporary cache was very busy. Workaround Description  This problem can be prevented by avoiding checkpoints on user connections. This would include explicit checkpoints, load with checkpoint, and dbspace commands. The automatic checkpoints that fire periodically will not have this issue

CR:403182

CR Number:   403182 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 14 Nov 2005 Fixed Description Sybase IQ 12.6 server startup may take longer if there are a large number of tables in the database that is being opened on startup.

CR:403319

CR Number:   403319 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows XP Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 17 Feb 2006 Fixed 12.6 e08 26 Sep 2006 Fixed Description DBISQL could report an OutOfMemory error during or shortly after executing a statement which returned a large result set. This was most likely to occur if: 1. The "Show multiple result sets" option was turned on, and 2. The "Maximum number of rows to display" option was set to "All rows", and 3. The result set contained a lot of data.

CR:403457

CR Number:   403457 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows XP Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 2 31 Dec 2007 Fixed Description DBA is able to drop views owned by SYS.E.g.:DROP VIEW "SYS"."SYSFOREIGNKEYS";

CR:403496

CR Number:   403496 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 25 Oct 2005 Fixed Description Needed to build libdbtsp9.sl.1 in order to use dblog.

CR:403601

CR Number:   403601 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows XP Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 22 Sep 2005 Fixed Description A query failed to execute when there were three scalar values (complex dfe expression nested with case ansi aggregation functions) and subqueries in the top select list.

CR:403795

CR Number:   403795 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 e16 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 22 Sep 2005 Fixed Description A LOAD operation in which constraint violations are being ignored can occasionally fail with the engine reporting an IQ Internal Error - s_ohcidx.cxx; 1379.