Re: Problem with MAX()

Chris Boget [EMAIL PROTECTED] wrote: What's going on with the MAX() function? Why did it return NULL in the first query above. There were no adding/deleting data between the above queries and yet MySQL didn't pull the MAX from the table until I added the AND assets IS NOT NULL to the

Re: Problem with MAX()

Chris Boget [EMAIL PROTECTED] wrote: We are running v4.0.12. Consider the following: mysql SELECT MAX(assets) as assets - FROM do_deductibles - WHERE currency = 'usd'; ++ | assets | ++ | NULL | ++ 1 row in set (0.00 sec) mysql SELECT MAX(assets) as

Re: Bug with MySQL (was Re: Problem with MAX())

At 16:09 -0500 6/12/03, Chris Boget wrote: CREATE TABLE do_deductibles ( currency varchar(10) NOT NULL default '', assets int(20) NOT NULL default '0', deductible int(10) NOT NULL default '0', do_deductibles_id int(5) NOT NULL auto_increment, PRIMARY KEY (do_deductibles_id),

Problem with MAX()

We are running v4.0.12. Consider the following: mysql SELECT MAX(assets) as assets - FROM do_deductibles - WHERE currency = 'usd'; ++ | assets | ++ | NULL | ++ 1 row in set (0.00 sec) mysql SELECT MAX(assets) as assets - FROM do_deductibles - WHERE

Fw: Minor install problem w/max-4.0.2

Concerning mysql-max-4.0.2-alpha-pc-linux-gnu-i686.tar.gz on SuSE 7.3 If you cd /usr/local and unpack the tarball then create a symlink to mysql, cd into mysql and run ./bin/mysqld.safe the daemon can't locate mysql-max-4.0.2-alpha-pc-linux-gnu-i686/share/mysql/english/errmsg.sys. If you

Re: problem with max

hello in delphi the type for max(date) if tstring. the only problem is there is no CAST in mysql 3.23.49 bye - Original Message - From: Johnny Withers [EMAIL PROTECTED] To: 'Jean Bernard' [EMAIL PROTECTED] Sent: Thursday, April 25, 2002 2:46 PM Subject: RE: problem with max I'm

problem with max

i write a program using MyIsam,and i want uses Innodb. the query: select max(date_comp) as mdate from pieces on MyIsam mdate is a date. on InnoDB mdate is string. win2000 delphi6 zeosdbo it's normal? - Before posting,

Problem with max() on select

I have a database of bids on auctions that I keep separate from the auction information. The problem comes when I attempt to generate a list of auctions with highest bid information. I set the database for bids like this: ANum, varchar(20), the auction number Bidders, int(4), number of

Re: Problem with max() on select

On Friday 17 August 2001 07:13, Jim Lynn wrote: I have a database of bids on auctions that I keep separate from the auction information. The problem comes when I attempt to generate a list of auctions with highest bid information. I set the database for bids like this: ANum, varchar(20),

Re: BDB Problem with MAX() and multipart primary keys

Guenther Pewny writes: Hi folks, I have a problem with BDB tables. Please look at this short mysql session: mysql create table sample ( id1 int(8) not null, id2 int(8) not null, primary key (id1,id2)) type=BDB; Query OK, 0 rows affected (0.67 sec) mysql

Re: BDB Problem with MAX() and multipart primary keys

It's a miracle. Which version of the BDB patch do you use? I'm using 3.2.9a. (Previously, there has been a version 3.2.3g...) Thanks... Gnther Pewny Sinisa Milivojevic wrote: Guenther Pewny writes: Hi folks, I have a problem with BDB tables. Please look at this short mysql session:

Re: BDB Problem with MAX() and multipart primary keys

Guenther Pewny writes: It's a miracle. Which version of the BDB patch do you use? I'm using 3.2.9a. (Previously, there has been a version 3.2.3g...) Thanks... Gnther Pewny Hi! I used latest source tarball from our 3.23 page. Regards, Sinisa __ _

BDB Problem with MAX() and multipart primary keys

Hi folks, I have a problem with BDB tables. Please look at this short mysql session: mysql create table sample ( id1 int(8) not null, id2 int(8) not null, primary key (id1,id2)) type=BDB; Query OK, 0 rows affected (0.67 sec) mysql insert into sample values (1, 2); Query OK, 1