Re: [gnome-db] Problem with 2.99.5



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



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]