|
Problem IC76851
|
Status: Closed |
OUTPUT ROWS ARE NOT ALIGNING PROPERLY FOR SELECT QUERY IF COLUMN IS GRAPHIC ON V95FP6 |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
Output rows are not aligning properly for select query if column
is graphic on v95fp6
Create a table having some graphic datatype columns
on v95fp6 project, linuxamd64 platform and s100918 build. Post
insert command, the rows fetched is bit misaligned and hence
creating confusion.
Steps to repro:
db2 create db migdb using codeset UTF-8 territory US
connect to migdb user newton using ******
create table tbgraphic (c1 graphic not null, c2 graphic with
default,c3 graphic with default gx'0041')
create table tcgraphic2 as (select * from tbgraphic) definition
only
commit
Issues:
create table tbgraphic (c1 graphic not null, c2 graphic with
default,c3 graphic with default gx'0041')
select * from tbgraphic
C1 C2 C3
-- -- --
G A << Here 'A' belongs to C3 but it is not properly
aligned
123456 --- We see it is on 5th position. I am expecting
'A' at 7th position.
1 record(s) selected.
select * from tcgraphic2
C1 C2 C3
-- -- --
G - -
123456 -- Here the value '-' value is at 6th position
1 record(s) selected. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* Output rows are not aligning properly for select query if *
* column *
* is graphic on v95fp6 *
* *
* *
* *
* Create a table having some graphic datatype columns *
* on v95fp6 project, linuxamd64 platform and s100918 build. *
* Post *
* insert command, the rows fetched is bit misaligned and hence *
* *
* creating confusion. *
* *
* *
* *
* Steps to repro: *
* *
* db2 create db migdb using codeset UTF-8 territory US *
* *
* connect to migdb user newton using ****** *
* *
* create table tbgraphic (c1 graphic not null, c2 graphic with *
* *
* default,c3 graphic with default gx'0041') *
* *
* create table tcgraphic2 as (select * from tbgraphic) *
* definition *
* only *
* *
* commit *
* *
* *
* *
* Issues: *
* *
* create table tbgraphic (c1 graphic not null, c2 graphic with *
* *
* default,c3 graphic with default gx'0041') *
* *
* select * from tbgraphic *
* *
* C1 C2 C3 *
* *
* -- -- -- *
* *
* G A << Here 'A' belongs to C3 but it is not properly *
* *
* aligned *
* *
* 123456 --- We see it is on 5th position. I am expecting *
* *
* 'A' at 7th position. *
* *
* 1 record(s) selected. *
* *
* *
* *
* select * from tcgraphic2 *
* *
* C1 C2 C3 *
* *
* -- -- -- *
* *
* G - - *
* *
* 123456 -- Here the value '-' value is at 6th position *
* *
* 1 record(s) selected. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2_v95fp9 or later releases. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
db2_v95fp9 and later releases contains the fix. After the fix,
indentation issue will be solved. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.06.2011
12.03.2012
12.03.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.9
|
 |
