SQL error when casting to double
--------------------------------
Key: DNET-342
URL: http://tracker.firebirdsql.org/browse/DNET-342
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework support
Reporter: Daniel Richter
Assignee: Jiri Cincura
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.
--
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
------------------------------------------------------------------------------
This SF.net email is sponsored by
Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
