Aqua Data Studio 15.0.0-dev-57
Build #: 35326
Built on: 2013-Dec-23 01:24:49 PM
DB2 - iSeries 7.1
1.Create Schema "deepti"
2. Create Tables
CREATE TABLE "deepti"."character_DT" (
"col_char" CHAR(25),
"col_char_varying" VARCHAR(25),
"col_character" CHAR(25),
"col_character_varying" VARCHAR(25),
"col_long_varchar" LONG VARCHAR,
"col_varchar" VARCHAR(25)
)
GO
CREATE TABLE "deepti"."datetime_DT" (
"col_date" DATE,
"col_time" TIME,
"col_timestamp" TIMESTAMP
)
GO
3. Follow below instructions to reproduce Bug:
Go to Schema Browser
Expand DB2iseries node
Expand Schemas node
Expand deepti Schema
Expand Tables node
Select Character_DT Table
Right click on it
Select Query Builder option
(Press Insert key from Keyboard if Add Table window is not opened)
In Add Table window select Schema: deepti
Select Tables "character_DT" and "datetime_DT"
Click on Add and Close button
Click on Execute icon on Query Builder window's Toolbar
Actual Result: DB2iseries supports SQL joins. And Query Builder generated below SQL query:
(see attached screenshot:crossjoin.png )
select
*
from
"deepti"."character_DT" "character_DT",
"deepti"."datetime_DT" "datetime_DT"
Expected Result: Query Builder should generate below SQL query to produce default cross join:
(see attached screenshot:crossjoin.png)
select
*
from
"deepti"."character_DT" "character_DT" cross join
"deepti"."datetime_DT" "datetime_DT"
Lets add support for this in the new query builder