#3919: db.dropcolumn and v.db.dropcolumn do not drop columns -------------------------+-------------------------------------------- Reporter: veroandreo | Owner: grass-dev@… Type: defect | Status: new Priority: normal | Milestone: 7.8.1 Component: Database | Version: git-releasebranch78 Resolution: | Keywords: db.dropcolumn, v.db.dropcolumn CPU: x86-64 | Platform: Linux -------------------------+--------------------------------------------
Comment (by veroandreo): So, I added the print line locally... It seems that the SQL statement is too long indeed. Here is the output: {{{ v.db.dropcolumn map=segs_stats_map column=dem_5m_cba_min_nbrmean DBMI-SQLite driver error: Error in sqlite3_prepare(): incomplete input DBMI-SQLite driver error: Error in sqlite3_prepare(): incomplete input ERROR: Error while executing: 'CREATE TEMPORARY TABLE segs_stats_map_backup (cat INTEGER, IGN_Cba_02m_blue_min DOUBLE PRECISION, IGN_Cba_02m_blue_max DOUBLE PRECISION, IGN_Cba_02m_blue_range DOUBLE PRECISION, IGN_Cba_02m_blue_mean DOUBLE PRECISION, IGN_Cba_02m_blue_stddev DOUBLE PRECISION, IGN_Cba_02m_blue_median DOUBLE PRECISION, IGN_Cba_02m_blue_first_quart DOUBLE PRECISION, IGN_Cba_02m_blue_third_quart DOUBLE PRECISION, IGN_Cba_02m_blue_perc_90 DOUBLE PRECISION, IGN_Cba_02m_green_min DOUBLE PRECISION, IGN_Cba_02m_green_max DOUBLE PRECISION, IGN_Cba_02m_green_range DOUBLE PRECISION, IGN_Cba_02m_green_mean DOUBLE PRECISION, IGN_Cba_02m_green_stddev DOUBLE PRECISION, IGN_Cba_02m_green_median DOUBLE PRECISION, IGN_Cba_02m_green_first_quart DOUBLE PRECISION, IGN_Cba_02m_green_third_quart DOUBLE PRECISION, IGN_Cba_02m_green_perc_90 DOUBLE PRECISION, IGN_Cba_02m_ndvi_min DOUBLE PRECISION, IGN_Cba_02m_ndvi_max DOUBLE PRECISION, IGN_Cba_02m_ndvi_range DOUBLE PRECISION, IGN_Cba_02m_ndvi_mean DOUBLE PRECISION, IGN_Cba_02m_ndvi_stddev DOUBLE PRECISION, IGN_Cba_02m_ndvi_median DOUBLE PRECISION, IGN_Cba_02m_ndvi_first_quart DOUBLE PRECISION, IGN_Cba_02m_ndvi_third_quart DOUBLE PRECISION, IGN_Cba_02m_ndvi_perc_90 DOUBLE PRECISION, IGN_Cba_02m_ndwi_min DOUBLE PRECISION, IGN_Cba_02m_ndwi_max DOUBLE PRECISION, IGN_Cba_02m_ndwi_range DOUBLE PRECISION, IGN_Cba_02m_ndwi_mean DOUBLE PRECISION, IGN_Cba_02m_ndwi_stddev DOUBLE PRECISION, IGN_Cba_02m_ndwi_median DOUBLE PRECISION, IGN_Cba_02m_ndwi_first_quart DOUBLE PRECISION, IGN_Cba_02m_ndwi_third_quart DOUBLE PRECISION, IGN_Cba_02m_ndwi_perc_90 DOUBLE PRECISION, IGN_Cba_02m_nir_min DOUBLE PRECISION, IGN_Cba_02m_nir_max DOUBLE PRECISION, IGN_Cba_02m_nir_range DOUBLE PRECISION, IGN_Cba_02m_nir_mean DOUBLE PRECISION, IGN_Cba_02m_nir_stddev DOUBLE PRECISION, IGN_Cba_02m_nir_median DOUBLE PRECISION, IGN_Cba_02m_nir_first_quart DOUBLE PRECISION, IGN_Cba_02m_nir_third_quart DOUBLE PRECISION, IGN_Cba_02m_nir_perc_90 DOUBLE PRECISION, IGN_Cba_02m_pan_min DOUBLE PRECISION, IGN_Cba_02m_pan_max DOUBLE PRECISION, IGN_Cba_02m_pan_range DOUBLE PRECISION, IGN_Cba_02m_pan_mean DOUBLE PRECISION, IGN_Cba_02m_pan_stddev DOUBLE PRECISION, IGN_Cba_02m_pan_median DOUBLE PRECISION, IGN_Cba_02m_pan_first_quart DOUBLE PRECISION, IGN_Cba_02m_pan_third_quart DOUBLE PRECISION, IGN_Cba_02m_pan_perc_90 DOUBLE PRECISION, IGN_Cba_02m_pan_11_ASM_min DOUBLE PRECISION, IGN_Cba_02m_pan_11_ASM_max DOUBLE PRECISION, IGN_Cba_02m_pan_11_ASM_range DOUBLE PRECISION, IGN_Cba_02m_pan_11_ASM_mean DOUBLE PRECISION, IGN_Cba_02m_pan_11_ASM_stddev DOUBLE PRECISION, IGN_Cba_02m_pan_11_ASM_median DOUBLE PRECISION, IGN_Cba_02m_pan_11_ASM_first_quart DOUBLE PRECISION, IGN_Cba_02m_pan_11_ASM_third_quart DOUBLE PRECISION, IGN_Cba_02m_pan_11_ASM_perc_90 DOUBLE PRECISION, IGN_Cba_02m_pan_11_IDM_min DOUBLE PRECISION, IGN_Cba_02m_pan_11_IDM_max DOUBLE PRECISION, IGN_Cba_02m_pan_11_IDM_range DOUBLE PRECISION, IGN_Cba_02m_pan_11_IDM_mean DOUBLE PRECISION, IGN_Cba_02m_pan_11_IDM_stddev DOUBLE PRECISION, IGN_Cba_02m_pan_11_IDM_median DOUBLE PRECISION, IGN_Cba_02m_pan_11_IDM_first_quart DOUBLE PRECISION, IGN_Cba_02m_pan_11_IDM_third_quart DOUBLE PRECISION, IGN_Cba_02m_pan_11_IDM_perc_90 DOUBLE PRECISION, IGN_Cba_02m_red_min DOUBLE PRECISION, IGN_Cba_02m_red_max DOUBLE PRECISION, IGN_Cba_02m_red_range DOUBLE PRECISION, IGN_Cba_02m_red_mean DOUBLE PRECISION, IGN_Cba_02m_red_stddev DOUBLE PRECISION, IGN_Cba_02m_red_median DOUBLE PRECISION, IGN_Cba_02m_red_first_quart DOUBLE PRECISION, IGN_Cba_02m_red_third_quart DOUBLE PRECISION, IGN_Cba_02m_red_perc_90 DOUBLE PRECISION, IGN_Cba_02m_ssi_min DOUBLE PRECISION, IGN_Cba_02m_ssi_max DOUBLE PRECISION, IGN_Cba_02m_ssi_range DOUBLE PRECISION, IGN_Cba_02m_ssi_mean DOUBLE PRECISION, IGN_Cba_02m_ssi_stddev DOUBLE PRECISION, IGN_Cba_02m_ssi_median DOUBLE PRECISION, IGN_Cba_02m_ssi_first_quart DOUBLE PRECISION, IGN_Cba_02m_ssi_third_quart DOUBLE PRECISION, IGN_Cba_02m_ssi_perc_90 DOUBLE PRECISION, dem_5m_cba_min DOUBLE PRECISION, dem_5m_cba_max DOUBLE PRECISION, dem_5m_cba_range DOUBLE PRECISION, dem_5m_cba_mean DOUBLE PRECISION, dem_5m_cba_stddev DOUBLE PRECISION, dem_5m_cba_median DOUBLE PRECISION, dem_5m_cba_first_quart DOUBLE PRECISION, dem_5m_cba_third_quart DOUBLE PRECISION, dem_5m_cba_perc_90 DOUBLE PRECISION, twi_5m_cba_min DOUBLE PRECISION, twi_5m_cba_max DOUBLE PRECISION, twi_5m_cba_range DOUBLE PRECISION, twi_5m_cba_mean DOUBLE PRECISION, twi_5m_cba_stddev DOUBLE PRECISION, twi_5m_cba_median DOUBLE PRECISION, twi_5m_cba_first_quart DOUBLE PRECISION, twi_5m_cba_third_quart DOUBLE PRECISION, twi_5m_cba_perc_90 DOUBLE PRECISION, neighbors_count DOUBLE PRECISION, IGN_Cba_02m_blue_min_nbrmean DOUBLE PRECISION, IGN_Cba_02m_blue_min_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_blue_max_nbrmean DOUBLE PRECISION, IGN_Cba_02m_blue_max_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_blue_range_nbrmean DOUBLE PRECISION, IGN_Cba_02m_blue_range_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_blue_mean_nbrmean DOUBLE PRECISION, IGN_Cba_02m_blue_mean_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_blue_stddev_nbrmean DOUBLE PRECISION, IGN_Cba_02m_blue_stddev_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_blue_median_nbrmean DOUBLE PRECISION, IGN_Cba_02m_blue_median_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_blue_first_quart_nbrmean DOUBLE PRECISION, IGN_Cba_02m_blue_first_quart_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_blue_third_quart_nbrmean DOUBLE PRECISION, IGN_Cba_02m_blue_third_quart_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_blue_perc_90_nbrmean DOUBLE PRECISION, IGN_Cba_02m_blue_perc_90_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_green_min_nbrmean DOUBLE PRECISION, IGN_Cba_02m_green_min_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_green_max_nbrmean DOUBLE PRECISION, IGN_Cba_02m_green_max_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_green_range_nbrmean DOUBLE PRECISION, IGN_Cba_02m_green_range_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_green_mean_nbrmean DOUBLE PRECISION, IGN_Cba_02m_green_mean_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_green_stddev_nbrmean DOUBLE PRECISION, IGN_Cba_02m_green_stddev_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_green_median_nbrmean DOUBLE PRECISION, IGN_Cba_02m_green_median_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_green_first_quart_nbrmean DOUBLE PRECISION, IGN_Cba_02m_green_first_quart_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_green_third_quart_nbrmean DOUBLE PRECISION, IGN_Cba_02m_green_third_quart_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_green_perc_90_nbrmean DOUBLE PRECISION, IGN_Cba_02m_green_perc_90_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_ndvi_min_nbrmean DOUBLE PRECISION, IGN_Cba_02m_ndvi_min_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_ndvi_max_nbrmean DOUBLE PRECISION, IGN_Cba_02m_ndvi_max_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_ndvi_range_nbrmean DOUBLE PRECISION, IGN_Cba_02m_ndvi_range_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_ndvi_mean_nbrmean DOUBLE PRECISION, IGN_Cba_02m_ndvi_mean_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_ndvi_stddev_nbrmean DOUBLE PRECISION, IGN_Cba_02m_ndvi_stddev_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_ndvi_median_nbrmean DOUBLE PRECISION, IGN_Cba_02m_ndvi_median_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_ndvi_first_quart_nbrmean DOUBLE PRECISION, IGN_Cba_02m_ndvi_first_quart_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_ndvi_third_quart_nbrmean DOUBLE PRECISION, IGN_Cba_02m_ndvi_third_quart_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_ndvi_perc_90_nbrmean DOUBLE PRECISION, IGN_Cba_02m_ndvi_perc_90_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_ndwi_min_nbrmean DOUBLE PRECISION, IGN_Cba_02m_ndwi_min_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_ndwi_max_nbrmean DOUBLE PRECISION, IGN_Cba_02m_ndwi_max_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_ndwi_range_nbrmean DOUBLE PRECISION, IGN_Cba_02m_ndwi_range_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_ndwi_mean_nbrmean DOUBLE PRECISION, IGN_Cba_02m_ndwi_mean_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_ndwi_stddev_nbrmean DOUBLE PRECISION, IGN_Cba_02m_ndwi_stddev_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_ndwi_median_nbrmean DOUBLE PRECISION, IGN_Cba_02m_ndwi_median_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_ndwi_first_quart_nbrmean DOUBLE PRECISION, IGN_Cba_02m_ndwi_first_quart_nbrstddev DOUBLE PRECISION, IGN_Cba_02m_ndwi_third_quart_nbrmean DOUBLE PRECISION, IGN_Cba_02m_ndwi_thi' ERROR: Deleting column failed }}} -- Ticket URL: <https://trac.osgeo.org/grass/ticket/3919#comment:3> GRASS GIS <https://grass.osgeo.org>
_______________________________________________ grass-dev mailing list grass-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-dev