Bug 469614
| Summary: | Six OOO database functions have malfunctions when running automation test script "b_lvl1_dBase_functions.bas" | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Product: | Red Hat Enterprise Linux 5 | Reporter: | Yolkfull Chow <yzhou> | ||||||||
| Component: | openoffice.org | Assignee: | Caolan McNamara <caolanm> | ||||||||
| Status: | CLOSED NOTABUG | QA Contact: | desktop-bugs <desktop-bugs> | ||||||||
| Severity: | medium | Docs Contact: | |||||||||
| Priority: | medium | ||||||||||
| Version: | 5.2 | CC: | desktop-bugs, dtardon | ||||||||
| Target Milestone: | rc | ||||||||||
| Target Release: | --- | ||||||||||
| Hardware: | All | ||||||||||
| OS: | Linux | ||||||||||
| Whiteboard: | |||||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||||
| Doc Text: | Story Points: | --- | |||||||||
| Clone Of: | Environment: | ||||||||||
| Last Closed: | 2008-11-04 12:50:48 UTC | Type: | --- | ||||||||
| Regression: | --- | Mount Type: | --- | ||||||||
| Documentation: | --- | CRM: | |||||||||
| Verified Versions: | Category: | --- | |||||||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||||||
| Embargoed: | |||||||||||
| Attachments: |
|
||||||||||
Created attachment 322262 [details]
The result file of running script "b_lvl1_dBase_functions.bas"
Created attachment 322328 [details]
Concrete example of sqrt
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 ?
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. I just re-ran the test and all passed.Really strange,we could close it temporarily now. Regards, OK, closing. |
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: