Connecting to ... php8.5.9 (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
178	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) )

Executed Ok. No resultset.

OK.

Add field Y

alter table PHP_TEST add y integer not null

Executed Ok. No resultset.

OK.

Insert1

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

Executed Ok. No resultset.

OK.

Select1 (check)

select x+y, x, y from PHP_TEST

ADD BIGINT	X INTEGER	Y INTEGER
3	1	2

3, 1, 2

OK.

Update2 X

update PHP_TEST set x = x + 10

Executed Ok. No resultset.

OK.

Select2 (check)

select x, y from PHP_TEST

X INTEGER	Y INTEGER
11	2

11, 2

OK.

Add field Z

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

Executed Ok. No resultset.

OK.

Update3 Z

update PHP_TEST set z = 1

Executed Ok. No resultset.

OK.

Select3 (check)

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

Z NUMERIC(18,2)	ADD NUMERIC(18,2)	MULTIPLY VARCHAR	DIVIDE VARCHAR
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 resultset.

OK.

Select4 (check)

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

Z NUMERIC(18,2)	ADD NUMERIC(18,2)	MULTIPLY VARCHAR	DIVIDE VARCHAR
-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 resultset.

OK.

Select5 (check)

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

Z NUMERIC(18,2)	ADD NUMERIC(18,2)	MULTIPLY VARCHAR	DIVIDE VARCHAR
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 resultset.

OK.

Select6 (check)

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

Z NUMERIC(18,2)	ADD NUMERIC(18,2)	MULTIPLY VARCHAR	DIVIDE VARCHAR
-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 resultset.

OK.

Select7 (check)

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

Z NUMERIC(18,2)	ADD NUMERIC(18,2)	MULTIPLY VARCHAR	DIVIDE VARCHAR
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 resultset.

OK.

Select8 (check)

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

Z NUMERIC(18,2)	ADD NUMERIC(18,2)	MULTIPLY VARCHAR	DIVIDE VARCHAR
-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 resultset.

OK.

Check char padding

select c from PHP_TEST

C
VARCHAR

PHP test

OK.

Update V

update PHP_TEST set v = 'PHP test'

Executed Ok. No resultset.

OK.

Check varchar padding

select v from PHP_TEST

V
VARCHAR

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 resultset.

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 resultset.

OK.

Check types1

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

D1 NUMERIC(9,2)	D2 NUMERIC(9,3)	D3 NUMERIC(9,4)	DD DOUBLE PRECISION	DF FLOAT
12.52	918.812	1234.8765	1234.5678	1234.5600585938

12.52, 918.812, 1234.8765, 1234.5678, 1234.56

OK.

Check types2

select d4,d5,d6 from PHP_TEST

D4 NUMERIC(18,5)	D5 NUMERIC(18,7)	D6 NUMERIC(18,8)
54321.06789	6543210.1234567	87654321.01234567

54321.06789, 6543210.1234567, 87654321.012346

OK.

Check types3

select df16,df34,d128 from PHP_TEST

DF16 VARCHAR	DF34 VARCHAR	D128 VARCHAR
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 resultset.

OK.

Select SP1

select c, v, x from php_test_sp

C VARCHAR	V VARCHAR	X INTEGER
PHP test	PHP test	11

PHP test

OK.

Select SP2

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

D1 NUMERIC(9,2)	D2 NUMERIC(9,3)	D3 NUMERIC(9,4)	DD DOUBLE PRECISION	DF FLOAT
12.52	918.812	1234.8765	1234.5678	1234.5600585938

12.52, 918.812, 1234.8765

OK.

Select SP3

select d4, d5, d6 from php_test_sp

D4 NUMERIC(18,5)	D5 NUMERIC(18,7)	D6 NUMERIC(18,8)
54321.06789	6543210.1234567	87654321.01234567

54321.06789, 6543210.1234567

OK.

Drop SP

drop procedure PHP_TEST_SP

Executed Ok. No resultset.

OK.

Drop Temporary Table - drop table PHP_TEST
Temporary Table Deleted

Testing complete.