Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SQL error when casting to double [DNET342] #351

Closed
firebird-automations opened this issue Aug 17, 2010 · 3 comments
Closed

SQL error when casting to double [DNET342] #351

firebird-automations opened this issue Aug 17, 2010 · 3 comments
Assignees
@cincuranet
Labels
component: entity framework fix-version: 2.6 priority: major resolution: fixed/done type: bug

Comments

@firebird-automations
Copy link

Submitted by: Daniel Richter (danielrichter)

Casting a column/value to double produces an SQL error.

E.g. the C#⁠ code
".Where(entity => entity.Value < 200.0)" (Value is System.Double)"
is translated to SQL
"WHERE Entity.Value < CAST (200 AS DOUBLE)"

(My) Firebird only accepts "DOUBLE PRECISION" instead of "DOUBLE"

After changing SqlGenerator.cs, ISqlFragment Visit(DbConstantExpression e), line 811, from "DOUBLE" to "DOUBLE PRECISION" it works.

Commits: 17bc4c0
@firebird-automations
Copy link
Author

Commented by: @cincuranet

And also line 3321. Fixed, thanks.

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5.3 [ 10380 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

Fix Version: 2.6 [ 10371 ]

Fix Version: 2.5.3 [ 10380 ] =>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@cincuranet cincuranet

Labels
component: entity framework fix-version: 2.6 priority: major resolution: fixed/done type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@cincuranet @firebird-automations