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

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

CR:722155

CR Number:   722155 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description running xp_cmdshell from an IQ server on Linux where the execution gives all the appearance of having been successfully run in IQ , but in reality nothing happens. The unix command, even if it is just a touch file, does not execute. It appears to have something to do with when the child process is spawned it seems to think it needs as much virtual memory as the parent process (the IQ server in this case) . The resolution almost always is to make sure that the swap space is at least 1 x the amount or RAM being used by IQ. This is related to CR 633354 - this feature request if to try find a better way to make this unix call / improve the message handling.

CR:722336

CR Number:   722336 Product Name:   IQ Management Product Component:   Web UI - Heat Chart Status:   Closed OS:   RH Linux Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Dec 2012 Fixed Description This resolution addresses a heat chart issue where alert related information is not accurately reflected unless the chart is refreshed

CR:722356

CR Number:   722356 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 31 Oct 2012 Added to user documentation Description "SQL, HOSTVARS, PLAN, PROCEDURES, TRIGGERS, OTHER, BLOCKS, REPLACE, ALL and YES, NONE, and NO" can be specified to be "-zr" database starting options. The details written to the IQ15Utility guide are not correct.

CR:722462

CR Number:   722462 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2012 Fixed Description When using distribited query processing in a MPX environment, IQ may crash when using a technique called early grouping sort and hash joins

CR:722485

CR Number:   722485 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 05 Mar 2013 Fixed Description User with the CREATE TABLE privilege will be prevented from proceeding in the table wizard if they select a user other than self.

CR:722560

CR Number:   722560 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.2 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 05 Dec 2012 Duplicate Description An update statement can result in a connection unable to be dropped.

CR:722578

CR Number:   722578 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.2 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2013 Not a Bug Description Connections that have a cursor in prepare mode could fail to be able to drop if application abnormally disconnects

CR:722606

CR Number:   722606 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2013 Fixed 16.0 sp01 03 Apr 2013 Fixed 02 May 2013 Fixed Description Value for field 'columns' of sp_iqdbspaceinfo, while run for IQ_SYSTEM_MAIN and a partitioned table,returns non-zero value, expected is zero. This has been fixed.

CR:722628

CR Number:   722628 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 08 Dec 2012 Fixed Description Temp buffer pool was running out of buffers for parallel distinct aggregates due to each thread obtaining its own pin allocation. After a few threads have done so, there was not enough buffers available to initialized the remaining threads.

CR:722661

CR Number:   722661 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 18 Dec 2012 Fixed Description Updates against an RLV enabled table using NBit could lead to a crash, this has been fixed.

CR:722919

CR Number:   722919 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e04 26 Mar 2013 Fixed 16.0 sp02 15 Aug 2013 Fixed Description Query with count aggregate on column having NULLs and a grouping column ran slowly when IQ optimizer performed aggregation using index.

CR:722973

CR Number:   722973 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jan 2013 Duplicate Description IQ 15.2 infrequent occurence of writer node hangs during a checkpoint. The system never comes back and they end up having to cancel the server. The pstacks prior to cancelling the writer node show no activity / movement. There is a lot of threads waiting on implicit locks and the thread handling the checkpoint seems to be blocked trying to flush version information.

CR:723133

CR Number:   723133 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows 7 Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jan 2013 Duplicate Description A long delay may have been observed when right-clicking in the SQL Statements panel, especially if the internet connection was slow, or if there was no internet connected at all. This has been fixed. Note, the problem does not occur if the documentation has been installed locally. (ADDL CR728720)

CR:723216

CR Number:   723216 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 05 Mar 2013 Fixed Description The Foreign Key Constraint Wizard had a 508 issue where the keyboard would not successfully enable a particular drop down menu.

CR:723294

CR Number:   723294 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e03 04 Feb 2013 Fixed Description LOAD TABLE may incorrectly report "Warning: Partial input record (x bytes) skipped at EOF" and fail to load the last row from the input file.

CR:723446

CR Number:   723446 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e03 21 Jan 2013 Fixed Description LOAD TABLE may incorrectly give error "Number of bytes (xxxxx) exceeds maximum (yyyyy)" during a LOAD with QUOTES ON.

CR:723476

