Reputation
16,980
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
8 43 71
Newest
 Nice Answer
Impact
~639k people reached

Apr
6
comment Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
@DocBrown I think my last (30 seconds ago) edit does it. Please protect the question from being closed.
Apr
6
revised Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
deleted 356 characters in body
Apr
6
comment Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
I wrote an update to my question about successfully storing the string "TOO MUCH" into a numeric colum. Automatic conversion would insert zero. Also this is the first relational database implementation that I know that would allow that. I've worked with MSSQLServer, Oracle, PostgreSQL, MySQL, MS Acces, DBase, Foxbase, COBOL and Sybase SQL Anywhere.
Apr
6
revised Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
added 295 characters in body
Apr
6
comment Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
@DocBrown I'm not calling it a bug. I'm wondering whether it's made so by design and not as a feature as the FAQs say.
Apr
6
revised Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
added 295 characters in body
Apr
6
comment Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
@DocBrown The official documentation states that if you try to insert a string into a numeric column and it cannot convert it into a number, then it inserts the string without converting it. For example if you try to insert the string "too much" into the numeric SALARY column it will be inserted successfully as it is, no convertion. So I think the issue is not so much about authomatic conversion than about inserting string unconverted data in a numeric column.
Apr
6
revised Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
edited title
Apr
6
comment Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
@DocBrown I'll change the question
Apr
6
comment Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
@DocBrown Not cause I say so but because it's sui generis.
Apr
6
comment Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
@Deduplicator please put that in an answer before they close the question as opinion-based.
Apr
6
comment Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
@Doval please put that in an answer before they close the question as opinion-based.
Apr
6
revised Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
edited title
Apr
6
revised Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
edited title
Apr
6
asked Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
Apr
6
comment What is the difference in memory between a variable assigned to null and one not assigned
Somewhere in your answer is the explanation to this: When you declare a variable without initializing it to null, then initialize it inside a if-then block, the compiler tells you that the variable maybe uninitialized ahead in the code if the then block is not executed. If you initialize it to null the code compiles. Why is that given that " a reference not explicitly assigned a value will have the value null" ? But it's still not clear enough for me. Could you explain it in other words?
Apr
6
comment What is the difference in memory between a variable assigned to null and one not assigned
When you declare a variable without initializing it to null, then initialize it inside a if-then block, the compiler tells you that the variable maybe uninitialized ahead in the code if the then block is not executed. If you initialize it to null the code compiles. Why is that given that " a reference not explicitly assigned a value will have the value null" ?
Mar
25
comment Implementing common logic in base class
"Please write more code, so we have to test more, but never the same thing twice." WTF???
Mar
25
comment Implementing common logic in base class
That way of thinking is sui generis, unprecedented, different and wrong.
Mar
24
comment What kind of programming pattern is appropriate for programming an algorithm with rules and exceptions?
I wrote a version of that game, but in my version the human plays and the program gives feedback. My program doesn't guess.