libgda r2996 - in trunk: . doc/C libgda libgda/sqlite libgda/sqlite/virtual libsql po tests/queries tools

[vivien svn gnome org]

Author: vivien
Date: 2007-10-24 19:43:47 +0100 (Wed, 24 Oct 2007)
New Revision: 2996
ViewCVS link: http://svn.gnome.org/viewcvs/libgda?rev=2996&view=rev

Removed:
   trunk/libgda/sqlite/sqlite_specs_add_column.xml.in
   trunk/libgda/sqlite/sqlite_specs_create_db.xml.in
   trunk/libgda/sqlite/sqlite_specs_create_index.xml.in
   trunk/libgda/sqlite/sqlite_specs_create_table.xml.in
   trunk/libgda/sqlite/sqlite_specs_drop_db.xml.in
   trunk/libgda/sqlite/sqlite_specs_drop_index.xml.in
   trunk/libgda/sqlite/sqlite_specs_drop_table.xml.in
   trunk/libgda/sqlite/sqlite_specs_dsn.xml.in
   trunk/libgda/sqlite/sqlite_specs_rename_table.xml.in
Modified:
   trunk/ChangeLog
   trunk/doc/C/libgda-3.0-docs.sgml
   trunk/doc/C/libgda-3.0-sections.txt
   trunk/libgda/gda-client.c
   trunk/libgda/gda-connection.c
   trunk/libgda/gda-data-model.c
   trunk/libgda/gda-query-parsing.c
   trunk/libgda/gda-query-private.h
   trunk/libgda/gda-query.c
   trunk/libgda/gda-query.h
   trunk/libgda/sqlite/gda-sqlite-provider.c
   trunk/libgda/sqlite/virtual/gda-vprovider-data-model.c
   trunk/libsql/Makefile.am
   trunk/libsql/lexer.l
   trunk/libsql/mem.c
   trunk/libsql/mem.h
   trunk/libsql/parser.y
   trunk/libsql/sql_display.c
   trunk/libsql/sql_parser.c
   trunk/libsql/sql_parser.h
   trunk/libsql/sql_parser_test.c
   trunk/libsql/sql_tree.c
   trunk/libsql/sql_tree.h
   trunk/po/POTFILES.in
   trunk/tests/queries/basic_sql.xml
   trunk/tests/queries/bug_param_sql.xml
   trunk/tools/Makefile.am
   trunk/tools/command-exec.c
   trunk/tools/gda-sql.c
   trunk/tools/tools-input.c
Log:
2007-10-24  Vivien Malerba <malerba gnome-db org>

	* libsql/* recognize the LIMIT and OFFSET keywords as in "SELECT ... LIMIT 3",
	or "SELECT ... LIMIT 3 OFFSET 4" or, for the MySQL syntax "SELECT ... LIMIT 4,3",
	for bug #488965
	* libsql/*: removed the unused memsql_*() functions in favor of the g_*() similar
	functions (it in fact changes nothing since the MEM_TEST macro was never defined
	and the g_*() functions were always used, but it cleans the code)
	* libgda/gda-query.[ch]: added gda_query_[gs]et_results_limit(), and SQL rendering
	minor improvement
	* libgda/gda-query-parsing.c: take into account the parsed LIMIT/OFFSET
	* testing/queries/basic_sql.xml: new tests with the LIMIT/OFFSET syntax
	* po/POTFILES.in: removed obsolete files
	* libgda/sqlite/*.xml.in: remove those files as they should not be here (they
	already are in providers/sqlite)
	* libgda/gda-client.c: in gda_client_open_connection_from_string(), the connection
	string can be in the "<provider_name>://<real cnc string>" format (such as
	"PostgreSQL://DB_NAME=sales" for example)
	* libgda/sqlite/virtual/gda-vprovider-data-model.c: make gda_server_provider_get_info()
	return "Virtual" as provider name instead of "SQLite"
	* tools/Makefile.am:
	* tools/gda-sql.c: the SQL console can now manage several connections at once (and
	switch between them), and it i spossible to create virtual connections which bind
	together several opened connections to execute some cross connections SQL; HTML
	output mode is now implemented