HUE-1863 [dbquery] Explain query doesn't work correctly

Review Request #4012 — Created Jan. 13, 2014 and submitted

abec
old-hue-rw
HUE-1863
hue
enricoberti, romain
commit 21da0d6b7c683d7fc865b68dd559d3f67492716f
Author: Abraham Elmahrek <abraham@elmahrek.com>
Date:   Mon Jan 13 11:00:23 2014 -0800

    HUE-1863 [dbquery] Explain query doesn't work correctly

:100644 100644 ca10e60... 3ac8e1a... M	apps/rdbms/src/rdbms/api.py
:100644 100644 0210528... be8c3ae... M	desktop/libs/librdbms/src/librdbms/server/rdbms_base_lib.py
manual and test fast. New explain test is very basic since the number of rows explain queries return might change depending on the version of SQLite (not verified). Here is what an explain query returns:

0|Trace|0|0|0||00|
1|Goto|0|10|0||00|
2|OpenRead|0|6|0|2|00|
3|Rewind|0|8|0||00|
4|Rowid|0|1|0||00|
5|Column|0|1|2||00|
6|ResultRow|1|2|0||00|
7|Next|0|4|0||01|
8|Close|0|0|0||00|
9|Halt|0|0|0||00|
10|Transaction|0|0|0||00|
11|VerifyCookie|0|314|0||00|
12|TableLock|0|6|0|auth_group|00|
13|Goto|0|2|0||00|
  • 0
  • 0
  • 0
  • 1
  • 1
Description From Last Updated
romain
  1. We might need a explain of explain for sqlite :)
  2. apps/rdbms/src/rdbms/tests.py (Diff revision 1)
     
     
    could look if row[0][0] is 0 too but this is ok :)
    1. Was thinking of ensuring some of the columns are there (ie opcode)... but as long as we get something.
  3. 
      
abec
Review request changed

Status: Closed (submitted)

Loading...