1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407 |
- /*
- +----------------------------------------------------------------------+
- | PHP Version 5 |
- +----------------------------------------------------------------------+
- | Copyright (c) 2006-2016 The PHP Group |
- +----------------------------------------------------------------------+
- | This source file is subject to version 3.01 of the PHP license, |
- | that is bundled with this package in the file LICENSE, and is |
- | available through the world-wide-web at the following url: |
- | http://www.php.net/license/3_01.txt |
- | If you did not receive a copy of the PHP license and are unable to |
- | obtain it through the world-wide-web, please send a note to |
- | license@php.net so we can mail you a copy immediately. |
- +----------------------------------------------------------------------+
- | Authors: Andrey Hristov <andrey@mysql.com> |
- | Ulf Wendel <uwendel@mysql.com> |
- | Georg Richter <georg@mysql.com> |
- +----------------------------------------------------------------------+
- */
- /* $Id$ */
- #include "php.h"
- #include "mysqlnd.h"
- #include "mysqlnd_wireprotocol.h"
- #include "mysqlnd_priv.h"
- #include "mysqlnd_result.h"
- #include "mysqlnd_result_meta.h"
- #include "mysqlnd_statistics.h"
- #include "mysqlnd_debug.h"
- #include "mysqlnd_block_alloc.h"
- #include "mysqlnd_ext_plugin.h"
- #define MYSQLND_SILENT
- const char * const mysqlnd_not_bound_as_blob = "Can't send long data for non-string/non-binary data types";
- const char * const mysqlnd_stmt_not_prepared = "Statement not prepared";
- /* Exported by mysqlnd_ps_codec.c */
- enum_func_status mysqlnd_stmt_execute_generate_request(MYSQLND_STMT * const s, zend_uchar ** request, size_t *request_len, zend_bool * free_buffer TSRMLS_DC);
- static void mysqlnd_stmt_separate_result_bind(MYSQLND_STMT * const stmt TSRMLS_DC);
- static void mysqlnd_stmt_separate_one_result_bind(MYSQLND_STMT * const stmt, unsigned int param_no TSRMLS_DC);
- /* {{{ mysqlnd_stmt::store_result */
- static MYSQLND_RES *
- MYSQLND_METHOD(mysqlnd_stmt, store_result)(MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- enum_func_status ret;
- MYSQLND_CONN_DATA * conn;
- MYSQLND_RES * result;
- DBG_ENTER("mysqlnd_stmt::store_result");
- if (!stmt || !stmt->conn || !stmt->result) {
- DBG_RETURN(NULL);
- }
- DBG_INF_FMT("stmt=%lu", stmt->stmt_id);
- conn = stmt->conn;
- /* be compliant with libmysql - NULL will turn */
- if (!stmt->field_count) {
- DBG_RETURN(NULL);
- }
- if (stmt->cursor_exists) {
- /* Silently convert buffered to unbuffered, for now */
- DBG_RETURN(s->m->use_result(s TSRMLS_CC));
- }
- /* Nothing to store for UPSERT/LOAD DATA*/
- if (CONN_GET_STATE(conn) != CONN_FETCHING_DATA ||
- stmt->state != MYSQLND_STMT_WAITING_USE_OR_STORE)
- {
- SET_CLIENT_ERROR(*conn->error_info, CR_COMMANDS_OUT_OF_SYNC,
- UNKNOWN_SQLSTATE, mysqlnd_out_of_sync);
- DBG_RETURN(NULL);
- }
- stmt->default_rset_handler = s->m->store_result;
- SET_EMPTY_ERROR(*stmt->error_info);
- SET_EMPTY_ERROR(*conn->error_info);
- MYSQLND_INC_CONN_STATISTIC(conn->stats, STAT_PS_BUFFERED_SETS);
- result = stmt->result;
- result->type = MYSQLND_RES_PS_BUF;
- /* result->m.row_decoder = php_mysqlnd_rowp_read_binary_protocol; */
- result->stored_data = (MYSQLND_RES_BUFFERED *) mysqlnd_result_buffered_zval_init(result->field_count, TRUE, result->persistent TSRMLS_CC);
- if (!result->stored_data) {
- SET_OOM_ERROR(*conn->error_info);
- DBG_RETURN(NULL);
- }
- ret = result->m.store_result_fetch_data(conn, result, result->meta, &result->stored_data->row_buffers, TRUE TSRMLS_CC);
- result->stored_data->m.fetch_row = mysqlnd_stmt_fetch_row_buffered;
- if (PASS == ret) {
- /* Overflow ? */
- if (result->stored_data->type == MYSQLND_BUFFERED_TYPE_ZVAL) {
- MYSQLND_RES_BUFFERED_ZVAL * set = (MYSQLND_RES_BUFFERED_ZVAL *) result->stored_data;
- if (result->stored_data->row_count) {
- /* don't try to allocate more than possible - mnd_XXalloc expects size_t, and it can have narrower range than uint64_t */
- if (result->stored_data->row_count * result->meta->field_count * sizeof(zval *) > SIZE_MAX) {
- SET_OOM_ERROR(*conn->error_info);
- DBG_RETURN(NULL);
- }
- /* if pecalloc is used valgrind barks gcc version 4.3.1 20080507 (prerelease) [gcc-4_3-branch revision 135036] (SUSE Linux) */
- set->data = mnd_emalloc((size_t)(result->stored_data->row_count * result->meta->field_count * sizeof(zval *)));
- if (!set->data) {
- SET_OOM_ERROR(*conn->error_info);
- DBG_RETURN(NULL);
- }
- memset(set->data, 0, (size_t)(result->stored_data->row_count * result->meta->field_count * sizeof(zval *)));
- }
- /* Position at the first row */
- set->data_cursor = set->data;
- } else if (result->stored_data->type == MYSQLND_BUFFERED_TYPE_ZVAL) {
- /*TODO*/
- }
- /* libmysql API docs say it should be so for SELECT statements */
- stmt->upsert_status->affected_rows = stmt->result->stored_data->row_count;
- stmt->state = MYSQLND_STMT_USE_OR_STORE_CALLED;
- } else {
- COPY_CLIENT_ERROR(*conn->error_info, result->stored_data->error_info);
- stmt->result->m.free_result_contents(stmt->result TSRMLS_CC);
- mnd_efree(stmt->result);
- stmt->result = NULL;
- stmt->state = MYSQLND_STMT_PREPARED;
- }
- DBG_RETURN(result);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::get_result */
- static MYSQLND_RES *
- MYSQLND_METHOD(mysqlnd_stmt, get_result)(MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- MYSQLND_CONN_DATA * conn;
- MYSQLND_RES *result;
- DBG_ENTER("mysqlnd_stmt::get_result");
- if (!stmt || !stmt->conn || !stmt->result) {
- DBG_RETURN(NULL);
- }
- DBG_INF_FMT("stmt=%lu", stmt->stmt_id);
- conn = stmt->conn;
- /* be compliant with libmysql - NULL will turn */
- if (!stmt->field_count) {
- DBG_RETURN(NULL);
- }
- if (stmt->cursor_exists) {
- /* Silently convert buffered to unbuffered, for now */
- DBG_RETURN(s->m->use_result(s TSRMLS_CC));
- }
- /* Nothing to store for UPSERT/LOAD DATA*/
- if (CONN_GET_STATE(conn) != CONN_FETCHING_DATA || stmt->state != MYSQLND_STMT_WAITING_USE_OR_STORE) {
- SET_CLIENT_ERROR(*conn->error_info, CR_COMMANDS_OUT_OF_SYNC,
- UNKNOWN_SQLSTATE, mysqlnd_out_of_sync);
- DBG_RETURN(NULL);
- }
- SET_EMPTY_ERROR(*stmt->error_info);
- SET_EMPTY_ERROR(*conn->error_info);
- MYSQLND_INC_CONN_STATISTIC(conn->stats, STAT_BUFFERED_SETS);
- do {
- result = conn->m->result_init(stmt->result->field_count, stmt->persistent TSRMLS_CC);
- if (!result) {
- SET_OOM_ERROR(*conn->error_info);
- break;
- }
- result->meta = stmt->result->meta->m->clone_metadata(stmt->result->meta, FALSE TSRMLS_CC);
- if (!result->meta) {
- SET_OOM_ERROR(*conn->error_info);
- break;
- }
- if ((result = result->m.store_result(result, conn, MYSQLND_STORE_PS | MYSQLND_STORE_NO_COPY TSRMLS_CC))) {
- stmt->upsert_status->affected_rows = result->stored_data->row_count;
- stmt->state = MYSQLND_STMT_PREPARED;
- result->type = MYSQLND_RES_PS_BUF;
- } else {
- COPY_CLIENT_ERROR(*stmt->error_info, *conn->error_info);
- stmt->state = MYSQLND_STMT_PREPARED;
- break;
- }
- DBG_RETURN(result);
- } while (0);
- if (result) {
- result->m.free_result(result, TRUE TSRMLS_CC);
- }
- DBG_RETURN(NULL);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::more_results */
- static zend_bool
- MYSQLND_METHOD(mysqlnd_stmt, more_results)(const MYSQLND_STMT * s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- DBG_ENTER("mysqlnd_stmt::more_results");
- /* (conn->state == CONN_NEXT_RESULT_PENDING) too */
- DBG_RETURN((stmt && stmt->conn && (stmt->conn->m->get_server_status(stmt->conn TSRMLS_CC) & SERVER_MORE_RESULTS_EXISTS))?
- TRUE:
- FALSE);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::next_result */
- static enum_func_status
- MYSQLND_METHOD(mysqlnd_stmt, next_result)(MYSQLND_STMT * s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- MYSQLND_CONN_DATA * conn;
- DBG_ENTER("mysqlnd_stmt::next_result");
- if (!stmt || !stmt->conn || !stmt->result) {
- DBG_RETURN(FAIL);
- }
- conn = stmt->conn;
- DBG_INF_FMT("stmt=%lu", stmt->stmt_id);
- if (CONN_GET_STATE(conn) != CONN_NEXT_RESULT_PENDING || !(conn->upsert_status->server_status & SERVER_MORE_RESULTS_EXISTS)) {
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("server_status=%u cursor=%u", stmt->upsert_status->server_status, stmt->upsert_status->server_status & SERVER_STATUS_CURSOR_EXISTS);
- /* Free space for next result */
- s->m->free_stmt_result(s TSRMLS_CC);
- {
- enum_func_status ret = s->m->parse_execute_response(s TSRMLS_CC);
- DBG_RETURN(ret);
- }
- }
- /* }}} */
- /* {{{ mysqlnd_stmt_skip_metadata */
- static enum_func_status
- mysqlnd_stmt_skip_metadata(MYSQLND_STMT * s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- /* Follows parameter metadata, we have just to skip it, as libmysql does */
- unsigned int i = 0;
- enum_func_status ret = FAIL;
- MYSQLND_PACKET_RES_FIELD * field_packet;
- DBG_ENTER("mysqlnd_stmt_skip_metadata");
- if (!stmt || !stmt->conn || !stmt->conn->protocol) {
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("stmt=%lu", stmt->stmt_id);
- field_packet = stmt->conn->protocol->m.get_result_field_packet(stmt->conn->protocol, FALSE TSRMLS_CC);
- if (!field_packet) {
- SET_OOM_ERROR(*stmt->error_info);
- SET_OOM_ERROR(*stmt->conn->error_info);
- } else {
- ret = PASS;
- field_packet->skip_parsing = TRUE;
- for (;i < stmt->param_count; i++) {
- if (FAIL == PACKET_READ(field_packet, stmt->conn)) {
- ret = FAIL;
- break;
- }
- }
- PACKET_FREE(field_packet);
- }
- DBG_RETURN(ret);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt_read_prepare_response */
- static enum_func_status
- mysqlnd_stmt_read_prepare_response(MYSQLND_STMT * s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- MYSQLND_PACKET_PREPARE_RESPONSE * prepare_resp;
- enum_func_status ret = FAIL;
- DBG_ENTER("mysqlnd_stmt_read_prepare_response");
- if (!stmt || !stmt->conn || !stmt->conn->protocol) {
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("stmt=%lu", stmt->stmt_id);
- prepare_resp = stmt->conn->protocol->m.get_prepare_response_packet(stmt->conn->protocol, FALSE TSRMLS_CC);
- if (!prepare_resp) {
- SET_OOM_ERROR(*stmt->error_info);
- SET_OOM_ERROR(*stmt->conn->error_info);
- goto done;
- }
- if (FAIL == PACKET_READ(prepare_resp, stmt->conn)) {
- goto done;
- }
- if (0xFF == prepare_resp->error_code) {
- COPY_CLIENT_ERROR(*stmt->error_info, prepare_resp->error_info);
- COPY_CLIENT_ERROR(*stmt->conn->error_info, prepare_resp->error_info);
- goto done;
- }
- ret = PASS;
- stmt->stmt_id = prepare_resp->stmt_id;
- stmt->warning_count = stmt->conn->upsert_status->warning_count = prepare_resp->warning_count;
- stmt->field_count = stmt->conn->field_count = prepare_resp->field_count;
- stmt->param_count = prepare_resp->param_count;
- stmt->upsert_status->affected_rows = 0; /* be like libmysql */
- done:
- PACKET_FREE(prepare_resp);
- DBG_RETURN(ret);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt_prepare_read_eof */
- static enum_func_status
- mysqlnd_stmt_prepare_read_eof(MYSQLND_STMT * s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- MYSQLND_PACKET_EOF * fields_eof;
- enum_func_status ret = FAIL;
- DBG_ENTER("mysqlnd_stmt_prepare_read_eof");
- if (!stmt || !stmt->conn || !stmt->conn->protocol) {
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("stmt=%lu", stmt->stmt_id);
- fields_eof = stmt->conn->protocol->m.get_eof_packet(stmt->conn->protocol, FALSE TSRMLS_CC);
- if (!fields_eof) {
- SET_OOM_ERROR(*stmt->error_info);
- SET_OOM_ERROR(*stmt->conn->error_info);
- } else {
- if (FAIL == (ret = PACKET_READ(fields_eof, stmt->conn))) {
- if (stmt->result) {
- stmt->result->m.free_result_contents(stmt->result TSRMLS_CC);
- mnd_efree(stmt->result);
- memset(stmt, 0, sizeof(MYSQLND_STMT_DATA));
- stmt->state = MYSQLND_STMT_INITTED;
- }
- } else {
- stmt->upsert_status->server_status = fields_eof->server_status;
- stmt->upsert_status->warning_count = fields_eof->warning_count;
- stmt->state = MYSQLND_STMT_PREPARED;
- }
- PACKET_FREE(fields_eof);
- }
- DBG_RETURN(ret);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::prepare */
- static enum_func_status
- MYSQLND_METHOD(mysqlnd_stmt, prepare)(MYSQLND_STMT * const s, const char * const query, unsigned int query_len TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- MYSQLND_STMT * s_to_prepare = s;
- MYSQLND_STMT_DATA * stmt_to_prepare = stmt;
- DBG_ENTER("mysqlnd_stmt::prepare");
- if (!stmt || !stmt->conn) {
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("stmt=%lu", stmt->stmt_id);
- DBG_INF_FMT("query=%s", query);
- SET_ERROR_AFF_ROWS(stmt);
- SET_ERROR_AFF_ROWS(stmt->conn);
- SET_EMPTY_ERROR(*stmt->error_info);
- SET_EMPTY_ERROR(*stmt->conn->error_info);
- if (stmt->state > MYSQLND_STMT_INITTED) {
- /* See if we have to clean the wire */
- if (stmt->state == MYSQLND_STMT_WAITING_USE_OR_STORE) {
- /* Do implicit use_result and then flush the result */
- stmt->default_rset_handler = s->m->use_result;
- stmt->default_rset_handler(s TSRMLS_CC);
- }
- /* No 'else' here please :) */
- if (stmt->state > MYSQLND_STMT_WAITING_USE_OR_STORE && stmt->result) {
- stmt->result->m.skip_result(stmt->result TSRMLS_CC);
- }
- /*
- Create a new test statement, which we will prepare, but if anything
- fails, we will scrap it.
- */
- s_to_prepare = stmt->conn->m->stmt_init(stmt->conn TSRMLS_CC);
- if (!s_to_prepare) {
- goto fail;
- }
- stmt_to_prepare = s_to_prepare->data;
- }
- if (FAIL == stmt_to_prepare->conn->m->simple_command(stmt_to_prepare->conn, COM_STMT_PREPARE, (const zend_uchar *) query, query_len, PROT_LAST, FALSE, TRUE TSRMLS_CC) ||
- FAIL == mysqlnd_stmt_read_prepare_response(s_to_prepare TSRMLS_CC))
- {
- goto fail;
- }
- if (stmt_to_prepare->param_count) {
- if (FAIL == mysqlnd_stmt_skip_metadata(s_to_prepare TSRMLS_CC) ||
- FAIL == mysqlnd_stmt_prepare_read_eof(s_to_prepare TSRMLS_CC))
- {
- goto fail;
- }
- }
- /*
- Read metadata only if there is actual result set.
- Beware that SHOW statements bypass the PS framework and thus they send
- no metadata at prepare.
- */
- if (stmt_to_prepare->field_count) {
- MYSQLND_RES * result = stmt->conn->m->result_init(stmt_to_prepare->field_count, stmt_to_prepare->persistent TSRMLS_CC);
- if (!result) {
- SET_OOM_ERROR(*stmt->conn->error_info);
- goto fail;
- }
- /* Allocate the result now as it is needed for the reading of metadata */
- stmt_to_prepare->result = result;
- result->conn = stmt_to_prepare->conn->m->get_reference(stmt_to_prepare->conn TSRMLS_CC);
- result->type = MYSQLND_RES_PS_BUF;
- if (FAIL == result->m.read_result_metadata(result, stmt_to_prepare->conn TSRMLS_CC) ||
- FAIL == mysqlnd_stmt_prepare_read_eof(s_to_prepare TSRMLS_CC))
- {
- goto fail;
- }
- }
- if (stmt_to_prepare != stmt) {
- /* swap */
- size_t real_size = sizeof(MYSQLND_STMT) + mysqlnd_plugin_count() * sizeof(void *);
- char * tmp_swap = mnd_malloc(real_size);
- memcpy(tmp_swap, s, real_size);
- memcpy(s, s_to_prepare, real_size);
- memcpy(s_to_prepare, tmp_swap, real_size);
- mnd_free(tmp_swap);
- {
- MYSQLND_STMT_DATA * tmp_swap_data = stmt_to_prepare;
- stmt_to_prepare = stmt;
- stmt = tmp_swap_data;
- }
- s_to_prepare->m->dtor(s_to_prepare, TRUE TSRMLS_CC);
- }
- stmt->state = MYSQLND_STMT_PREPARED;
- DBG_INF("PASS");
- DBG_RETURN(PASS);
- fail:
- if (stmt_to_prepare != stmt && s_to_prepare) {
- s_to_prepare->m->dtor(s_to_prepare, TRUE TSRMLS_CC);
- }
- stmt->state = MYSQLND_STMT_INITTED;
- DBG_INF("FAIL");
- DBG_RETURN(FAIL);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt_execute_parse_response */
- static enum_func_status
- mysqlnd_stmt_execute_parse_response(MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- enum_func_status ret;
- MYSQLND_CONN_DATA * conn;
- DBG_ENTER("mysqlnd_stmt_execute_parse_response");
- if (!stmt || !stmt->conn) {
- DBG_RETURN(FAIL);
- }
- conn = stmt->conn;
- CONN_SET_STATE(conn, CONN_QUERY_SENT);
- ret = mysqlnd_query_read_result_set_header(stmt->conn, s TSRMLS_CC);
- if (ret == FAIL) {
- COPY_CLIENT_ERROR(*stmt->error_info, *conn->error_info);
- memset(stmt->upsert_status, 0, sizeof(*stmt->upsert_status));
- stmt->upsert_status->affected_rows = conn->upsert_status->affected_rows;
- if (CONN_GET_STATE(conn) == CONN_QUIT_SENT) {
- /* close the statement here, the connection has been closed */
- }
- stmt->state = MYSQLND_STMT_PREPARED;
- stmt->send_types_to_server = 1;
- } else {
- /*
- stmt->send_types_to_server has already been set to 0 in
- mysqlnd_stmt_execute_generate_request / mysqlnd_stmt_execute_store_params
- In case there is a situation in which binding was done for integer and the
- value is > LONG_MAX or < LONG_MIN, there is string conversion and we have
- to resend the types. Next execution will also need to resend the type.
- */
- SET_EMPTY_ERROR(*stmt->error_info);
- SET_EMPTY_ERROR(*stmt->conn->error_info);
- *stmt->upsert_status = *conn->upsert_status; /* copy status */
- stmt->state = MYSQLND_STMT_EXECUTED;
- if (conn->last_query_type == QUERY_UPSERT || conn->last_query_type == QUERY_LOAD_LOCAL) {
- DBG_INF("PASS");
- DBG_RETURN(PASS);
- }
- stmt->result->type = MYSQLND_RES_PS_BUF;
- if (!stmt->result->conn) {
- /*
- For SHOW we don't create (bypasses PS in server)
- a result set at prepare and thus a connection was missing
- */
- stmt->result->conn = stmt->conn->m->get_reference(stmt->conn TSRMLS_CC);
- }
- /* Update stmt->field_count as SHOW sets it to 0 at prepare */
- stmt->field_count = stmt->result->field_count = conn->field_count;
- if (stmt->result->stored_data) {
- stmt->result->stored_data->lengths = NULL;
- } else if (stmt->result->unbuf) {
- stmt->result->unbuf->lengths = NULL;
- }
- if (stmt->field_count) {
- stmt->state = MYSQLND_STMT_WAITING_USE_OR_STORE;
- /*
- We need to set this because the user might not call
- use_result() or store_result() and we should be able to scrap the
- data on the line, if he just decides to close the statement.
- */
- DBG_INF_FMT("server_status=%u cursor=%u", stmt->upsert_status->server_status,
- stmt->upsert_status->server_status & SERVER_STATUS_CURSOR_EXISTS);
- if (stmt->upsert_status->server_status & SERVER_STATUS_CURSOR_EXISTS) {
- DBG_INF("cursor exists");
- stmt->cursor_exists = TRUE;
- CONN_SET_STATE(conn, CONN_READY);
- /* Only cursor read */
- stmt->default_rset_handler = s->m->use_result;
- DBG_INF("use_result");
- } else if (stmt->flags & CURSOR_TYPE_READ_ONLY) {
- DBG_INF("asked for cursor but got none");
- /*
- We have asked for CURSOR but got no cursor, because the condition
- above is not fulfilled. Then...
- This is a single-row result set, a result set with no rows, EXPLAIN,
- SHOW VARIABLES, or some other command which either a) bypasses the
- cursors framework in the server and writes rows directly to the
- network or b) is more efficient if all (few) result set rows are
- precached on client and server's resources are freed.
- */
- /* preferred is buffered read */
- stmt->default_rset_handler = s->m->store_result;
- DBG_INF("store_result");
- } else {
- DBG_INF("no cursor");
- /* preferred is unbuffered read */
- stmt->default_rset_handler = s->m->use_result;
- DBG_INF("use_result");
- }
- }
- }
- #ifndef MYSQLND_DONT_SKIP_OUT_PARAMS_RESULTSET
- if (stmt->upsert_status->server_status & SERVER_PS_OUT_PARAMS) {
- s->m->free_stmt_content(s TSRMLS_CC);
- DBG_INF("PS OUT Variable RSet, skipping");
- /* OUT params result set. Skip for now to retain compatibility */
- ret = mysqlnd_stmt_execute_parse_response(s TSRMLS_CC);
- }
- #endif
- DBG_INF(ret == PASS? "PASS":"FAIL");
- DBG_RETURN(ret);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::execute */
- static enum_func_status
- MYSQLND_METHOD(mysqlnd_stmt, execute)(MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- enum_func_status ret;
- MYSQLND_CONN_DATA * conn;
- zend_uchar *request = NULL;
- size_t request_len;
- zend_bool free_request;
- DBG_ENTER("mysqlnd_stmt::execute");
- if (!stmt || !stmt->conn) {
- DBG_RETURN(FAIL);
- }
- conn = stmt->conn;
- DBG_INF_FMT("stmt=%lu", stmt->stmt_id);
- SET_ERROR_AFF_ROWS(stmt);
- SET_ERROR_AFF_ROWS(stmt->conn);
- if (stmt->result && stmt->state >= MYSQLND_STMT_PREPARED && stmt->field_count) {
- /*
- We don need to copy the data from the buffers which we will clean.
- Because it has already been copied. See
- #ifndef WE_DONT_COPY_IN_BUFFERED_AND_UNBUFFERED_BECAUSEOF_IS_REF
- */
- #ifdef WE_DONT_COPY_IN_BUFFERED_AND_UNBUFFERED_BECAUSEOF_IS_REF
- if (stmt->result_bind &&
- stmt->result_zvals_separated_once == TRUE &&
- stmt->state >= MYSQLND_STMT_USER_FETCHING)
- {
- /*
- We need to copy the data from the buffers which we will clean.
- The bound variables point to them only if the user has started
- to fetch data (MYSQLND_STMT_USER_FETCHING).
- We need to check 'result_zvals_separated_once' or we will leak
- in the following scenario
- prepare("select 1 from dual");
- execute();
- fetch(); <-- no binding, but that's not a problem
- bind_result();
- execute(); <-- here we will leak because we separate without need
- */
- unsigned int i;
- for (i = 0; i < stmt->field_count; i++) {
- if (stmt->result_bind[i].bound == TRUE) {
- zval_copy_ctor(stmt->result_bind[i].zv);
- }
- }
- }
- #endif
- s->m->flush(s TSRMLS_CC);
- /*
- Executed, but the user hasn't started to fetch
- This will clean also the metadata, but after the EXECUTE call we will
- have it again.
- */
- stmt->result->m.free_result_buffers(stmt->result TSRMLS_CC);
- stmt->state = MYSQLND_STMT_PREPARED;
- } else if (stmt->state < MYSQLND_STMT_PREPARED) {
- /* Only initted - error */
- SET_CLIENT_ERROR(*conn->error_info, CR_COMMANDS_OUT_OF_SYNC, UNKNOWN_SQLSTATE,
- mysqlnd_out_of_sync);
- SET_STMT_ERROR(stmt, CR_COMMANDS_OUT_OF_SYNC, UNKNOWN_SQLSTATE, mysqlnd_out_of_sync);
- DBG_INF("FAIL");
- DBG_RETURN(FAIL);
- }
- if (stmt->param_count) {
- unsigned int i, not_bound = 0;
- if (!stmt->param_bind) {
- SET_STMT_ERROR(stmt, CR_PARAMS_NOT_BOUND, UNKNOWN_SQLSTATE,
- "No data supplied for parameters in prepared statement");
- DBG_INF("FAIL");
- DBG_RETURN(FAIL);
- }
- for (i = 0; i < stmt->param_count; i++) {
- if (stmt->param_bind[i].zv == NULL) {
- not_bound++;
- }
- }
- if (not_bound) {
- char * msg;
- mnd_sprintf(&msg, 0, "No data supplied for %u parameter%s in prepared statement",
- not_bound, not_bound>1 ?"s":"");
- SET_STMT_ERROR(stmt, CR_PARAMS_NOT_BOUND, UNKNOWN_SQLSTATE, msg);
- if (msg) {
- mnd_sprintf_free(msg);
- }
- DBG_INF("FAIL");
- DBG_RETURN(FAIL);
- }
- }
- ret = s->m->generate_execute_request(s, &request, &request_len, &free_request TSRMLS_CC);
- if (ret == PASS) {
- /* support for buffer types should be added here ! */
- ret = stmt->conn->m->simple_command(stmt->conn, COM_STMT_EXECUTE, request, request_len,
- PROT_LAST /* we will handle the response packet*/,
- FALSE, FALSE TSRMLS_CC);
- } else {
- SET_STMT_ERROR(stmt, CR_UNKNOWN_ERROR, UNKNOWN_SQLSTATE, "Couldn't generate the request. Possibly OOM.");
- }
- if (free_request) {
- mnd_efree(request);
- }
- if (ret == FAIL) {
- COPY_CLIENT_ERROR(*stmt->error_info, *conn->error_info);
- DBG_INF("FAIL");
- DBG_RETURN(FAIL);
- }
- stmt->execute_count++;
- ret = s->m->parse_execute_response(s TSRMLS_CC);
- DBG_INF_FMT("server_status=%u cursor=%u", stmt->upsert_status->server_status, stmt->upsert_status->server_status & SERVER_STATUS_CURSOR_EXISTS);
- if (ret == PASS && conn->last_query_type == QUERY_UPSERT && stmt->upsert_status->affected_rows) {
- MYSQLND_INC_CONN_STATISTIC_W_VALUE(conn->stats, STAT_ROWS_AFFECTED_PS, stmt->upsert_status->affected_rows);
- }
- DBG_RETURN(ret);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt_fetch_row_buffered */
- enum_func_status
- mysqlnd_stmt_fetch_row_buffered(MYSQLND_RES * result, void * param, unsigned int flags, zend_bool * fetched_anything TSRMLS_DC)
- {
- MYSQLND_STMT * s = (MYSQLND_STMT *) param;
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- const MYSQLND_RES_METADATA * const meta = result->meta;
- unsigned int field_count = meta->field_count;
- DBG_ENTER("mysqlnd_stmt_fetch_row_buffered");
- *fetched_anything = FALSE;
- DBG_INF_FMT("stmt=%lu", stmt != NULL ? stmt->stmt_id : 0L);
- /* If we haven't read everything */
- if (result->stored_data->type == MYSQLND_BUFFERED_TYPE_ZVAL) {
- MYSQLND_RES_BUFFERED_ZVAL * set = (MYSQLND_RES_BUFFERED_ZVAL *) result->stored_data;
- if (set->data_cursor &&
- (set->data_cursor - set->data) < (result->stored_data->row_count * field_count))
- {
- /* The user could have skipped binding - don't crash*/
- if (stmt->result_bind) {
- unsigned int i;
- zval **current_row = set->data_cursor;
- if (NULL == current_row[0]) {
- uint64_t row_num = (set->data_cursor - set->data) / field_count;
- enum_func_status rc = result->stored_data->m.row_decoder(result->stored_data->row_buffers[row_num],
- current_row,
- meta->field_count,
- meta->fields,
- result->conn->options->int_and_float_native,
- result->conn->stats TSRMLS_CC);
- if (PASS != rc) {
- DBG_RETURN(FAIL);
- }
- result->stored_data->initialized_rows++;
- if (stmt->update_max_length) {
- for (i = 0; i < result->field_count; i++) {
- /*
- NULL fields are 0 length, 0 is not more than 0
- String of zero size, definitely can't be the next max_length.
- Thus for NULL and zero-length we are quite efficient.
- */
- if (Z_TYPE_P(current_row[i]) >= IS_STRING) {
- unsigned long len = Z_STRLEN_P(current_row[i]);
- if (meta->fields[i].max_length < len) {
- meta->fields[i].max_length = len;
- }
- }
- }
- }
- }
- for (i = 0; i < result->field_count; i++) {
- /* Clean what we copied last time */
- #ifndef WE_DONT_COPY_IN_BUFFERED_AND_UNBUFFERED_BECAUSEOF_IS_REF
- if (stmt->result_bind[i].zv) {
- zval_dtor(stmt->result_bind[i].zv);
- }
- #endif
- /* copy the type */
- if (stmt->result_bind[i].bound == TRUE) {
- DBG_INF_FMT("i=%u type=%u", i, Z_TYPE_P(current_row[i]));
- if (Z_TYPE_P(current_row[i]) != IS_NULL) {
- /*
- Copy the value.
- Pre-condition is that the zvals in the result_bind buffer
- have been ZVAL_NULL()-ed or to another simple type
- (int, double, bool but not string). Because of the reference
- counting the user can't delete the strings the variables point to.
- */
- Z_TYPE_P(stmt->result_bind[i].zv) = Z_TYPE_P(current_row[i]);
- stmt->result_bind[i].zv->value = current_row[i]->value;
- #ifndef WE_DONT_COPY_IN_BUFFERED_AND_UNBUFFERED_BECAUSEOF_IS_REF
- zval_copy_ctor(stmt->result_bind[i].zv);
- #endif
- } else {
- ZVAL_NULL(stmt->result_bind[i].zv);
- }
- }
- }
- }
- set->data_cursor += field_count;
- *fetched_anything = TRUE;
- /* buffered result sets don't have a connection */
- MYSQLND_INC_GLOBAL_STATISTIC(STAT_ROWS_FETCHED_FROM_CLIENT_PS_BUF);
- DBG_INF("row fetched");
- } else {
- set->data_cursor = NULL;
- DBG_INF("no more data");
- }
- } else if (result->stored_data->type == MYSQLND_BUFFERED_TYPE_C) {
- /*TODO*/
- }
- DBG_INF("PASS");
- DBG_RETURN(PASS);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt_fetch_row_unbuffered */
- enum_func_status
- mysqlnd_stmt_fetch_row_unbuffered(MYSQLND_RES * result, void * param, unsigned int flags, zend_bool * fetched_anything TSRMLS_DC)
- {
- enum_func_status ret;
- MYSQLND_STMT * s = (MYSQLND_STMT *) param;
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- MYSQLND_PACKET_ROW * row_packet;
- const MYSQLND_RES_METADATA * const meta = result->meta;
- DBG_ENTER("mysqlnd_stmt_fetch_row_unbuffered");
- *fetched_anything = FALSE;
- if (result->unbuf->eof_reached) {
- /* No more rows obviously */
- DBG_INF("EOF already reached");
- DBG_RETURN(PASS);
- }
- if (CONN_GET_STATE(result->conn) != CONN_FETCHING_DATA) {
- SET_CLIENT_ERROR(*result->conn->error_info, CR_COMMANDS_OUT_OF_SYNC,
- UNKNOWN_SQLSTATE, mysqlnd_out_of_sync);
- DBG_ERR("command out of sync");
- DBG_RETURN(FAIL);
- }
- if (!(row_packet = result->unbuf->row_packet)) {
- DBG_RETURN(FAIL);
- }
- /* Let the row packet fill our buffer and skip additional malloc + memcpy */
- row_packet->skip_extraction = stmt && stmt->result_bind? FALSE:TRUE;
- /*
- If we skip rows (stmt == NULL || stmt->result_bind == NULL) we have to
- result->unbuf->m.free_last_data() before it. The function returns always true.
- */
- if (PASS == (ret = PACKET_READ(row_packet, result->conn)) && !row_packet->eof) {
- unsigned int i, field_count = result->field_count;
- if (!row_packet->skip_extraction) {
- result->unbuf->m.free_last_data(result->unbuf, result->conn? result->conn->stats : NULL TSRMLS_CC);
- result->unbuf->last_row_data = row_packet->fields;
- result->unbuf->last_row_buffer = row_packet->row_buffer;
- row_packet->fields = NULL;
- row_packet->row_buffer = NULL;
- if (PASS != result->unbuf->m.row_decoder(result->unbuf->last_row_buffer,
- result->unbuf->last_row_data,
- row_packet->field_count,
- row_packet->fields_metadata,
- result->conn->options->int_and_float_native,
- result->conn->stats TSRMLS_CC))
- {
- DBG_RETURN(FAIL);
- }
- for (i = 0; i < field_count; i++) {
- if (stmt->result_bind[i].bound == TRUE) {
- zval *data = result->unbuf->last_row_data[i];
- /*
- stmt->result_bind[i].zv has been already destructed
- in result->unbuf->m.free_last_data()
- */
- #ifndef WE_DONT_COPY_IN_BUFFERED_AND_UNBUFFERED_BECAUSEOF_IS_REF
- zval_dtor(stmt->result_bind[i].zv);
- #endif
- if (IS_NULL != (Z_TYPE_P(stmt->result_bind[i].zv) = Z_TYPE_P(data)) ) {
- if ((Z_TYPE_P(data) == IS_STRING) && (meta->fields[i].max_length < (unsigned long) Z_STRLEN_P(data))) {
- meta->fields[i].max_length = Z_STRLEN_P(data);
- }
- stmt->result_bind[i].zv->value = data->value;
- /* copied data, thus also the ownership. Thus null data */
- ZVAL_NULL(data);
- }
- }
- }
- MYSQLND_INC_CONN_STATISTIC(stmt->conn->stats, STAT_ROWS_FETCHED_FROM_CLIENT_PS_UNBUF);
- } else {
- DBG_INF("skipping extraction");
- /*
- Data has been allocated and usually result->unbuf->m.free_last_data()
- frees it but we can't call this function as it will cause problems with
- the bound variables. Thus we need to do part of what it does or Zend will
- report leaks.
- */
- row_packet->row_buffer->free_chunk(row_packet->row_buffer TSRMLS_CC);
- row_packet->row_buffer = NULL;
- }
- result->unbuf->row_count++;
- *fetched_anything = TRUE;
- } else if (ret == FAIL) {
- if (row_packet->error_info.error_no) {
- COPY_CLIENT_ERROR(*stmt->conn->error_info, row_packet->error_info);
- COPY_CLIENT_ERROR(*stmt->error_info, row_packet->error_info);
- }
- CONN_SET_STATE(result->conn, CONN_READY);
- result->unbuf->eof_reached = TRUE; /* so next time we won't get an error */
- } else if (row_packet->eof) {
- DBG_INF("EOF");
- /* Mark the connection as usable again */
- result->unbuf->eof_reached = TRUE;
- memset(result->conn->upsert_status, 0, sizeof(*result->conn->upsert_status));
- result->conn->upsert_status->warning_count = row_packet->warning_count;
- result->conn->upsert_status->server_status = row_packet->server_status;
- /*
- result->row_packet will be cleaned when
- destroying the result object
- */
- if (result->conn->upsert_status->server_status & SERVER_MORE_RESULTS_EXISTS) {
- CONN_SET_STATE(result->conn, CONN_NEXT_RESULT_PENDING);
- } else {
- CONN_SET_STATE(result->conn, CONN_READY);
- }
- }
- DBG_INF_FMT("ret=%s fetched_anything=%u", ret == PASS? "PASS":"FAIL", *fetched_anything);
- DBG_RETURN(ret);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::use_result */
- static MYSQLND_RES *
- MYSQLND_METHOD(mysqlnd_stmt, use_result)(MYSQLND_STMT * s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- MYSQLND_RES * result;
- MYSQLND_CONN_DATA * conn;
- DBG_ENTER("mysqlnd_stmt::use_result");
- if (!stmt || !stmt->conn || !stmt->result) {
- DBG_RETURN(NULL);
- }
- DBG_INF_FMT("stmt=%lu", stmt->stmt_id);
- conn = stmt->conn;
- if (!stmt->field_count ||
- (!stmt->cursor_exists && CONN_GET_STATE(conn) != CONN_FETCHING_DATA) ||
- (stmt->cursor_exists && CONN_GET_STATE(conn) != CONN_READY) ||
- (stmt->state != MYSQLND_STMT_WAITING_USE_OR_STORE))
- {
- SET_CLIENT_ERROR(*conn->error_info, CR_COMMANDS_OUT_OF_SYNC,
- UNKNOWN_SQLSTATE, mysqlnd_out_of_sync);
- DBG_ERR("command out of sync");
- DBG_RETURN(NULL);
- }
- SET_EMPTY_ERROR(*stmt->error_info);
- MYSQLND_INC_CONN_STATISTIC(stmt->conn->stats, STAT_PS_UNBUFFERED_SETS);
- result = stmt->result;
- result->m.use_result(stmt->result, TRUE TSRMLS_CC);
- result->unbuf->m.fetch_row = stmt->cursor_exists? mysqlnd_fetch_stmt_row_cursor:
- mysqlnd_stmt_fetch_row_unbuffered;
- stmt->state = MYSQLND_STMT_USE_OR_STORE_CALLED;
- DBG_INF_FMT("%p", result);
- DBG_RETURN(result);
- }
- /* }}} */
- #define STMT_ID_LENGTH 4
- /* {{{ mysqlnd_fetch_row_cursor */
- enum_func_status
- mysqlnd_fetch_stmt_row_cursor(MYSQLND_RES * result, void * param, unsigned int flags, zend_bool * fetched_anything TSRMLS_DC)
- {
- enum_func_status ret;
- MYSQLND_STMT * s = (MYSQLND_STMT *) param;
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- zend_uchar buf[STMT_ID_LENGTH /* statement id */ + 4 /* number of rows to fetch */];
- MYSQLND_PACKET_ROW * row_packet;
- DBG_ENTER("mysqlnd_fetch_stmt_row_cursor");
- if (!stmt || !stmt->conn || !result || !result->conn || !result->unbuf) {
- DBG_ERR("no statement");
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("stmt=%lu flags=%u", stmt->stmt_id, flags);
- if (stmt->state < MYSQLND_STMT_USER_FETCHING) {
- /* Only initted - error */
- SET_CLIENT_ERROR(*stmt->conn->error_info, CR_COMMANDS_OUT_OF_SYNC, UNKNOWN_SQLSTATE,
- mysqlnd_out_of_sync);
- DBG_ERR("command out of sync");
- DBG_RETURN(FAIL);
- }
- if (!(row_packet = result->unbuf->row_packet)) {
- DBG_RETURN(FAIL);
- }
- SET_EMPTY_ERROR(*stmt->error_info);
- SET_EMPTY_ERROR(*stmt->conn->error_info);
- int4store(buf, stmt->stmt_id);
- int4store(buf + STMT_ID_LENGTH, 1); /* for now fetch only one row */
- if (FAIL == stmt->conn->m->simple_command(stmt->conn, COM_STMT_FETCH, buf, sizeof(buf),
- PROT_LAST /* we will handle the response packet*/,
- FALSE, TRUE TSRMLS_CC)) {
- COPY_CLIENT_ERROR(*stmt->error_info, *stmt->conn->error_info);
- DBG_RETURN(FAIL);
- }
- row_packet->skip_extraction = stmt->result_bind? FALSE:TRUE;
- memset(stmt->upsert_status, 0, sizeof(*stmt->upsert_status));
- if (PASS == (ret = PACKET_READ(row_packet, result->conn)) && !row_packet->eof) {
- const MYSQLND_RES_METADATA * const meta = result->meta;
- unsigned int i, field_count = result->field_count;
- if (!row_packet->skip_extraction) {
- result->unbuf->m.free_last_data(result->unbuf, result->conn? result->conn->stats : NULL TSRMLS_CC);
- result->unbuf->last_row_data = row_packet->fields;
- result->unbuf->last_row_buffer = row_packet->row_buffer;
- row_packet->fields = NULL;
- row_packet->row_buffer = NULL;
- if (PASS != result->unbuf->m.row_decoder(result->unbuf->last_row_buffer,
- result->unbuf->last_row_data,
- row_packet->field_count,
- row_packet->fields_metadata,
- result->conn->options->int_and_float_native,
- result->conn->stats TSRMLS_CC))
- {
- DBG_RETURN(FAIL);
- }
- /* If no result bind, do nothing. We consumed the data */
- for (i = 0; i < field_count; i++) {
- if (stmt->result_bind[i].bound == TRUE) {
- zval *data = result->unbuf->last_row_data[i];
- /*
- stmt->result_bind[i].zv has been already destructed
- in result->unbuf->m.free_last_data()
- */
- #ifndef WE_DONT_COPY_IN_BUFFERED_AND_UNBUFFERED_BECAUSEOF_IS_REF
- zval_dtor(stmt->result_bind[i].zv);
- #endif
- DBG_INF_FMT("i=%u bound_var=%p type=%u refc=%u", i, stmt->result_bind[i].zv,
- Z_TYPE_P(data), Z_REFCOUNT_P(stmt->result_bind[i].zv));
- if (IS_NULL != (Z_TYPE_P(stmt->result_bind[i].zv) = Z_TYPE_P(data))) {
- if ((Z_TYPE_P(data) == IS_STRING) && (meta->fields[i].max_length < (unsigned long) Z_STRLEN_P(data))) {
- meta->fields[i].max_length = Z_STRLEN_P(data);
- }
- stmt->result_bind[i].zv->value = data->value;
- /* copied data, thus also the ownership. Thus null data */
- ZVAL_NULL(data);
- }
- }
- }
- } else {
- DBG_INF("skipping extraction");
- /*
- Data has been allocated and usually result->unbuf->m.free_last_data()
- frees it but we can't call this function as it will cause problems with
- the bound variables. Thus we need to do part of what it does or Zend will
- report leaks.
- */
- row_packet->row_buffer->free_chunk(row_packet->row_buffer TSRMLS_CC);
- row_packet->row_buffer = NULL;
- }
- /* We asked for one row, the next one should be EOF, eat it */
- ret = PACKET_READ(row_packet, result->conn);
- if (row_packet->row_buffer) {
- row_packet->row_buffer->free_chunk(row_packet->row_buffer TSRMLS_CC);
- row_packet->row_buffer = NULL;
- }
- MYSQLND_INC_CONN_STATISTIC(stmt->conn->stats, STAT_ROWS_FETCHED_FROM_CLIENT_PS_CURSOR);
- result->unbuf->row_count++;
- *fetched_anything = TRUE;
- } else {
- *fetched_anything = FALSE;
- stmt->upsert_status->warning_count =
- stmt->conn->upsert_status->warning_count =
- row_packet->warning_count;
- stmt->upsert_status->server_status =
- stmt->conn->upsert_status->server_status =
- row_packet->server_status;
- result->unbuf->eof_reached = row_packet->eof;
- }
- stmt->upsert_status->warning_count =
- stmt->conn->upsert_status->warning_count =
- row_packet->warning_count;
- stmt->upsert_status->server_status =
- stmt->conn->upsert_status->server_status =
- row_packet->server_status;
- DBG_INF_FMT("ret=%s fetched=%u server_status=%u warnings=%u eof=%u",
- ret == PASS? "PASS":"FAIL", *fetched_anything,
- row_packet->server_status, row_packet->warning_count,
- result->unbuf->eof_reached);
- DBG_RETURN(ret);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::fetch */
- static enum_func_status
- MYSQLND_METHOD(mysqlnd_stmt, fetch)(MYSQLND_STMT * const s, zend_bool * const fetched_anything TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- enum_func_status ret;
- DBG_ENTER("mysqlnd_stmt::fetch");
- if (!stmt || !stmt->conn) {
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("stmt=%lu", stmt->stmt_id);
- if (!stmt->result ||
- stmt->state < MYSQLND_STMT_WAITING_USE_OR_STORE) {
- SET_STMT_ERROR(stmt, CR_COMMANDS_OUT_OF_SYNC, UNKNOWN_SQLSTATE, mysqlnd_out_of_sync);
- DBG_ERR("command out of sync");
- DBG_RETURN(FAIL);
- } else if (stmt->state == MYSQLND_STMT_WAITING_USE_OR_STORE) {
- /* Execute only once. We have to free the previous contents of user's bound vars */
- stmt->default_rset_handler(s TSRMLS_CC);
- }
- stmt->state = MYSQLND_STMT_USER_FETCHING;
- SET_EMPTY_ERROR(*stmt->error_info);
- SET_EMPTY_ERROR(*stmt->conn->error_info);
- DBG_INF_FMT("result_bind=%p separated_once=%u", stmt->result_bind, stmt->result_zvals_separated_once);
- /*
- The user might have not bound any variables for result.
- Do the binding once she does it.
- */
- if (stmt->result_bind && !stmt->result_zvals_separated_once) {
- unsigned int i;
- /*
- mysqlnd_stmt_store_result() has been called free the bind
- variables to prevent leaking of their previous content.
- */
- for (i = 0; i < stmt->result->field_count; i++) {
- if (stmt->result_bind[i].bound == TRUE) {
- zval_dtor(stmt->result_bind[i].zv);
- ZVAL_NULL(stmt->result_bind[i].zv);
- }
- }
- stmt->result_zvals_separated_once = TRUE;
- }
- ret = stmt->result->m.fetch_row(stmt->result, (void*)s, 0, fetched_anything TSRMLS_CC);
- DBG_RETURN(ret);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::reset */
- static enum_func_status
- MYSQLND_METHOD(mysqlnd_stmt, reset)(MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- enum_func_status ret = PASS;
- zend_uchar cmd_buf[STMT_ID_LENGTH /* statement id */];
- DBG_ENTER("mysqlnd_stmt::reset");
- if (!stmt || !stmt->conn) {
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("stmt=%lu", stmt->stmt_id);
- SET_EMPTY_ERROR(*stmt->error_info);
- SET_EMPTY_ERROR(*stmt->conn->error_info);
- if (stmt->stmt_id) {
- MYSQLND_CONN_DATA * conn = stmt->conn;
- if (stmt->param_bind) {
- unsigned int i;
- DBG_INF("resetting long data");
- /* Reset Long Data */
- for (i = 0; i < stmt->param_count; i++) {
- if (stmt->param_bind[i].flags & MYSQLND_PARAM_BIND_BLOB_USED) {
- stmt->param_bind[i].flags &= ~MYSQLND_PARAM_BIND_BLOB_USED;
- }
- }
- }
- s->m->flush(s TSRMLS_CC);
- /*
- Don't free now, let the result be usable. When the stmt will again be
- executed then the result set will be cleaned, the bound variables will
- be separated before that.
- */
- int4store(cmd_buf, stmt->stmt_id);
- if (CONN_GET_STATE(conn) == CONN_READY &&
- FAIL == (ret = conn->m->simple_command(conn, COM_STMT_RESET, cmd_buf,
- sizeof(cmd_buf), PROT_OK_PACKET,
- FALSE, TRUE TSRMLS_CC))) {
- COPY_CLIENT_ERROR(*stmt->error_info, *conn->error_info);
- }
- *stmt->upsert_status = *conn->upsert_status;
- }
- DBG_INF(ret == PASS? "PASS":"FAIL");
- DBG_RETURN(ret);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::flush */
- static enum_func_status
- MYSQLND_METHOD(mysqlnd_stmt, flush)(MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- enum_func_status ret = PASS;
- DBG_ENTER("mysqlnd_stmt::flush");
- if (!stmt || !stmt->conn) {
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("stmt=%lu", stmt->stmt_id);
- if (stmt->stmt_id) {
- /*
- If the user decided to close the statement right after execute()
- We have to call the appropriate use_result() or store_result() and
- clean.
- */
- do {
- if (stmt->state == MYSQLND_STMT_WAITING_USE_OR_STORE) {
- DBG_INF("fetching result set header");
- stmt->default_rset_handler(s TSRMLS_CC);
- stmt->state = MYSQLND_STMT_USER_FETCHING;
- }
- if (stmt->result) {
- DBG_INF("skipping result");
- stmt->result->m.skip_result(stmt->result TSRMLS_CC);
- }
- } while (mysqlnd_stmt_more_results(s) && mysqlnd_stmt_next_result(s) == PASS);
- }
- DBG_INF(ret == PASS? "PASS":"FAIL");
- DBG_RETURN(ret);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::send_long_data */
- static enum_func_status
- MYSQLND_METHOD(mysqlnd_stmt, send_long_data)(MYSQLND_STMT * const s, unsigned int param_no,
- const char * const data, unsigned long length TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- enum_func_status ret = FAIL;
- MYSQLND_CONN_DATA * conn;
- zend_uchar * cmd_buf;
- enum php_mysqlnd_server_command cmd = COM_STMT_SEND_LONG_DATA;
- DBG_ENTER("mysqlnd_stmt::send_long_data");
- if (!stmt || !stmt->conn) {
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("stmt=%lu param_no=%u data_len=%lu", stmt->stmt_id, param_no, length);
- conn = stmt->conn;
- SET_EMPTY_ERROR(*stmt->error_info);
- SET_EMPTY_ERROR(*stmt->conn->error_info);
- if (stmt->state < MYSQLND_STMT_PREPARED) {
- SET_STMT_ERROR(stmt, CR_NO_PREPARE_STMT, UNKNOWN_SQLSTATE, mysqlnd_stmt_not_prepared);
- DBG_ERR("not prepared");
- DBG_RETURN(FAIL);
- }
- if (!stmt->param_bind) {
- SET_STMT_ERROR(stmt, CR_COMMANDS_OUT_OF_SYNC, UNKNOWN_SQLSTATE, mysqlnd_out_of_sync);
- DBG_ERR("command out of sync");
- DBG_RETURN(FAIL);
- }
- if (param_no >= stmt->param_count) {
- SET_STMT_ERROR(stmt, CR_INVALID_PARAMETER_NO, UNKNOWN_SQLSTATE, "Invalid parameter number");
- DBG_ERR("invalid param_no");
- DBG_RETURN(FAIL);
- }
- if (stmt->param_bind[param_no].type != MYSQL_TYPE_LONG_BLOB) {
- SET_STMT_ERROR(stmt, CR_INVALID_BUFFER_USE, UNKNOWN_SQLSTATE, mysqlnd_not_bound_as_blob);
- DBG_ERR("param_no is not of a blob type");
- DBG_RETURN(FAIL);
- }
- /*
- XXX: Unfortunately we have to allocate additional buffer to be able the
- additional data, which is like a header inside the payload.
- This should be optimised, but it will be a pervasive change, so
- conn->m->simple_command() will accept not a buffer, but actually MYSQLND_STRING*
- terminated by NULL, to send. If the strings are not big, we can collapse them
- on the buffer every connection has, but otherwise we will just send them
- one by one to the wire.
- */
- if (CONN_GET_STATE(conn) == CONN_READY) {
- size_t packet_len;
- cmd_buf = mnd_emalloc(packet_len = STMT_ID_LENGTH + 2 + length);
- if (cmd_buf) {
- stmt->param_bind[param_no].flags |= MYSQLND_PARAM_BIND_BLOB_USED;
- int4store(cmd_buf, stmt->stmt_id);
- int2store(cmd_buf + STMT_ID_LENGTH, param_no);
- memcpy(cmd_buf + STMT_ID_LENGTH + 2, data, length);
- /* COM_STMT_SEND_LONG_DATA doesn't send an OK packet*/
- ret = conn->m->simple_command(conn, cmd, cmd_buf, packet_len, PROT_LAST , FALSE, TRUE TSRMLS_CC);
- mnd_efree(cmd_buf);
- if (FAIL == ret) {
- COPY_CLIENT_ERROR(*stmt->error_info, *conn->error_info);
- }
- } else {
- ret = FAIL;
- SET_OOM_ERROR(*stmt->error_info);
- SET_OOM_ERROR(*conn->error_info);
- }
- /*
- Cover protocol error: COM_STMT_SEND_LONG_DATA was designed to be quick and not
- sent response packets. According to documentation the only way to get an error
- is to have out-of-memory on the server-side. However, that's not true, as if
- max_allowed_packet_size is smaller than the chunk being sent to the server, the
- latter will complain with an error message. However, normally we don't expect
- an error message, thus we continue. When sending the next command, which expects
- response we will read the unexpected data and error message will look weird.
- Therefore we do non-blocking read to clean the line, if there is a need.
- Nevertheless, there is a built-in protection when sending a command packet, that
- checks if the line is clear - useful for debug purposes and to be switched off
- in release builds.
- Maybe we can make it automatic by checking what's the value of
- max_allowed_packet_size on the server and resending the data.
- */
- #ifdef MYSQLND_DO_WIRE_CHECK_BEFORE_COMMAND
- #if HAVE_USLEEP && !defined(PHP_WIN32)
- usleep(120000);
- #endif
- if ((packet_len = conn->net->m.consume_uneaten_data(conn->net, cmd TSRMLS_CC))) {
- php_error_docref(NULL TSRMLS_CC, E_WARNING, "There was an error "
- "while sending long data. Probably max_allowed_packet_size "
- "is smaller than the data. You have to increase it or send "
- "smaller chunks of data. Answer was "MYSQLND_SZ_T_SPEC" bytes long.", packet_len);
- SET_STMT_ERROR(stmt, CR_CONNECTION_ERROR, UNKNOWN_SQLSTATE,
- "Server responded to COM_STMT_SEND_LONG_DATA.");
- ret = FAIL;
- }
- #endif
- }
- DBG_INF(ret == PASS? "PASS":"FAIL");
- DBG_RETURN(ret);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::bind_parameters */
- static enum_func_status
- MYSQLND_METHOD(mysqlnd_stmt, bind_parameters)(MYSQLND_STMT * const s, MYSQLND_PARAM_BIND * const param_bind TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- DBG_ENTER("mysqlnd_stmt::bind_param");
- if (!stmt || !stmt->conn) {
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("stmt=%lu param_count=%u", stmt->stmt_id, stmt->param_count);
- if (stmt->state < MYSQLND_STMT_PREPARED) {
- SET_STMT_ERROR(stmt, CR_NO_PREPARE_STMT, UNKNOWN_SQLSTATE, mysqlnd_stmt_not_prepared);
- DBG_ERR("not prepared");
- if (param_bind) {
- s->m->free_parameter_bind(s, param_bind TSRMLS_CC);
- }
- DBG_RETURN(FAIL);
- }
- SET_EMPTY_ERROR(*stmt->error_info);
- SET_EMPTY_ERROR(*stmt->conn->error_info);
- if (stmt->param_count) {
- unsigned int i = 0;
- if (!param_bind) {
- SET_STMT_ERROR(stmt, CR_COMMANDS_OUT_OF_SYNC, UNKNOWN_SQLSTATE, "Re-binding (still) not supported");
- DBG_ERR("Re-binding (still) not supported");
- DBG_RETURN(FAIL);
- } else if (stmt->param_bind) {
- DBG_INF("Binding");
- /*
- There is already result bound.
- Forbid for now re-binding!!
- */
- for (i = 0; i < stmt->param_count; i++) {
- /*
- We may have the last reference, then call zval_ptr_dtor() or we may leak memory.
- Switching from bind_one_parameter to bind_parameters may result in zv being NULL
- */
- if (stmt->param_bind[i].zv) {
- zval_ptr_dtor(&stmt->param_bind[i].zv);
- }
- }
- if (stmt->param_bind != param_bind) {
- s->m->free_parameter_bind(s, stmt->param_bind TSRMLS_CC);
- }
- }
- stmt->param_bind = param_bind;
- for (i = 0; i < stmt->param_count; i++) {
- /* The client will use stmt_send_long_data */
- DBG_INF_FMT("%u is of type %u", i, stmt->param_bind[i].type);
- /* Prevent from freeing */
- /* Don't update is_ref, or we will leak during conversion */
- Z_ADDREF_P(stmt->param_bind[i].zv);
- stmt->param_bind[i].flags = 0;
- if (stmt->param_bind[i].type == MYSQL_TYPE_LONG_BLOB) {
- stmt->param_bind[i].flags &= ~MYSQLND_PARAM_BIND_BLOB_USED;
- }
- }
- stmt->send_types_to_server = 1;
- }
- DBG_INF("PASS");
- DBG_RETURN(PASS);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::bind_one_parameter */
- static enum_func_status
- MYSQLND_METHOD(mysqlnd_stmt, bind_one_parameter)(MYSQLND_STMT * const s, unsigned int param_no,
- zval * const zv, zend_uchar type TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- DBG_ENTER("mysqlnd_stmt::bind_one_parameter");
- if (!stmt || !stmt->conn) {
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("stmt=%lu param_no=%u param_count=%u type=%u", stmt->stmt_id, param_no, stmt->param_count, type);
- if (stmt->state < MYSQLND_STMT_PREPARED) {
- SET_STMT_ERROR(stmt, CR_NO_PREPARE_STMT, UNKNOWN_SQLSTATE, mysqlnd_stmt_not_prepared);
- DBG_ERR("not prepared");
- DBG_RETURN(FAIL);
- }
- if (param_no >= stmt->param_count) {
- SET_STMT_ERROR(stmt, CR_INVALID_PARAMETER_NO, UNKNOWN_SQLSTATE, "Invalid parameter number");
- DBG_ERR("invalid param_no");
- DBG_RETURN(FAIL);
- }
- SET_EMPTY_ERROR(*stmt->error_info);
- SET_EMPTY_ERROR(*stmt->conn->error_info);
- if (stmt->param_count) {
- if (!stmt->param_bind) {
- stmt->param_bind = mnd_pecalloc(stmt->param_count, sizeof(MYSQLND_PARAM_BIND), stmt->persistent);
- if (!stmt->param_bind) {
- DBG_RETURN(FAIL);
- }
- }
- /* Prevent from freeing */
- /* Don't update is_ref, or we will leak during conversion */
- Z_ADDREF_P(zv);
- DBG_INF("Binding");
- /* Release what we had, if we had */
- if (stmt->param_bind[param_no].zv) {
- zval_ptr_dtor(&stmt->param_bind[param_no].zv);
- }
- if (type == MYSQL_TYPE_LONG_BLOB) {
- /* The client will use stmt_send_long_data */
- stmt->param_bind[param_no].flags &= ~MYSQLND_PARAM_BIND_BLOB_USED;
- }
- stmt->param_bind[param_no].zv = zv;
- stmt->param_bind[param_no].type = type;
- stmt->send_types_to_server = 1;
- }
- DBG_INF("PASS");
- DBG_RETURN(PASS);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::refresh_bind_param */
- static enum_func_status
- MYSQLND_METHOD(mysqlnd_stmt, refresh_bind_param)(MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- DBG_ENTER("mysqlnd_stmt::refresh_bind_param");
- if (!stmt || !stmt->conn) {
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("stmt=%lu param_count=%u", stmt->stmt_id, stmt->param_count);
- if (stmt->state < MYSQLND_STMT_PREPARED) {
- SET_STMT_ERROR(stmt, CR_NO_PREPARE_STMT, UNKNOWN_SQLSTATE, mysqlnd_stmt_not_prepared);
- DBG_ERR("not prepared");
- DBG_RETURN(FAIL);
- }
- SET_EMPTY_ERROR(*stmt->error_info);
- SET_EMPTY_ERROR(*stmt->conn->error_info);
- if (stmt->param_count) {
- stmt->send_types_to_server = 1;
- }
- DBG_RETURN(PASS);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::bind_result */
- static enum_func_status
- MYSQLND_METHOD(mysqlnd_stmt, bind_result)(MYSQLND_STMT * const s,
- MYSQLND_RESULT_BIND * const result_bind TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- DBG_ENTER("mysqlnd_stmt::bind_result");
- if (!stmt || !stmt->conn) {
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("stmt=%lu field_count=%u", stmt->stmt_id, stmt->field_count);
- if (stmt->state < MYSQLND_STMT_PREPARED) {
- SET_STMT_ERROR(stmt, CR_NO_PREPARE_STMT, UNKNOWN_SQLSTATE, mysqlnd_stmt_not_prepared);
- if (result_bind) {
- s->m->free_result_bind(s, result_bind TSRMLS_CC);
- }
- DBG_ERR("not prepared");
- DBG_RETURN(FAIL);
- }
- SET_EMPTY_ERROR(*stmt->error_info);
- SET_EMPTY_ERROR(*stmt->conn->error_info);
- if (stmt->field_count) {
- unsigned int i = 0;
- if (!result_bind) {
- DBG_ERR("no result bind passed");
- DBG_RETURN(FAIL);
- }
- mysqlnd_stmt_separate_result_bind(s TSRMLS_CC);
- stmt->result_zvals_separated_once = FALSE;
- stmt->result_bind = result_bind;
- for (i = 0; i < stmt->field_count; i++) {
- /* Prevent from freeing */
- Z_ADDREF_P(stmt->result_bind[i].zv);
- DBG_INF_FMT("ref of %p = %u", stmt->result_bind[i].zv, Z_REFCOUNT_P(stmt->result_bind[i].zv));
- /*
- Don't update is_ref !!! it's not our job
- Otherwise either 009.phpt or mysqli_stmt_bind_result.phpt
- will fail.
- */
- stmt->result_bind[i].bound = TRUE;
- }
- } else if (result_bind) {
- s->m->free_result_bind(s, result_bind TSRMLS_CC);
- }
- DBG_INF("PASS");
- DBG_RETURN(PASS);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::bind_result */
- static enum_func_status
- MYSQLND_METHOD(mysqlnd_stmt, bind_one_result)(MYSQLND_STMT * const s, unsigned int param_no TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- DBG_ENTER("mysqlnd_stmt::bind_result");
- if (!stmt || !stmt->conn) {
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("stmt=%lu field_count=%u", stmt->stmt_id, stmt->field_count);
- if (stmt->state < MYSQLND_STMT_PREPARED) {
- SET_STMT_ERROR(stmt, CR_NO_PREPARE_STMT, UNKNOWN_SQLSTATE, mysqlnd_stmt_not_prepared);
- DBG_ERR("not prepared");
- DBG_RETURN(FAIL);
- }
- if (param_no >= stmt->field_count) {
- SET_STMT_ERROR(stmt, CR_INVALID_PARAMETER_NO, UNKNOWN_SQLSTATE, "Invalid parameter number");
- DBG_ERR("invalid param_no");
- DBG_RETURN(FAIL);
- }
- SET_EMPTY_ERROR(*stmt->error_info);
- SET_EMPTY_ERROR(*stmt->conn->error_info);
- if (stmt->field_count) {
- mysqlnd_stmt_separate_one_result_bind(s, param_no TSRMLS_CC);
- /* Guaranteed is that stmt->result_bind is NULL */
- if (!stmt->result_bind) {
- stmt->result_bind = mnd_pecalloc(stmt->field_count, sizeof(MYSQLND_RESULT_BIND), stmt->persistent);
- } else {
- stmt->result_bind = mnd_perealloc(stmt->result_bind, stmt->field_count * sizeof(MYSQLND_RESULT_BIND), stmt->persistent);
- }
- if (!stmt->result_bind) {
- DBG_RETURN(FAIL);
- }
- ALLOC_INIT_ZVAL(stmt->result_bind[param_no].zv);
- /*
- Don't update is_ref !!! it's not our job
- Otherwise either 009.phpt or mysqli_stmt_bind_result.phpt
- will fail.
- */
- stmt->result_bind[param_no].bound = TRUE;
- }
- DBG_INF("PASS");
- DBG_RETURN(PASS);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::insert_id */
- static uint64_t
- MYSQLND_METHOD(mysqlnd_stmt, insert_id)(const MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- return stmt? stmt->upsert_status->last_insert_id : 0;
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::affected_rows */
- static uint64_t
- MYSQLND_METHOD(mysqlnd_stmt, affected_rows)(const MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- return stmt? stmt->upsert_status->affected_rows : 0;
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::num_rows */
- static uint64_t
- MYSQLND_METHOD(mysqlnd_stmt, num_rows)(const MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- return stmt && stmt->result? mysqlnd_num_rows(stmt->result):0;
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::warning_count */
- static unsigned int
- MYSQLND_METHOD(mysqlnd_stmt, warning_count)(const MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- return stmt? stmt->upsert_status->warning_count : 0;
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::server_status */
- static unsigned int
- MYSQLND_METHOD(mysqlnd_stmt, server_status)(const MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- return stmt? stmt->upsert_status->server_status : 0;
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::field_count */
- static unsigned int
- MYSQLND_METHOD(mysqlnd_stmt, field_count)(const MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- return stmt? stmt->field_count : 0;
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::param_count */
- static unsigned int
- MYSQLND_METHOD(mysqlnd_stmt, param_count)(const MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- return stmt? stmt->param_count : 0;
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::errno */
- static unsigned int
- MYSQLND_METHOD(mysqlnd_stmt, errno)(const MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- return stmt? stmt->error_info->error_no : 0;
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::error */
- static const char *
- MYSQLND_METHOD(mysqlnd_stmt, error)(const MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- return stmt? stmt->error_info->error : 0;
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::sqlstate */
- static const char *
- MYSQLND_METHOD(mysqlnd_stmt, sqlstate)(const MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- return stmt && stmt->error_info->sqlstate[0] ? stmt->error_info->sqlstate:MYSQLND_SQLSTATE_NULL;
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::data_seek */
- static enum_func_status
- MYSQLND_METHOD(mysqlnd_stmt, data_seek)(const MYSQLND_STMT * const s, uint64_t row TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- return stmt && stmt->result? stmt->result->m.seek_data(stmt->result, row TSRMLS_CC) : FAIL;
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::param_metadata */
- static MYSQLND_RES *
- MYSQLND_METHOD(mysqlnd_stmt, param_metadata)(MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- if (!stmt || !stmt->param_count) {
- return NULL;
- }
- return NULL;
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::result_metadata */
- static MYSQLND_RES *
- MYSQLND_METHOD(mysqlnd_stmt, result_metadata)(MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- MYSQLND_RES *result;
- DBG_ENTER("mysqlnd_stmt::result_metadata");
- if (!stmt) {
- DBG_RETURN(NULL);
- }
- DBG_INF_FMT("stmt=%u field_count=%u", stmt->stmt_id, stmt->field_count);
- if (!stmt->field_count || !stmt->conn || !stmt->result || !stmt->result->meta) {
- DBG_INF("NULL");
- DBG_RETURN(NULL);
- }
- if (stmt->update_max_length && stmt->result->stored_data) {
- /* stored result, we have to update the max_length before we clone the meta data :( */
- stmt->result->stored_data->m.initialize_result_set_rest(stmt->result->stored_data, stmt->result->meta, stmt->conn->stats,
- stmt->conn->options->int_and_float_native TSRMLS_CC);
- }
- /*
- TODO: This implementation is kind of a hack,
- find a better way to do it. In different functions I have put
- fuses to check for result->m.fetch_row() being NULL. This should
- be handled in a better way.
- In the meantime we don't need a zval cache reference for this fake
- result set, so we don't get one.
- */
- do {
- result = stmt->conn->m->result_init(stmt->field_count, stmt->persistent TSRMLS_CC);
- if (!result) {
- break;
- }
- result->type = MYSQLND_RES_NORMAL;
- result->unbuf = mysqlnd_result_unbuffered_init(stmt->field_count, TRUE, result->persistent TSRMLS_CC);
- if (!result->unbuf) {
- break;
- }
- result->unbuf->eof_reached = TRUE;
- result->meta = stmt->result->meta->m->clone_metadata(stmt->result->meta, FALSE TSRMLS_CC);
- if (!result->meta) {
- break;
- }
- DBG_INF_FMT("result=%p", result);
- DBG_RETURN(result);
- } while (0);
- SET_OOM_ERROR(*stmt->conn->error_info);
- if (result) {
- result->m.free_result(result, TRUE TSRMLS_CC);
- }
- DBG_RETURN(NULL);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::attr_set */
- static enum_func_status
- MYSQLND_METHOD(mysqlnd_stmt, attr_set)(MYSQLND_STMT * const s,
- enum mysqlnd_stmt_attr attr_type,
- const void * const value TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- DBG_ENTER("mysqlnd_stmt::attr_set");
- if (!stmt) {
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("stmt=%lu attr_type=%u", stmt->stmt_id, attr_type);
- switch (attr_type) {
- case STMT_ATTR_UPDATE_MAX_LENGTH:{
- zend_uchar bval = *(zend_uchar *) value;
- /*
- XXX : libmysql uses my_bool, but mysqli uses ulong as storage on the stack
- and mysqlnd won't be used out of the scope of PHP -> use ulong.
- */
- stmt->update_max_length = bval? TRUE:FALSE;
- break;
- }
- case STMT_ATTR_CURSOR_TYPE: {
- unsigned int ival = *(unsigned int *) value;
- if (ival > (unsigned long) CURSOR_TYPE_READ_ONLY) {
- SET_STMT_ERROR(stmt, CR_NOT_IMPLEMENTED, UNKNOWN_SQLSTATE, "Not implemented");
- DBG_INF("FAIL");
- DBG_RETURN(FAIL);
- }
- stmt->flags = ival;
- break;
- }
- case STMT_ATTR_PREFETCH_ROWS: {
- unsigned int ival = *(unsigned int *) value;
- if (ival == 0) {
- ival = MYSQLND_DEFAULT_PREFETCH_ROWS;
- } else if (ival > 1) {
- SET_STMT_ERROR(stmt, CR_NOT_IMPLEMENTED, UNKNOWN_SQLSTATE, "Not implemented");
- DBG_INF("FAIL");
- DBG_RETURN(FAIL);
- }
- stmt->prefetch_rows = ival;
- break;
- }
- default:
- SET_STMT_ERROR(stmt, CR_NOT_IMPLEMENTED, UNKNOWN_SQLSTATE, "Not implemented");
- DBG_RETURN(FAIL);
- }
- DBG_INF("PASS");
- DBG_RETURN(PASS);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::attr_get */
- static enum_func_status
- MYSQLND_METHOD(mysqlnd_stmt, attr_get)(const MYSQLND_STMT * const s,
- enum mysqlnd_stmt_attr attr_type,
- void * const value TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- DBG_ENTER("mysqlnd_stmt::attr_set");
- if (!stmt) {
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("stmt=%lu attr_type=%u", stmt->stmt_id, attr_type);
- switch (attr_type) {
- case STMT_ATTR_UPDATE_MAX_LENGTH:
- *(zend_bool *) value= stmt->update_max_length;
- break;
- case STMT_ATTR_CURSOR_TYPE:
- *(unsigned long *) value= stmt->flags;
- break;
- case STMT_ATTR_PREFETCH_ROWS:
- *(unsigned long *) value= stmt->prefetch_rows;
- break;
- default:
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("value=%lu", value);
- DBG_RETURN(PASS);
- }
- /* }}} */
- /* free_result() doesn't actually free stmt->result but only the buffers */
- /* {{{ mysqlnd_stmt::free_result */
- static enum_func_status
- MYSQLND_METHOD(mysqlnd_stmt, free_result)(MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- DBG_ENTER("mysqlnd_stmt::free_result");
- if (!stmt || !stmt->conn) {
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("stmt=%lu", stmt->stmt_id);
- if (!stmt->result) {
- DBG_INF("no result");
- DBG_RETURN(PASS);
- }
- /*
- If right after execute() we have to call the appropriate
- use_result() or store_result() and clean.
- */
- if (stmt->state == MYSQLND_STMT_WAITING_USE_OR_STORE) {
- DBG_INF("fetching result set header");
- /* Do implicit use_result and then flush the result */
- stmt->default_rset_handler = s->m->use_result;
- stmt->default_rset_handler(s TSRMLS_CC);
- }
- if (stmt->state > MYSQLND_STMT_WAITING_USE_OR_STORE) {
- DBG_INF("skipping result");
- /* Flush if anything is left and unbuffered set */
- stmt->result->m.skip_result(stmt->result TSRMLS_CC);
- /*
- Separate the bound variables, which point to the result set, then
- destroy the set.
- */
- mysqlnd_stmt_separate_result_bind(s TSRMLS_CC);
- /* Now we can destroy the result set */
- stmt->result->m.free_result_buffers(stmt->result TSRMLS_CC);
- }
- if (stmt->state > MYSQLND_STMT_PREPARED) {
- /* As the buffers have been freed, we should go back to PREPARED */
- stmt->state = MYSQLND_STMT_PREPARED;
- }
- /* Line is free! */
- CONN_SET_STATE(stmt->conn, CONN_READY);
- DBG_RETURN(PASS);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt_separate_result_bind */
- static void
- mysqlnd_stmt_separate_result_bind(MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- unsigned int i;
- DBG_ENTER("mysqlnd_stmt_separate_result_bind");
- if (!stmt) {
- DBG_VOID_RETURN;
- }
- DBG_INF_FMT("stmt=%lu result_bind=%p field_count=%u", stmt->stmt_id, stmt->result_bind, stmt->field_count);
- if (!stmt->result_bind) {
- DBG_VOID_RETURN;
- }
- /*
- Because only the bound variables can point to our internal buffers, then
- separate or free only them. Free is possible because the user could have
- lost reference.
- */
- for (i = 0; i < stmt->field_count; i++) {
- /* Let's try with no cache */
- if (stmt->result_bind[i].bound == TRUE) {
- DBG_INF_FMT("%u has refcount=%u", i, Z_REFCOUNT_P(stmt->result_bind[i].zv));
- /*
- We have to separate the actual zval value of the bound
- variable from our allocated zvals or we will face double-free
- */
- if (Z_REFCOUNT_P(stmt->result_bind[i].zv) > 1) {
- #ifdef WE_DONT_COPY_IN_BUFFERED_AND_UNBUFFERED_BECAUSEOF_IS_REF
- zval_copy_ctor(stmt->result_bind[i].zv);
- #endif
- zval_ptr_dtor(&stmt->result_bind[i].zv);
- } else {
- /*
- If it is a string, what is pointed will be freed
- later in free_result(). We need to remove the variable to
- which the user has lost reference.
- */
- #ifdef WE_DONT_COPY_IN_BUFFERED_AND_UNBUFFERED_BECAUSEOF_IS_REF
- ZVAL_NULL(stmt->result_bind[i].zv);
- #endif
- zval_ptr_dtor(&stmt->result_bind[i].zv);
- }
- }
- }
- s->m->free_result_bind(s, stmt->result_bind TSRMLS_CC);
- stmt->result_bind = NULL;
- DBG_VOID_RETURN;
- }
- /* }}} */
- /* {{{ mysqlnd_stmt_separate_one_result_bind */
- static void
- mysqlnd_stmt_separate_one_result_bind(MYSQLND_STMT * const s, unsigned int param_no TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- DBG_ENTER("mysqlnd_stmt_separate_one_result_bind");
- if (!stmt) {
- DBG_VOID_RETURN;
- }
- DBG_INF_FMT("stmt=%lu result_bind=%p field_count=%u param_no=%u", stmt->stmt_id, stmt->result_bind, stmt->field_count, param_no);
- if (!stmt->result_bind) {
- DBG_VOID_RETURN;
- }
- /*
- Because only the bound variables can point to our internal buffers, then
- separate or free only them. Free is possible because the user could have
- lost reference.
- */
- /* Let's try with no cache */
- if (stmt->result_bind[param_no].bound == TRUE) {
- DBG_INF_FMT("%u has refcount=%u", param_no, Z_REFCOUNT_P(stmt->result_bind[param_no].zv));
- /*
- We have to separate the actual zval value of the bound
- variable from our allocated zvals or we will face double-free
- */
- if (Z_REFCOUNT_P(stmt->result_bind[param_no].zv) > 1) {
- #ifdef WE_DONT_COPY_IN_BUFFERED_AND_UNBUFFERED_BECAUSEOF_IS_REF
- zval_copy_ctor(stmt->result_bind[param_no].zv);
- #endif
- zval_ptr_dtor(&stmt->result_bind[param_no].zv);
- } else {
- /*
- If it is a string, what is pointed will be freed
- later in free_result(). We need to remove the variable to
- which the user has lost reference.
- */
- #ifdef WE_DONT_COPY_IN_BUFFERED_AND_UNBUFFERED_BECAUSEOF_IS_REF
- ZVAL_NULL(stmt->result_bind[param_no].zv);
- #endif
- zval_ptr_dtor(&stmt->result_bind[param_no].zv);
- }
- }
- DBG_VOID_RETURN;
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::free_stmt_result */
- static void
- MYSQLND_METHOD(mysqlnd_stmt, free_stmt_result)(MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- DBG_ENTER("mysqlnd_stmt::free_stmt_result");
- if (!stmt) {
- DBG_VOID_RETURN;
- }
- /*
- First separate the bound variables, which point to the result set, then
- destroy the set.
- */
- mysqlnd_stmt_separate_result_bind(s TSRMLS_CC);
- /* Not every statement has a result set attached */
- if (stmt->result) {
- stmt->result->m.free_result_internal(stmt->result TSRMLS_CC);
- stmt->result = NULL;
- }
- if (stmt->error_info->error_list) {
- zend_llist_clean(stmt->error_info->error_list);
- mnd_pefree(stmt->error_info->error_list, s->persistent);
- stmt->error_info->error_list = NULL;
- }
- DBG_VOID_RETURN;
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::free_stmt_content */
- static void
- MYSQLND_METHOD(mysqlnd_stmt, free_stmt_content)(MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- DBG_ENTER("mysqlnd_stmt::free_stmt_content");
- if (!stmt) {
- DBG_VOID_RETURN;
- }
- DBG_INF_FMT("stmt=%lu param_bind=%p param_count=%u", stmt->stmt_id, stmt->param_bind, stmt->param_count);
- /* Destroy the input bind */
- if (stmt->param_bind) {
- unsigned int i;
- /*
- Because only the bound variables can point to our internal buffers, then
- separate or free only them. Free is possible because the user could have
- lost reference.
- */
- for (i = 0; i < stmt->param_count; i++) {
- /*
- If bind_one_parameter was used, but not everything was
- bound and nothing was fetched, then some `zv` could be NULL
- */
- if (stmt->param_bind[i].zv) {
- zval_ptr_dtor(&stmt->param_bind[i].zv);
- }
- }
- s->m->free_parameter_bind(s, stmt->param_bind TSRMLS_CC);
- stmt->param_bind = NULL;
- }
- s->m->free_stmt_result(s TSRMLS_CC);
- DBG_VOID_RETURN;
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::net_close */
- static enum_func_status
- MYSQLND_METHOD_PRIVATE(mysqlnd_stmt, net_close)(MYSQLND_STMT * const s, zend_bool implicit TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- MYSQLND_CONN_DATA * conn;
- zend_uchar cmd_buf[STMT_ID_LENGTH /* statement id */];
- enum_mysqlnd_collected_stats statistic = STAT_LAST;
- DBG_ENTER("mysqlnd_stmt::net_close");
- if (!stmt || !stmt->conn) {
- DBG_RETURN(FAIL);
- }
- DBG_INF_FMT("stmt=%lu", stmt->stmt_id);
- conn = stmt->conn;
- SET_EMPTY_ERROR(*stmt->error_info);
- SET_EMPTY_ERROR(*stmt->conn->error_info);
- /*
- If the user decided to close the statement right after execute()
- We have to call the appropriate use_result() or store_result() and
- clean.
- */
- do {
- if (stmt->state == MYSQLND_STMT_WAITING_USE_OR_STORE) {
- DBG_INF("fetching result set header");
- stmt->default_rset_handler(s TSRMLS_CC);
- stmt->state = MYSQLND_STMT_USER_FETCHING;
- }
- /* unbuffered set not fetched to the end ? Clean the line */
- if (stmt->result) {
- DBG_INF("skipping result");
- stmt->result->m.skip_result(stmt->result TSRMLS_CC);
- }
- } while (mysqlnd_stmt_more_results(s) && mysqlnd_stmt_next_result(s) == PASS);
- /*
- After this point we are allowed to free the result set,
- as we have cleaned the line
- */
- if (stmt->stmt_id) {
- MYSQLND_INC_GLOBAL_STATISTIC(implicit == TRUE? STAT_FREE_RESULT_IMPLICIT:
- STAT_FREE_RESULT_EXPLICIT);
- int4store(cmd_buf, stmt->stmt_id);
- if (CONN_GET_STATE(conn) == CONN_READY &&
- FAIL == conn->m->simple_command(conn, COM_STMT_CLOSE, cmd_buf, sizeof(cmd_buf),
- PROT_LAST /* COM_STMT_CLOSE doesn't send an OK packet*/,
- FALSE, TRUE TSRMLS_CC)) {
- COPY_CLIENT_ERROR(*stmt->error_info, *conn->error_info);
- DBG_RETURN(FAIL);
- }
- }
- switch (stmt->execute_count) {
- case 0:
- statistic = STAT_PS_PREPARED_NEVER_EXECUTED;
- break;
- case 1:
- statistic = STAT_PS_PREPARED_ONCE_USED;
- break;
- default:
- break;
- }
- if (statistic != STAT_LAST) {
- MYSQLND_INC_CONN_STATISTIC(conn->stats, statistic);
- }
- if (stmt->execute_cmd_buffer.buffer) {
- mnd_pefree(stmt->execute_cmd_buffer.buffer, stmt->persistent);
- stmt->execute_cmd_buffer.buffer = NULL;
- }
- s->m->free_stmt_content(s TSRMLS_CC);
- if (stmt->conn) {
- stmt->conn->m->free_reference(stmt->conn TSRMLS_CC);
- stmt->conn = NULL;
- }
- DBG_RETURN(PASS);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::dtor */
- static enum_func_status
- MYSQLND_METHOD(mysqlnd_stmt, dtor)(MYSQLND_STMT * const s, zend_bool implicit TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = (s != NULL) ? s->data:NULL;
- enum_func_status ret = FAIL;
- zend_bool persistent = (s != NULL) ? s->persistent : 0;
- DBG_ENTER("mysqlnd_stmt::dtor");
- if (stmt) {
- DBG_INF_FMT("stmt=%p", stmt);
- MYSQLND_INC_GLOBAL_STATISTIC(implicit == TRUE? STAT_STMT_CLOSE_IMPLICIT:
- STAT_STMT_CLOSE_EXPLICIT);
- ret = s->m->net_close(s, implicit TSRMLS_CC);
- mnd_pefree(stmt, persistent);
- }
- mnd_pefree(s, persistent);
- DBG_INF(ret == PASS? "PASS":"FAIL");
- DBG_RETURN(ret);
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::alloc_param_bind */
- static MYSQLND_PARAM_BIND *
- MYSQLND_METHOD(mysqlnd_stmt, alloc_param_bind)(MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- DBG_ENTER("mysqlnd_stmt::alloc_param_bind");
- if (!stmt) {
- DBG_RETURN(NULL);
- }
- DBG_RETURN(mnd_pecalloc(stmt->param_count, sizeof(MYSQLND_PARAM_BIND), stmt->persistent));
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::alloc_result_bind */
- static MYSQLND_RESULT_BIND *
- MYSQLND_METHOD(mysqlnd_stmt, alloc_result_bind)(MYSQLND_STMT * const s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- DBG_ENTER("mysqlnd_stmt::alloc_result_bind");
- if (!stmt) {
- DBG_RETURN(NULL);
- }
- DBG_RETURN(mnd_pecalloc(stmt->field_count, sizeof(MYSQLND_RESULT_BIND), stmt->persistent));
- }
- /* }}} */
- /* {{{ param_bind::free_parameter_bind */
- PHPAPI void
- MYSQLND_METHOD(mysqlnd_stmt, free_parameter_bind)(MYSQLND_STMT * const s, MYSQLND_PARAM_BIND * param_bind TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- if (stmt) {
- mnd_pefree(param_bind, stmt->persistent);
- }
- }
- /* }}} */
- /* {{{ mysqlnd_stmt::free_result_bind */
- PHPAPI void
- MYSQLND_METHOD(mysqlnd_stmt, free_result_bind)(MYSQLND_STMT * const s, MYSQLND_RESULT_BIND * result_bind TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
- if (stmt) {
- mnd_pefree(result_bind, stmt->persistent);
- }
- }
- /* }}} */
- MYSQLND_CLASS_METHODS_START(mysqlnd_stmt)
- MYSQLND_METHOD(mysqlnd_stmt, prepare),
- MYSQLND_METHOD(mysqlnd_stmt, execute),
- MYSQLND_METHOD(mysqlnd_stmt, use_result),
- MYSQLND_METHOD(mysqlnd_stmt, store_result),
- MYSQLND_METHOD(mysqlnd_stmt, get_result),
- MYSQLND_METHOD(mysqlnd_stmt, more_results),
- MYSQLND_METHOD(mysqlnd_stmt, next_result),
- MYSQLND_METHOD(mysqlnd_stmt, free_result),
- MYSQLND_METHOD(mysqlnd_stmt, data_seek),
- MYSQLND_METHOD(mysqlnd_stmt, reset),
- MYSQLND_METHOD_PRIVATE(mysqlnd_stmt, net_close),
- MYSQLND_METHOD(mysqlnd_stmt, dtor),
- MYSQLND_METHOD(mysqlnd_stmt, fetch),
- MYSQLND_METHOD(mysqlnd_stmt, bind_parameters),
- MYSQLND_METHOD(mysqlnd_stmt, bind_one_parameter),
- MYSQLND_METHOD(mysqlnd_stmt, refresh_bind_param),
- MYSQLND_METHOD(mysqlnd_stmt, bind_result),
- MYSQLND_METHOD(mysqlnd_stmt, bind_one_result),
- MYSQLND_METHOD(mysqlnd_stmt, send_long_data),
- MYSQLND_METHOD(mysqlnd_stmt, param_metadata),
- MYSQLND_METHOD(mysqlnd_stmt, result_metadata),
- MYSQLND_METHOD(mysqlnd_stmt, insert_id),
- MYSQLND_METHOD(mysqlnd_stmt, affected_rows),
- MYSQLND_METHOD(mysqlnd_stmt, num_rows),
- MYSQLND_METHOD(mysqlnd_stmt, param_count),
- MYSQLND_METHOD(mysqlnd_stmt, field_count),
- MYSQLND_METHOD(mysqlnd_stmt, warning_count),
- MYSQLND_METHOD(mysqlnd_stmt, errno),
- MYSQLND_METHOD(mysqlnd_stmt, error),
- MYSQLND_METHOD(mysqlnd_stmt, sqlstate),
- MYSQLND_METHOD(mysqlnd_stmt, attr_get),
- MYSQLND_METHOD(mysqlnd_stmt, attr_set),
- MYSQLND_METHOD(mysqlnd_stmt, alloc_param_bind),
- MYSQLND_METHOD(mysqlnd_stmt, alloc_result_bind),
- MYSQLND_METHOD(mysqlnd_stmt, free_parameter_bind),
- MYSQLND_METHOD(mysqlnd_stmt, free_result_bind),
- MYSQLND_METHOD(mysqlnd_stmt, server_status),
- mysqlnd_stmt_execute_generate_request,
- mysqlnd_stmt_execute_parse_response,
- MYSQLND_METHOD(mysqlnd_stmt, free_stmt_content),
- MYSQLND_METHOD(mysqlnd_stmt, flush),
- MYSQLND_METHOD(mysqlnd_stmt, free_stmt_result)
- MYSQLND_CLASS_METHODS_END;
- /* {{{ _mysqlnd_stmt_init */
- MYSQLND_STMT *
- _mysqlnd_stmt_init(MYSQLND_CONN_DATA * const conn TSRMLS_DC)
- {
- MYSQLND_STMT * ret;
- DBG_ENTER("_mysqlnd_stmt_init");
- ret = MYSQLND_CLASS_METHOD_TABLE_NAME(mysqlnd_object_factory).get_prepared_statement(conn TSRMLS_CC);
- DBG_RETURN(ret);
- }
- /* }}} */
- /* {{{ _mysqlnd_init_ps_subsystem */
- void _mysqlnd_init_ps_subsystem()
- {
- mysqlnd_stmt_set_methods(&MYSQLND_CLASS_METHOD_TABLE_NAME(mysqlnd_stmt));
- _mysqlnd_init_ps_fetch_subsystem();
- }
- /* }}} */
- /*
- * Local variables:
- * tab-width: 4
- * c-basic-offset: 4
- * End:
- * vim600: noet sw=4 ts=4 fdm=marker
- * vim<600: noet sw=4 ts=4
- */
|