Hi, thanks for reaching out.
Using your sample row and header I made a two-row CSV file, mydb_import()-ed it to MyDB, and when I run your test queries (using the datalab command), I get correct behavior in both cases. To be extra sure, when I run
I get '2.20.1'.
I suspect something must have gone wrong in getting your tmp_dr2 table to MyDB. If it's a CSV file that you loaded from, could you please make it available to us for testing? You could place it in your vospace, for instance in a notebook via
from dl import storeClient as sc
(Note that files in vos://public/ are visible to all DL users). If you prefer, you can also email the CSV file (if it's not too big) to firstname.lastname@example.org