Skip to content

Instantly share code, notes, and snippets.

@jarshwah

jarshwah/branch-oracle.sql

Created January 6, 2015 01:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jarshwah/dac2a587cd1b235748f0 to your computer and use it in GitHub Desktop.
Save jarshwah/dac2a587cd1b235748f0 to your computer and use it in GitHub Desktop.
Download ZIP
Compare queries
Raw
branch-oracle.sql
-- queries.tests.Queries1Tests.test_ticket2496
SELECT * FROM (
SELECT "_SUB".*,
ROWNUM AS "_RN" FROM (SELECT "QUERIES_ITEM"."ID",
"QUERIES_ITEM"."NAME",
"QUERIES_ITEM"."CREATED",
"QUERIES_ITEM"."MODIFIED",
"QUERIES_ITEM"."CREATOR_ID",
"QUERIES_ITEM"."NOTE_ID",
"QUERIES_AUTHOR"."ID",
"QUERIES_AUTHOR"."NAME",
"QUERIES_AUTHOR"."NUM",
"QUERIES_AUTHOR"."EXTRA_ID",
"QUERIES_EXTRAINFO"."ID",
"QUERIES_EXTRAINFO"."INFO",
"QUERIES_EXTRAINFO"."NOTE_ID",
"QUERIES_EXTRAINFO"."VALUE",
"QUERIES_NOTE"."ID",
"QUERIES_NOTE"."NOTE",
"QUERIES_NOTE"."MISC",
T5."ID",
T5."NOTE",
T5."MISC"
FROM "QUERIES_ITEM"
INNER JOIN "QUERIES_AUTHOR" ON ( "QUERIES_ITEM"."CREATOR_ID" = "QUERIES_AUTHOR"."ID" )
INNER JOIN "QUERIES_EXTRAINFO" ON ( "QUERIES_AUTHOR"."EXTRA_ID" = "QUERIES_EXTRAINFO"."ID" )
INNER JOIN "QUERIES_NOTE" ON ( "QUERIES_EXTRAINFO"."NOTE_ID" = "QUERIES_NOTE"."ID" )
INNER JOIN "QUERIES_NOTE" T5 ON ( "QUERIES_ITEM"."NOTE_ID" = T5."ID" )
ORDER BY "QUERIES_ITEM"."NAME" ASC) "_SUB" WHERE ROWNUM <= 1) WHERE "_RN" > 0
Raw
master-oracle.sql
-- queries.tests.Queries1Tests.test_ticket2496
SELECT * FROM (SELECT "_SUB".*,
ROWNUM AS "_RN" FROM (SELECT "QUERIES_ITEM"."ID",
"QUERIES_ITEM"."NAME",
"QUERIES_ITEM"."CREATED",
"QUERIES_ITEM"."MODIFIED",
"QUERIES_ITEM"."CREATOR_ID",
"QUERIES_ITEM"."NOTE_ID",
"QUERIES_AUTHOR"."ID" AS Col6,
"QUERIES_AUTHOR"."NAME" AS Col7,
"QUERIES_AUTHOR"."NUM",
"QUERIES_AUTHOR"."EXTRA_ID",
"QUERIES_EXTRAINFO"."ID" AS Col10,
"QUERIES_EXTRAINFO"."INFO",
"QUERIES_EXTRAINFO"."NOTE_ID" AS Col12,
"QUERIES_EXTRAINFO"."VALUE",
"QUERIES_NOTE"."ID" AS Col14,
"QUERIES_NOTE"."NOTE",
"QUERIES_NOTE"."MISC",
T5."ID" AS Col17,
T5."NOTE" AS Col18,
T5."MISC" AS Col19
FROM "QUERIES_ITEM"
INNER JOIN "QUERIES_AUTHOR" ON ( "QUERIES_ITEM"."CREATOR_ID" = "QUERIES_AUTHOR"."ID" )
INNER JOIN "QUERIES_EXTRAINFO" ON ( "QUERIES_AUTHOR"."EXTRA_ID" = "QUERIES_EXTRAINFO"."ID" )
INNER JOIN "QUERIES_NOTE" ON ( "QUERIES_EXTRAINFO"."NOTE_ID" = "QUERIES_NOTE"."ID" )
INNER JOIN "QUERIES_NOTE" T5 ON ( "QUERIES_ITEM"."NOTE_ID" = T5."ID" )
ORDER BY "QUERIES_ITEM"."NAME" ASC) "_SUB" WHERE ROWNUM <= 1) WHERE "_RN" > 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment