This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 144918 - [65cat][db]Run Selection wont work
Summary: [65cat][db]Run Selection wont work
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: All Windows XP
: P3 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-08-23 11:07 UTC by alcmontejo
Modified: 2008-09-12 06:03 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description alcmontejo 2008-08-23 11:07:06 UTC
hi!
 
on this dev build 200808221401, try to highlight mySql statement and use "Run Selection" 
function it doest work for me.
 
Thanks and more power,
Allen Montejo
Comment 1 David Vancouvering 2008-08-25 19:35:13 UTC
That is odd.  I just tried this in my trunk and it works for me.  I'll try the latest nightly build...
Comment 2 David Vancouvering 2008-08-25 19:43:55 UTC
This works for me using the latest nightly build (0824).  

*But* I have to highlight the full statements.  For example, using the Sakila sample, I have three statements in my SQL
editor:

select * from actor;
select * from address;
select * from category;

If I highlight the first two statements *completely* it work great.

If I highlight just part of each statement, then it says it's executing, but there is no output results.

I'm not sure what's expected here.   

I'm reassigning this to the SQL editor subcomponent - Andrei, your comments appreciated.
Comment 3 alcmontejo 2008-08-26 01:38:50 UTC
hi!

I got it now. the sql cannot recognized the script when it is not ended by the delimiter ";" even if we are going 
to highlight the script that we wanted to execute.

example:

select * from hotel /*this will return recordset*/

but if we add another script and if we are just going to highlight the "select * from hotel" and execute
it returns no rows and "Execution finished after 0 s, 0 error(s) occurred."

select * from hotel
select * from flight

Thanks and more power,
Allen Montejo
Comment 4 alcmontejo 2008-08-26 05:15:29 UTC
so in this case the highlighter wont work. its dependent on the delimiter ";". is supposed to return something
error or recordset what do u think?

Thanks,
Allen Montejo
Comment 5 Andrei Badea 2008-09-10 17:02:31 UTC
#b4ed064086d4
Comment 6 Roman Mostyka 2008-09-11 17:50:19 UTC
Verified with build 080910.
Comment 7 Quality Engineering 2008-09-12 06:03:45 UTC
Integrated into 'main-golden', will be available in build *200809120201* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main/rev/b4ed064086d4
User: Andrei Badea <abadea@netbeans.org>
Log: #144918: [65cat][db]Run Selection wont work