| Test name |
SQL |
Result |
Expected |
Commit |
| Check database | Select rdb$relation_id as RELATION, rdb$character_set_name as CHARACTER_SET from rdb$database |
RELATION
1 |
CHARACTER_SET
2 |
| 139 |
NONE |
| | OK. |
| Bad query | this one should fail | The Prepare Failed | | OK. |
| Create table | create table PHP_TEST ( x integer, c char(10), v varchar(10) ) | Array
(
[0] => 42000
[1] => -607
[2] => unsuccessful metadata update CREATE TABLE PHP_TEST failed No permission for CREATE TABLE operation
)
Executed OK. No Results | | OK. |
| Add field Y | alter table PHP_TEST add y integer not null | Array
(
[0] => 42S02
[1] => -607
[2] => unsuccessful metadata update ALTER TABLE PHP_TEST failed SQL error code = -607 Invalid command Table PHP_TEST does not exist
)
Executed OK. No Results | | OK. |
| Insert1 | insert into PHP_TEST (x,y) values (1,2) | The Prepare Failed | | OK. |
| Select1 (check) | select x+y, x, y from PHP_TEST | |