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

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

CR:297099

CR Number:   297099 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 08 Sep 2003 Fixed Description Adaptive Server IQ parsed a query incorrectly when the query combined the CONTAINS predicate and an 'Into #temp' clause.

CR:297235

CR Number:   297235 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 14 Jan 2003 Fixed Description A query takes 25min to get a query plan while the execution only need 1 seconds. This happens in version 12.4.3 ESD7.

CR:300063

CR Number:   300063 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2003 Presently Not Targeted For Any Future Release Of This Product Description The IQ server has 2 user event enabled. The event actions gete executed very 3 seconds and contain an INSERT... LOCATION statement. If you stop and start the IQ server the events cannot be executed because if the error: Exception Thrown from hqm_con.cxx:102, Err# 1, tid 264 origtid 264 O/S Err#: 0, ErrID: 8192 (hqm_exception) CtLibrary Error: 141, Severity: 0, Origin: 1, Layer: 1 Error Message: ct_con_props(SET,PASSWORD): user api layer: external error: buflen must be 0 or CS_UNUSED when buffer is NULL. OS Error: 0, OS Message: . -- (hqm_con.cxx 102) Probelm reason: The INSERT... LOCATION statement always takes the user and password from the current connection to connect to an ASE server. The catalog stores the password only as hash value created by an one-way algorithm for security reason. So the password string is not available for the event execution before the end user using this username has connected to ASIQ. As soon as an user has connected using the username all subsequent INSERT... LOCATION in events work file Its not possible to fix this problem without added new syntax or an new feature. i'm going to create an Enhancement Request for this.

CR:300064

