Doctrine ORM nativeQuery: How to rename table

Question

I'm trying to rename a table with nativeQuery like this:

$rsm = new ResultSetMapping();
$query = $em->createNativeQuery('RENAME TABLE `'.$oldname.'` TO `'.$newname.'`', $rsm);
$result = $query->getResult();

Strangely the table gets renamed, but the last line throws an error:

Undefined offset: 1
.\vendor\doctrine\dbal\src\Driver\PDO\Exception.php:20
.\vendor\doctrine\dbal\src\Driver\PDO\Result.php:107
.\vendor\doctrine\dbal\src\Driver\PDO\Result.php:38
.\vendor\doctrine\dbal\src\Result.php:59

What am I missing?

Blind guess is that you try to handle structure query just like data query which is wrong I would say. — Antoniossss, Apr 11 '22 at 13:35
@Antoniossss: Thanks for the hint. I tried $query->execute() with same result. Is there a method to execute the query in "structure" mode? — Onki Hara, Apr 11 '22 at 13:39

Antoniossss · Accepted Answer · 2022-04-11T13:44:14.987

You try to execute DDL query like it would be a DML SELECT. There will be no result set as an outcome of such operation

assuming that $em is EntityManager do this

$em->getConnection()->executeQuery($yourQuery);

no ResultSetMapping nor other stuff anywhere.

Please be advised that this is not something I have tested myself nor I am active user of the Doctrine. I am convinced as for the cause, not if the snippet is a valid (googled it out)

Doctrine ORM nativeQuery: How to rename table

1 Answers1