3 namespace Doctrine\Tests\ORM\Functional\Ticket;
8 class DDC1695Test extends \Doctrine\Tests\OrmFunctionalTestCase
10 public function testIssue()
12 if ($this->_em->getConnection()->getDatabasePlatform()->getName() != "sqlite") {
13 $this->markTestSkipped("Only with sqlite");
15 $dql = "SELECT n.smallText, n.publishDate FROM " . __NAMESPACE__ . "\\DDC1695News n";
16 $sql = $this->_em->createQuery($dql)->getSQL();
19 'SELECT d0_."SmallText" AS SmallText0, d0_."PublishDate" AS PublishDate1 FROM "DDC1695News" d0_',
26 * @Table(name="`DDC1695News`")
32 * @var integer $idNews
34 * @Column(name="`IdNews`", type="integer", nullable=false)
43 * @Column(name="`IdUser`", type="bigint", nullable=false)
48 * @var integer $idLanguage
50 * @Column(name="`IdLanguage`", type="integer", nullable=false)
55 * @var integer $idCondition
57 * @Column(name="`IdCondition`", type="integer", nullable=true)
62 * @var integer $idHealthProvider
64 * @Column(name="`IdHealthProvider`", type="integer", nullable=true)
66 private $idHealthProvider;
69 * @var integer $idSpeciality
71 * @Column(name="`IdSpeciality`", type="integer", nullable=true)
73 private $idSpeciality;
76 * @var integer $idMedicineType
78 * @Column(name="`IdMedicineType`", type="integer", nullable=true)
80 private $idMedicineType;
83 * @var integer $idTreatment
85 * @Column(name="`IdTreatment`", type="integer", nullable=true)
92 * @Column(name="`Title`", type="string", nullable=true)
97 * @var string $smallText
99 * @Column(name="`SmallText`", type="string", nullable=true)
104 * @var string $longText
106 * @Column(name="`LongText`", type="string", nullable=true)
111 * @var datetimetz $publishDate
113 * @Column(name="`PublishDate`", type="datetimetz", nullable=true)
115 private $publishDate;
118 * @var tsvector $idxNews
120 * @Column(name="`IdxNews`", type="tsvector", nullable=true)
125 * @var boolean $highlight
127 * @Column(name="`Highlight`", type="boolean", nullable=false)
132 * @var integer $order
134 * @Column(name="`Order`", type="integer", nullable=false)
139 * @var boolean $deleted
141 * @Column(name="`Deleted`", type="boolean", nullable=false)
146 * @var boolean $active
148 * @Column(name="`Active`", type="boolean", nullable=false)
153 * @var boolean $updateToHighlighted
155 * @Column(name="`UpdateToHighlighted`", type="boolean", nullable=true)
157 private $updateToHighlighted;