Teradata 16.20 might return wrong Query Results

Roland Wenzlofsky

December 6, 2018

minutes reading time


This is just a short warning when you are upgrading to Teradata 16.20.

We recently upgraded from Teradata 15.10 to 16.20 and detected that some of our reporting queries returned with each execution a different result set. Sometimes the result set was correct, sometimes wrong.

After analyzing it a little bit, I discovered that it’s related to Incremental Planning and Execution (IPE). It seems that something can go wrong with the execution plan when this feature is active. I will further investigate and update you if I can find out more about this issue. There may already be a patch available. Any input is appreciated.

Since I turned this feature off, the result set is always correct (I am adding the below query band as a pre-SQL to each Microstrategy report until this issue is fixed):

SET QUERY_BAND = ‘DynamicPlan=OFF;’ FOR SESSION;

This information might be useful for some of you experiencing this problem.

  • Avatar
    Roland Wenzlofsky says:

    The Problem was fixed with an update.

  • Hey Guys,

    Thanks for the update, can you provide a test case that demonstrates this wrong result?

    We are on 16.10 right now and are soon upgrading to 16.20

  • Avatar
    Shardul Kumar says:

    We still dont have TD 16.20, still working on TD 15.10. But good to know this and thank you Roland!

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    You might also like

    >