When the XML file embeds the table structure, $analyses is null and buildSql() falls back to is_numeric() to decide whether to quote. That strips quotes from values like "01234", which silently drops the leading zero on a varchar column and causes a duplicate-key error if the table also contains "1234". Add a roundtrip check: a value is still treated as numeric only when casting it to int or float gives back the original string. "01234", "1e10" and similar fail the roundtrip and stay quoted; plain integers like 1 and 1234 keep their existing unquoted form. Signed-off-by: Eyüp Can Akman <eyupcanakman@gmail.com> |
||
|---|---|---|
| .. | ||
| routes | ||
| __slashes.mediawiki | ||
| config.inc.php | ||
| db_import.sql | ||
| db_test_ldi.csv | ||
| db_test.csv | ||
| db_test.ods | ||
| dresden_osm.shp.zip | ||
| exploit_test.sql | ||
| import-slim.ods.xml | ||
| phpmyadmin_importXML_For_Testing.xml | ||
| phpmyadmin_importXML_GIS_For_Testing.xml | ||
| phpmyadmin_importXML_No_Database_For_Testing.xml | ||
| phpmyadmin_importXML_Numeric_String_For_Testing.xml | ||
| phpmyadmin.mediawiki | ||
| pma_bookmark.sql | ||
| server_import.sql | ||
| table_import.sql | ||
| test.bz2 | ||
| test.file | ||
| test.gz | ||
| test.zip | ||
| timezone.shp.zip | ||