01.07.2013 17:14, Pavel Cisar wrote:
>
> Next issues were discovered via FDB test suite. Tested on 64-bit Linux,
> default configuration (i.e. vanila install from tar.gz).
Were connections true local (embedded) or via localhost?
> 1. cursor.rowcount (isc_dsql_sql_info with isc_info_sql_records) returns
> 1 instead expected 6
>
> cur.execute('select * from project')
> self.assertEqual(cur.rowcount,0)
> cur.fetchone()
> self.assertEqual(cur.rowcount,6) <--
Correct for embedded connections (no record prefetch), incorrect for
remote connections (including localhost).
> 2. MON$ATTACHMENTS. Next columns are NULL: MON$REMOTE_PROTOCOL,
> mon$remote_address, mon$remote_pid, mon$remote_process.
MON$REMOTE_PROTOCOL, MON$REMOTE_ADDRESS:
Correct for embedded connections (no network layer involved), incorrect
for remote connections (including localhost).
MON$REMOTE_PID, MON$REMOTE_PROCESS:
Should always be present, unless you had connected via some old
fbclient. To be validated.
> 3. Unexpected RDB$VALID_BLR = True on stored procedure in database
> restored by v3.0
Why is it unexpected?
> 4. Can't get list of users via services API. Returns:
>
> Unable to perform the requested Service API action:
> - SQLCODE: -901
> - unrecognized service parameter block
> - All services except for getting server log require switches'
>
> -901
> 335544562
>
> BTW, Flamerobin fails with the same error on attempt to get list of
> users from server.
>
> 5. Call to isc_service_query with isc_info_svc_running raises error:
>
> Services/isc_service_query:
> - SQLCODE: -901
> - invalid service handle'
>
> -901
> 335544559
>
> Service handle is valid. This call fails ONLY before some actions are
> requested (via isc_service_start),
> for example isc_action_svc_get_ib_log. Once any service is started,
> isc_service_query starts to work properly.
Sounds like a bug.
Dmitry
------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:
Build for Windows Store.
http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
