InterBaseSQL.EntityFrameworkCore.InterBase issue

Embarcadero / IB.NETDataProvider

InterBase database .NET Data Provider

Other

12 stars 7 forks source link

InterBaseSQL.EntityFrameworkCore.InterBase issue #6

Open tramesh2009 opened 2 years ago

tramesh2009 commented 2 years ago

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 commented 2 years ago

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

OlivierLePichon commented 2 years ago

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 commented 2 years ago

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 commented 1 year ago

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.