List:MySQL++« Previous MessageNext Message »
From:Zhimin Song Date:July 4 2010 3:18am
Subject:an error when using group by
View as plain text  
hi, mysql++ group:

i countered a question like (http://lists.mysql.com/plusplus/7843), but that
thread did not say something... I post my valgrind log. *Any help* would be
really *appreciated*.

[2010-Jul-04 11:08:22.955427] 10931 [/cx.wt LIyq28z8mNxDJTHH] [notice]
"DBUtils::selectCount(int):select count(*)  from project , ppm  where
PAPE!=-100  and ( project.p_id like '%0808008%' or psn like
'%0808008%' or pname_cn like '%0808008%' or pname_en like '%0808008%'
or keywords_cn like '%0808008%' or keywords_en like '%0808008%' or
abstract_ like '%0808008%' or(ps_name like '%0808008%' or ps_id like
'%0808008%')or(pl_name like '%0808008%' or pl_id like
'%0808008%')or(pm_name like '%0808008%' or pm_id like '%0808008%'))
and ppm.p_id=project.p_id  group by project.p_id   order by
project.p_id desc "
==10931==
==10931== Thread 6:
==10931== Invalid read of size 4
==10931==    at 0x80F35E0: DBUtils::selectCount(std::string const&)
(stl_vector.h:397)
==10931==    by 0x80E3476: PList::confirm(std::string const&,
std::string const&) (PList.C:228)
==10931==    by 0x80AC15F: boost::function6<void, std::string const,
std::string const, Wt::NoClass, Wt::NoClass, Wt::NoClass,
Wt::NoClass>::operator()(std::string, std::string, Wt::NoClass,
Wt::NoClass, Wt::NoClass, Wt::NoClass) const
(function_template.hpp:989)
==10931==    by 0x80ACA5C: boost::signal6<void, std::string const,
std::string const, Wt::NoClass, Wt::NoClass, Wt::NoClass, Wt::NoClass,
boost::last_value<void>, int, std::less<int>, boost::function6<void,
std::string const, std::string const, Wt::NoClass, Wt::NoClass,
Wt::NoClass, Wt::NoClass> >::operator()(std::string, std::string,
Wt::NoClass, Wt::NoClass, Wt::NoClass, Wt::NoClass)
(signal_template.hpp:119)
==10931==    by 0x80ACF55: Wt::Signal<std::string const, std::string
const, Wt::NoClass, Wt::NoClass, Wt::NoClass,
Wt::NoClass>::emit(std::string, std::string, Wt::NoClass, Wt::NoClass,
Wt::NoClass, Wt::NoClass) (WSignal:840)
==10931==    by 0x80A981C: Search::search() (Search.C:118)
==10931==    by 0x42F4657: boost::function1<void,
Wt::WMouseEvent>::operator()(Wt::WMouseEvent) const
(function_template.hpp:989)
==10931==    by 0x42F5ACF: boost::signal1<void, Wt::WMouseEvent,
boost::last_value<void>, int, std::less<int>, boost::function1<void,
Wt::WMouseEvent> >::operator()(Wt::WMouseEvent)
(signal_template.hpp:119)
==10931==    by 0x42F5DB7:
Wt::EventSignal<Wt::WMouseEvent>::processDynamic(Wt::JavaScriptEvent
const&) (WSignal:978)
==10931==    by 0x434B99E:
Wt::WebSession::processSignal(Wt::EventSignalBase*, std::string
const&, Wt::WebRequest const&, Wt::WebSession::SignalKind)
(WebSession.C:1491)
==10931==    by 0x434F003: Wt::WebSession::notifySignal(Wt::WEvent
const&) (WebSession.C:1465)
==10931==    by 0x434FEA4: Wt::WebSession::notify(Wt::WEvent const&)
(WebSession.C:1225)
==10931==  Address 0x4cc60c0 is 8 bytes after a block of size 0 alloc'd
==10931==    at 0x4023294: operator new(unsigned) (vg_replace_malloc.c:224)
==10931==    by 0x4598ACE:
mysqlpp::StoreQueryResult::StoreQueryResult(st_mysql_res*,
mysqlpp::DBDriver*, bool) (new_allocator.h:91)
==10931==    by 0x45948F5: mysqlpp::Query::store(char const*,
unsigned) (query.cpp:534)
==10931==    by 0x4594D89:
mysqlpp::Query::store(mysqlpp::SQLTypeAdapter const&) (query.cpp:508)
==10931==    by 0x80F35BB: DBUtils::selectCount(std::string const&)
(query.h:463)
..............

Regards
Zhimin

Thread
an error when using group byZhimin Song4 Jul
  • Re: an error when using group byWarren Young6 Jul
    • Re: an error when using group byZhimin Song26 Aug
      • Re: an error when using group byWarren Young26 Aug