× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Nishtha Verma
nishtha(*) reported 2013-12-11T09:01:07Z  · SachinPrakash last modified 2017-04-10T03:28:22Z

Wrong result displayed for bit datatype in PostgreSQL


Dev
John LH
JohnLH
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component App - Visual Editing
Version 15.0
Aqua Data Studio 15.0.0-dev-47 
Build #: 35085
Database:PostgreSQL 9.2
 
Steps:
1.Connect to PostgreSQL
2.Goto Database postgres
3.Create a table in 'public' schema
 
   CREATE TABLE "t_bit"  ( 
    "c1" bit(3) NOT NULL 
   )
   GO
 
4.Insert values in table "t_bit"
 
   INSERT INTO "public"."t_bit"("c1") 
   VALUES('101')
   GO
 
   INSERT INTO "public"."t_bit"("c1") 
   VALUES('111')
   GO
 
   INSERT INTO "public"."t_bit"("c1") 
   VALUES('110')
   GO
 
 
5.Now execute select query for table "t_bit"
 
   SELECT * FROM "public"."t_bit"
   GO
 
6.Result displayed is not binary string which we have inserted.
  Result displayed as :
  false
  false
  false
 
 
But when we perform above steps in pgAdmin III native Tool result is same binary string which we have inserted through insert command.
1 attachment
  •  
  •  
  • No shares
  •  
All Comments (1) Change History
Sort 

Issue #11011
Closed
Fixed
Resolved 2014-06-26T12:43:48Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017