Defining a sequence through the fluent API creates wrong SQL syntax
-------------------------------------------------------------------
Key: DNET-874
URL: http://tracker.firebirdsql.org/browse/DNET-874
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework Core
Affects Versions: 6.5.0.0
Environment: Firebird 3.0.4, embedded
Reporter: Tobias Zipfel
Assignee: Jiri Cincura
When using ModelBuilder.HasSequence(string) the resulting SQL syntax executed
when running context.Database.EnsureCreated() leads to a FbException:
Test:
using (var context = new TestContext(connectionString))
{
var test = context.Database.EnsureCreated();
}
In TestContext:
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.HasSequence("HIBERNATE_SEQUENCE");
...
Debug output:
...
dbug: Microsoft.EntityFrameworkCore.Database.Command[20100]
Executing DbCommand [Parameters=[], CommandType='Text',
CommandTimeout='30']
CREATE SEQUENCE "HIBERNATE_SEQUENCE" START WITH 1 INCREMENT BY 1 NO
MINVALUE NO MAXVALUE NO CYCLE;
fail: Microsoft.EntityFrameworkCore.Database.Command[20102]
Failed executing DbCommand (26ms) [Parameters=[], CommandType='Text',
CommandTimeout='30']
CREATE SEQUENCE "HIBERNATE_SEQUENCE" START WITH 1 INCREMENT BY 1 NO
MINVALUE NO MAXVALUE NO CYCLE;
FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 66
NO ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 66
NO
...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
