 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
[10.0.187 Pro] - Select current statement issues (MySQL) |
|
There are certain dialect-specific structures that make the feature Select or Expand Current Statement go crazy. One of those is the IF [NOT] EXISTS for CREATE TABLE. I'm sorry for the nigh meaningless description and the short example, but I'm in a hurry.
 |
 |
CREATE TEMPORARY TABLE IF NOT EXISTS `hold_my_bear_watch_this`
(
`hi_there` int
,`just_hit` int
,`select_current_statement_hotkey` int
,`after_putting_cursor` int
,`to_this_line_here` int
,`and_watch_me` int
,`selecting_from_if_not_exists` int
,`and_fly_by_that_bracket` int
,`all_the_way_till_the_end` int
,`cause_there_wont_be` int
,`any_closing_brackets` int
);
SELECT
'hey, I''m not even here' AS duh;
SELECT
'haven''t seen anything, really' AS duh2;
|
|
|
Wed Dec 05, 2018 10:23 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
This is very helpful. Thank you I will submit a new defect to have this investigated and fixed.
|
|
Fri Dec 07, 2018 10:31 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
ACtually, I'm not able to reproduce it with 10.1 (I'm running pre-release version). So it might have been fixed already.
Here is my screenshot

|
|
Fri Dec 07, 2018 10:38 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|