Status: New Owner: ---- Labels: Version-TRUNK Type-Bug Priority-Medium OpSys-Any Dist-Any Arch-Any Desktop-Any GUI-Any
New issue 579 by [email protected]: Sqlite Conn.Exec failure with a CTE query https://code.google.com/p/gambas/issues/detail?id=579 I have a common table expression (CTE) query that I want to use on an Sqlite3 database. Essentially its goal is to return a result for a hierarchical data table in such a way that all parent items are listed before their children. The same query works properly in the sqlite3 CLI utility but fails when run either in a program using Connection.Exec() or in the IDE database browser. The same query works on a postgresql database in the CLI utility, in a gambas program and in the IDE database browser. I have checked through the sqlite3 website and cannot see any reference to a known error with the API. ____________________________________________________________ 1) Describe the problem. The CTE query in the attached project fails with a DBError code of 1 when issued from a gambas program against an sqlite3 dtabase. 2) Give information about your system. Use the 'System information' menu in the Gambas IDE, and paste the result there. [System] Gambas=3.6.90 OperatingSystem=Linux Kernel=3.12.18-pclos2 Architecture=x86 Distribution=PCLinuxOS Desktop=LXDE Theme=QWindows Language=en_AU.UTF-8 Memory=1008M [Libraries] Cairo=libcairo.so.2.11200.16 Curl=libcurl.so.3.0.0 Curl=libcurl.so.4.3.0 DBus=libdbus-1.so.3.7.8 GStreamer=libgstreamer-0.10.so.0.30.0 GStreamer=libgstreamer-1.0.so.0.403.0 GTK+3=libgtk-3.so.0.1200.2 GTK+=libgtk-x11-2.0.so.0.2400.22 OpenGL=libGL.so.1.2.0 OpenGL=libGL.so.173.14.39 OpenGL=libGL.so.96.43.23 Poppler=libpoppler.so.13.0.0 Poppler=libpoppler.so.19.0.0 Poppler=libpoppler.so.46.0.0 Qt4=libQtCore.so.4.8.5 SDL=libSDL-1.2.so.0.11.4 3) Indicate the Gambas version in the issue labels, and if it is a bug, a crash, or an enhancement request. rev 6652 4) Provide a little project that reproduces the bug or the crash. Attached. 5) If your project needs a database, try to provide it, or part of it. The attached project contains code and scripts to create the necessary database. 6) Explain clearly how to reproduce the bug or the crash. In the attached project are three modules and an sqlite ".READ" script. The postgresql modules are only there to demonstrate that the query works against a postgresql database and can be ignored if you accept that it does work. 1) Create the required "democte" in your home directory as follows: [you@wherever ~]$ sqlite3 democte sqlite> .echo on sqlite> .read <decompressed project path>/demo.sql (This creates the database, creates the "pages" table, loads the sample data, lists it and finally runs the said CTE query.) 2) Ensure that the MSqlite module is the startup class and run it. Attachments: execCTE-0.0.1.tar.gz 5.0 KB -- You received this message because this project is configured to send all issue notifications to this address. You may adjust your notification preferences at: https://code.google.com/hosting/settings ------------------------------------------------------------------------------ Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk _______________________________________________ Gambas-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/gambas-user
