Issue 188 in dblinq2007: Wrong query for boolean values in oracle
dblin...@googlecode.com
Owner: ----
New issue 188 by kamran.fallah: Wrong query for boolean values in oracle
http://code.google.com/p/dblinq2007/issues/detail?id=188
What steps will reproduce the problem?
1.generate db in oracle, create a table which contain a ISENABLED column of
type NUMBER(1)
2. generate linqToSql using DbMetal (the field type must be boolean)
3.run the following code:
var context= ...;
context.Log = Console.Out;
var query = (from x in context.Items where !x.ISENABLED).ToArray();
What is the expected output? What do you see instead?
The expected output would be the list of items that are not enabled.
you'll receive an OracleException.
What version of the product are you using? On what operating system?
DbLinq 0.19 on XP
Please provide any additional information below.
the generated query is "SELECT * FROM ITEM WHERE NOT ITEM.ISENABLED" which
is correct in MS SQL but not in Oracle as we do not have real boolean type
in Oracle.
the suggestion is to generate query "SELECT * FROM ITEM WHERE
(ITEM.ISENABLED = 0)
--
You received this message because you are listed in the owner
or CC fields of this issue, or because you starred this issue.
You may adjust your issue notification preferences at:
http://code.google.com/hosting/settings
dblin...@googlecode.com
Comment #1 on issue 188 by jonmpryor: Wrong query for boolean values in
oracle
http://code.google.com/p/dblinq2007/issues/detail?id=188
Issue 189 has been merged into this issue.
dblin...@googlecode.com
Labels: Type-Defect Component-Oracle Priority-Low
Comment #2 on issue 188 by jonmpryor: Wrong query for boolean values in
oracle
http://code.google.com/p/dblinq2007/issues/detail?id=188
(No comment was entered for this change.)
dblin...@googlecode.com
Comment #3 on issue 188 by mahadevb...@gmail.com: Wrong query for boolean
Hi,
I am using oracle 11g and I am able to generate using dbml but the DBML
file is empty and in version 10 If I tried to generate getting error as
DbMetal:Sequence contain more than one matching element. Please help me to
resolve the issue.
--
You received this message because this project is configured to send all
issue notifications to this address.
You may adjust your notification preferences at:
https://code.google.com/hosting/settings