CODEWITHSUNDEEP
kdb+
Terry
Terry

Reputation: 519

Replicating the error when saving down at the end of day

I would like to update the table so it has error message at EOD savedown. The goal is to have different type of data than the assigned type in the same column.

eg.

update col:5i from `t where i = 0

However, i got type error. Any idea how I should update the different type of data to those columns?

Upvotes: 0

Views: 94

Answers (1)

terrylynch
terrylynch

Reputation: 13657

If I understand you correctly, you want to deliberately break the consistency of a uniform type column so that it will fail to splay to disk, in order to test your EOD savedown procedures? If so, you can append or pre-append a row like:

q)t:([]col:1 2j)
q)show t:(update col:5i from select from t where i = 0),t
col
---
5i
1
2

This should then successfully fail to splay :)

Upvotes: 1

Related Questions