<p dir="auto"><strong>Migrated issue, originally created by Anonymous</strong></p>
<p dir="auto">In SQLAlchemy 4.0b4, create a model with a Sequence in its column against the Oracle backend.  Create the table, then create an object of the model and save it.  The SQL emitted will not be recognized by Oracle:<br>
sqlalchemy.exceptions.DatabaseError: (DatabaseError) ORA-02289: sequence does not exist<br>
'SELECT "myschema.seq_foobar".nextval FROM DUAL'</p>
<p dir="auto">This error is actually due to the fact that SQLAlchemy added the double-quotes.  Removing them makes Oracle run the same SQL without error:<br>
SELECT myschema.seq_foobar.nextval FROM DUAL;</p>
<p dir="auto">This worked fine in SQLAlchemy 3, which we'll have to keep using for now.</p>
<hr>
<p dir="auto">Attachments: <a href="../wiki/imported_issue_attachments/761/761.diff">761.diff</a></p>
<p dir="auto"><strong>Migrated issue, originally created by rgg (<a href="https://github.com/rgg">@rgg</a>)</strong></p>
<p dir="auto">The recipe "Storing/Using Enumerations", described in <a href="http://techspot.zzzeek.org/2011/01/14/the-enum-recipe/" rel="nofollow">http://techspot.zzzeek.org/2011/01/14/the-enum-recipe/</a> does not function in SQLite using the latest SQLAlchemy version (from the repository).</p>
<p dir="auto">It fails when it tries to create the CHECK constraint associated to the Enum field. The constraint receives the values associated to the enum symbols, but requires the symbols, and it fails when trying to get the values of the symbols.</p>
<p dir="auto">In PostgreSQL (which uses a native ENUM type) the recipe works ok.</p>
<p dir="auto">I suppose it will fail in all databases which don't have a native Enum type, but I have verified the failure only on SQLite.</p>
<p dir="auto">Regards,</p>