From: Richard W. <haw...@ta...> - 2006-05-30 20:04:36
|
I have a case where asking for a query plan for a prepared select =20 statement returns no data, just a single isc_info_end block. No =20 truncation, no errors, just an empty result block. The request =20 almost always works, but I have a reproducible case where it does =20 not. For the time being I can put a band aid on it and return an =20 empty string (it is just for logging purposes) but I would really =20 like to know what is going on here. Schema: CREATE TABLE "TableauExtract" ( "Customer Name" VARCHAR(21) CHARACTER SET WIN1252 COLLATE = WIN1252, "Delivery Date" TIMESTAMP, "Delivery Time" DOUBLE PRECISION, "Discount" DOUBLE PRECISION, "Gross Profit" DOUBLE PRECISION, "Market Segment" VARCHAR(25) CHARACTER SET WIN1252 COLLATE = WIN1252, "Order Date" TIMESTAMP, "Order ID" DOUBLE PRECISION, "Order Priority" VARCHAR(15) CHARACTER SET WIN1252 COLLATE = WIN1252, "Order_Detail$_Order ID" DOUBLE PRECISION, "Product Category 1" VARCHAR(15) CHARACTER SET WIN1252 COLLATE = WIN1252, "Product Category 2" VARCHAR(30) CHARACTER SET WIN1252 COLLATE = WIN1252, "Product Category 3" VARCHAR(21) CHARACTER SET WIN1252 COLLATE = WIN1252, "Product Category 4" VARCHAR(33) CHARACTER SET WIN1252 COLLATE = WIN1252, "Product Inventory" VARCHAR(12) CHARACTER SET WIN1252 COLLATE = WIN1252, "Record No" DOUBLE PRECISION, "Region" VARCHAR(7) CHARACTER SET WIN1252 COLLATE WIN1252, "Return Status" VARCHAR(8) CHARACTER SET WIN1252 COLLATE = WIN1252, "Sales Total" DOUBLE PRECISION, "Ship Container" VARCHAR(10) CHARACTER SET WIN1252 COLLATE = WIN1252, "Ship Method" VARCHAR(14) CHARACTER SET WIN1252 COLLATE WIN1252 ) CREATE ASC INDEX "_tidx_TableauExtract_2a" ON =20 "TableauExtract" ("Delivery Date") CREATE ASC INDEX "_tidx_TableauExtract_7a" ON =20 "TableauExtract" ("Order Date") CREATE ASC INDEX "_tidx_TableauExtract_1a" ON =20 "TableauExtract" ("Customer Name") CREATE ASC INDEX "_tidx_TableauExtract_12a" ON =20 "TableauExtract" ("Product Category 2") CREATE ASC INDEX "_tidx_TableauExtract_13a" ON =20 "TableauExtract" ("Product Category 3") CREATE ASC INDEX "_tidx_TableauExtract_14a" ON =20 "TableauExtract" ("Product Category 4") Query: SELECT ("TableauExtract"."Order Date") AS "none:Order Date:qk", ("TableauExtract"."Product Category 4") AS "none:Product Category =20 4:nk", ("TableauExtract"."Product Inventory") AS "none:Product =20 Inventory:nk", ("TableauExtract"."Region") AS "none:Region:nk", (SUM("TableauExtract"."Delivery Time")) AS "sum:Delivery Time:qk" FROM "TableauExtract" WHERE (((("TableauExtract"."Product Category 4") >=3D 'Avery 506' AND =20= ("TableauExtract"."Product Category 4") <=3D 'Avery 508') OR =20 (("TableauExtract"."Product Category 4") IN ( '6" Cubicle Wall Clock, =20= Black', 'Acco 3-Hole Punch', 'Acco Hanging Data Binders', 'Acco =20 Keyboard-In-A-Box=AE', 'Acco=AE Hot Clips=99 Clips to Go', 'Assorted =20= Color Push Pins', 'Avery 478', 'Avery 482', 'Avery 495', 'Avery =20 497', 'Avery 500', 'Avery 501', 'Avery 503', 'Avery 517', 'Avery =20= 520', 'Avery Non-Stick Binders', 'Bevis Steel Folding Chairs', =20 'Binder Clips by OIC', 'CF 768', 'Cameo Buff Policy Envelopes', =20 'Cardinal=AE Hold-It CD Pocket', 'Contract Clock, 14", Brown', =20 'Document Clip Frames', 'Economy #2 Pencils', 'Economy Rollaway =20 Files', 'Elite 5" Scissors', 'Ericsson 5125', 'Ericsson 8860', =20 'Executive Impressions 14"', 'Fellowes Binding Cases', 'Fellowes =20 Econo/Stor=AE Drawers', 'Fiskars=AE Softgrip Scissors', 'GBC Linen =20 Binding Covers', 'Holmes HEPA Air Purifier', 'Hon 4060 Series =20 Tables', 'Hon 5100 Series Wood Tables', 'Hon Metal Bookcases, =20 Gray', 'KI Adjustable-Height Table', 'Logitech Access Keyboard', =20 'Logitech Cordless Access Duo', 'Maxell 4.7GB DVD+R 5/Pack', =20 'Microsoft Office Keyboard', 'Motorola SB4200 Cable Modem', 'Newell =20= 309', 'Newell 314', 'Newell 323', 'Newell 328', 'Newell 335', =20 'Newell 350', 'Nokia 252', 'Nokia 768', 'Novimex Fabric Task =20 Chair', 'Novimex Turbo Task Chair', 'Nu-Dell Oak Frame', 'Poly =20 String Tie Envelopes', 'Portable Personal File Box', 'Profile =20 300', 'Rogers=AE Jumbo File, Granite', 'SC-3160', 'Safco Drafting =20 Table', 'Siemens 300 Series Non-Flip', 'Staples 6 Outlet Surge', =20 'StarTAC 6500', 'StarTAC ST7868', 'StarTAC Series', 'Super Bands, =20 12/Pack', 'TDK 4.7GB DVD-R', 'Timeport L7082', 'Ultra Door Pull =20 Handle', 'Verbatim DVD Rewritable Disc', 'Vinyl Sectional Post =20 Binders', 'Wilson Jones Impact Binders', 'Xerox 1884', 'Xerox =20 1891', 'Xerox 1895', 'Xerox 1902', 'Xerox 1911', 'Xerox 1913', =20 'Xerox 1919', 'Xerox 1924', 'Xerox 1935', 'Xerox 1936', 'Xerox =20 1951', 'Xerox 1958', 'Xerox 1959', 'Xerox 1968', 'Xerox 1978', =20 'Xerox 1981', 'Xerox 1982', 'Xerox 1994', 'Xerox 1998', 'Xerox =20 203', 'Xerox 210', 'Xerox 212', 'Xerox 216', 'i50sx', 'iDEN =20 i95')) )) GROUP BY 1, 2, 3, 4 I have the database itself should that be required. TIA, ________________________________________________________ Richard Wesley Software Engineer =20 Tableau Software http://www.tableausoftware.com/ hawkfish =20 tableausoftware com |