1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407 |
- #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";
- 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);
- 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;
-
- if (!stmt->field_count) {
- DBG_RETURN(NULL);
- }
- if (stmt->cursor_exists) {
-
- DBG_RETURN(s->m->use_result(s TSRMLS_CC));
- }
-
- 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->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) {
-
- 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) {
-
- if (result->stored_data->row_count * result->meta->field_count * sizeof(zval *) > SIZE_MAX) {
- SET_OOM_ERROR(*conn->error_info);
- DBG_RETURN(NULL);
- }
-
- 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 *)));
- }
-
- set->data_cursor = set->data;
- } else if (result->stored_data->type == MYSQLND_BUFFERED_TYPE_ZVAL) {
-
- }
-
- 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);
- }
- 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;
-
- if (!stmt->field_count) {
- DBG_RETURN(NULL);
- }
- if (stmt->cursor_exists) {
-
- DBG_RETURN(s->m->use_result(s TSRMLS_CC));
- }
-
- 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);
- }
- 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");
-
- DBG_RETURN((stmt && stmt->conn && (stmt->conn->m->get_server_status(stmt->conn TSRMLS_CC) & SERVER_MORE_RESULTS_EXISTS))?
- TRUE:
- FALSE);
- }
- 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);
-
- s->m->free_stmt_result(s TSRMLS_CC);
- {
- enum_func_status ret = s->m->parse_execute_response(s TSRMLS_CC);
- DBG_RETURN(ret);
- }
- }
- static enum_func_status
- mysqlnd_stmt_skip_metadata(MYSQLND_STMT * s TSRMLS_DC)
- {
- MYSQLND_STMT_DATA * stmt = s? s->data:NULL;
-
- 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);
- }
- 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;
- done:
- PACKET_FREE(prepare_resp);
- DBG_RETURN(ret);
- }
- 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);
- }
- 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) {
-
- if (stmt->state == MYSQLND_STMT_WAITING_USE_OR_STORE) {
-
- stmt->default_rset_handler = s->m->use_result;
- stmt->default_rset_handler(s TSRMLS_CC);
- }
-
- if (stmt->state > MYSQLND_STMT_WAITING_USE_OR_STORE && stmt->result) {
- stmt->result->m.skip_result(stmt->result TSRMLS_CC);
- }
-
- 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;
- }
- }
-
- 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;
- }
-
- 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) {
-
- 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);
- }
- 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) {
-
- }
- stmt->state = MYSQLND_STMT_PREPARED;
- stmt->send_types_to_server = 1;
- } else {
-
- SET_EMPTY_ERROR(*stmt->error_info);
- SET_EMPTY_ERROR(*stmt->conn->error_info);
- *stmt->upsert_status = *conn->upsert_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) {
-
- stmt->result->conn = stmt->conn->m->get_reference(stmt->conn TSRMLS_CC);
- }
-
- 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;
-
- 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);
-
- 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");
-
-
- stmt->default_rset_handler = s->m->store_result;
- DBG_INF("store_result");
- } else {
- DBG_INF("no cursor");
-
- 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");
-
- ret = mysqlnd_stmt_execute_parse_response(s TSRMLS_CC);
- }
- #endif
- DBG_INF(ret == PASS? "PASS":"FAIL");
- DBG_RETURN(ret);
- }
- 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) {
-
- #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)
- {
-
- 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);
-
- stmt->result->m.free_result_buffers(stmt->result TSRMLS_CC);
- stmt->state = MYSQLND_STMT_PREPARED;
- } else if (stmt->state < MYSQLND_STMT_PREPARED) {
-
- 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) {
-
- ret = stmt->conn->m->simple_command(stmt->conn, COM_STMT_EXECUTE, request, request_len,
- PROT_LAST ,
- 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);
- }
- 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 (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))
- {
-
- 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++) {
-
- 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++) {
-
- #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
-
- 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) {
-
- 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;
-
- 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) {
-
- }
- DBG_INF("PASS");
- DBG_RETURN(PASS);
- }
- 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) {
-
- 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);
- }
-
- row_packet->skip_extraction = stmt && stmt->result_bind? FALSE: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];
-
- #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;
-
- ZVAL_NULL(data);
- }
- }
- }
- MYSQLND_INC_CONN_STATISTIC(stmt->conn->stats, STAT_ROWS_FETCHED_FROM_CLIENT_PS_UNBUF);
- } else {
- DBG_INF("skipping extraction");
-
- 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;
- } else if (row_packet->eof) {
- DBG_INF("EOF");
-
- 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;
-
- 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);
- }
- 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
- 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 + 4 ];
- 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) {
-
- 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);
- if (FAIL == stmt->conn->m->simple_command(stmt->conn, COM_STMT_FETCH, buf, sizeof(buf),
- PROT_LAST ,
- 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);
- }
-
- for (i = 0; i < field_count; i++) {
- if (stmt->result_bind[i].bound == TRUE) {
- zval *data = result->unbuf->last_row_data[i];
-
- #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;
-
- ZVAL_NULL(data);
- }
- }
- }
- } else {
- DBG_INF("skipping extraction");
-
- row_packet->row_buffer->free_chunk(row_packet->row_buffer TSRMLS_CC);
- row_packet->row_buffer = NULL;
- }
-
- 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);
- }
- 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) {
-
- 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);
-
- if (stmt->result_bind && !stmt->result_zvals_separated_once) {
- unsigned int i;
-
- 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);
- }
- 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 ];
- 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");
-
- 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);
-
- 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);
- }
- 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) {
-
- 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);
- }
- 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);
- }
-
- 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);
-
- 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);
- }
-
- #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);
- }
- 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");
-
- for (i = 0; i < stmt->param_count; i++) {
-
- 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++) {
-
- DBG_INF_FMT("%u is of type %u", i, stmt->param_bind[i].type);
-
-
- 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);
- }
- 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);
- }
- }
-
-
- Z_ADDREF_P(zv);
- DBG_INF("Binding");
-
- if (stmt->param_bind[param_no].zv) {
- zval_ptr_dtor(&stmt->param_bind[param_no].zv);
- }
- if (type == MYSQL_TYPE_LONG_BLOB) {
-
- 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);
- }
- 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);
- }
- 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++) {
-
- 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));
-
- 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);
- }
- 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);
-
- 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);
-
- stmt->result_bind[param_no].bound = TRUE;
- }
- DBG_INF("PASS");
- DBG_RETURN(PASS);
- }
- 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;
- }
- 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;
- }
- 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;
- }
- 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;
- }
- 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;
- }
- 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;
- }
- 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;
- }
- 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;
- }
- 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;
- }
- 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;
- }
- 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;
- }
- 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;
- }
- 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) {
-
- 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);
- }
-
- 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);
- }
- 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;
-
- 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);
- }
- 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);
- }
- 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 (stmt->state == MYSQLND_STMT_WAITING_USE_OR_STORE) {
- DBG_INF("fetching result set header");
-
- 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");
-
- stmt->result->m.skip_result(stmt->result TSRMLS_CC);
-
- mysqlnd_stmt_separate_result_bind(s TSRMLS_CC);
-
- stmt->result->m.free_result_buffers(stmt->result TSRMLS_CC);
- }
- if (stmt->state > MYSQLND_STMT_PREPARED) {
-
- stmt->state = MYSQLND_STMT_PREPARED;
- }
-
- CONN_SET_STATE(stmt->conn, CONN_READY);
- DBG_RETURN(PASS);
- }
- 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;
- }
-
- for (i = 0; i < stmt->field_count; i++) {
-
- if (stmt->result_bind[i].bound == TRUE) {
- DBG_INF_FMT("%u has refcount=%u", i, Z_REFCOUNT_P(stmt->result_bind[i].zv));
-
- 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 {
-
- #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;
- }
- 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;
- }
-
-
- 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));
-
- 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 {
-
- #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;
- }
- 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;
- }
-
- mysqlnd_stmt_separate_result_bind(s TSRMLS_CC);
-
- 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;
- }
- 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);
-
- if (stmt->param_bind) {
- unsigned int i;
-
- for (i = 0; i < stmt->param_count; i++) {
-
- 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;
- }
- 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 ];
- 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);
-
- 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);
-
- 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 ,
- 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);
- }
- 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);
- }
- 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));
- }
- 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));
- }
- 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);
- }
- }
- 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 *
- _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);
- }
- void _mysqlnd_init_ps_subsystem()
- {
- mysqlnd_stmt_set_methods(&MYSQLND_CLASS_METHOD_TABLE_NAME(mysqlnd_stmt));
- _mysqlnd_init_ps_fetch_subsystem();
- }
|