Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
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 #596424] Mon, 28 September 2009 12:49 Go to next message
No real name is currently offline 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 #596450 is a reply to message #596424] Wed, 30 September 2009 17:15 Go to previous message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
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.
Previous Topic:Queries returning results containing MySQL DATE columns return no results
Next Topic:Capabilities of DTP
Goto Forum:
  


Current Time: Thu Oct 30 18:16:05 GMT 2014

Powered by FUDForum. Page generated in 0.13467 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software