mirror of
https://github.com/php/php-src.git
synced 2026-03-26 01:02:25 +01:00
30 lines
899 B
PHP
30 lines
899 B
PHP
--TEST--
|
|
PDO SQLite Feature Request #42589 (getColumnMeta() should also return table name)
|
|
--EXTENSIONS--
|
|
pdo
|
|
pdo_sqlite
|
|
--SKIPIF--
|
|
<?php
|
|
$db = new PDO("sqlite::memory:");
|
|
$options = $db->query('PRAGMA compile_options')->fetchAll(PDO::FETCH_COLUMN);
|
|
if(!in_array('ENABLE_COLUMN_METADATA', $options, true))
|
|
die("skip sqlite3 must be compiled with SQLITE_ENABLE_COLUMN_METADATA");
|
|
?>
|
|
--FILE--
|
|
<?php
|
|
$db = new PDO("sqlite::memory:");
|
|
|
|
$db->exec('CREATE TABLE test_42589 (field1 VARCHAR(10))');
|
|
$db->exec('INSERT INTO test_42589 VALUES("test")');
|
|
|
|
$result = $db->query('SELECT * FROM test_42589 t1 LEFT JOIN test_42589 t2 ON t1.field1 = t2.field1');
|
|
$meta1 = $result->getColumnMeta(0);
|
|
$meta2 = $result->getColumnMeta(1);
|
|
|
|
var_dump(!empty($meta1['table']) && $meta1['table'] == 'test_42589');
|
|
var_dump(!empty($meta2['table']) && $meta2['table'] == 'test_42589');
|
|
?>
|
|
--EXPECT--
|
|
bool(true)
|
|
bool(true)
|