CR Number:   300064 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2003 Not a Bug Description If 2 user event concurrently run and both execute an insert location then after 15 min (or 1-3 hours) the IQ server gets into one of the following situations: - the IQ server crashes with the below stacktrace - the IQ server prints the below stacktrace but still exist as unix process and consumes about 380 percent CPU usage on a 4 CPU machine The stack trace is: ucstkgentrace__FilT2 + 0x70 [/sybase/t/sys/asiq12/bin//../lib/libiq.sl] hos_ABORT__FPCcUiT1 + 0x1c4 [/sybase/t/sys/asiq12/bin//../lib/libiq.sl] SigHndlr__Fi + 0x48 [/sybase/t/sys/asiq12/bin//../lib/libiq.sl] _sigreturn [/usr/lib/pa20_64/libc.2] _memmove + 0x22c [/usr/lib/pa20_64/libc.2] mallinfo + 0x1f70 [/usr/lib/pa20_64/libc.2] _ltostr + 0xb6c [/usr/lib/pa20_64/libc.2] realloc + 0x1fc [/usr/lib/pa20_64/libc.2] ut_do_realloc + 0x18 [/sybase/t/sys/asiq12/lib/libdbserv7.sl.1] ut_realloc + 0x64 [/sybase/t/sys/asiq12/lib/libdbserv7.sl.1] MsgListAddToRow__FPciT2 + 0xb4 [/sybase/t/sys/asiq12/lib/libdbserv7.sl.1] Workaround Description  Run only one event with a insert location

CR:300708

CR Number:   300708 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows NT Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Dec 2002 Fixed Description The option Ansi_update_constraints is not descripted for ASIQ but has an effect. This should be corrected. With Ansi_update_constraints = 'strict' an delete statement returns: "update operation attempted on non-updatabled"

CR:301743

CR Number:   301743 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows NT Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 02 Dec 2002 Duplicate Description When using collation ISO_1 and grouping using an LF index the returned result set shows wrong data.

CR:302231

CR Number:   302231 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 04 Dec 2002 Fixed Description In version 12.4.3 ebf3 and above the SET ROWCOUNT nnn statement has no effect for UPDATE and DELETE (see 260409). Please document this correct at least for the next version

CR:303350

CR Number:   303350 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2002 Fixed Description The EBF coverletter for 12.4.3 ebf7 and 8 for HP-UX 64-bit is incorrect for the value shmmax 2147483647 (0x47FFFFFFF). The decimal and the hex value does not fit.

CR:305554

CR Number:   305554 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 e01 14 Apr 2003 Fixed Description A problem that could potentially cause the server to fail when an application opened two cursors concurrently in a single connection has been corrected.

CR:306932

CR Number:   306932 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 22 Mar 2004 Fixed Description Allow concurrent DDL operations to different tables.

CR:307373

CR Number:   307373 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e02 20 May 2003 Fixed Description Starting the Sybase IQ database without the transaction log could corrupt the IQ database. The transaction log is required.

CR:307380

CR Number:   307380 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to improve performance for small fast queries (a.k.a web queries).

CR:309177

CR Number:   309177 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows NT Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e02 07 May 2003 Fixed Description Queries to the metadata for columns of type bigint, unsigned smallint, unsigned int, and unsigned bigint returned the column type as NULL.

CR:309305

CR Number:   309305 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2003 Presently Not Targeted For Any Future Release Of This Product Description Feature request to have the ability to copy/move users' logins and pwd from one database to another, just like the way ASE allows (bcp rows out of the system tables from one database/server and bcp into the same system tables in another database/server after setting a flag (sp_configure "allow updates to system tables" 1) in that ASE server to enable update to system tables). In IQ, we could select rows for login & pwd data out of the sysuserperm system table, but IQ would not allow the user to add (load/insert) rows to the system tables. So right now, we don't have the functionality in ASIQ to accomplish this though this could be done through scripts by the user.

CR:309459

CR Number:   309459 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 03 Jun 2003 Fixed 20 May 2003 Fixed Description If you run ASIQ on HP-UX the OS charset is ROMAN8. If you do an INSERT..LOCATION to an ASE database all characters are converted to ROMAN8 but the ASIQ db is ISO_1. To prevent this convertion the LC_ALL variable on OS level has to be set. With the request the connection done by the INSERT..LOCATION should always set the client local info to the same as the IQ db's collation sequence.

CR:309832

CR Number:   309832 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows NT Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2003 Fixed Description On Windows systems, you can now generate a stack trace on an unresponsive server by creating a file named DumpAllThreads or dumpallthreads in the %ASDIR%\logfiles directory. Starting ASIQ as recommended, using the Program Manager or start_asiq, sets the ASDIR variable automatically. If the ASDIR variable is not set, create the dumpallthreads file in the directory where the server started.

CR:310008

CR Number:   310008 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jun 2003 Fixed Description When a user issues a CREATE DBSPACE ... SERVER ... (long-form, or "alias" version) of a CREATE DBSPACE that names a server that already has a row in SYSIQFILE for the indicated file_id, the ASA code simply lets it through, although no row is added to SYSIQFILE as would be the case if the SERVER specified did not already have a row in SYSIQFILE. The IQ code assumes that the PRIMARY KEY (file_id, server_name) in SYSIQFILE would have caught the duplicate, and so goes ahead and opens (on a query server) the dbspace all over again. This will cause a fatal Throw if the user subsequently tries to drop this dbspace since it is "open" twice.

CR:310194

CR Number:   310194 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 e08 05 Jan 2004 Fixed Description If the environmental variable SQLCONNECT was set, and contained the "dbf" parameter, then dbspawn failed with the error: DBSPAWN ERROR: -81 Invalid database server command line Workaround Description  leave dbf out of SQLCONNECT whenever possible.

CR:310263

CR Number:   310263 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 e02 05 Jun 2003 Fixed Description A problem occurred with queries using parallel GROUP BY where outer references contain switch statements added together. Such statements returned "Can not evaluate expression" errors.

CR:310948

CR Number:   310948 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e02 09 Jun 2003 Fixed 12.6 08 Sep 2003 Fixed Description Certain scripts that contain proxy tables referring to Sybase IQ fail with a stack trace.

CR:311043

CR Number:   311043 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows NT Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2003 Not a Bug Description When running the following remote procedure call the ASIQ server dies.

CR:312448

CR Number:   312448 Product Name:   IQ Product Component:   other tools Status:   Closed OS:   Windows NT Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e02 28 Apr 2003 Fixed Description Errors in prompts returned by the getiqinfo tool have been corrected. The tool is named getiqinfo.bat on Windows systems and iqgetifo.sh on UNIX.

CR:312542

CR Number:   312542 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.4.3 e10 17 Jun 2003 Fixed 12.5 e02 05 Sep 2003 Fixed Description A problem with mismatched datatypes now returns the appropriate conversion error instead of causing server failure.

CR:312577

CR Number:   312577 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 e04 17 Sep 2003 Fixed Description If the option QUERY_RUN_AFTER_PLAN is set ON, queries of the form: INSERT INTO <temp table> ... SELECT ... did not generate a pre-run query plan as they normally would.

CR:312721

CR Number:   312721 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows NT Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e02 16 Jun 2003 Fixed Description Certain large queries within INSERT statements caused Sybase IQ to fail with a stack overrun. To solve this problem, ASIQ now allows a larger safety margin for thread stack space. INSERT SELECT statements may be returned with an insufficient stack error message requesting that you increase the -iqtss setting. Increasing -iqtss by 72KB permits such statements to complete. On 32-bit systems only, depending on your memory configuration, you may need to decrease Load_Memory_MB in order to increase -iqtss.

CR:313022

CR Number:   313022 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 07 Mar 2006 Fixed Description ASE compat: support default values in Load/Insert/Update including automatic TIMESTAMP

CR:313358

CR Number:   313358 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e02 12 Jun 2003 Duplicate Description Various stored procedure syntax errors, such as improper use of quotation marks or invalid table and variable references could result in a SEGV or Signal 10 server failure. Related CRs are 310843, 312345, 316064 and 317803.

CR:314519

CR Number:   314519 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 e01 16 Apr 2003 Fixed Description A problem affected the incremental High_Group load algorithm.

CR:315146

CR Number:   315146 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e02 09 Jun 2003 Fixed Description Certain queries with complex derived tables could either return incorrect results or cause server failure. This problem is corrected.

CR:315238

CR Number:   315238 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows NT Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e02 13 May 2003 Fixed Description Executing the getdate() function within an insert statement like the following returned zeroes for the milliseconds: INSERT INTO testtable VALUES (getdate())

CR:315421

CR Number:   315421 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 e02 20 May 2003 Fixed Description A query with certain characteristics could return a "can not evaluate expression" error. This problem affected a query with a SELECT DISTINCT column in a derived table that was not used in another query block. The column also happened to be in a case expression that was an argument of a complex expression.

CR:315571

CR Number:   315571 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e02 18 Nov 2003 Fixed Description There is a chance that Sybase IQ on an AIX system will receive an internal error and create a core file if an attempt is made to generate an HTML file.

CR:315729

CR Number:   315729 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 e02 19 Jun 2003 Fixed Description Turning on the ASA option for long plans in java dbisql could cause an IQ server to fail.

CR:315738

CR Number:   315738 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e02 06 May 2003 Fixed Description Sybase has corrected a problem affecting columns where either all values are null or the table is empty, have either a 1-byte or 2-byte FP index, and has neither a LF nor an HG index. Such a column, used in a predicate, could potentially cause either a floating point hardware exception and subsequent server failure or an "invalid arithmetic construction" error. Workaround Description  For SamSung Card: (1) Execute "Select count(*) from the table into a variable" and only run the query if the COUNT(*) returned is not zero. (2) Supply a user selectivity estimate, for example for 10% selectivity: Where (<column

CR:316440

CR Number:   316440 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2000 Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e02 25 May 2003 Fixed Description On rare occasions, when multiple users try to extract to the same public file, the server could fail and return only a "no connection to the server" message. Now the client receives "OS error reported on file: xxxx", where xxxx is the file name that Adaptive Server IQ failed to create for the EXTRACT operation, followed by the error code and location (source filename and line number) that triggered the error. In very rare cases, the error "Failed in derived class conductors" may be returned instead.

CR:316661

CR Number:   316661 Product Name:   IQ Product Component:   other tools Status:   Closed OS:   Windows NT Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jun 2003 Duplicate Description DBISQL Java stacktrace when numeric column has no precision defined or column has precison > (90,0) Workaround Description  Define scale and precision with numeric column < (90,0)

CR:316907

CR Number:   316907 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e02 24 May 2003 Fixed Description While processing certain unusual queries that contain several joins and that include several join conditions containing the same columns, the server could fail. Workaround Description  Disable the substitution of equated expressions by: set temporary option dml_options3 = 8388608

CR:317290

CR Number:   317290 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 e02 20 May 2003 Fixed Description While processing certain unusual queries containing numerous joins, the server could fail. Workaround Description  Workaround: set temporary option dml_options25 = 'on'; <run query> set temporary option dml_options25 = 'off'; This disables all pushdown join algorithms within that query.

CR:317602

CR Number:   317602 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 e02 10 Jun 2003 Fixed Description Prior to this release, a server failure might occur when the datatype, precision, and/or scale of a column changed between the cursor describe and open. This error is now corrected and IQ processes the statement and logs a warning in the .iqmsg file.

CR:317650

CR Number:   317650 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e02 05 Jun 2003 Fixed Description A problem with the stop_asiq script prevented Sybase IQ from detecting all servers running.

CR:317830

CR Number:   317830 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.4.3 e10 30 Jun 2003 Fixed 12.5 e02 08 Sep 2003 Fixed Description A timing sensitive issue involving scheduling priority of writing information to the server log, connection disconnecting, and server commits/checkpoints is corrected. On active servers with many connections, it would appear that the server was temporarily suspended during these scheduling conflicts.

CR:317857

CR Number:   317857 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 e02 03 Jun 2003 Fixed Description On rare occasions while processing a statement containing an IN predicate using an HG index, the server could fail.

CR:317861

CR Number:   317861 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e02 23 May 2003 Fixed Description On HP-UX, a query with more than 24 individual GROUP BY columns could portentially cause server failure.

CR:318250

CR Number:   318250 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e02 16 Jun 2003 Fixed Description Certain queries containing host variables whose values were bound via an Embedded SQL OPEN statement were incorrectly rejected with a "Non-Fatal IQ Internal Error". Workaround Description  Workaround is simply to avoid redundant predicate elimination optimization by: set temporary option dml_options2 = 67108864 <run query> set temporary option dml_options2 = 0

CR:318332

CR Number:   318332 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 04 Mar 2004 Fixed 12.5 e08 26 Jan 2004 Fixed Description Certain queries could get rejected with an internal error in dfo.cxx Workaround Description  The problem in this particular query is not the generated plan, but is instead in the error checking code for orderedness within the plan. To disable this error checking code: set temporary option dml_options3 = 512

CR:318650

CR Number:   318650 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 e02 09 Jun 2003 Fixed Description The sp_iqcheckdb procedure verify and repair options incorrectly reported that the LF index was inconsistent.

CR:318942

CR Number:   318942 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e02 10 Jun 2003 Fixed Description Certain concatenated statements caused Adaptive Server IQ to fail.

CR:318978

CR Number:   318978 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.4.3 e10 30 Jun 2003 Fixed 12.5 e02 08 Sep 2003 Fixed Description A timing-sensitive issue involving resource management during set options processing and connection open/close is corrected. On servers handling many connects/disconnects, it could make the server unresponsive.

CR:319000

CR Number:   319000 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Sep 2003 Fixed Description A certain program failed with a stack trace using the embedded-SQL preprocessor and associated libraries shipped for Sun and AIX 64-bit systems, but worked correctly on HP 64-bit and Sun 32-bit systems. Duplicate of CR 329001.

CR:319059

CR Number:   319059 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows NT Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.4.3 e10 02 Jun 2003 Fixed 12.5 e02 08 Sep 2003 Fixed Description Under certain circumstances, a statement could fail with the error "Cannot find index for field."

CR:319278

CR Number:   319278 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2000 Original Version:   12.5 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e02 06 Jun 2003 Fixed Description A problem prevented previous versions of Sybase Central and the IQ plug-in from starting, even after documentation instructions for preserving these versions was followed. Workaround Description  The end user might need to make some minor changes in the files: SybCentral.res & scjviewIQ.bat, Documentation sent to TSE. Or auomated fix planned to be added to ESD2 or higher for an automated fix.

CR:319519

CR Number:   319519 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 e02 21 May 2003 Fixed Description A problem with DATE and DTTM indexes has been corrected. After updating a DATE or DTTM index, running sp_iqcheckdb reported that the index was inconsistent due to a bitmap verify error.

CR:319687

CR Number:   319687 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 e02 06 Jun 2003 Fixed Description If the sp_iqcontext procedure was run on one connection at exactly the same instant that a different connection was destroying a cursor, the server could on rare occasions fail.

CR:320552

CR Number:   320552 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 e04 17 Sep 2003 Fixed Description A certain query with join keys of different data types ran slower after IQ 12.5 was installed, the database was rebuilt, and the tables were reloaded.

CR:320562

CR Number:   320562 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e08 14 Jan 2004 Fixed 12.6 22 Jan 2004 Fixed Description A server failure indicating "v2s_bmseg.cxx" and "Verify error" with "out of order" has been fixed.

CR:320717

CR Number:   320717 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 e04 17 Sep 2003 Fixed Description Adaptive Server IQ 12.5 does not support the PARTITION BY clause, for example: SELECT district, grade, avg(math_score), rank() over (PARTITION BY district ORDER BY AVG(math_score) desc) AS rank_d FROM math_report GROUP BY district, grade ORDER BY district; Such statements now return an appropriate error.

CR:320816

CR Number:   320816 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows NT Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 17 Sep 2003 Fixed Description Using a Java function call in place of a column name in a select could cause server failure. (Duplicate of CR 277876 and 313199.)

CR:320902

CR Number:   320902 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 17 Sep 2003 Fixed Description A simple insert with a join between columns of different datatypes (char(9) and char(10)) returned the error "Non-Fatal IQ Internal Error Detected at dfjo_Hash.cxx:378 on thread 273" followed by a stack trace. Workaround Description  One workaround is to replace the original join condition: f.CORP_CD *= l.CORP_CD with one that casts the narrow key to the wider data type: cast(f.CORP_CD as char(10)) *= l.CORP_CD The alternate (and ultimately better) workaround is to chang

CR:320910

CR Number:   320910 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.4.3 e10 26 Jun 2003 Fixed 12.5 e04 25 Aug 2003 Fixed Description Certain INSERT ... SELECT operations could result in an unresponsive server. The problem occurred on a statement such as INSERT ... SELECT col1, col2, ... FROM table1 where there were many columns in the select list and each column had a HG index on it.

CR:320930

CR Number:   320930 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e02 02 Jun 2003 Fixed Description Sybase IQ did not write "Total number of blocks being restored" messages to the .stderr file.

CR:321050

CR Number:   321050 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 08 Sep 2003 Fixed Description A single GROUP BY query without a WHERE clause using a HG index returned the wrong result. For example: SELECT col, COUNT(*) FROM T GROUP BY col

CR:321179

CR Number:   321179 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows NT Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 28 Sep 2004 Fixed Description A server failure could occur on Windows when running a query with nested string functions.

CR:321182

CR Number:   321182 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 04 Mar 2004 Fixed 12.5 e08 22 Jan 2004 Fixed Description The support for pushdown joins into a view containing a UNION ALL over a set of simple base tables has been extended to include cases where the exact distinct count for the join column from the view is not available, but the exact distinct counts for all the underlying base columns are available. In these cases the cost analysis of the pushdown join can proceed using the worst case collective distinct count.

CR:321699

CR Number:   321699 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Apr 2004 Fixed 12.5 e04 17 Sep 2003 Fixed 12.6 21 Apr 2004 Fixed Description A query that features a series of disjuncts on the same column returned incorrect results. For example: SELECT * FROM test1 WHERE (a > 1 AND a <3) OR (a > 4 AND a <6) OR (a > 8 AND a <10) returned values 2,5,6,7,8 and 9.

CR:321946

CR Number:   321946 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 08 Sep 2003 Fixed Description Running a query containing a Java function on a Sun 64-bit or AIX 64-bit (IQ 12.5. ESD2) system caused server failure. On an HP-UX 64-bit system (ESD2), the same query returned incorrect results.

CR:322287

CR Number:   322287 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 08 Sep 2003 Fixed 12.5 e04 17 Sep 2003 Fixed Description While loading rows with constraint violations, a server failure occurred at st_server.cxx; 1037.

CR:322556

CR Number:   322556 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 17 Sep 2003 Fixed Description When calling a remote stored procedure using class ASEODBC, the following error is returned if the procedure has an IN parameter of type NUMERIC: DIAG [HY104] [DataDirect][ODBC Sybase Wire Protocol driver]Invalid precision value. Error in parameter 1. (0) (Duplicate of CR 323070.)

CR:322730

CR Number:   322730 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e03 17 Jun 2003 Fixed Description A problem in the join optimization phase for some queries for which the join optimizer selected a join plan where the right join tree below a hash pushdown or sort/merge pushdown join contained additional hash pushdown or sort/merge pushdown joins, could under some circumstances cause server failure. This problem has been fixed. Workaround Description  Only workaround available is to avoid all pushdown joins via: set temporary option dml_options25 = 'on'; <run query>; set temporary option dml_options25 = 'off';

CR:322760

CR Number:   322760 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.5 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e03 24 Jun 2003 Fixed Description A problem caused a server deadlock when the buffer caches were stressed.

CR:322939

CR Number:   322939 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.4.3 e10 27 Jun 2003 Fixed 12.5 e04 04 Sep 2003 Fixed Description When a multiplex query server is promoted to be a write server before a backup, a dummy row is left in the sysiqfile and sysfile tables for the original IQ_SYSTEM_TEMP dbspace. The restore operation tries to restore this file, which conflicts with the other temporary dbspaces, and the restore fails.

CR:322940

CR Number:   322940 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.4.3 e10 19 Jun 2003 Fixed 12.5 e04 22 Sep 2003 Fixed Description An incremental restore operation could fail if no database changes were made between the last full backup and a subsequent incremental backup. This could occur for example, during a virtual backup.

CR:322991

CR Number:   322991 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 08 Sep 2003 Fixed Description An attempt to drop a table with 211,000,000 rows caused server failure and returned a "memory corruption detected" error.

CR:322996

CR Number:   322996 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 22 Sep 2003 Fixed Description A procedure that created a nested view in a loop failed with the error "correlation name A not found." In 12.5 esd2, the error is "column '' not found." Duplicate of CR 324035.

CR:323403

CR Number:   323403 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 10 Oct 2003 Fixed 12.5 e04 08 Sep 2003 Fixed Description On a machine with a very large number of CPUs, an ASIQ server may fail while creating a very large database with the default main cache size.

CR:323417

CR Number:   323417 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.5 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 09 Sep 2003 Fixed Description In Adaptive Server IQ 12.5, Chained=OFF was not doing an implicit commit after commands like INSERT, UPDATE, or DELETE, or TRUNCATE.

CR:323539

CR Number:   323539 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 e04 17 Sep 2003 Fixed Description The "Other Versions" display returned by sp_iqstatus was incorrect.

CR:323566

CR Number:   323566 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 17 Sep 2003 Fixed Description A query with a host variable in the select list could return the non-fatal internal error: IQ Internal error. Please report this to Sybase IQ support. -- (dfe_HostVar.cxx 250) Duplicate of CR 326228. Workaround Description  The workaround is to replace the host variable with an equivalent expression. For char or varchar data types, use (@hos_var_char || '') and for numeric data types, use (@hos_var_num + 0).

CR:323760

CR Number:   323760 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2000 Original Version:   12.5 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e02 15 Jul 2003 Presently Not Targeted For Any Future Release Of This Product Description The below select statement does not show the result set in DBISQLC if the db was created with UTF8 and the engine was started with -ct: select char(233). The problem does not exist in DBISQL (java)

CR:323869

CR Number:   323869 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.5 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 17 Sep 2003 Fixed Description Committing certain REVOKE statements may result in an unresponsive server.

CR:323983

CR Number:   323983 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.5 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 17 Sep 2003 Fixed Description Using Ctrl-C while processing a multi-level hash push down join with union views caused server failure and the following Signal 11 error: *** SybaseIQ Abort at st_server.cxx:1037 for PID: 174 ***

CR:324247

CR Number:   324247 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.5 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 07 Oct 2003 Fixed Description Server failure with the error "Memory Allocation size too large" occurred when running a 300+ UNION ALL statement. An expression cannot be larger than the PAGE SIZE of the database. Duplicate of CR 327225.

CR:324254

CR Number:   324254 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.5 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2004 Workaround Description When a session using Open Client isql makes any reference to a remote server, the connection to the remote server (from the SA engine) is not closed correctly when the client disconnects. Connections from dbisql java are handled correctly with the connection closed on disconnect.

CR:324387

CR Number:   324387 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.5 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 30 Jun 2003 Duplicate Description A certain cartesian join query causes the server to fail with the following Signal 10 error: *** SybaseIQ Abort at st_server.cxx:1037 for PID: 5410 *** Same as CR 324390.

CR:325101

CR Number:   325101 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 17 Sep 2003 Fixed Description A certain query on non-unique HG indexes caused server failure and the following Signal 10 error: *** SybaseIQ Abort at st_server.cxx:1037 for PID: 15979 *** Caught signal 10, program abort

CR:325116

CR Number:   325116 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.5 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jul 2003 Duplicate Description Doc enhancement request: add an IQ system tables poster to the IQ doc set, such as we publish for ASE and RepServer (color, approx. 26" x 32"). The customer would like to see the IQ system tables diagram in a poster. The system table diagram currently in the Reference Manual is too small and not easy to be posted to wall for group discussion.

CR:325125

CR Number:   325125 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.0.2 (GA) Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 08 Sep 2003 Fixed Description An UPDATE statement caused a server failure with a signal 11 error. The statement contained CASE WHEN clauses, for example: UPDATE CONCORD SET A.err_cd = (case when substr(A.packet,1,10) = 'HOST ERROR' then 'HOST ERROR' when substr(A.packet,1,3) = 'TXF' then substr(A.packet,56,10) else '' end), A.err_gb = (case when substr(A.packet,1,10) = 'HOST ERROR' or substr(A.packet,1,3) = 'TXF' then 'E' else 'O' end) FROM CONCORD A WHERE trdate like '20030625%'

CR:325127

CR Number:   325127 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 08 Sep 2003 Fixed Description On HP-UX systems, a query with more than 24 tables in a view could cause server failure with the error "Sybase IQ Abort at hos_eom.cxx:205."

CR:325436

CR Number:   325436 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows NT Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 08 Sep 2003 Fixed Description Not verifying the size of a raw partition during the restore could cause a problem where a dbspace is defined to be larger than the raw partion where it was created.

CR:325501

CR Number:   325501 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.5 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e05 09 Jan 2004 Duplicate Description Executing a certain query sometimes failed, returning the error s_bufman.cxx:1791 or s_bufman.cxx:3717.

CR:325830

CR Number:   325830 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 29 Sep 2003 Fixed Description An unresponsive server may result when a race condition occurs between 'backup' and any other connection performing the first operation of a new transaction.

CR:325890

CR Number:   325890 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows NT Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 28 Apr 2004 Fixed Description MPX/SJC: Allow use of other DBA user to control database

CR:326031

CR Number:   326031 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows NT Original Version:   12.4.3 e11 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 08 Sep 2003 Fixed Description A multiplex query server failed in db_catReplRow::OpenMCIndex() while processing Table Level Versioning (TLV) updates. Workaround Description  Write server transactions that update a table must not have a cursor open on the table when they commit the transaction. Note that certain clients may have this behavior, dbisql classic being one example.

CR:326723

CR Number:   326723 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.5 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2003 Fixed Description If a view containing a UNION and defined with SELECT * is no longer valid because columns have been added to the tables referenced in the view, a query referencing that view could cause an unresponsive server.

CR:326839

CR Number:   326839 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 08 Sep 2003 Fixed Description In an UPDATE statement, omitting the equality token from a SET clause enclosed in parentheses caused server failure and a SEGV error from "static SA_RESULT AnnotateUpdate(a_ptree_info *info, a_statement *stmt)." Duplicate of CR 309290.

CR:326880

CR Number:   326880 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 e04 16 Sep 2003 Fixed Description If the option HASH_THRASHING_PERCENT has been set to any value other than the default value, it should appear in the query plan.

CR:327214

CR Number:   327214 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.3 e11 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Sep 2003 Workaround Description "Connection failed: Database server not running" when attempting to connect to the database using ODBC. The problem occurs when there are 3 servers running on the same host machine, and the one having the problem is listening to port #2638 and is started last. There is NO problem if it's started first. Workaround Description  Add "udp=no" in TCP/IP (in network tab)

CR:327299

CR Number:   327299 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 13 Oct 2003 Fixed 12.5 e04 17 Sep 2003 Fixed Description Inserting the date '0001-01-01' into a DATE index or a value of '0001-01-01 00:00:00' into a DTTM index caused server failure. Duplicate of CR 327307.

CR:327523

CR Number:   327523 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 e04 08 Sep 2003 Fixed Description A LOAD statement that explicitly set the BLOCK FACTOR value greater than 10000 loads zero rows instead of exactly one row. To avoid the problem, always set BLOCK FACTOR less than or equal to 10000 in the LOAD statement.

CR:327563

CR Number:   327563 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 e04 17 Sep 2003 Fixed Description The following query returned an incorrect result on a Sun platform and caused a server on HP-UX to fail with a Signal 10 error: SELECT ... SUM(b2.num1) AS num1 FROM (SELECT ...) b1, (SELECT ... sum(1) AS num1 ... GROUP BY char12, date1) b2 ... GROUP BY char12, date1