On 2/14/07, Phil Longstaff <plongstaff rogers com> wrote:
>
> I downloaded the 2.99.5 tarball and built and installed it. I'm now having
> problems with it.
>
> OS: SuSE 10.2
> libgda: 2.99.5 built with --prefix= and --enable-debug
>
mysql: 5.0.26
>
> The following section of code:
> {
> GdaQuery* query;
> GdaQueryTarget* target;
> GdaQueryField* allFields;
>
> /* SELECT */
> query = gda_query_new( be->pDict );
> gda_query_set_query_type( query, GDA_QUERY_TYPE_SELECT );
>
> /* FROM */
> target = gda_query_target_new( query, table_name );
> gda_query_add_target( query, target, NULL );
> g_object_unref( G_OBJECT(target)
);
>
> /* all fields */
> allFields = gda_query_field_all_new( query, table_name );
> gda_query_field_set_visible( allFields, TRUE );
> gda_entity_add_field( GDA_ENTITY(query), GDA_ENTITY_FIELD(allFields)
> );
> g_object_unref( G_OBJECT(allFields) );
>
> return query;
> }
>
> followed by:
> {
> GError* error = NULL;
>
> GdaObject* ret;
>
> ret = gda_query_execute( query, NULL, FALSE, &error
);
>
> if( error != NULL ) {
> printf( "SQL error: %s\n", error->message );
> }
>
> return ret;
> }
> now produces this output:
>
> FAMOpen failed, FAMErrno=0
> [;31;1mImplementation missing:
> database_constraints_update_list() in gda-dict-database.c
> line 1214
> [;31;1mImplementation missing:
> database_constraints_update_list() in gda-dict-database.c
> line 1214
> COMMAND> SELECT t1.* FROM lots AS t1 (Provider MySQL on cnx 0x840cb30)
> EVENT> ERROR: You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> 'FROM lots
AS t1' at line 1 (on cnx 0x840cb30)
> SQL error: You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> 'FROM lots AS t1' at line 1
> COMMAND> SELECT t1.* FROM budgets AS t1 (Provider MySQL on cnx 0x840cb30)
> EVENT> ERROR: You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> 'FROM budgets AS t1' at line 1 (on cnx 0x840cb30)
> SQL error: You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> 'FROM budgets AS t1' at line 1
>
> I did not get this behavior with earlier versions of libgda.
Can you please fill a bug report in bugzilla mentionning the
regression from the previous version you used? I'm afraid I don't have
the time
right now to look at it.
Thanks,
Vivien
_______________________________________________
gnome-db-list mailing list
gnome-db-list gnome org
http://mail.gnome.org/mailman/listinfo/gnome-db-list