Trim trailing whitespace in *.phpt

Remove trailing whitespace

Explicitly allow NULL values for dblib compatibility

MSSQL won't necessarily default columns to NULL, see:
https://msdn.microsoft.com/en-us/library/ms174979.aspx#Nullability Rules Within

Explicitly allow NULL values for dblib compatibility

MSSQL won't necessarily default columns to NULL, see:
https://msdn.microsoft.com/en-us/library/ms174979.aspx#Nullability Rules Within a Table Definition

show more ...

Fix PDO tests to match SQL standard syntax and pass Firebird tests.

Addendum to #73234: Assume param types are nullable

Fix #73234: Emulated statements let value dictate parameter type

The prepared statement emulator (pdo_sql_parser.*) figures out how to quote
each query parameter. The intended type is sp

Fix #73234: Emulated statements let value dictate parameter type

The prepared statement emulator (pdo_sql_parser.*) figures out how to quote
each query parameter. The intended type is specified by the PDO::PARAM_*
consts, but this direction wasn't always followed. In practice, queries could
work as expected, but subtle errors could result. For example, a numeric string
bound as PDO::PARAM_INT would be sent to a driver's quote function. While these
functions are told which type is expected, they generally assume values are
being quoted as strings. This can result in implicit casts, which are bad for
performance.

This commit includes the following changes:
- Cast values marked as bool/int/null to the appropriate type and bypass the
driver's quote function.
- Save some memory by dropping the temporary zval used for casting.
- Avoid a memory leak if the driver's quote function produces an error.
- Appropriate test suite updates.

show more ...

Add special case for earlier versions of TDS

Explicitly allow NULL values for dblib compatibility

MSSQL won't necessarily default columns to NULL, see:
https://msdn.microsoft.com/en-us/library/ms174979.aspx

- Fixed tests

- Fixed tests

fix test

Fixed bug #40757 (get_object_vars get nothing in child class)
Fixed bug #41929 (Foreach on object does not iterate over all visible properties)

Correct non-standard SQL. Standard SQL would define "DEFAULT NULL" -- but
that is the default value if the DEFAULT clause is omitted anyways.

- MFH change require to require_once

- Add ability to execute .php generated from .phpt on failure without the
need to manually set the environment.

MFH: Make PDO use class constants

some drivers want you to say that its ok to use NULL for these columns.

should always bind columns after execute.
There're probably more of these to fix.

Added:

proto bool PDOStatement::closeCursor()
Closes the cursor, leaving the statement ready for re-execution.

The purpose of the function is to free up the connection to the se

Added:

proto bool PDOStatement::closeCursor()
Closes the cursor, leaving the statement ready for re-execution.

The purpose of the function is to free up the connection to the server so that
other queries may be issued, but leaving the statement in a state that it can
be re-executed.

This is implemented either as an optional driver specific method (allowing for
maximum efficiency), or as the generic PDO fallback if no driver specific
function is installed.

The PDO generic fallback is semantically the same as writing the following code
in your PHP script:

do {
while ($stmt->fetch())
;
if (!$stmt->nextRowset())
break;
} while (true);

show more ...

and as a result, need to update the expected data

we declare the column as NOT NULL, so inserting NULL is not a good idea.

1st set of fixes to make tests work with MySQL

# Additional changes pending

Stop on the 1st skip.

skip if we can't connect (include reason in skip output)

Need to state NOT NULL here, as DB2 won't allow the UNIQUE constraint without it.