Description: ------------ When I use createTable() with a lower case table name ('test2' in my case) and call then tableInfo() with this lower case table name, the result is: Warning: ibase_query(): Dynamic SQL Error SQL error code = -204 Table unknown TEST2 At line 1, column 21. in E:\htdocs\pear\PEAR\MDB2\Driver\ibase.php on line 491 string(165) [Last query: SELECT * FROM test2 WHERE 1=0] [Native code: -204] [Native message: Dynamic SQL Error SQL error code = -204 Table unknown TEST2 At line 1, column 21. ] Altough one can see 'TEST2' twice in upper case letters in the quotation, the query uses 'test2'.

Strange: Setting $result to upper case before doing the query results in the same error, although the table definitely exists and the query 'SELECT * FROM TEST2 WHERE 1=0' works as expected when executed in a tool like IBExpert (works also with lower case name). Auto commit is active (default), so this should actually not be the problem.

are you creating the table and then checking it in *the same* script? If so, I experience the same issue, but I don't have the slightest idea on why it happens. Try doing an explicit $db->exec('COMMIT') query before the call to tableInfo(). Does PEAR::DB have the same behaviour?

> are you creating the table and then checking it in *the > same* script? If so, I experience the same issue, but I > don't have the slightest idea on why it happens. Yes, same script. > Try doing an explicit $db->exec('COMMIT') query before > the call to tableInfo(). That works. The table is found. > Does PEAR::DB have the same behaviour? No, with DB it works (without the explicit COMMIT). Very strange.

should be fixed. Can you check the latest CVS version, I've committed a workaround for this issue.

Thanks, the new CVS version works as expected.