search

microsoft / azuredatastudio-mysql

MySQL extension for Azure Data Studio
MIT License
39 stars 9 forks source link

MySql ROW_COUNT() does not correctly reflect the number of rows modified in the previous statement. #248

Open davegoopot opened 3 months ago

davegoopot commented 3 months ago

Type: Bug

  1. Create a table with three rows.
  2. delete from table_name
  3. SELECT ROW_COUNT()

EXPECTED: Row count should show 3 rows modified. ACTUAL: Row count reports 0 rows modified.

Running the same test on the mysql command line give the expected 3 rows modified answer.

Extension version: 1.0.0 Azure Data Studio version: azuredatastudio 1.48.1 (8825ec21e67a34ede00e4f02a4afc692eb6cab61, 2024-06-13T21:07:19.253Z) OS version: Windows_NT x64 10.0.19045 Restricted Mode: No Preview Features: Enabled Modes: