Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > ORM Profiler Section > Bugs & Issues> Wrong PostgreSQL boolean value format
 

Pages: 1
Bugs & Issues
Wrong PostgreSQL boolean value format
Page:1/1 

  Print all messages in this thread  
Poster Message
Mihies
User



Location:
Nova Gorica, Slovenia
Joined on:
08-Oct-2012 18:35:02
Posted:
20 posts
# Posted on: 25-Mar-2016 13:58:22.  
When copying PostgreSQL sql command to clibpboard the boolean value is wrongly converted to integer instead to True/False.

i.e.
Code:
AND ("LPA_L1"."is_active" = :p2))))


becomes
Code:

AND ("LPA_L1"."is_active" = 1/* :p2 */))))

instead to
Code:
AND ("LPA_L1"."is_active" = true /* :p2 */))))


Update: I'm working with latest LLBLGenPro 5.0 beta framework
Miha Markic [MVP C#, INETA Country Leader for Slovenia, LLBLGenPro Partner, DXSquad, Friend of Red Gate]
Blog:http://blog.rthand.com/
Righthand .net consulting and software development
http://www.rthand.com/
 
Top
Otis
ORM Profiler Team



Location:
The Hague, The Netherlands
Joined on:
22-Aug-2011 10:26:38
Posted:
612 posts
# Posted on: 25-Mar-2016 14:48:03.  
This is by design, as the query needs '1' and '0' to run on the DB, not 'true'/'false'. The copied query therefore has 1 and 0.

Frans Bouma
ORM Profiler / LLBLGen Pro Lead Developer | Blog | Twitter
 
Top
Mihies
User



Location:
Nova Gorica, Slovenia
Joined on:
08-Oct-2012 18:35:02
Posted:
20 posts
# Posted on: 25-Mar-2016 14:53:26.  
Hm, you sure?
I mean I'm trying with pgsqlIII and its sql window requires true/false.
It raises an error with 1/0.
Miha Markic [MVP C#, INETA Country Leader for Slovenia, LLBLGenPro Partner, DXSquad, Friend of Red Gate]
Blog:http://blog.rthand.com/
Righthand .net consulting and software development
http://www.rthand.com/
 
Top
Otis
ORM Profiler Team



Location:
The Hague, The Netherlands
Joined on:
22-Aug-2011 10:26:38
Posted:
612 posts
# Posted on: 25-Mar-2016 14:58:30.  
Mihies wrote:
Hm, you sure?
I mean I'm trying with pgsqlIII and its sql window requires true/false.
It raises an error with 1/0.

hmm... I think you're right. The bool concept is different for each DB, e.g. sql server requires 1/0, not true/false, but no exception is made for postgresql (which didn't have a bool type when orm profiler was first released, if I'm not mistaken. It was never updated as well).



Frans Bouma
ORM Profiler / LLBLGen Pro Lead Developer | Blog | Twitter
 
Top
Otis
ORM Profiler Team



Location:
The Hague, The Netherlands
Joined on:
22-Aug-2011 10:26:38
Posted:
612 posts
# Posted on: 25-Mar-2016 15:03:46.  
It requires an architectural change to fix this Dissapointed Is this really important for you?
Frans Bouma
ORM Profiler / LLBLGen Pro Lead Developer | Blog | Twitter
 
Top
Mihies
User



Location:
Nova Gorica, Slovenia
Joined on:
08-Oct-2012 18:35:02
Posted:
20 posts
# Posted on: 25-Mar-2016 15:07:50.  
Otis wrote:
It requires an architectural change to fix this Dissapointed Is this really important for you?


Since I got Result Set Execute working, not that much. Plus I can test in LINQPad.

It is always nice to have the ability to run the sql in proper editor though (where one can mutilate it Regular Smiley).


Miha Markic [MVP C#, INETA Country Leader for Slovenia, LLBLGenPro Partner, DXSquad, Friend of Red Gate]
Blog:http://blog.rthand.com/
Righthand .net consulting and software development
http://www.rthand.com/
 
Top
Otis
ORM Profiler Team



Location:
The Hague, The Netherlands
Joined on:
22-Aug-2011 10:26:38
Posted:
612 posts
# Posted on: 25-Mar-2016 15:18:13.  
Ok, filed an issue, not sure when it's fixed.

The copy still works of course, you then just have to alter 1 into true, 0 into false... not ideal, but it has to do for now. Glad it's all sorted!
Frans Bouma
ORM Profiler / LLBLGen Pro Lead Developer | Blog | Twitter
 
Top
Mihies
User



Location:
Nova Gorica, Slovenia
Joined on:
08-Oct-2012 18:35:02
Posted:
20 posts
# Posted on: 25-Mar-2016 15:18:59.  
Otis wrote:
Ok, filed an issue, not sure when it's fixed.

The copy still works of course, you then just have to alter 1 into true, 0 into false... not ideal, but it has to do for now. Glad it's all sorted!


Yep Regular Smiley


Miha Markic [MVP C#, INETA Country Leader for Slovenia, LLBLGenPro Partner, DXSquad, Friend of Red Gate]
Blog:http://blog.rthand.com/
Righthand .net consulting and software development
http://www.rthand.com/
 
Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.09082011 Final.