AutoIt v3.3.11.3 Beta

[mLipok]

Please think about or do not recognize this change

 

3.3.10.0 (23rd December, 2013) (Release)

- Changed: VT_NULL VARIANT converts to Null keyword (previously empty string).

 

as a "script-breaking changes"

 

---

In my case, it has just been, and still is. 

Especially if you are working on data from MS SQL database. 

 

 

Early enough to use this kind of code:

...
If $value <> '' Then ....
...

Now I need to change many parts of my scripts to something like this:

...
If $value <> '' And $value <> Null Then ....
...

[trancexx]

If the change is due to bug-fixing then the change can't be script breaking. Did AutoIt's documentation ever suggested conversion from COM variant NULL to internal empty string happens? No.

Old behavior was classified as bug and fixed accordingly when new type was added.

[mLipok]

After your explanations, it should be noted that I had some bad habits, and EDIT: life has verified them  @trancexx verified them

 

Thanks for the clarification 

 

Regards 

mLipok

Edited February 19, 2014 by mLipok

[water]

If the return value was changed from "" to NULL then it would be enough to check for NULL. No need to check for "" any longer.

If $value <> Null Then ....

I noticed this "problem" for my AD UDF. But it was quite easy to change

[mLipok]

Not always. 

For example, in SQL by using 'INNER JOIN', if the table does not have an attached data, the value is NULL, but if the data exists but are empty, then the value is an empty string.

[jchd]

mLipok,

Are you sure you mean INNER join and not OUTER join?  Which engine does behave like this and can you PM me a short reproducer?

[Nologic]

Okay this hasn't anything to do with the current Beta, just something I noticed when looking at whether or not to convert from >_FileListToArrayXT to _FileListToArrayRec.

I found in my testing that _FileListToArrayXT was still noticably faster.

Tests where performed on network mapped 7200rpm drives, results reported are after drives are awake & spun up.

Non recursive search on 2,529 files:

_FileListToArrayXT

- 190ms

_FileListToArrayRec

- 268ms

Recursive search on 19,773 files & 954 Folders:

_FileListToArrayXT

- 3.0-3.1 seconds

_FileListToArrayRec

- 3.4-3.5 seconds

Don't get me wrong both are bloody fast...but maybe there is something to be learned from _FileListToArrayXT that could help speed up _FileListToArrayRec.

Anyways food for thought.

Non Recursive Code:

#include <File.au3>
#include <_FileListToArrayXT.au3>

$cExtensionsC  = '*.3gp;*.avi;*.avs;*.divx;*.f4v;*.flv;*.m2ts;*.m4v;*.mkv;*.mp3;*.mp4;*.mpg;*.ogg;*.ogm;*.ts;*.vob'
$sFolderPath = 'V:\Movies\'

$hTimer1 = TimerInit()

_FileListToArrayXT( $sFolderPath , $cExtensionsC , 1 , 2 , False , '' , 1 )

$iDiff1 = TimerDiff( $hTimer1 ) 


$hTimer2 = TimerInit()

_FileListToArrayRec( $sFolderPath , $cExtensionsC , 0 , 1 , 0 , 2 )

$iDiff2 = TimerDiff( $hTimer2 ) 

MsgBox( 0 , '' , '_FileListToArrayXT:' & @LF & $iDiff1 & @LF & @LF & '_FileListToArrayRec:' & @LF & $iDiff2 )

Recursive Code:

#include <File.au3>
#include <_FileListToArrayXT.au3>

$cExtensionsC  = '*.3gp;*.avi;*.avs;*.divx;*.f4v;*.flv;*.m2ts;*.m4v;*.mkv;*.mp3;*.mp4;*.mpg;*.ogg;*.ogm;*.ts;*.vob'
$sFolderPath = 'Q:\TV Shows\'

$hTimer1 = TimerInit()

_FileListToArrayXT( $sFolderPath , $cExtensionsC , 1 , 2 , True , '' , 1 )

$iDiff1 = TimerDiff( $hTimer1 ) 


$hTimer2 = TimerInit()

_FileListToArrayRec( $sFolderPath , $cExtensionsC , 1 , 1 , 0 , 2 )

$iDiff2 = TimerDiff( $hTimer2 ) 

MsgBox( 0 , '' , '_FileListToArrayXT:' & @LF & $iDiff1 & @LF & @LF & '_FileListToArrayRec:' & @LF & $iDiff2 )

[DXRW4E]

@Nologic

'?do=embed' frameborder='0' data-embedContent>>

Ciao.

Edited March 7, 2014 by DXRW4E

[AZJIO]

@Nologic
>_FO_FileSearch

[Nologic]

Thanks for the links.

@ AZJIO

Rather impressive.

Non recursive: 205-210ms

Recursive: 2.9-3.0 seconds

[guinness]

The numbers are negligible.