CR Number:   723476 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2013 Fixed 16.0 sp01 27 Feb 2013 Fixed 20 Nov 2013 Presently Not Targeted For Any Future Release Of This Product Description A query with an outer join and many case expressions in the the select list may consume an unacceptable amount of temporary space.

CR:723503

CR Number:   723503 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Windows 2008 Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2012 Not a Bug Description Windows GPT disk was supported by Sybase IQ 15.4 ESD#1

CR:723697

CR Number:   723697 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2012 Fixed Description When a table created in an IQ 15 database with 1, 2, or 3 byte FP is upgraded and joined to a N bit tokenized FP created in IQ 16,the server will crash

CR:723820

CR Number:   723820 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When all the 3 conditions are met: - IQ SERVER is 15.4 esd 2 of any platform - ISQL client is from 15.4 esd 2 LINUX 64 install (bundled Open Client 15.7.0.1) - the option RETURN_DATE_TIME_AS_STRING=on Then: 1> select getdate() 2> go getdate() ----------------------- 2012-11 CT-LIBRARY error: ct_fetch(): protocol specific layer: external error: There is a tds protocol error. An illegal token was received.

CR:723829

CR Number:   723829 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2012 Fixed Description The following scenario would lead to a server crash. Client has auto-commit on disconnect enabled. 1) Client 1 tries to insert a row in RLV store and has taken the lock. (this insert is not committed) 2) Client 2 fires non-blocking RLV-main store merge, which blocks on the lock. 3) Insert from client 1 completes, followed by merge from client 2. 4) Run select from client 1 5) Disconnect the client 1 fires auto-commit 6) Re-connect and run select again on client 1 This has now been fixed.

CR:723891

CR Number:   723891 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 11 Dec 2012 Fixed Description The conditions for which insert/load currently written to "System Administration Guide Volume 1" uses a multithread are not correct.

CR:724003

CR Number:   724003 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e03 10 Dec 2012 Fixed Description Data is loaded incorrectly to a partitioned table following a data value constraint violation.

CR:724109

CR Number:   724109 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp02 24 Jul 2013 Fixed 16.0 sp02 05 Aug 2013 Fixed 16.0 sp02 21 Aug 2013 Fixed 16.0 sp02 21 Aug 2013 Not a Bug 16.0 sp02 13 Aug 2013 Fixed 16.0 sp02 15 Aug 2013 Fixed 16.0 sp02 21 Aug 2013 Fixed 16.0 sp02 04 Sep 2013 Fixed 16.0 sp02 19 Aug 2013 Test Exists 16.0 sp02 29 Aug 2013 Not a Bug Description A query that contains a UNION ALL with an uncorrelated subquery executed over a set of tables performs much slower than the same query executed over a single giant base table.

CR:724223

CR Number:   724223 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e03 12 Dec 2012 Fixed Description The server could in some cases fail while performing a BCP IN request if an error was generated while servicing the BCP request. This problem has now been fixed.

CR:724297

CR Number:   724297 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Windows 2008 Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Use of a special value or a user SQL function generate the incorrect query plan. However, an issue is not reproduced when a special value with the date types, such as CURRENT TIMESTAMP is used.

CR:724391

CR Number:   724391 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Dec 2012 Fixed Description If you create a logical server with no servers, the secondary servers can go into an infinite loop during TLV replay giving an impression of a hang

CR:724532

CR Number:   724532 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Nov 2013 Presently Not Targeted For Any Future Release Of This Product 16.0 sp02 03 Oct 2013 Fixed Description An insert .. select statement containing WITH .. AS fails with a Column not found error in 15.4 esd2.

CR:724591

CR Number:   724591 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Consult Complete Description LOAD TABLE does not output error column information, when the data over string length exists.

CR:724601

CR Number:   724601 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Unknown Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Currently LIST function resides in the SA catalog. Each time it is called from IQ, it needs to go through CIS, which causes some performance overhead. The customer would like the LIST function to be implemented in the IQ SYSTEM store to boost performance.

CR:724627

