InterBaseSQL.EntityFrameworkCore.InterBase issue

[tramesh2009]

Getting this below error in class library project in .Net core
InterBaseSql.Data.InterBaseClient.IBException: 'Dynamic SQL Error
SQL error code = -104
Token unknown - line 2, column 14
AS'
some please help to resole this issue

[ulrich-berkmueller]

Please be so kind and provide more info (e.g. the SQL statement). This is too less for helping you.

[OlivierLePichon]

I may have had the same problem.

My InterBase version do not accept :

• FROM Xxxx AS yy but only FROM Xxxx yy (without AS)
• INNER JOIN Xxxx AS yy but only INNER JOIN Xxxx yy (without AS)

Perhaps a clue.

[jeffovercash]

Sorry, I did not get a chance to get to this in the 7.12.1 release but I have some work to do on EFCore over the next month and might be able to get it out in that. You have just hit a place where there probably is not a unit test to catch a SQL syntax difference between Fb and InterBase.

[jeffovercash]

IB has always supported AS for aliasing table names. This runs fine in IBConsole

select * from employee as e
where e.emp_no > 10

I need more details on this, some sort of example code I can run through a debugger to test.