Bug 469614 - Six OOO database functions have malfunctions when running automation test script "b_lvl1_dBase_functions.bas"
Six OOO database functions have malfunctions when running automation test scr...
Status: CLOSED NOTABUG
Product: Red Hat Enterprise Linux 5
Classification: Red Hat
Component: openoffice.org (Show other bugs)
5.2
All Linux
medium Severity medium
: rc
: ---
Assigned To: Caolan McNamara
desktop-bugs@redhat.com
:
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2008-11-03 01:30 EST by Yolkfull Chow
Modified: 2008-11-04 07:50 EST (History)
2 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2008-11-04 07:50:48 EST
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)
The result file of running script "b_lvl1_dBase_functions.bas" (26.81 KB, text/plain)
2008-11-03 01:32 EST, Yolkfull Chow
no flags Details
Concrete example of sqrt (2.97 KB, application/vnd.oasis.opendocument.database)
2008-11-03 11:03 EST, Caolan McNamara
no flags Details
a proper example (2.97 KB, application/vnd.oasis.opendocument.database)
2008-11-03 11:07 EST, Caolan McNamara
no flags Details

  None (edit)
Description Yolkfull Chow 2008-11-03 01:30:08 EST
Description of problem:
Use automation test script "b_lvl1_dBase_functions.bas" to test OOO database functions, following six functions cann't work well(value is incorrect).
------------
TEST_CASE: tCONCAT()
MESSAGE: open the File Open dialog
MESSAGE: open the given file: /root/.openoffice.org2.0/user/work/tt_dbase_level2.odb
MESSAGE: open new query design
MESSAGE: - Add TT_Func1 table to query design
MESSAGE: set CONCAT(f_text,f_text) for the field
MESSAGE: Execute the query
MESSAGE: check if the value is texttext
WARNING: it should texttext it is xy
TEST_CASE: 
---------
TEST_CASE: tLOCATE()
MESSAGE: open the File Open dialog
MESSAGE: open the given file: /root/.openoffice.org2.0/user/work/tt_dbase_level2.odb
MESSAGE: open new query design
MESSAGE: - Add TT_Func1 table to query design
MESSAGE: set LOCATE('ex',f_text) for the field
MESSAGE: Execute the query
MESSAGE: check if the value is 2
WARNING: it should 2 it is xy
MESSAGE:    **    Error in TestExit -Routine      **
WARNING: WORKWINDOW "Query1 - OpenOffice.org Base: Query Design" geschlossen, RType = WORKWINDOW, UId = MessageBox
WARNING: Message Box (No) "OpenOffice.org 2.3 " geschlossen, RType = FIRST, UId = MessageBox
QA_ERROR: Needed to close window: (1/1) on TestExit
TEST_CASE:
---------------
TEST_CASE: tFLOOR()
MESSAGE: open the File Open dialog
MESSAGE: open the given file: /root/.openoffice.org2.0/user/work/tt_dbase_level2.odb
MESSAGE: open new query design
MESSAGE: - Add TT_Func1 table to query design
MESSAGE: set FLOOR(1.789) for the field
MESSAGE: Execute the query
MESSAGE: check if the value is 1
WARNING: it should 1 it is -1
------------------
TEST_CASE: tSQRT()
MESSAGE: open the File Open dialog
MESSAGE: open the given file: /root/.openoffice.org2.0/user/work/tt_dbase_level2.odb
MESSAGE: open new query design
MESSAGE: - Add TT_Func1 table to query design
MESSAGE: set SQRT(2) for the field
MESSAGE: Execute the query
MESSAGE: check if the value is 1.41
WARNING: it should 1.41 it is 8
TEST_CASE:
------------------
TEST_CASE: tCURTIME()
MESSAGE: open the File Open dialog
MESSAGE: open the given file: /root/.openoffice.org2.0/user/work/tt_dbase_level2.odb
MESSAGE: open new query design
MESSAGE: - Add TT_Func1 table to query design
MESSAGE: set CURTIME() for the field
MESSAGE: Execute the query
MESSAGE:    **    Error in TestExit -Routine      **
WARNING: Message Box (No) "OpenOffice.org 2.3 " geschlossen, RType = FIRST, UId = MessageBox
QA_ERROR: Needed to close window: (1/1) on TestExit
TEST_CASE: 

Version-Release number of selected component (if applicable):
openoffice.org-2.3.0-6.5.4.el5_2 

How reproducible:
Everytime

Steps to Reproduce:
1. setup OOO automation testtool
2. run b_lvl1_dBase_functions.bas
3.
  
Actual results:


Expected results:
Basic database functions like SQRT(2)=1.41 should work well,whereas it actually has malfunction that get value of 8.

Additional info:
Comment 1 Yolkfull Chow 2008-11-03 01:32:00 EST
Created attachment 322262 [details]
The result file of running script "b_lvl1_dBase_functions.bas"
Comment 2 Caolan McNamara 2008-11-03 11:03:57 EST
Created attachment 322328 [details]
Concrete example of sqrt
Comment 3 Caolan McNamara 2008-11-03 11:07:23 EST
Created attachment 322331 [details]
a proper example

This is just a bit of a dump of stuff, and I see totally different results when I run (the very slow) test myself.

So in response to the concrete report of "Basic database functions like SQRT(2)=1.41 should work well,whereas it actually has malfunction": 

I attach sqrt.odb which has the above SQRT test saved as "Query 1". I get 1.41 when I run it do you get 8 for this ?
Comment 4 Caolan McNamara 2008-11-03 11:09:25 EST
If this example does work, then I need concrete examples like it that reproduce the original report. I am not confident that the test-tooling itself has bugs in it which are giving spurious reports. If it can be reproduced in a standalone document then I can work with that easily.
Comment 5 Yolkfull Chow 2008-11-04 07:34:03 EST
I just re-ran the test and all passed.Really strange,we could close it temporarily now.
Regards,
Comment 6 David Tardon 2008-11-04 07:50:48 EST
OK, closing.

Note You need to log in before you can comment on or make changes to this bug.