CR Number:   724627 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e03 02 Jan 2013 Fixed 15.4 e02.x 04 Feb 2013 Fixed 16.0 17 Jan 2013 Fixed Description CR724627 A left outer join on ISNULL() may not return a correct result set. For example, "select * from A left outer join B on IsNull(A.b,9999) = B.b;" To be more generic any query having leftouter join with all the join condition as invariant predicate (either they are invariant or become invariant because of some simplification by the optimizer) might return wrong result. After the fix the leftouter join remains as it is rather than getting converted to cross join.

CR:724634

CR Number:   724634 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Original Version:   15.4 e01.x Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_iqcheckdb can return corrupt index error on an LF index created with more than 10000 unique values after setting LF_Max_Unique_Values option to a number as high or higher as actual unique values over 10000

CR:724764

CR Number:   724764 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2012 Fixed 16.0 sp01 29 Mar 2013 Fixed 16.0 sp01 22 Mar 2013 Fixed 16.0 sp01 01 Apr 2013 Fixed Description Query plans would not display all fields for RLV enabled tables. This has been fixed.

CR:724804

CR Number:   724804 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jul 2013 Not reproducible with latest version of the product available as of Resolution Date Description IQ 12.7 -> 15.2 upgrade - performance degrade in Subsequent Fetch performance returning result set to client in some queries in Solaris environment

CR:724806

CR Number:   724806 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Dec 2012 Fixed 21 Dec 2012 Fixed Description Usage of updateable cursors on secondary MPX Writers can cause the Writer to crash

CR:725054

CR Number:   725054 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e02.x 05 Dec 2012 Fixed Description LOAD TABLE will case a server failure if loading from a file with no filename extension.

CR:725055

CR Number:   725055 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Unknown Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Nov 2012 Not a Bug Description select dateformat('2012-nov-12 08:05:02','YYYY-MM-DD-HH:NN:SS') errors in 15.4, but not in 12.7 or 15.2.

CR:725181

CR Number:   725181 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description "select dateformat('2012-nov-12-08:05:02','YYYY-MM-DD-HH:NN:SS') from iqdummy" should throw an error same as the catalog (from dummy) does.

CR:725406

CR Number:   725406 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2012 Fixed Description Bad data could be merged from the RLV store into the IQ main store base table, if a column was set to the bit datatype. This has now been fixed.

CR:725639

CR Number:   725639 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e03 27 Dec 2012 Fixed 15.4 e03 15 Jan 2013 Fixed 15.3 14 Feb 2013 Fixed 15.4 e03 14 Feb 2013 Fixed 15.4 e04 14 Feb 2013 Fixed Description An IS NULL test in a CASE expression can fail to return rows. Workaround Description  set temporary option dml_options6=131072;

CR:725806

CR Number:   725806 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2013 Duplicate Description 15.4 esd 2 Simple query slower compared to 15.2 esd 3

CR:725871

CR Number:   725871 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.4 future Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 14 Dec 2012 Fixed Description The description about the fault caused during DQP execution does not exist in the manual of IQ.

CR:726114

CR Number:   726114 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Dec 2012 Fixed Description The LastReqTime connection property could have had an incorrect time stamp compared to current time. This would have only occurred if the server had been running for more than 24 hours. This has been fixed.

CR:726127

CR Number:   726127 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e03 06 Feb 2013 Fixed 13 Feb 2013 Fixed 16.0 13 Feb 2013 Fixed Description sp_iqrebuildindex will fail with "Invalid expression" if the index_clause is a quoted identifier. Workaround Description  Rename column with . (DOT) to some string literal without . (DOT) Run sp_iqrebuildindex on this temporary string literal Rename column back to original name with . (DOT)

CR:726128

CR Number:   726128 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Dec 2012 Fixed 05 Dec 2012 Fixed Description When logging message in the iqmsgfile, the username string may get truncated.

CR:726167

CR Number:   726167 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2012 Fixed Description Performing an incremental back of the RLV enabled store could lead to a server crash. This has been fixed.

CR:726373

