Hi On Thu, May 11, 2017 at 6:38 AM, Khushboo Vashi < [email protected]> wrote:
> Hi, > > As we have been facing many issues with different data-type display in > Query Tool output, Dave suggested to write the feature test for the same. > > I have started with some basic set of data-type values and will add more. > Please find the attached initial patch for the same. > Some thoughts: - Instead of sleeping, which is almost always a bad design, can we wait for objects to appear? - Currently you're testing each datatype with an individual query, e.g. SELECT 32768; I would suggest we test all datatypes at once, e.g. SELECT 32768, 43723489023489, '2017-09-12 15:34:11', 12345.56; etc. That will massively reduce the time taken to execute the tests (which is a big concern). - Shouldn't we be casting the values in the SELECT, so we (and the database) know exactly what we're expecting? e.g. SELECT 32768::int, 43723489023489::bigint, '2017-09-12 15:34:11':timestamp, 12345.56::numeric(8,4); That would also allow us to verify the type name displayed in the column headers. Thanks! -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
