Connecting to ... php8.5.9 (pdo_firebird) -> 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 1	CHARACTER_SET 2
179	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) )

Executed OK. No Results

OK.

Add field Y

alter table PHP_TEST add y integer not null

Executed OK. No Results

OK.

Insert1

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

Executed OK. No Results

OK.

Select1 (check)

select x+y, x, y from PHP_TEST

ADD 1	X 1	Y 1
3	1	2

3, 1, 2

OK.

Update2 X

update PHP_TEST set x = x + 10

Executed OK. No Results

OK.

Select2 (check)

select x, y from PHP_TEST

X 1	Y 1
11	2

11, 2

OK.

Add field Z

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

Executed OK. No Results

OK.

Update3 Z

update PHP_TEST set z = 1

Executed OK. No Results

OK.

Select3 (check)

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

Z 2	ADD 2	MULTIPLY 2	DIVIDE 2
1.00	2.00	11.00	0.0800

1, 2, 11, 0.08

OK.

Update4 Z

update PHP_TEST set z = -1

Executed OK. No Results

OK.

Select4 (check)

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

Z 2	ADD 2	MULTIPLY 2	DIVIDE 2
-1.00	0.00	-11.00	-0.0800

-1, 0, -11, -0.08

OK.

Update5 Z

update PHP_TEST set z = 0.48

Executed OK. No Results

OK.

Select5 (check)

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

Z 2	ADD 2	MULTIPLY 2	DIVIDE 2
0.48	1.48	5.28	0.0384

0.48, 1.48, 5.28, 0.0384

OK.

Update6 Z

update PHP_TEST set z = -0.52

Executed OK. No Results

OK.

Select6 (check)

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

Z 2	ADD 2	MULTIPLY 2	DIVIDE 2
-0.52	0.48	-5.72	-0.0416

-0.52, 0.48, -5.72, -0.0416

OK.

Update7 Z

update PHP_TEST set z = 1.18

Executed OK. No Results

OK.

Select7 (check)

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

Z 2	ADD 2	MULTIPLY 2	DIVIDE 2
1.18	2.18	12.98	0.0944

1.18, 2.18, 12.98, 0.0944

OK.

Update8 Z

update PHP_TEST set z = -1.38

Executed OK. No Results

OK.

Select8 (check)

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

Z 2	ADD 2	MULTIPLY 2	DIVIDE 2
-1.38	-0.38	-15.18	-0.1104

-1.38, -0.38, -15.18, -0.1104

OK.

Update C

update PHP_TEST set c = 'PHP test'

Executed OK. No Results

OK.

Check char padding

select c from PHP_TEST

C
2

PHP test

OK.

Update V

update PHP_TEST set v = 'PHP test'

Executed OK. No Results

OK.

Check varchar padding

select v from PHP_TEST

V
2

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

Executed OK. No Results

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

Executed OK. No Results

OK.

Check types1

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

D1 2	D2 2	D3 2	DD 2	DF 2
12.52	918.812	1234.8765	1234.5678	1234.5601

12.52, 918.812, 1234.8765, 1234.5678, 1234.56

OK.

Check types2

select d4,d5,d6 from PHP_TEST

D4 2	D5 2	D6 2
54321.06789	6543210.1234567	87654321.01234567

54321.06789, 6543210.1234567, 87654321.012346

OK.

Check types3

select df16,df34,d128 from PHP_TEST

DF16 2	DF34 2	D128 2
1234567890.1234	12345678901234567890123456789	12345678901234567890123456789

1234567890.1234, 12345678901234567890123456789, 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

Executed OK. No Results

OK.

Select SP1

select c, v, x from php_test_sp

C 2	V 2	X 1
PHP test	PHP test	11

PHP test

OK.

Select SP2

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

D1 2	D2 2	D3 2	DD 2	DF 2
12.52	918.812	1234.8765	1234.5678	1234.5601

12.52, 918.812, 1234.8765

OK.

Select SP3

select d4, d5, d6 from php_test_sp

D4 2	D5 2	D6 2
54321.06789	6543210.1234567	87654321.01234567

54321.06789, 6543210.1234567

OK.

Drop SP

drop procedure PHP_TEST_SP

Executed OK. No Results

OK.

Drop Temporary Table - drop table PHP_TEST
Temporary Table Deleted

Connecting to ... php8.5.9 (pdo_firebird) -> OK.

Running tests...

Testing complete.