Only results after update statistics

[m.burkhardt]

Hello, we have a fault behavior with our SQLBASE 11.6 and the same on 12.0.1!
Description:
Offline Database: no Client writes into the database!!!
-> check database -> OK!!
-> Execute a complex select-statement (with joins) -> no results!! (That’s Wrong!!)
-> Execute each table separated! Each result set counted 16 Rows
-> Execute the complex select-statement again -> no results!!
-> UPDATE STATISTICS to only one of the involved table!
-> Execute the complex select-statement again -> 16 Rows!
What can I do!


Thanks in advance

Greetings from Germany
Michael

[EwaldP]

Hi Michael,

I had a similar problem years ago. The problem occurred by joining two tables with columns defined char(120). I converted to char(40) and everything was ok.