Solved thread

This post is marked as solved. If you think the information contained on this thread must be part of the official documentation, please contribute submitting a pull request to its repository.

Can't select column started with chars "not"

I'm making a query with querybuilder, like code:

... $this->item->columns([\i3S\i3Builder\Api\Models\Compra::class . '.NotaFiscal as NotaFiscal']) ...

But the query don't run and return the error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Compras.aFiscal' in 'field list'

I tried with columns named as: Notebook, Notacao, Noticia.. and same error, the chars "not" are replaced by nothing.

This occurs with phalcon 4.0.6 and 4.1.0 too



7.8k
Accepted
answer

it is a bug and its been reported many times

https://github.com/phalcon/cphalcon/issues/14918

Quick workaround would be to enclose the field with [] i.e. [not_for_delivery].

This is known bug, unfortunatly it won't be fixed in near patch versions.

As workaround please see my response in your github issue - https://github.com/phalcon/cphalcon/issues/15218#issuecomment-731635482

OK. Thank's for help.