My company has decided to give a try to CRDB, after a small amount of time in testing we have decided to deploy a 3 node cluster to support a low traffic api with one database and two tables (~5q/s with peaks @ 100qps caused by certain taks), recently I was committed to execute a dump of the main database 1.6GB when I stumbled upon an error:
Error: pq: internal error: Non-nullable column with no value! Index scanned was “primary” with the index key columns () and the values
This error prevents me to create a dump and is casting a shadow on the process of evaluation for the adoption of this system.
Strange fact is that a full table scan (SELECT * FROM) returns same error, but, SELECT + LIMIT (whatsoever limit, may it be less or more than the actual rows) complete successfully.