Skip to main content
To homepage To homepage
Solved

Why are history system fields BigInt?

sierd.zuiderveld
Contributor
Forum|alt.badge.img+1

I am curious why system fields like SCD is Current & SCD is TombStone are datatype bigint. 

 

Is there a way to change them to tinyint? As far as I know they can only be 0 or 1. 

Best answer by rory.smith

Hi @sierd.zuiderveld ,

 

I have suggested using a smaller int type to TimeXtender in the past; tinyint has the drawback that it does not support negative numbers making calculations based on that field a bit more tricky. It would be nice to have a choice to make it a bit smaller anyhow.

View original
Did this topic help you find an answer to your question?

2 replies

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • rory.smith
  • TimeXtender Xpert
  • 686 replies
  • Answer
  • April 6, 2023

Hi @sierd.zuiderveld ,

 

I have suggested using a smaller int type to TimeXtender in the past; tinyint has the drawback that it does not support negative numbers making calculations based on that field a bit more tricky. It would be nice to have a choice to make it a bit smaller anyhow.

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @sierd.zuiderveld currently this is not possible. Please see the idea Rory posted here, and feel free to upvote

https://support.timextender.com/ideas/change-types-of-scd-is-current-and-scd-is-tombstone-to-smaller-types-307

 

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings