Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | database table column are shifted to the left after execute a special query | ||||||||
---|---|---|---|---|---|---|---|---|---|
Product: | Base | Reporter: | vytis | ||||||
Component: | code | Assignee: | ocke.janssen | ||||||
Status: | CLOSED FIXED | QA Contact: | issues@dba <issues> | ||||||
Severity: | Trivial | ||||||||
Priority: | P3 | CC: | issues | ||||||
Version: | OOo 1.1 | ||||||||
Target Milestone: | OOo 2.0 | ||||||||
Hardware: | All | ||||||||
OS: | All | ||||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||
Developer Difficulty: | --- | ||||||||
Attachments: |
|
Description
vytis
2003-09-24 11:40:50 UTC
hi, my table look like this IDField Field1 IDField2 1 2 3 when I do this query SELECT DISTINCT Sheet1.IDField, Sheet1.* FROM Sheet1 I got this result IDField IDField1 Field1 IDField2 1 1 2 3 This is exactly what I expect. The second field get the sufix 1 because the fieldname 'IDField' is allready used. Bye Marc Created attachment 9659 [details] screenshot for issue 19979 I tried many times, but result is the same - bad. OO 1.1.0 RC4 spreadsheet. I made query : SELECT DISTINCT(Table1.IDField), Table1.* FROM Table1 SELECT DISTINCT ( "Bonus"."IDBonus" ), "Bonus".*, "Receivers"."NickName" AS "Receiver_NickName", "Assigners"."NickName" AS "Assigner_NickName", "Groups"."Name" AS "Group_Name", FROM "Bonus", "Users" "Assigners", "Users" "Receivers", "Groups" WHERE ... <conditions for joining of tables> Expected result - column titles in such order: IDBonus IDBonus Receiver Assigner Title ... But i got : column tiles : values IDBonus : IDBonus Receiver : IDBonus Assigner : Receiver Title : Assigner ... Data are beeing displayed corect, but all field names are shifted to the left. On OO 1.1.0 is the same look to second attached document. On OO 1.1.0 is the same look to second attached document. Created attachment 9953 [details]
simple example with oo 1.1.0
hi, can you please tell us which kind of datasource you use. It can't be a spreadsheet as you write. Please describe or screenshot us the table structure. Bye Marc DB : MS SQL Server Driver : SDBC:ODBC Explanation for "screenshot for issue 19979" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I executed the same query on MS SQL and OO. Data, i got using OO, is in the top. Correct data (I made copy from MS SQL server) is beeing show in the bottom, as speadsheet. Red circles shows problems: 1. MS SQL: two columns IDBonus - this is ok OO : Only one column named IDBonus, second is named (wrongly) receiver - this is bug 2. MS SQL: column Title contains text data - this is ok OO : Title contains numbers - this is bug Explanation for "simple example with oo 1.1.0" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I made simpler sample of bug. I have two tables : Bonus {IDBonus, IDGroup} Groups {IDGroup, Name} I made query: SELECT DISTINCT(Bonus.IDBonus), Bonus.IDBonus, Groups.Name FROM Bonus INNER JOIN Groups ON Groups.IDGroup = Bonus.IDGroup BUG: I got results Columns' titles: IDBonus, Name , Name Columns' data : IDBonus, IDBonus, IDBonus But it should be: Columns' titles: IDBonus, IDBonus, Name Columns' data : IDBonus, IDBonus, Name Hi, I can reproduce this. follow the instruction from "Oct 20 04:06:10". The problem occurr also with hsqldb. Bye Marc reassign change subcomponent to 'none' Fixed in cws insight01 verify in CWS insight01 . |