SQL Search Specifications for EA

[Stefan Bolleininger]

Hi!

i wonder if there are any documentated specifications for the EA SQL-Search?

When is use a Union Search for two tables

"SELECT "isObject", Object_Type, CreatedDate, Status, null, null, null, null, null, null FROM t_object
Union All
SELECT "isTest", null, null, null, Object_Id, Test, TestClass, TestType, `Status`, DateRun FROM t_objecttests"

I get the correct result from my Database but I haven't the right one in my EA Model search.

In my EA-Search all Fields for "isObject" are filled but "isTest'" is completely empty.
By rotating the Search to:

"SELECT "isTest", null, null, null, Object_Id, Test, TestClass, TestType, `Status`, DateRun FROM t_objecttests
Union All
SELECT "isObject", Object_Type, CreatedDate, Status, null, null, null, null, null, null FROM t_object"

my isTest is correct but Object_type and CreatedDate is empty.

What specials for EA-Search do you know?

[Eve]

It sounds like you are running mysql. There is an oddity we've found that unions containing strings will restrict the column length to the length of the first entry.

Try using something like space(50) instead of null.

Of course, you can ignore that suggestion if you're not using mysql.