CR Number:   726373 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Suse Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 20 Mar 2013 Fixed Description If the trigger definition resulting from ALTER TRIGGER statement execution conflicted with an existing trigger, the original trigger could be deleted, and wrong error returned. This has been fixed. This change also introduces a change in the algorithm used to decide the order of firing triggers when ORDER clause is not specified or multiple triggers with the same order and combination of events were created. For example, this may change the order in which triggers created with UPDATE ORDER 2, UPDATE, DELETE ORDER 2 and UPDATE OF <col> ORDER 2 are fired. Note that documentation explicitly recommends specifying different ORDER values for triggers with the same event. If your database contains such sets of triggers, and the order of firing is important, please alter the triggers to reorder them accordingly. In general, both UPDATE ORDER 1 and UPDATE OF <col> ORDER 1 triggers will fire before any UPDATE ORDER2 triggers are fired. A unique ordering between UPDATE and UPDATE OF <col> triggers is still recommended.

CR:726496

CR Number:   726496 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2012 Fixed Description When merging updates from the RLV enable store back into the IQ main store, an ordering error might be encountered. This has been fixed.

CR:726541

CR Number:   726541 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jan 2013 Fixed Description IQ server generates an error 9216 saying "Feature, ORDER BY in Union View, is not supported." when using a select-into query with an orderby clause

CR:726559

CR Number:   726559 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) QA PF 10 14 Dec 2012 Fixed Description For the grouped queries against the RLV store, wrong results might be returned. This has been fixed.

CR:726794

CR Number:   726794 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description IQ 15.4 ESD 1.1 Linux64 - IBM pSeries 2.6.18. They have a large partial width update statement that threw an exception at s_bm.cxx:1919 call at _ZN4s_bm7SetBits. Workaround Description  customer broke down the size of the update (by rowid) and got around the issue

CR:726819

CR Number:   726819 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2013 Fixed 11 Feb 2014 Fixed 03 Sep 2014 Fixed Description Queries having a combination of Sort merge join and Windows operator might give wrong result. Because of early exit logic of sort mege join this bug got exposed. Fix resolves this issue. Workaround Description  Avoid short merge join : set temporary option join_preference = '-1' serial execution : set temporary option DML_OPTIONS8=8 works around this

CR:726924

CR Number:   726924 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e03 03 Mar 2013 Fixed 16.0 sp01 18 Feb 2013 Fixed 18 Feb 2013 Fixed Description When the data of the duplicate primary key and WD index is inserted, IQ process stops. Workaround Description  Set "core_options27=1" before the INSERT VALUES or INSERT SELECT statement when inserting to a word index to workaround the problem.

CR:727002

CR Number:   727002 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Linux Red Hat Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description LOAD TABLE does not output error column information, when the data over string length exists.

CR:727006

CR Number:   727006 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Linux Red Hat Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The information on the violation of constraint outputted to a ROW LOG file is outputted based on ROWID. The function which outputs a data file name and a line number does not exist.

CR:727148

CR Number:   727148 Product Name:   IQ Management Product Component:   Web UI - Node Monitor - View All Statistics in Tab Status:   Open OS:   RH Linux Original Version:   3.2.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description SCC does not have the function which exports performance data etc. to external data.

CR:727155

CR Number:   727155 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2012 Fixed 16 Jan 2013 Fixed 17 Jan 2013 Fixed Description When using IQ MPX server, the coordinator may hang when doing distributed query processing under heavy load.

CR:727388

CR Number:   727388 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp08 30 Dec 2013 Already Fixed by Another CR Description A query that includes TOP, a subquery with an alias, and the alias used in the order by clause failed with a Non-Fatal IQ Internal Error Detected at dfo_cOrderBy.cxx:481.

CR:727417

CR Number:   727417 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e02.x 03 May 2013 Duplicate Description Stack trace on at s_packedRec.cxx:1287, on a query with CAST to varchar > 255 Workaround Description  If possible, CAST TO VARCHAR (255)

CR:727427

CR Number:   727427 Product Name:   IQ Product Component:   Utility Status:   Open OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description As the number of concurrent requests across the resource gate increases , as expected you see the number of available concurrent commands reported in the Context Server statistics StCntxNResource field drop. However if all concurrent resources are in use and requests start queuing (i.e. the figure in StCntxNWaiting starts increasing) then the data reported in StCntxNResource becomes a nonsensical / corrupt 10 digit figure.

CR:727579

CR Number:   727579 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Dec 2012 Fixed Description IQ may produce wrong result in some rare cases when probing an nBit index.

CR:727581

