https://bugs.documentfoundation.org/show_bug.cgi?id=162833
Julien Nabet <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from Julien Nabet <[email protected]> --- On pc Debian x86-64 with master sources updated today, I could reproduce the error message. After some gdb trace, I noticed that when opening the query in edition, I got: #0 dbaui::OQueryController::setStatement_fireEvent (this=0x5583a3cb8d90, _rNewStatement="SELECT \"fiPayTermin\", SUM( CASE WHEN \"dtPayTyp\" = 1 THEN \"dtPayBetrag\" * - 1 ELSE \"dtPayBetrag\" END ) \"qcpSollHabenErsatz\" FROM \"tblmPay\" GROUP BY \"tblmPay\".\"fiPayTermin\"", _bFireStatementChange=true) at dbaccess/source/ui/querydesign/querycontroller.cxx:1724 #1 0x00007fe3f1eb882f in dbaui::OQueryController::impl_reset (this=0x5583a3cb8d90, i_bForceCurrentControllerSettings=false) at dbaccess/source/ui/querydesign/querycontroller.cxx:1609 #2 0x00007fe3f1eb7de4 in dbaui::OQueryController::impl_initialize (this=0x5583a3cb8d90, rArguments=...) at dbaccess/source/ui/querydesign/querycontroller.cxx:809 #3 0x00007fe3f1bb4fe2 in dbaui::OGenericUnoController::initialize (this=0x5583a3cb8d90, aArguments=uno::Sequence of length 13 = {...}) at dbaccess/source/ui/browser/genericcontroller.cxx:217 #4 0x00007fe3f1b2a76d in (anonymous namespace)::DBContentLoader::load (this=0x5583a1707c50, rFrame=uno::Reference to ((anonymous namespace)::XFrameImpl *) 0x5583a3d45af0, rURL=".component:DB/QueryDesign", rArgs=uno::Sequence of length 12 = {...}, rListener=uno::Reference to (framework::(anonymous namespace)::LoadEnvListener *) 0x5583a3aad4a8) at dbaccess/source/ui/browser/dbloader.cxx:226 #5 0x00007fe424c1da70 in framework::LoadEnv::impl_loadContent (this=0x7fff543b7218) at framework/source/loadenv/loadenv.cxx:1163 #6 0x00007fe424c1aa84 in framework::LoadEnv::start (this=0x7fff543b7218) at framework/source/loadenv/loadenv.cxx:412 so _rNewStatement="SELECT \"fiPayTermin\", SUM( CASE WHEN \"dtPayTyp\" = 1 THEN \"dtPayBetrag\" * - 1 ELSE \"dtPayBetrag\" END ) \"qcpSollHabenErsatz\" FROM \"tblmPay\" GROUP BY \"tblmPay\".\"fiPayTermin\"" but when executing, i got: #0 dbaui::OQueryController::setStatement_fireEvent (this=0x5583a49acae0, _rNewStatement="SELECT \"fiPayTermin\", Sum(Sum( WHEN \"dtPayTyp\" = 1 THEN \"dtPayBetrag\" * - 1 ELSE \"dtPayBetrag\" END) AS \"qcpSollHabenErsatz\" FROM \"tblmPay\" GROUP BY \"tblmPay\".\"fiPayTermin\" ", _bFireStatementChange=false) at dbaccess/source/ui/querydesign/querycontroller.cxx:1724 #1 0x00007fe3f1ebaca4 in dbaui::OQueryController::translateStatement (this=0x5583a49acae0, _bFireStatementChange=false) at dbaccess/source/ui/querydesign/querycontroller.cxx:1520 #2 0x00007fe3f1eb53ab in dbaui::OQueryController::executeQuery (this=0x5583a49acae0) at dbaccess/source/ui/querydesign/querycontroller.cxx:1081 #3 0x00007fe3f1eb2bb7 in dbaui::OQueryController::Execute (this=0x5583a49acae0, _nId=10721, aArgs=uno::Sequence of length 1 = {...}) at dbaccess/source/ui/querydesign/querycontroller.cxx:582 SELECT \"fiPayTermin\", Sum(Sum( WHEN \"dtPayTyp\" = 1 THEN \"dtPayBetrag\" * - 1 ELSE \"dtPayBetrag\" END) AS \"qcpSollHabenErsatz\" FROM \"tblmPay\" GROUP BY \"tblmPay\".\"fiPayTermin\" " Notice the "SUM ( CASE" is transformed in "Sum(Sum" -- You are receiving this mail because: You are the assignee for the bug.
