Connecting to ... php8.5.12 (interbase) -> OK.

Running tests...

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 SMALLINT	CHARACTER_SET VARCHAR
139	NONE

OK.

Bad query

this one should fail

Warning: ibase_query(): Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 1 this in /etc/webstack/domains/lsces/extras/ibtest.php on line 142
Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 1 this

OK.

Create table

create table PHP_TEST ( x integer, c char(10), v varchar(10) )

Warning: ibase_query(): unsuccessful metadata update CREATE TABLE PHP_TEST failed No permission for CREATE TABLE operation in /etc/webstack/domains/lsces/extras/ibtest.php on line 142
unsuccessful metadata update CREATE TABLE PHP_TEST failed No permission for CREATE TABLE operation

OK.

Add field Y

alter table PHP_TEST add y integer not null

Warning: ibase_query(): unsuccessful metadata update ALTER TABLE PHP_TEST failed SQL error code = -607 Invalid command Table PHP_TEST does not exist in /etc/webstack/domains/lsces/extras/ibtest.php on line 142
unsuccessful metadata update ALTER TABLE PHP_TEST failed SQL error code = -607 Invalid command Table PHP_TEST does not exist

OK.

Insert1

insert into PHP_TEST (x,y) values (1,2)

Warning: ibase_query(): Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST At line 1, column 13 in /etc/webstack/domains/lsces/extras/ibtest.php on line 142
Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST At line 1, column 13

OK.

Select1 (check)

select x+y, x, y from PHP_TEST

Warning: ibase_query(): Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST At line 1, column 23 in /etc/webstack/domains/lsces/extras/ibtest.php on line 142
Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST At line 1, column 23

3, 1,
Warning: Undefined array key 2 in /etc/webstack/domains/lsces/extras/ibtest.php on line 170
2

OK.

Update2 X

update PHP_TEST set x = x + 10

Warning: ibase_query(): Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST At line 1, column 8 in /etc/webstack/domains/lsces/extras/ibtest.php on line 142
Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST At line 1, column 8

OK.

Select2 (check)

select x, y from PHP_TEST

Warning: ibase_query(): Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST At line 1, column 18 in /etc/webstack/domains/lsces/extras/ibtest.php on line 142
Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST At line 1, column 18

11, 2

OK.

Add field Z

alter table PHP_TEST add Z decimal(16,2) default 0 not null

OK.

Update3 Z

update PHP_TEST set z = 1

OK.

Select3 (check)

select z, z+1, z*11, z/12.50 from PHP_TEST

Warning: ibase_query(): Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST At line 1, column 35 in /etc/webstack/domains/lsces/extras/ibtest.php on line 142
Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST At line 1, column 35

1, 2,
Warning: Undefined array key 2 in /etc/webstack/domains/lsces/extras/ibtest.php on line 170
11,
Warning: Undefined array key 3 in /etc/webstack/domains/lsces/extras/ibtest.php on line 170
0.08

OK.

Update4 Z

update PHP_TEST set z = -1

OK.

Select4 (check)

select z, z+1, z*11, z/12.50 from PHP_TEST

-1, 0,
Warning: Undefined array key 2 in /etc/webstack/domains/lsces/extras/ibtest.php on line 170
-11,
Warning: Undefined array key 3 in /etc/webstack/domains/lsces/extras/ibtest.php on line 170
-0.08

OK.

Update5 Z

update PHP_TEST set z = 0.48

OK.

Select5 (check)

select z, z+1, z*11, z/12.50 from PHP_TEST

0.48, 1.48,
Warning: Undefined array key 2 in /etc/webstack/domains/lsces/extras/ibtest.php on line 170
5.28,
Warning: Undefined array key 3 in /etc/webstack/domains/lsces/extras/ibtest.php on line 170
0.0384

OK.

Update6 Z

update PHP_TEST set z = -0.52

OK.

Select6 (check)

select z, z+1, z*11, z/12.50 from PHP_TEST

-0.52, 0.48,
Warning: Undefined array key 2 in /etc/webstack/domains/lsces/extras/ibtest.php on line 170
-5.72,
Warning: Undefined array key 3 in /etc/webstack/domains/lsces/extras/ibtest.php on line 170
-0.0416

OK.

Update7 Z

update PHP_TEST set z = 1.18

OK.

Select7 (check)

select z, z+1, z*11, z/12.50 from PHP_TEST

1.18, 2.18,
Warning: Undefined array key 2 in /etc/webstack/domains/lsces/extras/ibtest.php on line 170
12.98,
Warning: Undefined array key 3 in /etc/webstack/domains/lsces/extras/ibtest.php on line 170
0.0944

OK.

Update8 Z

update PHP_TEST set z = -1.38

OK.

Select8 (check)

select z, z+1, z*11, z/12.50 from PHP_TEST

-1.38, -0.38,
Warning: Undefined array key 2 in /etc/webstack/domains/lsces/extras/ibtest.php on line 170
-15.18,
Warning: Undefined array key 3 in /etc/webstack/domains/lsces/extras/ibtest.php on line 170
-0.1104

