PM43962: Clicking on the ellipsis button '...' next to a column value after sorting the SQL results produces incorrect data

Rational Software Architect Interim Fix 1 for 8.0.4.2
Rational Software Architect for WebSphere Software Interim Fix 1 for 8.0.4.2

APAR status

• Closed as program error.

Error description

• Description of problem:
  
  When the order of a SQL query result is changed by a sort on the
  SQL results view, clicking on the ellipsis button [...] next to
  a large column value shows data of the value before the sort.
  
  Steps to reproduce:
  
  1) Create a table like
  CREATE TABLE 'USERXXX'.'TABLE1' (
          'SMALL' CHAR(10),
          'LARGE' CHAR(255)
      )
  
      AUDIT NONE
      DATA CAPTURE NONE
      CCSID EBCDIC;
  
  2) Insert data to the table like:
  1111
  1111111111111111111111111111111111111111111111111111111111111111
  11111111111111111111111
  2222
  2222222222222222222222222222222222222222222222222222222222222222
  22222222222222222222222
  4444
  4444444444444444444444444444444444444444444444444444444444444444
  44444444444444444444444
  0000
  0000000000000000000000000000000000000000000000000000000000000000
  00000000000000000000000
  
  3) From the Data perspective, create a new SQL script from your
  database connection and run a query like
  Select * from  'USERXXX'.'TABLE1'
  
  4) On the SQL Results view, click on header to sort the result
  
  5) Hilight LARGE data cell of any row and click on the ellipsis
  '....' button
  
  6) The LONG DATA window displays the results of before the sort
  
  Workaround:
  
  Double click on the row with long data instead of clicking on
  the Ellipsis button: it should correctly present the sorted data
  to the long data dialog.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Clicking on the ellipsis button [...] next to a column value
  after sorting the SQL results produces incorrect data.
  

Problem conclusion

• The problem has been fixed in Rational Application Developer
  v8.0.4.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  RATL APP DEV WI

• Fixed component ID

  5724J1901

Applicable component levels

• R800 PSN

     UP