CR Number:   727581 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2013 Fixed Description When running distributed query processing in a MPX server, all worker threads may crash for that given query

CR:727585

CR Number:   727585 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 7 Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Dec 2012 Fixed Description Under rare circumstances, the background automerge of an RLV enabled table would loop repeatedly. This has been fixed.

CR:727648

CR Number:   727648 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Dec 2012 Fixed Description RLV Update queries involving a join in the FROM clause using aliases might crash. This has been fixed.

CR:727679

CR Number:   727679 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2013 Fixed Description An RLV table with char columns might merge incorrect data to the IQ main base table. This has been fixed.

CR:727728

CR Number:   727728 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_iqindexadvice gives wrong datatype info in the 3rd row of the Advice column if the select has a join with 2 columns of different datatypes.

CR:727747

CR Number:   727747 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jan 2013 Fixed Description Concurrent update/load/delete operation into an RLV store followed by a select top20 query crashes IQ. This has been fixed.

CR:727942

CR Number:   727942 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e03 Fixed Description Sub query containing NOT EXISTS causes an internal error.

CR:727958

CR Number:   727958 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Dec 2012 Fixed Description When running distributed queries using IQ MPX, coordinator may crash at stcxtlib/st_server.cxx:1485 under a heavy work load.

CR:727979

CR Number:   727979 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e04 27 May 2013 Fixed 16.0 sp02 13 Jun 2013 Fixed Description CONVERT to BIT gives INT instead of BOOLEAN for the return value datatype

CR:728058

CR Number:   728058 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.3 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Connection to Coordinator from Sybase Central doing Refresh All/Refresh folder spawns too many syncID_xx connections

CR:728097

CR Number:   728097 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jan 2013 Fixed 07 Feb 2013 Fixed Description After applying the Sybase IQ15.4 ESD#2 on EUCJIS enviroment, would garbled srvlog messages IQ server.

CR:728121

CR Number:   728121 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When dml_options2 = 64, query with group by could fire the error: Input to GROUP BY # from child # not ordered as required Workaround Description  remove dml_options2

CR:728124

CR Number:   728124 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Explanations needed on query plan generating 2 GROUP BY nodes

CR:728153

CR Number:   728153 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2013 Fixed Description When using the IQ MPX server, the reader nodes may crash under heavy stress condition that includes a combination of DML and DDL jobs.

CR:728319

CR Number:   728319 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When you already have an IQ 15.2 esd 2 or esd 2.x installed, and you upgrade your IQ solfware install to 15.2 esd 3, after applying "ALTER DATABASE UPGRADE", iqsrv15 -v select @@version in IQMSG still display the old IQ version/esd number. Workaround Description  Uninstall previous 15.2 esd before indtalling 15.2 esd 3.

CR:728435

CR Number:   728435 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Aug 2013 Not reproducible with latest version of the product available as of Resolution Date Description IQ 15.4 ESD 2 Linux64 - x86_64 - a number of simplex production servers on different host intermittently experience problems shutting the IQ process down. The final checkpoint completes and the CloseDatabase messages is seen but the IQ process hangs and does not go away. The customer has to issue a kill -9 to resolve. This appears to happen with dbstop, stop_iq and SQL command STOP ENGINE UNCONDITIONALLY.

CR:728739

CR Number:   728739 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Windows 2008 Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Assertion failed: 201501. No stack trace, no assert.dmp, were generated

CR:728927

CR Number:   728927 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description S99SybaseIQAgent15 sets the wrong value in the environment variable PATH.S99SybaseIQAgent15 refers to the "$IQDIR15/bin". The correct path is "$IQDIR15/bin64".

CR:729095

CR Number:   729095 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 26 Feb 2013 Fixed Description User was allowed to bypass an invalid DBSpace selection in the Materialized View Wizard.

CR:729154

CR Number:   729154 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 14 Feb 2013 Fixed Description The Login Policy Wizard was not enabling the Next button based on the sequence of data entry. The issue has been resolved.

CR:729299

CR Number:   729299 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 11 Feb 2013 Fixed Description The Partition Wizard will now properly check for appropriate "create" permissions on the desired DBSpace. The user cannot proceed without selecting a valid DBSpace (one in which they have create permissions).