OK.

Update C

update PHP_TEST set c = 'PHP test'

OK.

Check char padding

select c from PHP_TEST

Warning: ibase_query(): Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST At line 1, column 15 in /etc/webstack/domains/lsces/extras/ibtest.php on line 142
Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST At line 1, column 15

PHP test

OK.

Update V

update PHP_TEST set v = 'PHP test'

OK.

Check varchar padding

select v from PHP_TEST

PHP test

OK.

Add decimal fields

alter table PHP_TEST add d1 decimal(4,2), add d2 decimal(6,3), add d3 decimal(8,4), add d4 decimal(10,5), add d5 decimal(14,7), add d6 decimal(16,8), add dd double precision, add df float, add df16 decfloat(16), add df34 decfloat(34), add d128 int128

OK.

Update decimals

update PHP_TEST set d1 = 12.52, d2 = 918.812, d3 = 1234.8765, d4 = 54321.06789, d5 = 6543210.1234567, d6 = 87654321.01234567, dd = 1234.5678, df = 1234.56, df16 = 1234567890.1234, df34 = 12345678901234567890123456789, d128 = 12345678901234567890123456789

OK.

Check types1

select d1,d2,d3,dd,df from PHP_TEST

Warning: ibase_query(): Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST At line 1, column 28 in /etc/webstack/domains/lsces/extras/ibtest.php on line 142
Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST At line 1, column 28

12.52, 918.812,
Warning: Undefined array key 2 in /etc/webstack/domains/lsces/extras/ibtest.php on line 170
1234.8765,
Warning: Undefined array key 3 in /etc/webstack/domains/lsces/extras/ibtest.php on line 170
1234.5678,
Warning: Undefined array key 4 in /etc/webstack/domains/lsces/extras/ibtest.php on line 170
1234.56

OK.

Check types2

select d4,d5,d6 from PHP_TEST

Warning: ibase_query(): Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST At line 1, column 22 in /etc/webstack/domains/lsces/extras/ibtest.php on line 142
Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST At line 1, column 22

54321.06789, 6543210.1234567,
Warning: Undefined array key 2 in /etc/webstack/domains/lsces/extras/ibtest.php on line 170
87654321.012346

OK.

Check types3

select df16,df34,d128 from PHP_TEST

1234567890.1234, 12345678901234567890123456789,
Warning: Undefined array key 2 in /etc/webstack/domains/lsces/extras/ibtest.php on line 170
12345678901234567890123456789

OK.

Create SP

create procedure php_test_sp returns ( x integer, c char(10), v varchar(10), d1 decimal(4,2), d2 decimal(6,3), d3 decimal(8,4), d4 decimal(10,5), d5 decimal(14,7), d6 decimal(16,8), dd double precision, df float) as BEGIN for select x, c, v, d1, d2, d3, d4, d5, d6, dd, df from php_test into :x, :c, :v, :d1, :d2, :d3, :d4, :d5, :d6, :dd, :df do suspend; END

Warning: ibase_query(): unsuccessful metadata update CREATE PROCEDURE PHP_TEST_SP failed No permission for CREATE PROCEDURE operation in /etc/webstack/domains/lsces/extras/ibtest.php on line 142
unsuccessful metadata update CREATE PROCEDURE PHP_TEST_SP failed No permission for CREATE PROCEDURE operation

OK.

Select SP1

select c, v, x from php_test_sp

Warning: ibase_query(): Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST_SP At line 1, column 21 in /etc/webstack/domains/lsces/extras/ibtest.php on line 142
Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST_SP At line 1, column 21

PHP test

OK.

Select SP2

select d1,d2,d3,dd,df from php_test_sp

Warning: ibase_query(): Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST_SP At line 1, column 28 in /etc/webstack/domains/lsces/extras/ibtest.php on line 142
Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST_SP At line 1, column 28

12.52, 918.812,
Warning: Undefined array key 2 in /etc/webstack/domains/lsces/extras/ibtest.php on line 170
1234.8765

OK.

Select SP3

select d4, d5, d6 from php_test_sp

Warning: ibase_query(): Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST_SP At line 1, column 24 in /etc/webstack/domains/lsces/extras/ibtest.php on line 142
Dynamic SQL Error SQL error code = -204 Table unknown PHP_TEST_SP At line 1, column 24

54321.06789, 6543210.1234567

OK.

Drop SP

drop procedure PHP_TEST_SP

Warning: ibase_query(): unsuccessful metadata update DROP PROCEDURE PHP_TEST_SP failed Procedure PHP_TEST_SP not found in /etc/webstack/domains/lsces/extras/ibtest.php on line 142
unsuccessful metadata update DROP PROCEDURE PHP_TEST_SP failed Procedure PHP_TEST_SP not found

OK.

Drop Temporary Table - drop table PHP_TEST

Warning: ibase_query(): unsuccessful metadata update DROP TABLE PHP_TEST failed SQL error code = -607 Invalid command Table PHP_TEST does not exist in /etc/webstack/domains/lsces/extras/ibtest.php on line 193

Testing complete.