Annotation of embedaddon/php/ext/pdo_sqlite/tests/bug_42589.phpt, revision 1.1
1.1 ! misho 1: --TEST--
! 2: PDO SQLite Feature Request #42589 (getColumnMeta() should also return table name)
! 3: --SKIPIF--
! 4: <?php
! 5: if (!extension_loaded('pdo') || !extension_loaded('pdo_sqlite')) die('skip not loaded');
! 6: ?>
! 7: --FILE--
! 8: <?php
! 9: $db = new PDO("sqlite::memory:");
! 10:
! 11: $db->exec('CREATE TABLE test (field1 VARCHAR(10))');
! 12: $db->exec('INSERT INTO test VALUES("test")');
! 13:
! 14: $result = $db->query('SELECT * FROM test t1 LEFT JOIN test t2 ON t1.field1 = t2.field1');
! 15: $meta1 = $result->getColumnMeta(0);
! 16: $meta2 = $result->getColumnMeta(1);
! 17:
! 18: var_dump(!empty($meta1['table']) && $meta1['table'] == 'test');
! 19: var_dump(!empty($meta2['table']) && $meta2['table'] == 'test');
! 20: ?>
! 21: --EXPECTF--
! 22: bool(true)
! 23: bool(true)
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>