<i>Bug found when execute(...) with template query</i>.
by
anonymous
2018-12-20 09:13:04.
D 2018-12-20T09:13:04.173
J foundin mysql++-3.2.4
J icomment MySQL\sversion:\smysql-5.7.23-win32\r\nOS:\sWindows\s10\s1809\r\nVisual\sStudio:\svs2015\supdate\s3\r\n\r\n\s\s\s\sI\sbuilt\smysql++-3.2.4\sin\sits\svc2005\sproject\sand\sgot\sthe\sx86\slib.\sI\sdid\ssome\smodification\sin\sthe\sresetdb.cpp\sand\sran\sthe\sresetdb\sproject,\sthen\sI\sfound\sa\sproblem.\r\n\r\n```\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s//\sNow\screate\sempty\simages\stable,\sfor\stesting\sBLOB\sand\sauto-\r\n\t\t//\sincrement\scolumn\sfeatures.\r\n\t\tcout\s<<\s"Creating\sempty\simages\stable..."\s<<\sendl;\r\n\t\tquery.reset();\t\t//\sforget\stemplate\squery\sinfo\r\n\t\tquery\s<<\s\r\n\t\t\t\t"CREATE\sTABLE\simages\s("\s<<\r\n\t\t\t\t"\s\sid\sINT\sUNSIGNED\sAUTO_INCREMENT,\s"\s<<\r\n\t\t\t\t"\s\sdata\sBLOB,\s"\s<<\r\n\t\t\t\t"\s\sPRIMARY\sKEY\s(id)"\s<<\r\n\t\t\t\t")";\r\n\t\tquery.execute();\r\n\s\s\s\s\s\s\s\squery.execute(\s"insert\sinto\simages\s(data)\svalues\s(\\"def\\")");\r\n\r\n\s\s\s\s\s\s\s\squery\s<<\s"insert\sinto\s%1:tab\s(%2:field)\svalues\s(%0q:val1)";\r\n\s\s\s\s\s\s\s\s//query\s<<\s"insert\sinto\s%0:table\svalues\s(\\"def\\")";\r\n\s\s\s\s\s\s\s\squery.parse();\r\n\s\s\s\s\s\s\s\squery.template_defaults["tab"]\s=\s"images";\r\n\s\s\s\s\s\s\s\squery.template_defaults["field"]\s=\s"data";\r\n\s\s\s\s\s\s\s\squery.template_defaults["val1"]\s=\s"abc";\r\n\s\s\s\s\s\s\s\s//query.template_defaults["field"]\s=\s"data";\r\n\s\s\s\s\s\s\s\scout\s<<\squery.str()\s<<\sendl;\r\n\s\s\s\s\s\s\s\squery.execute("abc",\s"images");\r\n\s\s\s\s\s\s\s\squery.execute("images");\r\n\s\s\s\s\s\s\s\squery.reset();\r\n```\r\n\r\n\s\s\s\sA\sBadQuery\swas\scaught\swhen\sexecuting\s`query.execute("images");`.\sI\sdebuged\sand\swaited\sin\smysql_real_query(...),\sthen\sI\sfound\sthat\sthe\s`qstr`\sis\s"images".\r\n\r\n\s\s\s\sI\sthink\sit's\ssomething\swrong\swhen\sthere're\smore\sthan\sone\splaceholder\sbut\spass\sonly\sone\sparameter\sinto\sexecute(...).\r\n\r\n\s\s\s\sIf\sit's\snot\sa\sbug,\splease\sgive\sme\ssome\sadvice\son\show\sto\sdo\sin\sthis\ssituation.
J login anonymous
J mimetype text/x-fossil-plain
J private_contact 0efae30de6243cd4e4a987402a972c4d3d740c40
J severity Important
J status Open
J title Bug\sfound\swhen\sexecute(...)\swith\stemplate\squery
J type Code\sDefect
K 8075e2d150258d4c9c77c9f7650b7861edc5c8f6
U anonymous
Z 36015da3a8e2957087a5f24dcc3a9673