Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

2003-03-02 Thread Tea Yu
> >>The only way I can debug this is if you give me a repeatable test case. > >>Since the test case I showed you does not repeat the bug, you will need > >>to generate a standalone test case, with schema, data, and the java code > >>that demonstrates the issue. > >> > >>-Mark > > > > > > Hey mark,

Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

2003-02-28 Thread Tea Yu
> -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Tea Yu wrote: > > Hi there! > > > > Sorry, cause I didn't copy-n-paste those so there were typos, actually I > > created the table in console: > > > > 1) create table test (id INTEGER NOT NU

Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

2003-02-28 Thread Tea Yu
> This will return the last_insert_id() for each row of the table. > You just select last_insert_id(). > > Tea Yu wrote: > > >Hi! I just tried > >Windows ME + MySQL Server - 4.0.9/4.0.11 + > >ConnectorJ - 3.0.4/3.0.6/3.1.0 > > > >with an InnoDB ta

Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

2003-02-28 Thread Tea Yu
Hi there! > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Tea Yu wrote: > > Hi! I just tried > > Windows ME + MySQL Server - 4.0.9/4.0.11 + > > ConnectorJ - 3.0.4/3.0.6/3.1.0 > > > > with an InnoDB table > > test (id bigint not

Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

2003-02-28 Thread Tea Yu
Hi! I just tried Windows ME + MySQL Server - 4.0.9/4.0.11 + ConnectorJ - 3.0.4/3.0.6/3.1.0 with an InnoDB table test (id bigint not null auto_increment, name varchar(255)) also tried test (id int not null auto_increment, name varchar(255)) and did an SQLQuery thru JDBC insert