Home » Eclipse Projects » DTP » Queries returning results containing MySQL DATE columns return no results
Queries returning results containing MySQL DATE columns return no results [message #488366] |
Mon, 28 September 2009 12:49 |
No real name Messages: 2 Registered: September 2009 |
Junior Member |
|
|
I have a table called candidates with the following DDL
CREATE TABLE candidates (
ID INTEGER UNSIGNED NOT NULL,
Candidate_Type_ID INTEGER UNSIGNED,
Current_Employer VARCHAR(45),
Current_employer_hide BIT,
current_employer_start DATE,
years_with_cur_employer INTEGER UNSIGNED,
profession_position_id INTEGER UNSIGNED,
DoB DATE DEFAULT '0000-00-00' NOT NULL,
Qualifications VARCHAR(45),
Memberships TEXT,
Awards TEXT,
Languages TEXT,
User_ID INTEGER UNSIGNED DEFAULT 0 NOT NULL,
reward_rate INTEGER UNSIGNED DEFAULT 50 NOT NULL,
personalstatement TEXT,
profession_id INTEGER UNSIGNED NOT NULL,
universities TEXT NOT NULL,
industry_id INTEGER UNSIGNED NOT NULL,
industry_text VARCHAR(255),
status_id INTEGER UNSIGNED DEFAULT 1 NOT NULL,
profession_position VARCHAR(255),
modified DATETIME
) ENGINE=InnoDB;
The statement
SELECT candidates.industry_text FROM candidates
will return 24 records.
The statement
SELECT candidates.industry_text, candidates.current_employer.start_date FROM candidates
fails.
Any statement that selects a DATE column fails. Statements selecting DATETIME columns succeed.
Both queries succeed and return results using other tools.
|
|
|
Re: Queries returning results containing MySQL DATE columns return no results [message #488918 is a reply to message #488366] |
Wed, 30 September 2009 17:15 |
Brian Fitzpatrick Messages: 500 Registered: July 2009 |
Senior Member |
|
|
Please create a bugzilla for this in Datatools and we can look into it.
--Fitz
eclipse_bugs@wyrdbyrd.demon.co.uk wrote:
> I have a table called candidates with the following DDL
>
> CREATE TABLE candidates (
> ID INTEGER UNSIGNED NOT NULL,
> Candidate_Type_ID INTEGER UNSIGNED,
> Current_Employer VARCHAR(45),
> Current_employer_hide BIT,
> current_employer_start DATE,
> years_with_cur_employer INTEGER UNSIGNED,
> profession_position_id INTEGER UNSIGNED,
> DoB DATE DEFAULT '0000-00-00' NOT NULL,
> Qualifications VARCHAR(45),
> Memberships TEXT,
> Awards TEXT,
> Languages TEXT,
> User_ID INTEGER UNSIGNED DEFAULT 0 NOT NULL,
> reward_rate INTEGER UNSIGNED DEFAULT 50 NOT NULL,
> personalstatement TEXT,
> profession_id INTEGER UNSIGNED NOT NULL,
> universities TEXT NOT NULL,
> industry_id INTEGER UNSIGNED NOT NULL,
> industry_text VARCHAR(255),
> status_id INTEGER UNSIGNED DEFAULT 1 NOT NULL,
> profession_position VARCHAR(255),
> modified DATETIME
> ) ENGINE=InnoDB;
>
> The statement
> SELECT candidates.industry_text FROM candidates
>
> will return 24 records.
>
> The statement
>
> SELECT candidates.industry_text, candidates.current_employer.start_date
> FROM candidates
>
> fails.
>
> Any statement that selects a DATE column fails. Statements selecting
> DATETIME columns succeed.
>
> Both queries succeed and return results using other tools.
|
|
|
Goto Forum:
Current Time: Thu Sep 26 02:09:08 GMT 2024
Powered by FUDForum. Page generated in 0.02896 seconds
|