Re: [gnome-db] Problem with 2.99.5

["Vivien Malerba" <vmalerba gmail com>]

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