New 3.6 feature does not honor formatting options

• 
  Another small item I found is that a sort of 'rare' SELECT INTO query isn't recognized:
  
  SELECT tx_id
  INTO #test3
  FROM edic_charges
  
  UNION ALL
  
  SELECT tx_id FROM edic_details;
  
  SELECT * FROM #test3 WHERE #test3.<cursor>
  
  After you hit the . it doesn't bring up any suggestions. If you take the UNION ALL part out it works OK. I don't know how many people use UNION <ALL> as part of a SELECT .. INTO statement, but I suspect not many, so it probably isn't a big deal.

  MikeyC September 17, 2007 16:46

  - 0 +
• 
  Thanks for this. There's always something that slips through. As you've no doubt guessed, the first item is of much greater concern to us than the second. The frustrating thing is that I fixed it this afternoon in less than 10 minutes, however because we've just switched to a new branch, it's not been integrated into our build system it's just sitting on my office desktop at the moment.
  
  Our plan is to see if anything else comes up over the next week, fix any major problems, of which we hope there won't be many, and then get a patch out within the next 4 weeks or so. This first problem is really very irritating, but things do occasionally slip through despite our best efforts. Sorry for any inconvenience.
  
  
  Thanks,
  Bart

  Bart Read September 17, 2007 17:55

  - 0 +
• 
  Another temp table related problem... Given these statements:
  
  SELECT
  CAST(NULL AS NUMERIC(16,0)) AS tdl_id,
  tx_id,
  post_date,
  plan_id,
  c.payor_id
  INTO #DetailsForCredit
  FROM edic_details n
  LEFT JOIN Edic.dbo.COVERAGE c
  ON n.CUR_CVG_ID=c.COVERAGE_ID;
  
  SELECT * FROM #DetailsForCredit
  WHERE #DetailsForCredit.<cursor>
  
  Once you have typed the . right before <cursor> the suggestion box pops up with what you would expect, but does not include the payor_id field. It appears that by using the "c." alias in front of the field name that the field gets excluded from the suggestions.

  MikeyC September 17, 2007 18:36

  - 0 +
• 
  It looks like 3.8.0.244 doesn't fix two of the issues I reported:
  
  SELECT
  CAST(NULL AS NUMERIC(16,0)) AS tdl_id,
  tx_id,
  post_date,
  plan_id,
  c.payor_id
  INTO #DetailsForCredit
  FROM edic_details n
  LEFT JOIN Edic.dbo.COVERAGE c
  ON n.CUR_CVG_ID=c.COVERAGE_ID;
  
  SELECT * FROM #DetailsForCredit
  WHERE #DetailsForCredit.<cursor>
  
  Once you have typed the . right before <cursor> the suggestion box pops up with what you would expect, but does not include the payor_id field. It appears that by using the "c." alias in front of the field name that the field gets excluded from the suggestions.
  

  ---

  
  SELECT tx_id
  INTO #test3
  FROM edic_charges
  
  UNION ALL
  
  SELECT tx_id FROM edic_details;
  
  SELECT * FROM #test3 WHERE #test3.<cursor>
  
  After you hit the . it doesn't bring up any suggestions. If you take the UNION ALL part out it works OK. I don't know how many people use UNION <ALL> as part of a SELECT .. INTO statement, but I suspect not many, so it probably isn't a big deal.
  
  Michael

  MikeyC April 23, 2008 13:57

  - 0 +

Add comment

Please sign in to leave a comment.