here's a select. don't run it just look at it and think what it returns:
SELECT 123.654, 123d6, 123e4, '123'e4
ok now run it.
the results are:
|(No column name)
||(No column name)
I lost 2 hours of debugging this little annoying as hell "feature" for 123d6 value.
i mean come on... where is the freakin' logic here???
why not just say error in parsing or something??