Summary: | EDITING: Values in correlated subquery were not shown in queries. | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | robert |
Component: | Database | Assignee: | Lionel Elie Mamane <lionel> |
Status: | RESOLVED FIXED | QA Contact: | |
Severity: | normal | ||
Priority: | high | CC: | iplaw67, lionel, nthiebaud |
Version: | 4.0.0.3 release | Keywords: | regression |
Hardware: | x86 (IA32) | ||
OS: | Linux (All) | ||
See Also: | https://bugs.freedesktop.org/show_bug.cgi?id=61871 | ||
Whiteboard: | target:4.1.0 target:4.0.2 | ||
i915 platform: | i915 features: | ||
Bug Depends on: | |||
Bug Blocks: | 60504 |
Description
robert
2013-02-20 13:19:16 UTC
Long story: I opened this database with LO 4.0.0.3. Then I opened either query in SQL view. After looking at the SQL I wondered what it would look like in Design view, so I clicked Design View On/Off icon. But when I clicked this again to return to SQL View, I got an error message "SQL syntax error". When I ran the query, the Balance column was empty. Later I closed the query and reopened it in SQL view. Then I clicked the icon labeled "run SQL command directly". Then when I ran the query, the Balance column had the values that it should have. Confirming on Linux 32 bit master : Version 4.1.0.0.alpha0+ (Build ID: 779f6188d9ee2f3db2514ea6db72663d35a064c) Alex Adding Lionel to CC Work-around: set a numeric format on that column instead of text format. This is caused by a copy-paste/error in the handling of numeric values by a text format. (Not sure why this column was getting text format instead of numeric format.) Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=966ab5cd805d403f1dec73bb1a452b9ed38348d5 fdo#61166 text format: correctly chain the formatter->getOutputString calls The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-4-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8a203e4996979fd9be3eba835fb84dd005ac3f69&h=libreoffice-4-0 fdo#61166 text format: correctly chain the formatter->getOutputString calls It will be available in LibreOffice 4.0.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Have downloaded LO 4.0.2.1 rc . Well done, Lionel. All values in subqueries were shown. Robert |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.