Timeline for Why are some numbers converted after load data local infile?
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 19, 2023 at 5:12 | comment | added | Rick James | Can there be negative numbers? How many digits might exist before the decimal place? To follow the letter of the request, you will probably have to use string maniuplation. | |
| Jun 19, 2023 at 3:24 | comment | added | enharmonic | @RickJames I tried reducing the problem to its simplest reproducible form, even though the inputs have some more variety than given. The requirement to truncate was given by the client, in cases where the input values have more than 8 decimal places (some inputs do); I agree that round would be a better choice. The example of 8.04 as input is an actual input value. | |
| Jun 16, 2023 at 21:31 | comment | added | Rick James | Let's see the input value. Do you really need to truncate, not round? Do the input values have more than 8 decimal places? | |
| S Jun 13, 2023 at 15:25 | answer | added | enharmonic | timeline score: 1 | |
| S Jun 13, 2023 at 15:25 | history | asked | enharmonic | CC BY-SA 4.0 |