From: Masataka S. <pg...@gm...> - 2013-08-07 01:31:52
|
I'm sorry to be late. This is the thing I intended. All right to change other tests like this one. On Wed, Aug 7, 2013 at 8:33 AM, Abbas Butt <abb...@en...> wrote: > Hi, > Please spare some time for this patch, once accepted the same technique > needs to be applied to fix integer, date. time and time-stamp tests. > Thanks. > > > On Tue, Aug 6, 2013 at 8:27 AM, Abbas Butt <abb...@en...> > wrote: >> >> PFA revised patch. >> >> >> On Tue, Aug 6, 2013 at 7:21 AM, Masataka Saito <pg...@gm...> wrote: >>> >>> I meant append a serial column to the tail of tables. >>> Then you need not to modify INSERTs and SELECT targets because they >>> want first column to test. >>> >>> e.g. >>> TestUtil.createTable(con, "testbool", "i serial, a boolean"); >>> -> TestUtil.createTable(con, "testbool", "a boolean, i serial"); >>> >>> stmt.executeUpdate("INSERT INTO testboolstring VALUES('true')"); >>> -> (needless to change) >>> >>> ResultSet rs = con.createStatement().executeQuery("select * from >>> testbool"); >>> -> ResultSet rs = con.createStatement().executeQuery("select * >>> from testbool"); >>> rs.close(); >>> rs = con.createStatement().executeQuery("select * from >>> testbool order by i"); >>> (Of course, you can branch statement like you did.) >>> >>> Regards. >>> >>> On Mon, Aug 5, 2013 at 9:16 PM, Abbas Butt <abb...@en...> >>> wrote: >>> > Please use this patch for review, attached the wrong patch file with >>> > the >>> > previous mail. >>> > >>> > >>> > On Mon, Aug 5, 2013 at 4:59 PM, Abbas Butt >>> > <abb...@en...> >>> > wrote: >>> >> >>> >> Attached please find a revised patch according to your suggestion. >>> >> I am holding the rest of the patches till you review this one, because >>> >> we >>> >> need similar changes for integer, date, time and time-stamp tests. >>> >> >>> >> >>> >> On Mon, Aug 5, 2013 at 12:45 PM, Masataka Saito <pg...@gm...> >>> >> wrote: >>> >>> >>> >>> Hi, >>> >>> >>> >>> I feel feckless for sorting assertins. >>> >>> >>> >>> I propose appending a serial column to test tables and SELECT rows >>> >>> ORDERED BY it. >>> >>> I think this idea makes costless and it doesn't against to the gist >>> >>> of >>> >>> the test. >>> >>> >>> >>> Regards. >>> >>> >>> >>> On Fri, Aug 2, 2013 at 8:47 PM, Abbas Butt >>> >>> <abb...@en...> >>> >>> wrote: >>> >>> > Hi, >>> >>> > PFA patch to fix wrongly written boolean tests, patch comments >>> >>> > explain >>> >>> > the >>> >>> > errors and the fix. >>> >>> > >>> >>> > -- >>> >>> > Abbas >>> >>> > Architect >>> >>> > >>> >>> > Ph: 92.334.5100153 >>> >>> > Skype ID: gabbasb >>> >>> > www.enterprisedb.com >>> >>> > >>> >>> > Follow us on Twitter >>> >>> > @EnterpriseDB >>> >>> > >>> >>> > Visit EnterpriseDB for tutorials, webinars, whitepapers and more >>> >>> > >>> >>> > >>> >>> > >>> >>> > ------------------------------------------------------------------------------ >>> >>> > Get your SQL database under version control now! >>> >>> > Version control is standard for application code, but databases >>> >>> > havent >>> >>> > caught up. So what steps can you take to put your SQL databases >>> >>> > under >>> >>> > version control? Why should you start doing it? Read more to find >>> >>> > out. >>> >>> > >>> >>> > >>> >>> > http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk >>> >>> > _______________________________________________ >>> >>> > Postgres-xc-developers mailing list >>> >>> > Pos...@li... >>> >>> > https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers >>> >>> > >>> >> >>> >> >>> >> >>> >> >>> >> -- >>> >> -- >>> >> Abbas >>> >> Architect >>> >> >>> >> Ph: 92.334.5100153 >>> >> Skype ID: gabbasb >>> >> www.enterprisedb.com >>> >> >>> >> Follow us on Twitter >>> >> @EnterpriseDB >>> >> >>> >> Visit EnterpriseDB for tutorials, webinars, whitepapers and more >>> > >>> > >>> > >>> > >>> > -- >>> > -- >>> > Abbas >>> > Architect >>> > >>> > Ph: 92.334.5100153 >>> > Skype ID: gabbasb >>> > www.enterprisedb.com >>> > >>> > Follow us on Twitter >>> > @EnterpriseDB >>> > >>> > Visit EnterpriseDB for tutorials, webinars, whitepapers and more >> >> >> >> >> -- >> -- >> Abbas >> Architect >> >> Ph: 92.334.5100153 >> Skype ID: gabbasb >> www.enterprisedb.com >> >> Follow us on Twitter >> @EnterpriseDB >> >> Visit EnterpriseDB for tutorials, webinars, whitepapers and more > > > > > -- > -- > Abbas > Architect > > Ph: 92.334.5100153 > Skype ID: gabbasb > www.enterprisedb.com > > Follow us on Twitter > @EnterpriseDB > > Visit EnterpriseDB for tutorials, webinars, whitepapers and more |