CR:729384

CR Number:   729384 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2013 Fixed 15 Jan 2013 Fixed 3.2.7 ESD1 13 Feb 2013 Fixed Description Create permission on the desired DBSpace is now verified before you can proceed to the next step for Partition Properties / column Storage.

CR:729413

CR Number:   729413 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 18 Feb 2013 Fixed 3.2.7 22 Jan 2013 Added to user documentation Description Performing a Split Partition now ensures correct permission on the destination DBSpace.

CR:729557

CR Number:   729557 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   RH Linux Original Version:   3.2.7 Beta1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 04 Mar 2013 Fixed Description The Table Objects page will not be updated when primary key columns are added. Previously the page could get out of sync.

CR:729570

CR Number:   729570 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 14 Feb 2013 Fixed 3.2.7 ESD1 12 Mar 2013 Added to user documentation Description Create permission on the destination DBSpace is now verified for the Table Index Wizard.

CR:729768

CR Number:   729768 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   RH Linux Original Version:   3.2.7 Beta1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 14 Feb 2013 Fixed Description There was no way for a user to undo a selection in the various role wizards. This can now be done.

CR:730008

CR Number:   730008 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp02 10 Jun 2013 Fixed 16.0 06 Jun 2013 Fixed 16.0 sp02 11 Sep 2013 Fixed Description In IQ 16 with the Revert_To_V15_Optimizer option set some queries ran much slower and with different plans than in 15.4.

CR:730018

CR Number:   730018 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 05 Mar 2013 Fixed Description Edit, move and delete options for indexes were not working correctly on the table objects page.

CR:730137

CR Number:   730137 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e04 26 Apr 2013 Fixed 26 Apr 2013 Fixed 16.0 sp02 20 Aug 2013 Fixed Description A UNION ALL query with an aggregate and a group by expression runs slow in IQ 15.4 when the cardinality of the group by expression is low.

CR:730157

CR Number:   730157 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 13 Mar 2013 Fixed 13 Mar 2013 Presently Not Targeted For Any Future Release Of This Product Description The spinbox for the upper range of values was not working correctly.

CR:730225

CR Number:   730225 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   15.4 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e03 04 Feb 2013 Fixed 04 Feb 2013 Fixed Description Non-Fatal IQ Internal Error Detected at s_garray.cxx:3125 on thread May be reported deleting from a HG index. Workaround Description  dropping all HGs seems to get around this issue, however that is unacceptable as a valid workaround.

CR:730350

CR Number:   730350 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e04 18 Mar 2013 Fixed 15.4 e03.x 30 Sep 2013 Fixed Description A SELECT with a LIKE clause on a column with a HG index may return wrong results. Workaround Description  Either Delete the HG index, an run the slect again, the results are correct. or Keep the HG index and "set temporary option index_preference = 5;", the results are correct Abandoned the use of HG index at Varchar column. Resulting in sever loss of IQ performance ============================================================================================== set temporary option dml_options8=128 Can be used as a W/A.

CR:730502

CR Number:   730502 Product Name:   IQ Management Product Component:   Web UI - Other Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 15 Mar 2013 Fixed Description A user with DBA authority was unable to comment on a proxy table.

CR:730633

CR Number:   730633 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 26 Feb 2013 Fixed Description Granting Administrative and Role privileges to a system role was causing a failure.

CR:730784

CR Number:   730784 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 15 Mar 2013 Fixed Description Deleting Domains from multiple resources is not working. The issue has been resolved.

CR:730898

CR Number:   730898 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 03 Mar 2013 Fixed Description Insert into a LOB column using a LOB variable containing partial multi-byte characters could fail. This has been fixed now. Target Version  16.0 sp01

CR:730918

CR Number:   730918 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 08 Mar 2013 Fixed Description Alter table add long varchar column with LOB variable was failing. This fix resolves this issue.

CR:731039

CR Number:   731039 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Unknown Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 06 Mar 2013 Fixed Description Added missing php files to the installer.

CR:731290

CR Number:   731290 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2013 Not reproducible with latest version of the product available as of Resolution Date Description ROLLUP functions are not allowed in a SELECT subquery. It certain situations, IQ executes it without firing an error and returns wrong results.