|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2010-06-04 10:47 UTC] ovendrell at oip dot jazztel dot es
[2010-08-19 10:10 UTC] kalle@php.net
-Status: Open
+Status: Feedback
[2010-08-19 10:10 UTC] kalle@php.net
[2013-02-18 00:34 UTC] php-bugs at lists dot php dot net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Mon Nov 03 03:00:01 2025 UTC |
Description: ------------ I generate a SQL statement dynamically in PHP script. When I execute this SQL query, the system crash with error "Query Processor Error: The query processor could not produce a query plan". If I execute the same query directly on SQL server, it works. The SQL string is: $sql = "BEGIN TRY BEGIN TRANSACTION DELETE FROM EEES_AprenAssigPE WHERE IdAssig like '200166' AND Curs=2009; INSERT INTO EEES_AprenAssigPE (IdPlaEst, IdAssig, CodiRes, Curs) VALUES ('GEL01', '200166', 'C2', 2009); INSERT INTO EEES_AprenAssigPE (IdPlaEst, IdAssig, CodiRes, Curs) VALUES ('GEL01', '200166', 'E23', 2009); INSERT INTO EEES_AprenAssigPE (IdPlaEst, IdAssig, CodiRes, Curs) VALUES ('GEL01', '200166', 'E23.7', 2009); SELECT 1 AS OK; COMMIT TRANSACTION; END TRY BEGIN CATCH SELECT -1 AS OK; ROLLBACK TRANSACTION; END CATCH";