Hi!
On Dec 1, 2008, at 4:44 AM, Jim Starkey wrote:
And, by the way, LOAD DATA doesn't check for nulls on fields
declared as non null. The dbt2 data is crap, of course, so my load
app had to work around this. Should drizzle be bug for bug
compatible with MySQL on this?
Drizzle tosses an error in such cases. We never accept a NULL into a
NOT NULL field.
'Twere I doing drizzle, I'd drop the LOAD DATA INFILE as a lipstick-
less pig, put in an analog to addBatch/executeBatch, put in a client
library a) parse separator delimited files (and maybe others, like
the native black hole storage format), an a load utility using the
library and extended API.
The only part the above does not answer is "should the database know
how to load files". For a remote execution I agree with you, for a
local... we shall see.
Cheers,
-Brian
--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/ <-- Me
http://tangent.org/ <-- Software
_______________________________________________________
You can't grep a dead tree.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
