Bugs item #2834654, was opened at 2009-08-10 01:13 Message generated for change (Comment added) made by stmane You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2834654&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: PF/runtime Group: Clients "stable" >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Wouter Alink (vzzzbx) Assigned to: Gabriele Modena (gabriele_modena) Summary: PHP+XQUERY: multiple results not returned correctly Initial Comment: Regarding the use of the XQuery language in the PHP interface: Conforming to the current JDBC behavior (which allows both XQuery and SQL queries): a different row should be returned for each item in a sequence of results. An example: a query like "1 to 4" should return a result with 1 column and 4 rows, containing 1, 2, 3, and 4 respectively. Currently it doesn't seem to do so. See test in pathfinder: tests/clients/Tests/php_monetdb.XQUERY.sh And see example in clients: src/examples/php/xquerysample.php ---------------------------------------------------------------------- >Comment By: Stefan Manegold (stmane) Date: 2009-11-17 00:24 Message: The PHP tests now seems to work fine for both SQL & XQuery: http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-Fedora10/src_test_mapi/php_monetdb.out.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/pathfinder/.mTests103/GNU.64.64.d.1-Fedora10/tests_clients/php_monetdb.out.00.html Exceptions on Gentoo & Windows are probably due to PHP "glitched" on those systems: Fatal error: Call to undefined function socket_create() in /home/monet/testing/monet.GNU.64.64.d.1.13984/clients/.GNU.64.64.d.1-Gentoo2.0.1/share/php/monetdb/php_mapi.inc on line 675 Fatal error: Call to undefined function socket_create() in G:\monet\monet.Int.32.32.d.1.13984\clients\.Int.32.32.d.1-Windows5.1\share\php\monetdb\php_mapi.inc on line 675 cf., http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-Gentoo2.0.1/src_test_mapi/php_monetdb.out.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/pathfinder/.mTests103/Int.32.32.d.1-Windows5.1/tests_clients/php_monetdb.out.00.html CLosing. ---------------------------------------------------------------------- Comment By: Peter Boncz (boncz) Date: 2009-11-12 10:55 Message: Gabriele: what is the status of this bug? ---------------------------------------------------------------------- Comment By: Gabriele Modena (gabriele_modena) Date: 2009-08-17 14:29 Message: I'm having a look at it right now. It should be just a matter of letting the native php diver "speak" M4 protocol correctly and then parse the result of an xquery. ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2009-08-17 11:38 Message: Since we cannot find why this doesn't work, I suggest to fix it differently (by recoding it from scratch ;) ) Gabriele, how about adding support for this to your new driver? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2834654&group_id=56967 ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
